Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the ms_access group. File : /COMPUTER.xls...
ms_access@yahoogroups...
Dec 1, 2005 2:39 pm
18957
Dear friends, i wishing you all the best i want a calculator in my Internet Cafe which Ending time - Starting time = Total used time and cost minimum 3.00$,...
Hi, I'm trying to base a listbox on two combobox choices. Example: form has two comboboxes month and year. and a listbox, set to visible.false on open Once...
Excel works just like Access - the format you define for the Cell determines how the value is displayed, so you should be able to display 12-hour times. To...
Set the listbox rowsource after the user chooses the month and year. If the rowsource is set on form open that is when it is looking for the parameters, not...
Hai All, I am a beginner in MS Access. I am preparing all the concepts to pragram and develop an efficient application using VBA. But as i dont hav any real...
Hi Mitch, I tried the following: Forms!viewincidentsbymonth!Imy.RowSourceType = "Table/Query" Forms!viewincidentsbymonth!Imy.RowSource = "empbymonth" 'where...
Hi everyone, I have a rather simple dilemma but for some reason I cannot get this to work. Can someone help me out? I am creating a database for a crisis...
Joe- You can't assign a string value to RowSourceType - it's actually an integer. But you shouldn't need to set that property in code anyway. What's the SQL ...
Jose- You should use the Primary Key value for the filter: DoCmd.OpenForm "frmCallDetails", _ WhereCondition:="[Call Received] = #" & _ Me.[Call Received] &...
I have a table with sequences of numbers that are essentially the same except for the leading digits. The idea is a "10" indicates a case and the "00"...
Ray- Maybe I'm missing something, but the "From" data looks exactly like the "To" data, so I don't understand your problem. John Viescas, author "Building...
I have a data entry form with a button that can be clicked so that the user can check to see if any new cases have been loaded for him. The ID number on the...
Sorry. Thanks for taking a look. The list (table) is vertical, and the end result (either table or spreadsheet) has to be horizontal. It's just something that...
Oh. Join the table to itself: SELECT T1.UPC, T1.gtin As ItemCode, T2.gtin As CaseCode, T1.Desc As Description FROM MyTable As T1 INNER JOIN MyTable As T2 ON...
Hi everyone, Is there a way to manually save through a macro and/or VB while a new record is being entered in a form? I have a form with the following fields: ...
Hi, Now that I have my listbox working(Thanks John!) I'm trying to setup a button on the form which sends a different form to the printer. Form that opens =...
Joe- First, the query should be: PARAMETERS [Forms]![irneedaproval]![iralist] int; SELECT [Incident Query].* FROM [Incident Query] WHERE ((([Incident...
Hi John, The form does open using the command: DoCmd.OpenForm "iraprovalformprint", acViewNormal under a button ,but what I'd like to do is send the above form...
Joe- Forms are primarily for viewing on screen and editing. If you want to directly print something, build a report. It is possible to open a form in Print...
Greetings, I am running a query where the results may contain one or multiple records for a given customer. The results of that query are then brought into a...
Hi, I'm looking for some samples for checking for duplicates. I have an SSN field set to be unique, but sometimes do not get the SSN I'd like to setup a...
Joe- Check out the BeforeUpdate event in frmContacts in this sample database: ftp://ftp.viescas.com/Download/Contacts2000.zip It performs a check for possible...
Thanks John, There's alot of nice code in there to look at! 2 questions... 1. I get a compile error on the ISNothing statement, am I missing a file? 2. Is...
Joe- 1. You need the modUtility module from my database - that contains the IsNothing custom function. 2. Note that the sample code in the form BeforeUpdate...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
