Recent content by tanya74

Thanks ash1123 for your prompt reply... I didnt use a select list or combo box because the number of patients is very large... Is that the right thing to do? I am still pretty new to Access. I did a bit more research and found I should be using...

Hi everyone, I am having some difficulty and I'm sure if I am just way off track or not!! I am trying to provide a form to allow the user to select two patients from the Patients Table. Each patient can have notes. I need to be able to move one patients notes to another patient. At the...

Thanks for your reply. I slept on it and realised that I needed to remove the SQLText function to the FindFirst when I use double quotes. rstCurrentPatients.FindFirst ("PracSoftId = " & Chr(34) & rstNewPatients("PracSoftId") & Chr(34)) Thanks again

Hi everyone, I am not sure if anyone else has had this problem but I am using FindFirst for a Id of a new patient as I would like to update the details if it already exists. The FindFirst does NOT find a matching record but I know it exists!! The Ids contain letters and punctation (legacy...

Both fields are set values by a third party product. Data is imported into this Access database. Ethnicity options are Y = Aboriginal, T = Torres Strait Islander, B = Aboriginal and Torres Strait Islander N = neither or unknown. Sex: unknown or blank. I would be happy just to just...

I didnt think Access would provide the locking functionality that my client requires. I have a two tables. Patients and Case Notes. One patient can have many Case Notes. The Patients table can not be edited by the users at all. All Patient records are imported. The users can only add Case...

thanks for your reply. Sorry I'm a bit confused still. I think I have the logic right. Just not sure about the functions I should use. I have included my code below so far and some of the logic. What is the difference between DBEngine(0)(0).Execute and DoCmd.RunSQL? I am leaning towards...

So I have attached image files... thanks

oh dear... the formatting is even worse then before...

Thank you for your reply. Sorry if I confused you with the formatting of results. Hopefully today it will be clearer. I have changed my query after your suggestion so now the sql looks like: SELECT [myDateTime], User AS CaseOfficer, Count(Description) AS Total FROM ( SELECT...

I need to produce a report listing how much users created a case note per month per ethincity and sex. So something like this So far I have the sql [/INDENT] I just have no idea how to convert to the desired result. Can anyone help?? thanks in advance Tanya

Hi... I am a little confused and hoped that someone here might be able to help me? I am creating am Access 2010 database to record case notes for patients. Only one user can read the patients details or add case notes to the patients record at any one time. I have created an extra field...

Thank you all for your help. I have the PatientStaging table populated now but wish to now compare the two tables and run either updates or additions depending if the record already exists or not. I am a little confused about how to do this. Can someone help? Do I create a loop or cursor to...

Hi, I am very new to Access 2010 so I'm sorry if these questions seem a little simple. :) I am wanting to update a table with data from a fixed length text file (programmatically). Some of the rows in the text file may be new, some old. As far as I can tell in my research... I have a few...