Search results

thank you speakers_86 its solves my problem. :):)

thanks speakers_86 for your reply. if i wanted to show only two specific Leave Type on my parameter query i cannot do it if i will use the bracket. Like if i will put on the criteria "National Holiday" and or "Annual Leave". Is there any way i can do this? thanks again..

I want to create a parameter query on the table i made. The fields on the table that i want to create a parameter is a lookup table (tblLeaveType), this lookup table has two fields one is the primary key(auto number) and the other is the type of the Leave example 1. Annual Leave 2. National...

i created a form to become my switchboard. i add a command button to open my employee form so the user can add another employee. when i click the command button i saw that all the records in the employee form was visible. how can i hide all the records and a blank record will see if i will open...

how can i create a form from the table EMPLOYEES LEAVE that when i enter data on the form i will not enter numbers corresponding to the ID of the table for example department ID instead of i enter the number 2 which is the id of INTERNAL MEDICINE i will see a list of all the department. hope i...

djossh you told me to have a foreign key so i add 1 more table so i can create a relationship. i attached again a file. if i will create a form from the last table i created how can i enter data for example on the DepartmentID that i will not enter the value 2 which correspond for example the...

i have five tables and i wanted to extract data out of this five table. the data that i wanted to extract is being shown below on the excell file that i will attached here. do i have to add 1 more table to create a relationship? hope somebody could help me..thanks.. :)

thank you djossh. i will try to create relationship for the table you gave me. :)

I'm a newbie here and also new to Access programming.I hope somebody can help me to normalize my table.. thanks.. :)