Search results

tblSurveys should I make the comboboxes from a query such as tblSurveys/ UnitNumberID - tblUnitNumber/ UnitNumber or UnitNumber The attachment is what the final form needs to look like with the answer fields Thank you Bill

Please let me know what I am doing wrong Thank you, Bill

Any Ideas? Thank you, Bill

I need all the records to show at the same time. This is the thread that I found http://www.access-programmers.co.uk/forums/showthread.php?t=69924

I want to thank everyone that is helping me out but I am still a little confused Is this table structure correct? tblUnitNumber UnitNumberID AutoNumber PK UnitNumber DateChecked tblInventoryItems InventoryItemID AutoNumber PK InventoryItem tblUnitCompartmentNumber CompartmentNumberID...

Trying to do step 2 so that my questions show up on the form but cant get it to work can anyone help me out with this? Thank you, Bill

Makes sense that is the way I will do it. Thank you very much you have been a great help. Bill

I understand the table structure but I don’t understand how to list the 117 records on a form so that I can make a check sheet for the employees to check the vehicle every morning. The items have to be listed for that employee to be able to check the compartment to make sure they are there. Such...

Forms Thank you for your help. I have 117 records in tblCheckType I have to make a form that list all of these and the answers which I set up as yes/No and Not applicable in tblAnswerCodes. I also added tblParamedic which will list approximately 100 employees. I am not having any luck. Can you...

I am writing a access database for work(fire dept). It is a database for the vehicle checks. Most of the fields are Boolean fields we just need to know if the inventory is on the unit. I am kind of new to this. My tables so far are as follows: TCardiacMonitors TFirstInBags TGlucometerKits...

How can I get an AutoNumber column to start with a higher number such as 5000? Thank you Bill

I have a couple of question: Can I purge a database and keep the structure intact and if so how? How can I move records such as all records from one customer (No longer doing business) to another database for storage that has related records in another table? Thanks for your help Bill

I am going to be splitting an Access database back-end will be on the server and front end will be on the client. I am some what new at this so I have a couple of questions: How many times can this be done with the same database (I believe there are 8 computers i need to place the front-end...