Recent content by Simba

Thank you plog! That worked awesome! Here is my query. TRANSFORM First(tblPhoneNumbers.Phone) SELECT tblPhoneNumbers.ResourceID FROM tblPhoneNumbers GROUP BY tblPhoneNumbers.ResourceID PIVOT tblPhoneNumbers.contactsType;

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

Hi! I set up the security access. However, I have an issue. I setup secruity access only to a particular database. But the problem is, the logon window comes up, even if I open up someother database (that is other than the one, I set up security access). Is this how, this will work?

Mr.Pillai! Thank you. Your explanation and articles are good and I am implementing.

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:

Karl! I think you could do this way but still I am also on learning stage. tblExchangeRate RateType,Currency tblRateType id, description Then if you create the relationship, you might get the values. Anyone here to tell, if this is correct.

Thanks John and Jemma! I am able to understand a bit more about the combo box. I have a question now. I am having a subform. When I select a value, I want that to fill out the address details. I am able to do that. After selecting the value and when I move to the next record in the main...

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.:)