Search results

Thanks MajP. That solved the issue.

Hi all, I am trying to upload excel file and then run bunch of queries to update few tables based on uploaded file. I want to have a sub that calls function(to upload excel) with two vars supplied, and function in turn returns Boolean value back to sub. So the sub can use the boolean value to...

Hello all, Getting stuck again on trying something new. I have few action queries which updates TblUsers based on imported table from HR data to addnew users and update current users. I put this action query in a VBA module(ActiveListSync) and attempting to run a VB Script to run the module...

That did the trick. For I was looking at the value which gets assigned to the checkbox (-1 for true and 0 for false) Thank you very much for quick replies.

Thanks for that. It fixed the runtime error, however, it is not updating the record on the table. Not even sure where to begin to look.

Run-Rime error' 3464': Data type mismatch in criteria expression. Debug.Print result UPDATE TblUsers SET TblUsers.HasCar = '-1' WHERE TblUsers.ID= '2684'

The TempVars is UsrID which saves the ID field from the table when user logs in, which is set as Autonumber in TblUsers. Now I am not sure when the TempVars is saved if it converts datatype to string Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("TblUsers", dbOpenSnapshot...

Hi All, I started exploring the SQL statement in VBA rather than building a query and I am having issue with Update query. So basically what I want is to get a msgbox which is asking user "If you have a car or not" and based on the answer (YES/NO), I want to check off the checkbox (HasCar) in...

"Eval(prm.Name)" only ready Forms!Subform!ControlName rather than reading it like suggested. I googled to find any documents or post that may help with this, but unable to locate one. Not sure even if it is possible.

I looked at it prior to posting the thread, I just don't know how to reference it.

Hello, I have a sub form AddEditEmployee within main form Admin. Both forms are not linked and only purpose of the subform is to Add/update users. I am getting error 2450 when the AddEditEmployee form is inserted as subform in the Admin form, but when open as stand alone, it doesn't throw an...

I had parameter set in the query so just needed the code to run the query without messages. You solution worked great. Thanks for the help.

I would like to run the query without popping up messages so took the execute method. Now building SQL is beyond my current skill sets with VBA. Is there anyway you can lend a hand or point me to some resources?

Hello, I built the update qry which has criteria and update To fields set from the form which I am attempting to execute via VBA. When I run the VBA it throws a runtime error 3061. Not sure where the mistake is. I checked to see if there was a typo anywhere, but unable to find it. Please let...

Following your code give me an error message Run-time 3265- "Item not found in this collection" at line 5 where first parameter is set.

I don't want to set warnings to false just in case if it fails, thus used execute.

I don't have the SQL string on vba. I created an update query in access and using the query name next to Execute. But here is the SQL from the query. UPDATE TblTransactions SET TblTransactions.Void = True, TblTransactions.VoidTimeStamp = Now(), TblTransactions.[Voided by] = "Admin"...

Hi all, I have saved UpdateQry named qryvoidBlank on my FE to void blank records (not to delete). If I run query directly or via docm.openquery, it runs without any errors and makes necessary updates. However, if I use Currentdb.execute method then it kicks in error 3061 with "Too few...

That worked great. I had to remove Option compare Database though for it work as I was receiving an error.

That was very helpful link. Just needed to add “form” before “Dropamount” The second part works just fine.