Recent content by mathboy23

strSql = "SELECT tblUsers.UserID FROM TBLUSERS WHERE tblUsers.UserID = strUSERID" 'Set the source query defInItIon to get the current records In curSourceQueryDef Set rsResult = dbs.Execute(strSql, dbOpenDynaset) The last line in this code is not working in VBA. Can anyone help me with...

I added a line for SetWarnings=No as step 1 and SetWarnings=Yes as the final step, but I still get the error saying, Table qryOutput already exists. If I delete the Sheet in the Excel file, it will transfer the records as I wish. I don't want to force the user to delete that sheet everyday, but...

I have a simple two step macro that is designed to transfer the information (qryOutput) to an excel spreadsheet (and then tell the user it is done). The first time it was run, it worked like a charm. The second time that I run it, Access gives me an error message that the Table qryOutput already...

Thanks for your help! We just added some phone reps and they may not have been given the same security access as everyone else. I really appreciate the help! Michael

We have a very simple database (1 form, 1 table, 2 queries) stored on our network. We have had no problems with it for months, but today some of the phone reps are receiving an error message when trying to enter data into the form. The message states "Could not update; Currently locked by admin...

Thanks Pat, That has solved the issue. I've had to change the code where I had some other messy stuff, but this is my first try at coding, so figured I'd learn something new.

I am creating a log-in form for a database and am running into a 'Too few parameters' error when trying to login. I am using the login form to determine which form should be opened (based on a user's department) and to use the login ID as a parameter in a query. Here is the code I am using on...