Search results for query: *

Remou and PHV, Thanks for the help. It is working perfectly now. Much nicer than I had it before!!

I tried the following code in the control source for the text box, but no luck (#Name? is returned). =DLookUp ("[CountOfStrawID]","qryNumberofStrawsAvailable","[Shipped] = No" And "[SampleID] =" & Me.SampleID) The query should count the number of straws that do not have a check in the field...

I don't think DLookup will work because the query uses 2 parameters. Can you use DLookup with 2 parameters? I did not see any in the help section.

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...

Remou, I tried the MsgBox and SpeciesSelect is showing the still has the space in the string (Schaphirhynchus albus). So obviously the replace is not working correctly. Thanks for the MsgBox tip. I would not have thought of that. Well I got it working. It must have been a typo, although I...

Remou - I tried that and it does not work with the space. When I remove the space, it does. PHV - I tried that and it does not work either. Here is a copy of the code in the OnClick Event to open the form. This works if Me.Species is Scaphirhynchusalbus, but not if Scaphirhynchus albus: Dim...

I thought trim would remove leading and trailing spaces. I am interested in removing a space within a single field. For example: Value = Red Hat I want: Value1 = RedHat I don't think trim will do that.

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...

Where should I put that code? I entered it in the format section of the Time field in the table, and that did not work. I entered it in the format section of the Time field in the form, but that did not work either. I can get the form to show only the min:sec data by using nn:ss in the form...

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...

Thanks

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,

Dan and Tofias1, Thanks, now working!! I put the command at the beginning of the OnClick event to open the next form and it worked perfectly.

Dan, Would the record appear in tblCane if it had not been saved? Bill

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...

Rolliee, How do I check for no records, and then add a record? Sorry, kind of new to this. Thanks, Bill

Dongled, Thanks for the help. I assume I am going to have to write this querry in visual basic, and I have not done that yet. Could you give me some code for that based on the above criteria? If I can just make a normal query (say using the wizard) and base the form on it, how do I get it to...

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...