Search results

Hello everybody, I've managed with the help of these forums :D to creat a search form, howver how do i get it to update for the next search results. For now it gets all mixed up. Private Sub srchBtn_Click() Dim dbs As Database Dim rst As Recordset Dim strsql As String Set dbs = CurrentDb...

Hi Gurus, I've a table visits in which am entering data...however I've searched for a way of having a value repeat to no avail. On one fo the forums (dont remember which) I got this IIF(IsNull(Height),DLOOKUP("Height","tblVisit","Height"),Height) but it is not working. What I want is when I...

Hello, I've two questions. I created an access login form for username and password right, and its OK. My question is? Is there a way I can get to track the login dates and times? 2ndly how would I create a button for new users... I've already entered some two users. I need to create some...

Hello again, I come back again with yet another three part question. I would like to be able to generate unique id for my database. Is it possible to do this using fields that exist in the database; say I've District, County, Parish and Village... that have codes as 01 01 01. I would like an id...

Greetings everybody, I'm trying to transfer a community clinic's data form paper based to computer based using access database. Basically a patient has many visits to the clinic, during each visit a number of investigations can be requested by a number of doctors, and they get treatment (many)...

Hi Guys, what could be the probelm with my query? Here: ****************** SELECT tblPartnerProfile.PartnerType AS [Org Type], tblPartnerProfile.PartnerName, tblPartnerProfile.PartnerLoc1, tblPartnerProfile.PartnerStatus AS Status, Count(PartnerType) AS TotalType, FROM tblPartnerProfile WHERE...

Hello there, I'm trying to develop a database for an organisation for their partners....see attached. I would like you to take a look and tell me if what I've done is the right thing. Secondly, (I'm just learning Access) I would like to have a query that give a count of 3 how many CBOs, how...

Hi Everybody, I've a question that is teasing me. How would I create a multivalue/multiple answer field in access 2002. P'se forgive if this question has been asked before. Thanks in advance, Samia

Hello Everyone, I've data already entered (access/tables) on two different computers, however for the clientid on one computer has a hypen (-) and on another - because of something they couldn't get the hypen to work - so they used the slash (/) my Q is: 1) can I search and convert these to...

Hello Everybody, I thank you for this great resource. It's helped me a great deal on my project. Now, my problem is: I want to have a fully fledged DB system with reports and all. I know DB development is a process and that I'll keep adding more tables. However, for now I need to get this DB...

Hello Everybody, Please advise. I have created a main form with a subform for data entry. After data entry into the main form it continues to the subform for data entry. Am I doing the right thing. What I want is for the demographich data to be entered in tblPatient (main form) and tblHistory...

Hello Guys, I appreciate all that you're doing and thank you for your time. I would like to transfer pateint information from cards to access. I've so far managed to come up with the following tables. Please correct me if am wrong. tblPatient PatientID - PK RegistrationNo (patient no on the...