Search results

Thanks John, just what I was looking for!

Hi All I want to do an unmatched query, but first I need to set up my criteria. I have a date field and I need to find Max of Date Field which I can do with a Totals query. I then want to find records with a Max of Date Field - 7 days, this is where I am going round in circles. Then I will...

Thank you Kafrin, really appreciate it!

Hi I have managed this part of the code: Dim i As Integer Dim lngLen As Long Dim strWhere As String For i = 1 To 11 If Me("chk" & i).Value Then strWhere = strWhere & i & "," End If Next Me!txtMedical = strWhere lngLen = Len(strWhere) - 1 'Without trailing comma If lngLen > 0 Then...

Hi All I am trying to concatenate 13 checkboxes into a text field for reporting. I know that I can add the following to the ControlSource ID on a text box in the report. =[BloodTest] & (", " + [BowelPrep]) & (", " + [DietReq]) & (", " + [MedReq]) Though what I am wanting to test is the...

DOH! It's amazing what some sleep can do for you... I have stopped trying to recreate the wheel and added check boxes.. All learning is worthwhile even if you spend countless hours trying when working to a deadline - tongue in cheek!

Thanks VBAInt for your previous help on another post that has got me this far. I have an appointments table and I now have set up a many to many table for the multiple medical instructions for each appointment. On the main appointments form there is a subform that allows the user to select from...

Thank you vbaInet, just what it needed. Have learnt for next time, cheers.

Hi Guys Can you look at my code and tell me where I may be blind! HospitalSiteID is a text field and PatientID is an autonumber field. When I break the criteria down it is fine but when I have multiple criteria using And then I get the datatype mismatch error. I am thinking it may have...

Hi All I have a grouped report that I want to display page (n of n) page 1 of 3. I also then want to display page headers on the subsequent pages of the grouped report but not the first page. I.e. Whole report as 10 pages, made of three grouped reports. Report 1 - Page 1 of 3 -...

Hi I am a trainer, and have found all sorts of problems when running both together in a training environment in 2007. I now run separately to avoid issues...

Hi All Just wanted to post this ref. audit trails. I have been banging my head on this one, though as always the simplest solution seems to prevail!! I kept getting the runtime error 3251, after much deliberation I have found the reason, two of my forms are built on tables and one on a...

Thanks Guys... I guess it is as you say Banana not without its problems as I have found out... Will return to opening a form. Thanks for your input..

Hi Pat, thanks for your reply. Though this is not what I am after, if you have a look at the sample db, I can write a new city to the combo box on the form, by entering the data into the combo box and then it displays a message box to confirm that I want to add a new value. But the combo...

Hi Guys.. I need to be able to write data to two fields using the not in list event for a combo box. My form has a combo box that has set the row source to display the city and country field from the tblCityCountries. I can achieve writing the data to the city field, though also want to...

No Worries.. A property not used before, as below. Figured that conundrum.. Me![YourComboBoxName].Dropdown

Hi there.. Got me stumped, sure it is so simple.. I want to expand the values in a combo box when users are entering data, so that they can view multiple companies with the same name and different cities and then add new companies if not exisiting. This is the same as when you press...

Thanks awfully... Will no doubt call on your services again...

Finished Sorry, seem to have answered my questions. Thanks for your time. How do you close a thread?

Found the error Hi I have worked out the error that I was getting and changed the line to look for a blank field in the txtEndDate. So many thanks for your original code. Though have come up with a new question if that is OK? My dates are in English format. Though when I filter on date...