.....Will my Code change when I convert.....?

[Popparod]

.....Hi...!
......I created a Database for our Bluegrass Assoc. to keep track of
Members/Duties/Festivals/Trailers/Bands and what not.......

......Our Secretary , Treasurer and Events Mgr. have been doing most of this
thru Excel
because they find they can manage "cells" easier that way....

......You guy's have helped me out before on other stuff which I'm very
thankful for
because it has made the creating of this one easier.......

......I don't need to put the .mdb on a server as only a minimum number of
people will be using it.....Only 4 tables will ever be affected at any given
time,
usually once a year......

............Members/Payments/Trailers/Bands........

.......I've taken into consideration (I think), that if one of the three
people update a particular table it can be exported to a temp.mdb from a
Form with Export/Import command buttons to auto the process in/out of the
temp.mdb at Form level....
Then Emailed accordingly to the rest of the Officers.....

......I also made a form with 4 Update Queries to auto process the imported
forms into
the pre-existing Tables....a button for each depending on the table that was
imported......

.....I've also included on the form an SQL Query for each Table imported so
the "WhateverTable(1)'s"
can be deleted at "Form Level" without interferring with the original
Table........

.....I happened to inherit Office 95 on my Mom's PC so it's the only Access I
have Access to (no pun intended)

.....My question is.......since 2 of our Officers have "Office 2000" and 2
with "Office 97".....will all my efforts
be for naught or will they be able to do a simple conversion from my
"Dinosaur Access".....?

.....I really do miss working on "Office 2000".....(a learning process , is a
a learning process though I guess)

.....There's no way to intoduce an updated Jet into 95 is there.....


.........Thanks for being there and answering novices' silly
questions.........

 

[Arvin Meyer]

If you save the files as Access 97 files, everyone will be able to read and
write data, but only the 97 users will be able to make changes to the design
of the database. Assuming you can tell the Access 2000 users to NEVER
convert the database, you'll have no problems. If someone makes a mistake
and converts to 2000, you can convert back, but I would not habitually be
converting back and forth.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

Add a textbox to the bottom of each column in a footer that corresponds to
how you want your some (Group, Page, Report) Then use the Sum function in
the controlsource of the textbox, like:

=Sum([MyField])
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access