Task for Advanced people.

[NickyThorne]

Okay.

I have a database that stores information on customers of Llandaff hotel. I have one table called Member Redemption. This is the main table that stores fields such as First Name, Address, Points etc.

What i want the customers to be able to do, is too see the details of their account. For example, how many nights they have stayed in the hotel, how many points they have, and what vouchers/gifts they have bought/recieved (these are also fields in the Member redeption table). To do this, i want a login for to be displayed when the database is opened, and i want the customers to be able to login with their Card Number (Primary Key) and a password (field in Member Redemption table). When the user has supplied legit information, i want a Report to be displayed, with the details of their account. It is at this point where i run into difficulty.

When the user then closes the form, i want the report to be deleted. In addition to this, i want a "create user" form, that will allow me to add/remove users and customers easily.
I wish to have admin accounts also.

Is anyone capable of creating such a thing?

Here's the link to download the relevant tables. (Was too big to upload)

http://rapidshare.com/files/166311716/Database.zip.html

Thanks in advance.

[Allan Murphy]

For a login screen have a look at my example at http://forums.databasejournal.com/sh...ad.php?t=45488 about message 43 for the latest version.

Is it possible to save your database in Access 2003 format as most users are not using Accees 2007?