Search results

Hi, I just want to say thank you all for your responses. Especially for the person that send the zipped file. I copied your code and it is now working perfectly in my database. Thank you again for your time and effort I really appreciate it, I probable would never have got it working without...

Yes, the "Discontinued" field is a CheckBox. Sorry, I forgot to mention that!! Thanks for your responce.

Hi, Thank you for your suggestion but before I get the message box to open automatically I need to be able to check through the tblStores and find the PartNames to be reordered. Not sure how this goes, but something like this, If(UnitsInStock <= ReorderLevel And are not Discontinued) Then show...

Hi, I really need some help with this as I am a novice at vb. I have a table called tblStores which contains the fields PartName, UnitsInStock, ReorderLevel and Discontinued. I have created a form called frmStoreRoom, this form displays the PartNames details upon selecting a part name via a...

Silly me! your right. I got it working. Thanks again for your response.

Saving a Foreign key multiple time to a primary key Hi, Thank you for your response. The navigation buttons on the subform will indeed add a new record but the problem is it will not obtain the Job Details ID number on the subform. This Job Details ID number is a primary key in the...

Hello, On my form, when adding a new record I select Job Name form a combo box, which creates a new record for the Job Details table. On the Subform, the Job Details ID creates a new record for the parts used table. It will allow me to save that record once. I need to be able to select more...

Saving a Primary Key to two different tables on the one form? Hi, On my form, I select a Job Name from a combo box (got from the Jobs table). I then fill out it's details (which are stored in a table called JobDetails.) I then select a boat name from another Combo box which is stored in...

Sorry, I had ment to attact my database example but it was too big so I have attached a picture of the layout of my tables and a picture of the form I am working on. I hope you understand it. Thanks again, Rita

Hi, I have two questions. 1st Question: On my form (frmSurvey), I select a job name from a combo box (get from Jobs table) and then enter it's details in another table (JobDetails table). I then, select one or more employee names (Employees table) from a list box to be stored in EmpDetails...