Search results

Are you an alien ? That code works perfect with a little tweak. Thank you again for your help !

Thanks for your help Gasman....i understand it's difficult when your doing this from a distance. Good advice for my next project

Sorry Pat i know you guys don't have a lot to go on and yes, this database is old and badly designed but i'm not guilty on that count. I'll definitely keep your recommendations in mind thanks

Thanks for the suggestions guys....we're having a little trouble with our shared drives at the moment so i can't open the database to make any changes.

Ok gave it a try and it's grouping by the customer but not totalling the amount of times they didn't pay. I'm also getting a data type mismatch error when i run the query now.....i'm counting on the OrderPaid field. I should also mention that there are a couple of criteria also in the query...

I did try that and for some reason it won't group the totals together. My results look like below Apple Phones 1 Apple Phones 1 Apple Phones 1 Samsung Tablets 1 Samsung Tablets 1

It's just haven't paid on time. There's no allowance of a particular amount of days after the delivery date....so it's "Paid by delivery date" (Yes or No)

Hi Everyone, I've got a really old database (customers and orders) which only has one table, but it works so i'm going to leave it as it is. I've been asked to add a query which counts how many times each customer hasn't paid for an item on time. The table is roughly as follows RecordID...

Wow....working perfectly. You are a genius Mr Arnel....thank you very much. Also, thanks to everyone who took the time to make a suggestion. Much appreciated Em x

I've changed it and the calibration subreport is blank. I've attached the change so you can see if i did it right

Thanks Arnel.....there was already some code in the OnCurrent event of that subform so i just added that code as a new line. Is that ok ? I added the other code to the Calibration subreport properties (attached)......is that what you meant ? When i click the print button now i'm still getting...

I checked both subreports and the master/child link fields are set to EquipID Each piece of equipment may have several calibration records in the subreport and these are what's printing. So for example say that a particular piece of equipment has 10 calibration records, these are what's printing...

Mike.....the screenshot doesn't show all the fields in the Standards table. Each piece of equipment has a manufacturer but each standard also has a manufacturer. Each piece of equipment also uses a certain standard. The Standards are also completely unrelated to the Calibration records. Confused...

Yes i'm sorry....EquipID is always a letter followed by digits. The report is opening up ok now but the subreport displays all the records and not the one i'm viewing. For example....i might need to print off the subreport record from a year ago and so i need that one to appear on it's own

Ranman....i get a data mismatch error on clicking the button

Arnel.....i've added the code and when the button is activated i get a pop-up message with the EquipID value at the top (attached). If i enter that value into the parameter box then the report opens fine

Hi Everyone, I've got a main form (frm_AddEdit), a related subform (frm_subCalRecords) and a second subform (frm_subStds) The main form is related to both subforms using the PK field 'EquipID' I want to put a 'Print' command button on the main form which will print the contents of that main...

Thanks for your help Isaac......much appreciated. Thanks also to Ranman and Arnel....you guys have dug me out of many a hole (y)

Thanks Isaac....this is actually an Excel sheet i'm working with so don't think the Access commands will work :)

That worked great thanks....do you know if there's something i could add to the code to make the database open in a maximised window ?.