[mso] Re: Question Guidelines :VSMail mx3
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 10 Jun 2003 08:28:52 -0700
Ray,
The more I look at your question, the more I think you want to create your
own search tool. You can use the InStr function to search for whatever is
typed in. Depending on the amount of data you have, you could either have
it requery On Change, or have them press a button to do the search. I have
a form that allows them to search any of a number of fields simply by
selecting the appropriate option and typing what they want to look for.
If that is an option you want to pursue, I can offer you some assistance
there.
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:
