Recent content by evanhughes

Thankyou for the speedy response. I see what you mean and if I add the table2 to the query it returns hundreds of extra records all the same. How would I use a DLookup in an if statement. Not something I have done before. Could you possibly give me some code. Evan

Hi All I have a query to which I need to add a charge. The query is based on table1 but the charge is only added if a yes/no field in table2 is true. This is what I have tried but it does not work. Charge: IIf([Table2]![Field1]=True,Format("25","Currency"),Format("0","Currency")) Any...

Brian Thanks for the quick reply. The code is attached in a text file. Evan

Hi All I have a macro which deletes line 2 of a csv file and converts all values in existing cells in columns K to AC to a currency format. This works well. What I need to add is code to check column D and if cell value is "OWO" then modify cells in columns K to AC in same row to 0 (zero)...

Dear Bob The forms work ok in access 2010 on win xp but when run on win7 sp1 with access 2010 i get this message. Runtime error 2683 There is no object in this control. And the debug shows the following line (coloured red) as the error. Private Sub Combo7_MouseDown(Button As Integer...

Dear Bob When selecting the date field instead of a calendar popping up I get a debug message for the vba code that loads the message. Is there some setting that disables vba like macros in excel. I have no idea as it works fine on all xp machines with access 2007 and 2010 just not the one...

How do I change the following criteria. Charge: IIf([UnitCode]="P005",25,55) I need to apply this criteria only if it is not equal to [table] [field5] is not equal to "can" and if it is equal to can then value will be 0. Can't get my head around it. Evan

Hi all I have a database created in access 2010 on win xp. I have calendars on some forms that pop up when date field selected and it works well. My problem is that on new machine with windows 7 and access 2010 you get a debug message pops up when date field selected but is still fine on xp...

Dear Boyd. That could take some working out. I have never used sub reports but will have a go. Any suggestions on where to look. Evan PS Have a good weekend.

Dear Boyd I am sorry to trouble you again but I have another question. Management has asked if it is possible to show values in the report footer. I would need to show the subtotal of each unit code in a text box and show it with certain ammounts deducted. Lets say when report is run I need...

Dear Boyd Thank you very much for all your assistance. All is working well now. I very much appreciate all your assistance. Kindest regards Evan

Thanks Boyd The only issue is it does not total each unit code report but totals only all reports togrther on last report. Evan

Hi Boyd Here is the database. And thankyou for the assistance. Evan

Dear Boyd Here is the database. And thankyou for the assistance. Evan

Hi Boyd I hope this finds you well. I sorted out the batch print routine and it works fine if only one selection is made on the form but if multiple selections are made it won't print the reports individually but tries to combine them all together as if running one report without separating by...