Search results

Hi I have a problem which hope will have a simple solution, which has been driving me mad all day I have a client who has two prices for the same service depending on speed of turnaround These prices are entered into the Client table seperately using the CDetails form. I then wish to use...

Hi I wish to add a command button which on the click event does the following 1 Saves the current record 2 Prompts the user with the question " Do you which to print lab sheet for this batch" 3 If the user selects Ok then the report "Lab Sheet" runs, if they select cancel I wish to close...

Would this work On the click event of the command button there is code to open a new record. Could I put a line in to record the batch number in the current view and then after the new record creation put a line to set the value in the batch number in the new record Code below for command...

Thanks I am fairly new to this and am struggling with the most of what you said, could you expand on you reply Thanks Richard

Hi Have a form which has various fields. the key fields for this question are Sample Number -- Autonumber BatchNumber --Combo Box based upon query I have a command button which adds a new record and I want it to create a new record but to use the batch number from the previously...

thanks, works great

Hi Have a form with 2 combo boxes on it, titled combobox1 and combobox2 Combobox2 is related to combobox1 depending on the selection made. What I have done is to create a query that pulls the information for combobox2 to utilise depending on the selection in combobox1. Nothing difficult so far...

Thanks for the answer, I would like some further understanding of the formula you have given please. I have put both examples in and both still return #Error Am I trying to do this the right way, or is there a better way of achieving what I want to do?????

I have data in a table I am extracting using an append Query, I wish to assign a number from the original table +1 to the records pulled by the append query. I am very new to this and have the expression below, however the result is #error in created field CertifNumber The data I am looking for...

Hi I have a table within which I store data showing the results of tests. I wish to create a certificate(as a report) which displays these results. The certificate should have a unique number which is then stored with the original record within the original table, called 'Sample Results' I have...