G
Guest
I need to create an interface in Access 2007 for a non profit organization.
Just to give you a little background information, this organization gives
money and housing services to clients who can't afford them or need them.
Now, I've already got two tables made - CLIENT INFO & SERVICES for that
client (just to let you know), and I've already made a form with client info
& each client's services.
I've worked with switchboards before but I am not familiar with the way they
want me to do this interface. Here's how it needs to be:
1. It needs to have 2 sections or buttons: CLIENTS and SERVICES
2. When I click on the CLIENTS button, I need it set up so that when I type
in a client's ID Number (which was automatically assigned in the CLIENTS
table I already made), it brings up that client's personal information in the
form I've already made (that way they can edit it if they need to). IF NO
CLIENT ID NUMBER IS ENTERED, I need so that it will bring up a blank version
of that form I've created.
3. Now, for the SERVICES section: When a client clicks on the SERVICES
button, or whatever, I need it to bring up a BLANK version of the SERVICES
section of the form I've created so the client can add other services they've
requested.
I know this is a lot of information, but if someone tells me at least how to
GET STARTED, that would be a GREAT help because I am on a deadline.
Thank You Very Much!
(If you need me to give you any more information, just say so & I will reply)
Just to give you a little background information, this organization gives
money and housing services to clients who can't afford them or need them.
Now, I've already got two tables made - CLIENT INFO & SERVICES for that
client (just to let you know), and I've already made a form with client info
& each client's services.
I've worked with switchboards before but I am not familiar with the way they
want me to do this interface. Here's how it needs to be:
1. It needs to have 2 sections or buttons: CLIENTS and SERVICES
2. When I click on the CLIENTS button, I need it set up so that when I type
in a client's ID Number (which was automatically assigned in the CLIENTS
table I already made), it brings up that client's personal information in the
form I've already made (that way they can edit it if they need to). IF NO
CLIENT ID NUMBER IS ENTERED, I need so that it will bring up a blank version
of that form I've created.
3. Now, for the SERVICES section: When a client clicks on the SERVICES
button, or whatever, I need it to bring up a BLANK version of the SERVICES
section of the form I've created so the client can add other services they've
requested.
I know this is a lot of information, but if someone tells me at least how to
GET STARTED, that would be a GREAT help because I am on a deadline.
Thank You Very Much!
(If you need me to give you any more information, just say so & I will reply)