Search results

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

Thanks you for helping, since i am new to it, i was wondering whether you could tell me the meaning of a junction table. Also if the patient have two of the same test how is it possible to add as it is the primary key and it wouldn't allow you to duplicate. also what kind of conncetion should i...

Hi I creating a database using VB 6.0 as front and access 07 as back.I Have a report called "rptmonthly" made in my access. the database is in mdb format. How do i give a command button from vb 6.0 to display that report. thanks

Hi everyone I am using VB 6 on the front end and access 07 at the back. i have a form. The form contains patient details. the pat id is the primary key. so one form per patient kind of thing. It also has two fields called test and test result. for a patient there might be atleast 3-4 test. so i...

Hi everyone I am using access 07. i have a form. The form contains patient details. the pat id is the primary key. so one form per patient kind of thing. It also has two fields called test and test result. for a patient there might be atleast 3-4 test. so i would like each test to be entered. i...

hi everyone. I made my report and when i run it, i get the data . the problem is that if i i more than one page, my page skips before getting printing out the second page. To make it more clear, if i give the print out after my first page is printed properly then the second page is blank, then...