By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

7952 You made an illegal function call.

P: 91
Hey people,
Need your help again i'm getting "7952 You made an illegal function call."

i m getting a message "This RecordSet is not updatable"
i don't want that message to be displayed on the status bar and i have used SysCmd method with acSysCmdSetStatus as its parameter but it doesn't work
Expand|Select|Wrap|Line Numbers
  1. Doevents
  2. SysCmd(acSysCmdClearStatus)
Aug 3 '12 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 3,284

Is your question regarding the error or regarding the message displayed?

If it is concerning the actual error, that type of error typically occurs when you are trying to update a table from a query, but the design of the query prevents the DB from performing such an update, usually, because the specific field is ambiguous or aggregated.

If you are concerned about the warning message, one way to turn these messagees off is to use this code:

Expand|Select|Wrap|Line Numbers
  1.     DoCmd.SetWarning False
  2.     'Insert your code here
  3.     DoCmd.SetWarnings True
But, either way, you should have effective Error Handling code built into all of your VBA, so that you will be able to know when your code malfunctions and where and why, without your DB locking up or crashing.

Let me know if this helps.
Aug 3 '12 #2

P: 91
Thanks for the reply And yes the query design view of the query prevents the DB from performing such an update

Thanks a lot
Aug 8 '12 #3

P: 91
I Didn't Knew thanx for the Explanation twinnyfo
Aug 8 '12 #4

Expert Mod 2.5K+
P: 3,284
My pleasure. Glad I could help!
Aug 8 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.