Trying to set up a new database for a gym...

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

Jacqueline

Hi
My sister is opening a gym for women...and I was going to
create a small Access database for her...

A few forms...contact info form...a general health/weight
form.

In a sample database that was sent to her by the gym's
head office it went something like this...

1st screen opened where the member entered their
telephone #...pressed enter and if there were any
reminders for her they would pop up...ie: you haven't
filled out your health form...or your membership is up
this week...or this is your 5 trip to the gym this week,
etc...

I can do the basic tables/forms and reporting for my
sister...for attendance, membership renewals, etc...

BUT I am not sure how to code to check data for these
things above based on the member's phone # and have them
display after they hit that ENTER button??
 
You can use the after update event of the text box. This form will likely be
a un-bound form. Most of the graphical interface stuff when you ask
questions to the user is going to be based on un-bound forms.

For some sample screen shots of forms that ask users questions, but don't
edit data, you can take a look at:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html

In the above, all examples are un-bound forms.

So, in your case, we would first get the customer the phone number belongs
to, and then at that point, you need to display the reminders, or whatever
else you plan to do. It is not clear if you have a separate reminders table
(good idea), or you need to just check/warn the operator. You could just
simply display the customer and then user could see/edit that form.

The code in the after update event of the un-bound text box could be:

strWhere = "HomePhone = '" & txtPhone & "'" & _
" or WorkPhone = '" & txtPhone & "'"

docmd.OpenForm "frmCustomer",,,strWhere

The above two lines of code would open up the customer form with the phone
number you entered. At that point any kind of reminders etc could be
display. And, since the customer is displayed at that point, then any thing
like address info etc could be entered.

Searching for a customer is something that your users will do all day. Here
is some more ideas based on the above code idea of using the after update
event.

http://www.attcanada.net/~kallal.msn/Search/index.html
 
I suggest you invest (small dollars) in a set of books named "Access 2000
Developer's Handbook" author is Ken Getz, Publisher SYBEX. Available from
places like Amazon.com for a discount. A two volume set that has great
tutorials, many examples, a Cd with all the examples and a great resource.
I have used these books with good success. They will be a great help in
design ing and implementing your database.
Wish you success,
Cheers,
Henry
 
Back
Top