Search results

Hi I have a form(frmNewTest) that generates a fitness test id when you enter the month and year (you do not need to enter anything in the Fitness test id field which is greyed out). This data on the form should then append to the tblFitnessTest. However, when I select the button to add...

Hi Thanks for the advice, I managed to get it working by adding the following to control source for txtNewNumber: =DLookUp("[newUserNumber]","qryNewUserNumber") Thanks Darth Sidious

Hi I am having problems with my frmAddCustomers. I have a qryNewUserNumber which works. I want the number generated by this query to appear in my unbound text field(txtNewNumber) on the form. Nomatter what I try it does not seem to work. I have attached my database for any suggestions...

Hi Thanks for your contribution it worked! Can I ask why my version did not work? Thanks Again Darth

Hi I've attached the database I'm working on. The problem I have relates to the DLookUp I have on the form frmFindSeats. I have a query for the Combo box 'available seats' which finds all the free seats for you to select one from. The normal price field should display the price for this seat...

Hi I'm a complete newbie and have just started to play around with access 2010. Don't let my name scare you off, I can assure you I'm a pretty easy going guy. I'm hoping to get lots of help and assistance through this forum so please feel free to contribute ideas to any problems I list as...