Create a continuous form based on a query based on your contacts table. Be sure
to include the ContactID field. Sort last name ascending.
Create an option group named ContactLastNameInitial with 26 toggle buttons
labeled A to Z. (The buttons will have the value 1 to 26 in the form header.
Put the following expression in the criteria of the Lastname field of the query:
Like Me!ContactLastNameInitial & "*"
Put the following code in the AfterUpdate event of ContactLastNameInitial:
Select Case Me!ContactLastNameInitial
Case 1
Me!ContactLastNameInitial = "A"
Case 2
Me!ContactLastNameInitial = "B"
|
|
|
Case 26
Me!ContactLastNameInitial = "Z"
End Select
In one of the fields on your form, put the following code in the Click event:
DoCmd.OpenForm "NameOfIndividualDetails",,,"[ContactID] = " & Me!ContactID
Build a single form based on a copy of the query above without the criteria in
LastName for adding/deleting/modifying records.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"nospam" <no****@nospam.demon.co.uk> wrote in message
news:nd**************@nospam.demon.co.uk...
Am I trying to do something that is impossible with access 97?
I want to write an address book application.
I have exported (from a Casio BOSS organiser) all my contact information
and it is now in a file called addresses.mdb I can edit this file using
the tables and forms in access.
But I want a stand alone application.
I want to double click on an icon on the desktop and a window opens up
with 26 tabs across the top (A - Z).
under the letter tab I want a window with all my contacts for that
letter shown horizontally and when I click on a row it open a window
with all the details for that individual, or displays them in a
different part of the screen.
I would lick to be able to put this application and the .mdb file on all
the computers I use.
I will also need a screen for adding/deleting/modifying records.
Is this possible with access?
thanks