I need to install Access Utility Add-In-Where do I find it??

[leonb]

I am completing a macro to open a form and also open the Find box, (Ctrl+F). All the language and syntax is correct. However I receive the error message below.

SendKeys action requires the Microsoft Access Utility Add-In to be loaded Rerun access.

i have re-run access twice and it will not load the "Utility Add-in".

Any help will be greatly appreciated. Please reply to

blacknomad@ca.freei.net

Thank you, Leon Brodeur

 

[Robertd]

Hi Leon,

Ok if this is access 97 (previous vers are similar, not sure about access 2k). but in the tools menu near the bottom is the "add in manager" to add an "add in" select this and follow the instrucions "utility.mda" is likely what it is looking for. if this doesn't work you may need to re-run the install procedure using add/remove software/office select the access components you require and cross your fingers, er,.. whatever. now i'm not sure why it want's this as i don't use macros and i don't have the "utility.mda" loaded, you can achieve the same result using code, but it may be required for a macro to use the "sendkeys" method.

HTH
Robert [sig][/sig]