By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,658 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,658 IT Pros & Developers. It's quick & easy.

Access 97 - is this possible?

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Yes

"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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
On Thu, 3 Jun 2004, nospam <no****@nospam.demon.co.uk> wrote:
But I want a stand alone application.
I would lick to be able to put this application and the .mdb
file on all the computers I use.


You MIGHT be able to find an old Access 97 Developer CD for sale
somewhere, which includes the runtime and developer tools
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 13 '05 #4

P: n/a
_Might_ is the operative word. For a long time, those were hard to find and
expensive. I haven't heard for anyone who's looked recently. It would be
interesting to see if any are posted in the online auctions.

"John Thomas Smith" <jt*****@pacifier.com> wrote in message
news:lv********************************@4ax.com...
On Thu, 3 Jun 2004, nospam <no****@nospam.demon.co.uk> wrote:
But I want a stand alone application.
I would lick to be able to put this application and the .mdb
file on all the computers I use.


You MIGHT be able to find an old Access 97 Developer CD for sale
somewhere, which includes the runtime and developer tools
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith

Nov 13 '05 #5

P: n/a
nospam wrote:
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.


If you don't have Access on all of your PCs then you need to Developers
Toolkit. Hard to find. In that case, you might want to get VB6.

The rest of your requirements are more than doable.

Nov 13 '05 #6

P: n/a
Possible?
Perhaps, if you're lucky, as other posters have mentioned, and find an
available and affordable copy of the Access 97 Developer's Edition. In case
it's not abundantly clear from those posts, you cannot run an Access
database on any PC without some form of Access. What the Developer's
Edition lets you do is create a Runtime version of Access (where you can run
Access databases and change data, but cannot make design changes) - this is
still not strictly speaking a stand-alone application.

But why on earth anyone would want to write a custom contact manager when
there are so many very workable ones on the market already - that's what
eludes me.

Unless you have other things you want to do with Access, I'd say your money
is better spent on a contact manager than on a Developer's Edition. I'd be
very surprised if there weren't contact managers of the same vintage as
Access 97 available at a pretty reasonable price.

HTH
- Turtle

"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

Nov 13 '05 #7

P: n/a
Thanks for the info.

It seems I need a developers edition and if I were to spend money I
would buy the latest version not access97 version.

The reason I said access97 is that I have that on my home PC, the PCs at
school, I'm a teacher, run different versions of access.

I just wanted a simple address book that was portable and had birthdays
and Christmas card tick boxes so I could print address labels for cards,
and a section with space to add misc. Notes.

All the contact managers I have seen have a bit of this and a bit of
that, I think I will have another look at what is available.

Thanks again

MacDermott <ma********@nospam.com> Writes
Possible?
Perhaps, if you're lucky, as other posters have mentioned, and find an
available and affordable copy of the Access 97 Developer's Edition. In case
it's not abundantly clear from those posts, you cannot run an Access
database on any PC without some form of Access. What the Developer's
Edition lets you do is create a Runtime version of Access (where you can run
Access databases and change data, but cannot make design changes) - this is
still not strictly speaking a stand-alone application.

But why on earth anyone would want to write a custom contact manager when
there are so many very workable ones on the market already - that's what
eludes me.

Unless you have other things you want to do with Access, I'd say your money
is better spent on a contact manager than on a Developer's Edition. I'd be
very surprised if there weren't contact managers of the same vintage as
Access 97 available at a pretty reasonable price.

HTH
- Turtle

"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



Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.