Search results

Finally i sorted out.. It was with the quotation marks.

The trouble i think is with the date and time fields.. It is not checking it..

Hi, Im using a dlookup query and it gives a null value everytime. DLookup("[N_seats]", "Allocation", "[M_Name] = '" & Me.str2 & _ "' AND [A_date] = #" & Combo33.Value & _ "# AND [A_time] = #" & Me.str1 & "#") A_date: date type A_time: time type Combo33.value is a date and...

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

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 ...

Table : Customer Fields: C_ID, C_pwd

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

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

Hi JANR thx for reply On button click search the table 'Customer' whether the username and password is valid..

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...