SendKey

[joekuhn]

I am using a "SendKey" macro in my database and it works ok except the first time I use it it shows a warning message and when I click ok it turns off the Numeric Lock. How can I prevent the warning message from coming up and avoid the Numeric Lock from being turned off? The database is in a safe location and I am using Access 2007 with Windows Vista. Help!

[TheShabz]

setwarnings off
or
DoCmd.Setwarnings False

[joekuhn]

Thank you for your suggestion. I have the setwarnings on "no" in the macro and the following message still comes up. I also tried the Docmd in the "On Open" property and the same thing happens. Any suggestions on how I can get around this?

"Microsoft Office Access Security Notice
A potential security concern has been identified.
Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you trust its source.
File Path: C:\.. -FT OFFICE\OFFICE1\ACCWIZ\UTILITY.ACCDA
This file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation?
More information
Open"

[TheShabz]

have you set the folder it is located in to be a "trusted location" in your Access security settings?

[joekuhn]

"My Documents" folder which contains all my files is declared a trusted location. I am assuming that that includes all subfolders.

[TheShabz]

There is a checkbox for subfolders. Open up your trust center and make sure it's checked. Outside of that, I really dont know what else to advise.

[joekuhn]

Any suggestions where else I might look for help?

[TheShabz]

1. Google
2. wait until someone else replies
3. try other forums