Search results

In the end, my (u) look like this: SELECT * FROM (table) WHERE ((((col1)=([Forms]![REPORT_ADMIN]![A1])) AND ((col2)=([Forms]![REPORT_ADMIN]![A2])) AND); How do i remove the last "AND" at the back?

Does that mean my sql should be something like this: SELECT * FROM (table) WHERE (u); then using my VBA coding for my button i will need to add the condition to the (u).

I have 20 criteria (yes/no). All in the same query, but at all time not all of them are need to filter the table. How should i compose my sql? Furthermore, i have made it into a form if the user want to use this criteria, he will check the box and choose (yes/no). If he did not check the box...

Thank you...

I have 2 options button, how do i know which one was checked or choosen by the user?

But i need to verify the value like (dd) has a value of 0-31, (mm), has a value of 1-12, ensuring a valid date is input.

I managed to change my format of a textbox that display date to (dd/mm/yyyy), but how do i change my input mask to the same format?

Thank you.. trucktime :D

I managed to make my login form been display upon the lauching of my access file. Now the problem is that database file control table (the one where we create new database, form and anything) is still visible. How do i hide it and only allow it to be shown is the user login as the...

I place it like this -------------------------------------------------------------------------- Option Compare Database Public SESSION_NRIC As String Private Sub Form_Open(Cancel As Integer) 'On open set focus to combo box 'Completed Me.cboNRIC.SetFocus End Sub Private Sub...

I should place it outside the sub procedures, right? But i try, but still cannot work.

I have saved it to the public variable (under the same variable name as my query), but it still prompt me to enter a value for the variable. :(

Ok. Thanks for the advice.. How do i do that? How and where should i declare a public variable ? How do i read it into my query?

The form is created from a query SELECT * FROM PARTICULARS WHERE ((PARTICULARS.NRIC)=[SESSION_NRIC]); How do i pass the id into the variable SESSION_NRIC?

Thanks it works... But how do i pass the cboNRIc.Value into the form?

My form should do the following: 1)When user choose their id (Eg: S8745215G) from a combo-box(cboNRIC) and enter their name in a textbox(txtName). 2)The system check to see if the name entered matches the name stored in the table(PARTICULARS) 3)If name entered matches the name stored in the...

:confused: I learnt very basic MS Access in school. Currently I have a project that states the following: It started off with a main menu where user will enter their id number while administrator will enter their id(known as admin). For user, according to their id number, the database will...