Search results

Hello, Is it possible to run a loop through each record in query, but refresh the query in between loops? The query I am looping needs to be updated before moving to the next record. Thanks for any help. I have found plenty of advice on how to run through each record, but can't figure out...

Hello everybody, Thanks for reading my post. I am wanting to randomly assign different users to records in a split database. I have a table UserField User1 User2 User3 User4 Records Table RecordField record1 record2 record3 record4 record5 record6 ......could end up being up to 600 records at...

Greetings everybody, I am using an afterupdate event on my main form that changes the source object of my subform. This works fine. If a control on that subform = true, I want to change the source object again. This is where my code fails. I get an error message stating it can't find that...

Good evening everybody, I currently have a button on my form that creates a spreadsheet based on a query called "Area". The name of the spreadsheet is based on a field on the current record on the form Private Sub Command6_Click() FileName = PathName & Forms!Areas!Area & ".xls"...

Hello Everybody, I have an append query that contains a parameter [PTIdent] under the field named PTID. I would like to be able to set the parameter through VBA from a control on a form eg Form!PTID I use the following code as normal Private Sub Command19_Click() On Error GoTo...

Hello everybody, I am having trouble with this criteria on one field in a query <>19 Or <>15 Or <>14 Or <>16 Or <>17 Or <>1 Or <>3 The query is still showing records that contain 14, 3 and 16. Basically, I don't want to show records containing 19, 15, 14, 16, 17, 1 and 3. Thanks

Hello, I am a little familiar with Access but having a problem figuring out how to alert a user that the date entered on a form is not the current month. I was hoping to have a warning msgbox pop up alerting the user. I am trying to prevent incorrect date entry. Thank you very much