Invalid Procedure call or Argument...

[asmodius]

Hey anyone,

So I thought I've been getting the following error because of bad requery code. "invalid procedure call or argument." but when I delete all of the code in code editor and leave absolutely nothing, I still get that when compiling. Where might I go in the database to figure out what the heck is wrong? If there is any more info you think might be helpful please don't hesitate to ask.

Cheers.

 

[The_Doc_Man]

At least in theory, you could get this if a VBA function is activated in a query and you have a bad reference or if you used improper args in activating it. Functions like SQRT and MID$ and other things like them can appear in a query. I'd look there next.

 

[asmodius]

Resolved, thank you...

So I figured out what the problem was. There was bad code in the database when I started working with it. But since I wasn't the owner of the database all of the changes to the code that I made didn't really get applied, they just appeared to. What I had to do was make a blank database then import that one. All the changes I made after that were actually applied. Thank you for your help.