Recent content by JoeAcess

hey thanks that worked :)

Hello everybody I made a form where i need to take a name by giving just the id. So i gave the Dlookup commnad but there is an error "data type mismatch in criteria expression". Can anybody please help Private Sub Command97_Click() Me.PtName = DLookup("Baby_Name", "tblFollow_up"...

Hi everyone I am using access 2007, I have a form "FrmBorrow" where i enter all the details of book borrowed from the library. Now i have another form "Frm Defaulters" in which a query is placed which will show all the defaulters. But the Form is in a datasheet view. Is there any way i can...

Hi everyone I have a form called stocks which contains many fields. there are 2 fields of interest, current stock, ordered stock. Now suppose i have a material called pins, I would have entered the current stock and ordered stock. now suppose i want to enter the current stock later and the...

thanks guys

how do i code it under "on exit"

Hi everyone I have a form in which i want all the enteries to be made in caps... Can i Make sure all the fields is entered in caps lock. How is this done?

Hello everyone I have a text field with size of seven. Its actually a hospital number field. the thing is whenever i enter the hosp_ Num i want the number to have a R at the end of the number without being entered.... the actual size of the number is 6 digits. Add the "R" and the size becomes...

The appointment is given to particular person for a particular day at a particular time slot. I can't base it on a primary key. Because the same time slots come for the next day.

Hello once again I use access 2007 If i have a subform which is in a datasheet view, can i have a row have specific colour according to a particular condition Suppose a row has got a field called availability and if the filed is "yes", i want the row to show green else red. Can this be...

Hello everybody I am a newbie to Access. I creating a form called appointments. There are appointment slots between 1 - 10 for a particular day. As i enter the data if i put slot number 2, i need the computer to respond to me if the slot is free for that particular day or already entered. If...

the following is the command that i used to fill the data when the data type of empno was number in both the tables Me.Staffnam = DLookup("staffnam", "tblstaffdetails", "empno=" & Nz(Me.EmpNo, 0)) But i changed the empno to text because it was not taking zero in both the tables. then i changed...

hello everybody I have an emp no which can start with zero. i put the data type as number but the value zero is not taken at the beginning. now i have changed it to text. but the problem now is that i was using the dlookup command to get the rest of the data now since i changed it to text its...

i just want a sequential number for each record of data that appears on the report. starting from 1 it should continue till the end of the report, doesn't matter how much ever page it is. Also since you asked how do i limit my numbers to one page and start afresh for a new page? No permanent...

hello everybody how can i have a serial number in my report.. isthere a fn??