Recent content by shathaway

I think I have an idea of what I need to do...thanks for all your help! Shannon

Thanks, I will do some more searching. Actually, the way I want this to work is the activity will have already been entered. For example, there's a record in the activity table for a piece of equipment with serial # ABC123 with a date of 7/20/2007. The scenario might be that someone calls on...

I have another question on the design of a different form and was hoping someone would be able to help me with it. I need to desin a form for tracking Election Day Problems. The user will need to enter the equipment serial number and then the date and have the Problem, Resolution, and Note...

That worked! Thank you so much for all your help! Shannon

Thank you again. I tried what you suggested and I don't get any results when I try to run the query. I added the relationships under Relationships by dragging UserID over to Republican (enforcing Referencial Integrity) and then again for Democrat. Then I designed a query (qryUserNames) with...

Thanks for your reply, Tim. I created the two queries and added a Republican and Democrat field to tblActivity. I decided to add the lookup fields through the form instead of adding them to the table. The fields pull the full name and then store the UserID in the respective fields in...

I am designing a database to track election machine activities at different vote centers. I have a form (frmActivity) where the user enters Activity information for a specific machine at a specific location. There needs to be 2 different fields for 2 users to "sign off" on each activity...one...

Great! Thank you so much for your help. Shannon

Hello. I am have created a database in Access 2003 that will be used to track receipts and disbursements. I am having some trouble with Beginning and Ending balances in the report. I attached a ZIP file that contains the databse I created named New_Transactions.mdb. Basically, the report that...