Search results

We use queries instead of tables for our forms because we have multiple users. Our databases are all on a server. By using tables it will lock up all records and not allow for multiple user access. I was told that using queries clears this up.

I need to ask why I've been trained to link my forms to queries I was never really clear on that. But I've figured it out with the help of a co-worker of mine. I will post an updated finished version and will also post the explaination as to why I link forms to queries cuz again im not sure...

The Tab Subform 'All'. I removed all test data upon compact and repairing. Enter 1 in Request No., then enter multiple supplies. Create a new record. Then Enter 2 in Request No., then enter multiple supplies. Repeat however many times you would like. Then you should see my problem when...

Uploaded Database Hope this worked, Thank You!

I tried both nav buttons. The nav buttons on the datasheet subform control only those records. The nav buttons on the main form wont change the 'request number' until it goes through all records on the datasheet subform. I even created my own nav buttons. Didn't work. I'm thinking that a...

I made a form in single form view with a 'Request Number' as a field. The 'Request Number' is linked to a subform that is in datasheet view. When I want to go to the next record, the form will first scroll through all the records in the datasheet, before going to the next 'Request Number'. I...