I will be out of the office starting 12/31/2002 and will not return until 01/02/2003. I am currently out of the office - returning Thursday, Jan. 2nd...
OK, let's try a little debugging. Right-click on the line, Me.Order_Subform!ProductID.Requery. Choose Toggle/breakpoint. This will force the code to stop at...
Hello Bill, I did as you have to according to you, but the supplierID is not Empty it shows the value. I dont understand what the problem is. I am again...
Shariff The only reason why the list is blank is if there was nothing returned by the row source. If you can upload a sample database to the group files, I ...
I don't know if I'm calling it the correct words but what I'm seeking to do is if a user enters text in a text box say the name micheal, and he enters it as...
Help, please. I'm new to Access, being a retread from dBase. To populate the primary key, IDnum, in new records, I do not want to use the AutoNumber data type....
yes I do it every day but you need to be an administrator on the server. here is how I do it I have BATCH files that brings down the files from the ftp site to...
... Otherwise, you can put something like this in the after update event: Me.TextBoxName = StrConv(Me.TextBoxName, vbProperCase) Paul ... seeking ... Michael...
I'm sorry. I mis-read your request. This will make all the characters upper case. You would want to use the StrConv() function. ' ... calling it the correct...
Much better idea would be to use the autonumber field, hide it from your users, and create a new field to hold your 'public' key. Cheers, Andrew ... From:...
What you want to do completely defeats the purpose of a primary key. How are you going to establish relationships if you reuse deleted keys? I strongly advise...
sorry folks!! Another problem. I have this gobal variable that is declared as a DAO recordset, when a user perform a search the criteria for the search in the...
This may not have any impact on your problem, but I've found out that whenever you go into `Debug' mode your Global Variables lose their contents. For...
yeah but when I place the cursor over the gobal variable in a small yellow box it say RS=Nothing. All I am trying to do is to move to the next record or to ...
I have created a query that returns all the data I need. Now I must create a form so a user can enter specific criteria to get selected info from that...
I meant " Now I must create a form so a user can SELECT specific criteria (eg. date) and return data from the query and display it in a report. I know I must...
I populate an Access 97 table with data from an Oracle database using the import process. Each week I append data to my table. Recently date fields were...
Create a form with unbound test boxes. Format the boxes accordingly - i.e. date, number, etc. Save & close the form. In the design mode of the query you've...
Annie, In this example, there is a combobox called cboDate that is used to select the date the user want a report on, and a button called cmdPreview that the ...
There are all kinds of ways to do this. You don't really need a filter. Create a form with textboxes for "from" and "to" dates, or whatever the criteria you...
Howdy, Could some please provide a list of all the tools/packages/files necessary to create an Access runtime for distribution. I am in the process of...
Hello Everyone, I've recently committed myself to creating our 2003 budget in MS Access 2000. I have all of my information uploaded as a series of tables and...
I'll have a button that I click on to order the report. That button calls up the input form, which has the input fields and a "Continue" button. The continue...
Anita I must be misunderstanding you. Are you referring to a list box? It's not possible for a user to delete an item from a listbox. Bill ... From:...
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.
