Ray, Just a couple suggestions. Most importantly, put the title of the application you are asking your question about in the Subject of your email. I know that personally, I have my email filters set to highlight Access question since that is where I am most comfortable. As for your question, as Dian said, it may be that no one here knows the answer. Personally I have no idea if you can change the defaults. My guess is that it would be a registry entry change which is specific to the machine that Access is currently running on which would do you no good as far as a distributable application. There are other possibilities. You could try to use Sendkeys and try to accomplish what you want. Its not the cleanest way to do it, but it is a way. It may also be possible in VBA, but I am not familiar with how to do it. James -----Original Message----- From: Ray Shapp [mailto:rayshapp@xxxxxxxxx] Sent: Monday, June 09, 2003 9:53 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Question Guidelines :VSMail mx3 Hi Group, I have asked essentially the same question about modifying a macro in Access three times, but got no responses. Please look at the question (below my signature), and tell me how to rephrase it in order to get help on that topic. Am I violating a guideline for this group? Should I take that kind of question to another Group? Thanks for the guidance and/or help on the macro question. Ray Shapp **************question re-posted from 5/26, 5/28 and 6/7*************** >Currently, when I open a personal database, the macro shown (below my >signature) runs. It opens the main form in the DB, and prepares it for >viewing, searching, editing. > >Please tell me what modifications to the macro are needed to open the Find and >Replace dialog with "Look In:" pre-selecting the entire form and "Match:" >pre-selecting "Any Part of Field", and "Search:" pre-selecting "All". > >I'm guessing the current macro should call a separate macro. For some reason, >Tools > Macro does not provide an option for recording a new macro. How can I >get the macro recorder to become available? > >I'm using Access 2002 SP-2 on a WinXP Home box. > >Thanks for the help. > >Ray Shapp > *********macro begins on next line************* Option Compare Database Option Explicit Private Sub OpenAddressBook_Click() On Error GoTo Err_OpenAddressBook_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "View or Edit Addresses" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_OpenAddressBook_Click: Exit Sub Err_OpenAddressBook_Click: MsgBox Err.Description Resume Exit_OpenAddressBook_Click End Sub ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************