Button click event

[tijotomjoy]

Hi
im a beginner in microsoft access. I need to create an online movie booking application with front end and back end in access.
Created a login form for front end, but have no idea to program button click event. The main trouble for me is the query to verify whether the username is in table or not. Can anyone help me plss...

 

[JANR]

What do you want the button to do??

 

[tijotomjoy]

Hi
JANR thx for reply

On button click search the table 'Customer' whether the username and password is valid..

 

[rainman89]

Look at this thread see if you can use whats on there

http://www.access-programmers.co.uk/forums/showthread.php?t=126131&highlight=dvd

also if you want a login page then look here http://www.databasedev.co.uk/login.html

 

[ghudson]

Hi
im a beginner in microsoft access. I need to create an online movie booking application with front end and back end in access.

Sounds like a homework assignment.

 

[tijotomjoy]

Look at this thread see if you can use whats on there

http://www.access-programmers.co.uk/forums/showthread.php?t=126131&highlight=dvd

also if you want a login page then look here http://www.databasedev.co.uk/login.html

Thxx that link was helpful..
I have created all tables and forms needed to add data. My problem was the search through the database. Think the problem is with DLookup().
can u explain this function plss.. When i click the button nothing happens

 

[rainman89]

You would want something like this

employeepassword= DLookup("EmployeeUserPass", "tbl_Employee",  "[EmployeeUserName]= """ & txtName & """")

To get the user password

See this thread on changing a users password. You should be able to use the code on there to make a login form

http://www.access-programmers.co.uk/forums/showthread.php?t=189408&highlight=login

 

[tijotomjoy]

You would want something like this

employeepassword= DLookup("EmployeeUserPass", "tbl_Employee",  "[EmployeeUserName]= """ & txtName & """")

To get the user password

See this thread on changing a users password. You should be able to use the code on there to make a login form

http://www.access-programmers.co.uk/forums/showthread.php?t=189408&highlight=login

When i click the button it doesnt do anything. After i write the code, do i need to compile or do anything.

 

[rainman89]

Whats your exact code behind the button?

 

[tijotomjoy]

Whats your exact code behind the button?

Table : Customer
Fields: C_ID, C_pwd

 

[tijotomjoy]

Thxx rainman
it is working now..
there was a security warning and it was disabled.
donno just now i enabled it and it started working ...

 

[rainman89]

Happy to help

 

[boblarson]

Are you using Access 2007? If so, have you done this?

 

[tijotomjoy]

Are you using Access 2007? If so, have you done this?

Yes that was the problem. Now its fine...

 

[boblarson]

Yes that was the problem. Now its fine...

Good, glad we could help.