Search results for query: *

I have a form (Form1) that gets a calculated value from a query. Form1 is not based on the this query though (based on another query), so I am currently opening another form (Form2)to store the value of the query temporarily and then use the value of the field in Form2 as the control source for...

Depending on the value of a combo box, I want to open one of a few different forms. I have a case function set up to do this, but the problem is that the combo box value is a text string with a space in it. It appears that the case function will not work due to the space. What I would like to...

I am having a problem getting the format for a custom time format. I want the user to enter a time in minutes and seconds only. I tried nn:ss in the format box for the time field, but it still gave me xx:xx:xx AM in the output. Any suggestions? Thanks,

Is it possible to create a Tab Control page that will open a different form depending on the information in the main form? I have a form that lists a particular species based on the selection of a combo box on the previous form. The subform Tab Control has pages for information regarding that...

I had gotten my database working the way I wanted, so I cleared out all the data I used to test the database. I compacted the database to get all the autonumbers to reset. Now I am getting a null error in 2 fields on a form. The fields are supposed to be populated by the following code: Dim...

I have basically gotten my database how I want it, but while testing certain things I have entered a lot of useless data. How do I delete the data and return all autonumber fields to 1 (basically start over). Thanks,

This should be easy, but has me totally confused. I am trying to save a record in frmLabNotes, but it won't allow the save because a related record was not found in tblCane. tblLabNotes and tblCane have a 1 to many relationship between the field SampleID and referential integrity is enforced...

Hello all, I am having a few problems with my database. I have a form (frmCane2) in which the user enters information then clicks a button (butLabNotes) to open another form (frmLabnotes)to enter more information. At the bottom of frmLabnotes is a button (butClose) to close the form and return...

I am having problems requerying a form (frmData). The form gets its data from a query. On the form is a button to change information. The button brings up another form (frmChange) to select the new data from. When the frmChange closes, I want the new data to appear in frmData. I have tried...

I have 2 combo boxes. They are set up so that the information selected in combo1 controls the information listed in combo 2. The choice in the combo1 can be changed and combo2 requeries it's list. No problem there. What I would like it to do is this. I want combo2 to be blank (null) if...

I have a form "A" that gets information for 2 fields (there are more for the user to enter)from a previous form "B". When form "A" opens the information is already in the fields. What I want to do is put in a Cancel button so that the user can close form...

I have a database which controls the inventory for a store. When a "Species" come in, it gets a record which among other things stores how many were "Received". As the "Species" are shipped out, the number "Shipped" for each specific species is...

I have a query which has 2 fields (among others). The fields are NumStraws and Shipped. The Numstraws field simply displays the number of straws entered for that SampleID. The Shipped field counts the number of shipped straws for that SampleID. Shipped is a check box. It works right now...

I need to be able to autonumber a field, but simply using the autonumber type wont work. Here is why: Currently the user enters the quantity of straws to be entered into the database, and access assigns these individual straws a number, consequetively from the last number entered. For example...

I have a form (let's call form 2) in which one of the fields data is taken from a previous form (let's call form 1). When form 2 opens the correct information is in the field, but when the form is closed it is not saved to the table connected to form 2. All the other information entered into...