[mso] Re: Question Guidelines :VSMail mx3

  • From: James LaBorde <jlaborde@xxxxxxxxx>
  • To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jun 2003 08:22:13 -0700

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
*************************************************************

Other related posts: