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

VBA code that used to work, no longer works

P: 1
Access 2000- I used a statement in a module or just the code behind a button example me.[field] = "String" or me.[field] = 20

When I attempted to use this format in acces 2007, it wouldn't paste the data or even yield an error message. Is there a new syntax that I'm not aware of or has this functionality gone away? I tried looking for an equivalent in a macro but didn't find one.
Apr 9 '10 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,768
Hi Dave. Welcome to Bytes!

Your question is a little obscure. I suspect it may be that your code is simply not enabled, but you don't indicate if other code works. Code often gets disabled when moving to Access 2007.

If that isn't the case, then we'd probably need a bit more info from you to help us understand the context and maybe come up with a solution.
Apr 9 '10 #2

Expert 2.5K+
P: 3,532
To repeat NeoPa's question, does other code run? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:
  1. Office Button (top left)
  2. Access Options (bottom of dialog)
  3. Trust Center (left)
  4. Trust Center Settings (button)
  5. Trusted Locations (left)
  6. Add new location (button)
Linq ;0)>
Apr 9 '10 #3

Expert Mod 15k+
P: 31,768
Thanks for getting the slack there Linq. I'd have included that helpful info if I'd had it. Unfortunately I know little about 2007 working.
Apr 9 '10 #4

Post your reply

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