searching a table and creating an admin area

[ZahleServ]

Hi, I was searching the web for some access help and I found this forum so I registered directly to post a couple of questions. Actually i'm new to microsoft access and i own a small bookstore and i'm creating a small software to manage the books. I've created the books table with the field (title, author, edition, bookid) now i would like to create a form that perform a keyword search by title or author or edition (of corse it needs the correct query...) any help would be very appreciated to gain some knowledge and continue this piece of software. another question how can i create an admin interface with a user/paswd stored in a separate table so only the admin can add/del records to the table... coz i'm planning in the near future after i accomplish the work to make it usable by the visitors...

thank you in advance for ur cooperation.

 

[spacepro]

Hi,

Firstly for your search function do a search of this forum and specify the keywords "search engine". The topic has been covered many many times. You will find loads of examples.

Secondly as far as creating a admin area. There are several options for this depending on your database security, personally I prefer not to store passwords in tables but using code instead on opening of the admin area form. This is carried out through an If statement (Event Procedure) on Form Load.

So for example :

If Me.Text1.Value = "password" Then
Docmd.Openform "FormName"
Else
Docmd.Openform "RefusedEntryForm"
End If

Then change the format of the textbox (Text1)to password

Basically the above code will only allow access to the admin area (FormName) if the value is correct otherwise it will open a form (RefusedEntryForm) to tell the user they have been unsuccessful and then redirect them to where ever you want to send them.

I then password protect my VB code.
This is my opinion and possibly a few people on the forum may disagree but it will give you a start into how to go about it .

Do a search of the forum anyway you will find loads of answers to these queries.

Hope this Helps

Andy

 

[ZahleServ]

10x a lot