Search results

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

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

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

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

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

Hi Guys Can you help with the criteria for filtering a list box with date ranges on a form. Form1 has a list box with multiple fields, one of the fields is an invoice date, in Column(2). Form1 has two unbound text boxes: txtStartDate and txtEndDate. Also one of the options buttons that...

In my quandry, I am able to set up with code and query that I can select a product and then it will show the price dependent on the customer banding. i.e. select one product at a time. However, with 20000 customers and 300 products will be time consuming. What I am banging my head with is...

Could you answer a diabolical question? I am trying to track the changes of a record in a table when I have imported a text file. I will import a txt file everyday and to that end I have wrote the code for the insert of new records into customer table and customer history tables and then the...

Hi - This is what I am trying to do, any help greatly appreciated... i.e. Customer Table Customer History Table Import Table 1 Insert New Cust from Import Table into Cust table - Yes can do 2 Insert New Cust History from Import Table into Cust History Table - Yes can do 3 Update changes...