Search results

Hi vbaInet, Thank you for taking time to respond, much appreciated SELECT Count(*) AS CountOfMembers, [ABHno] FROM HHDetails GROUP BY [ABHno] HAVING Rel2hd='Head' OR Rel2hd='Spouse' OR Rel2hd='Partner' OR Rel2hd='Child'; However, when I run the above code I get the following msg...

Guys, So far, no responses <sigh>.. Is it that difficult??? Will

BTW I'm using Access 2007 Thanks

Hello everyone, I have a table with data on household members and their relationship to the head of the household. Each record has a field ABHID which comprises of the AREA CODE [2], BUILDING NO[4] and HOUSEHOLD NO[2] eg. 02014401 where AREACODE="02" , BUILDING NO ="0144" and HOUSEHOLD NO...

Hi Everyone, I need some help with this problem. I have a form with which I enter patient info. Patient will normally visit once per year. When a patient visits, I would like to enter the patient's ID on the form and then search the DB for an existing record. If the patient already exists...

Thanks a million, I used the crosstab query to get it done... Appreciated

Hi everyone, I'm wondering whether this report can be done, if it can, I'll appreciate any help if getting it done. I have a table with approx 10,600 records of patients with cancer. The fields are - County, Village, Year, Site There are about nine (9) counties, each with up to 15 Villages...

Thanks for the tip Gemma Appreciated Will

Yep Brian... I could have saved myself a lotta frustrating hours trying to figure out why it wasn't working... :o Thanks again everyone. Will

Ryan, What I'm working on is a scheduling/appointment module for a screening application. The patient comes in for a test, is examined and the patient demographics and examination data is entered. At this point the appointment module is selected to schedule the patient's return to collect the...

Hi Everyone, PROBLEM SOLVED!!!!!!!!! Apparently I was using the variable name 'dtdob' in a sub to calculate age and the same variable was declared as the public variable... Whew!!!! :rolleyes: Thanks a million, Appreciate all the help. Will

Thanks Gemma, Hmmmm.. Up to this point it's ok i.e. the dob entered is stored in the public variable dtdob dtdob = Dob MsgBox "date of birth = " & Dob MsgBox "public variable date of birth = " & dtdob Then I click on a button in the data entry form. In the on click property I again display...

Thanks guys. Ryan - thanks for the tip Brian - yes it's an error, it has been changed After changing the date format to short in the form and the table, I'm now getting the date to be 1899/12/30.... Dunno what's going on here!!! :confused: Help.. anyone??? Will

Hi Ryan, Thank You, it worked great. One problem though, instead of storing the date of birth, I'm seeing this value... 12:00:00 AM. Any idea what's happening? I use this statement to assign the DOB entered to the public variable /********* dtdob = Dob MsgBox "date of birth = " & Dob...

Hi Moniker, Thanks so much for responding.. I changed the VALUE clause as suggested, but when I debug, I'm getting a syntax error... /******** DoCmd.RunSQL "INSERT INTO tblappointments ([apptdate], [patientno], [pfname], [psname], [address],[dob]) VALUES ("#" & [cboapptdate] & "#, '" &...

Hi everyone, I'm trying to add a record to a table using the SQL INSERT statement, but somehow it's not working.. I have declared in a standard module some public variables, which are populated during data entry. After the data entry, I want to save a record using the public variables, but...

Thank You!! Hi Jon, Thank you so much, it worked wonderfully... Appreciated, Will

hi everyone, I have a table with persons age and location and I want to generate a report of all persons by location and age group. The age groups are 0-9, 10 - 19, 20 - 29..., 90-99. The location codes are 10,20,30,...90,99. Any suggestions? Many thanks Will.

Hi Paul & Rainman Yep.. it was a typo..... Thanks so much.. it works just fine now... Much appreciated Will

Hi rainman, Thanks for your response. I tried it but it still does not work.. Here's the code I'm using.. '*************** Private Sub DateTstReslt_AfterUpdate() If IsNull(datetstresult) Then Text7 = DateDiff("ww", [DateSmearSent], Date) Text9 = "Outstanding" Else Text7 =...