Search results

I have a table like this. Source ID contactType Phone No. 1 Office 1234567 1 Hotline 1234567 1 Fax 1234567 1 After Hours 1234567 My...

I have a form, in which, when the user enters the zipcode, it should obtain the relevant city, state and county from the table. After entering the zipcode, it gives out an error 3061 and highlights as below: Set rstAny = dbAny.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges) The...

I have an access 2003 database with front end and back end. The backend is in a server and a copy of the front end, in 20 users' pcs. The database has information, about the resources available and I am planning to give write access to 2 persons for making new entry / edit. There is also a...

Hi! I have developed a database and attached here. Kindly review my relationship diagram and suggest me the ways to improve the caller tracking part. Each resource / service will have many caller. Each caller will have a family. The caller should be searchable and retriveable. Should a...

Hi! I have a database and I am creating a form, where user can search from the list. Herewith, I have attached my search form. I got a search code from the net, which I am trying to make it work. As I am not very much familiar with coding, can any one figure out problem and make the search...

I have added an add and delete button in a sub form to add/delete a new physician. The problem is, when I delete the record in the subfrm, it is deleting the main record of the patient. Can anyone tell what is wrong with the button?:confused:

I am an access newbie and I have created multiple subforms. When you select sfrmGeneticCenter and populate the data it is not filling in. Kindly look into the attachment and tell me what is going wrong. Help is highly appreciated.:)