Recent content by JFHBIFF

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...

Any ideas?

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...

Thanks for offering to help RuralGuy. Somebody helped me via PM. Below is the code that worked. Forms!frmSCOrd![tblDefCatDump subform1].Controls("ynsPrefix") Have a great evening!

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...

Thanks for the reply pbaldy. I couldn't get sendobject to add the attachemnt. I found some code that would work. The only thing I am having trouble with is adding a subject line to the email and text to the body of the email. I am using transferspreadsheet to update current spreadsheets...

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"...

Thank you very much for your help DCrake. This worked perfectly. Have a great week

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...

Thanks for your help Bob. Works perfectly

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

Ok, I figured it out. I had the end if in the wrong place. Thanks for your help

Thank you very much for your help llkhoutx. Works perfectly, now that you got me thinking about incorrect year I tried the code shown below. Problem with my code is, if the month is correct and the year isn't it wont pick up the incorrect year. Is there a way to combine the two so both work...

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