Search results

Won't let me save. Error msg says Extra ")". I think all the opening/closing brackets in my code check out.

Hi James, Thanks for the updates. Yes, setting the warnings on and off works great for my purpose. Hi vbaInet, Although, I'm able to accomplish my task with update query method, just curious what I was doing wrong in your method. Please review the SQL if you have time. I appreciate both of...

Hi VbaInet, I'm sorry I read the post from my cell phone and didn't see your reply after James first reply. I was referring to his code. Thanks for your help as well. Here is what happens when I try your suggested code: First, nothing happens when I write the code for After Insert Event of...

James, thanks the replying so fast.Update query works fine. The only issue with that is that it prompts user that an update query is about to run and gives user the option to proceed or cancel. I am hoping i can accomplish this without any user prompt and make it almost invisible process to...

Hi, I have a main form (AccountInfo) with subform (ReviewInfo) in it. Subform contains multiple reviews done on the Account# showing in main form. I am trying to make only one of the reviews as ACTIVE review. I have a checkbox field in my table from to which the ReviewInfo subform is bound...

Hi Bob, Thanks for the reply. I tried the code you mentioned but it didn't work. This is the error msg I get: "438 Object doesn't support this property or method". Any other tips? Thanks,

I am trying to pick values from an unbound OLE object. Can you help me with the following: 1) I have a form which has a field AccountBalance. 2) I have embedded an unbound OLE excel object which consists of some simple additions and subtraction calculated cells. This sheet is embedded in the...