Search results

The error I found was in the control source key on the reports LAB ID. It was just LAB ID so I changed it to Table1a.LAB ID and now it works. But that button on the form doesn't seem to be working properly. I made the button using the wizard and the form doesn't close so I don't know what...

Ok, I found the error! The query works by itself and the report works by itself but when I use the form with the print report button I get a blank report. Do I have to send the beginID and endID in? Thanks again for your help, i am nearing the end of this mess so hopefully I won't bug you too...

I did just that but it has the exact same error message. My new criteria is this... Between [Forms]![PrintILS]![BeginID] And [Forms]![PrintILS]![EndID] but it still spits out the error about the ....'[Lab ID]'..... Do you know what the problem could be? Thanks!

Running out of time and getting desperate. Please forgive me for posting in tables forum also. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer...

Hi, Yet another problem, big surprise. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer to more than one table listed in the FROM clause of your...

Can a datasheet from a table have many sub datasheets? I have a project number that can have up to thirty tests performed on it and I would like to show all the tests listed under the project number as a sub datasheet. I was thinking a query might be better but I wouldn't know how to do this...

Yes, I did not have in the after update event and now it works. You are the best. THanks!

Yes it is the first column. I will try 2 and see if that brings up the right text. I also tried that DLookup and I just get a blank in the text box. Is this the right code for the DLookup function. =DLookUp("[Company Number]","[Clients]","[Text52] = Form.[Combo6]")

I tried this code.... Me.Text52 = Me.Combo6.Column(0) and I get this in the text box... #Name?

Ok, I will do that-thanks!

Nope, it only has the company name column in the combo box. Is there a way I can get the company number from the table without having it in the combo box?

Hi again, I have one more question. I have a combo box on a form where the user selects a company name. After selecting the comapany name I would like to have a text box on the form displaying the company number corresponding to the comapany name the user selected from the combo box. Do...

Great, I finally figured it out. There was a glitch in my linking fields. Thanks for your help!!

Thanks for your help. I do want it to show in the datasheet view so they can see an overall picture of what projects are working for the clients. I will keep working on it and see if I can find an answer to my problem. Thanks again!

It is saving to the projects table but when I look at the record in the clients table and click on the plus box it shows the projects table with nothing saved in it. THank you!

Thanks for the help. I made a form and a subform and it took care of the error code problem but now it is not saving the information from the subform into the projects table. Thank you for your patience and help! I will go look through the article you sent and see if there is anything about...

Thanks I will do that but is there another way also for future reference. (I have many forms which are linked together and I am curious if this may happen again if there is an alternative.) Thanks Again!

Hello, I have two tables which are linked together by the Client ID. One is a Clients Information table and the other is a Project Details table. When I try to save a new record to the Project Details table it gives me this error: You cannot add or change a record because a related record is...

Thank you for the help. It prompts me with this "Forms!ChainOfCustody!BBCID". Is there a way to just pass it in, WIthout being prompted to enter it? Thank you.

Thanks! I am getting a compile error now. Private Sub checkbox1_Click() DoCmd.OpenReport "InternalLab1b", acViewPreview SELECT * FROM Query1b WHERE [Sample ID] = Forms!ChainOfCustody!BBCID End Sub