I need to have a macro to search VB code

[Jcuster]

I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change it
to ".FirstPageTray = 16642" inside the code. I also need to do the same thing
with ".OtherPagesTray = xxxxxx"

I do not want to do this by hand because I would have to visit over 200
user's desks

 

[James]

I assume you are talking about VBA in an Access Database?

You can use Edit | Replace from the file menu to search for and replace
text. The best way would be to do this in one front end and then role
this out to all users. Therefore making this change once, rather than
200 times. never wise to try to maintain 200 separate mdb files.

You can always put this updated front end onto a server and provide a
link to the share asking users to copy and paste it onto their local
computers.

James

 

[Klatuu]

To add to James' response, you may want to visit this site. With as many
users as you have, it would certainly make your life easier:

http://www.granite.ab.ca/access/autofe.htm