Search results

try this link I had the same type of problem and was fixed be the good membershttp://www.access-programmers.co.uk/forums/showthread.php?s=&postid=140029#post140029 hope this helps Steve

Thank for that but the problem is the unique aspect of each record as sometimes the order number will appear more than once ie failed delivery and 2nd attempt etc. (the updated fields show the date, time and comment of each event) Steve

I import daily 2-3,000 records from a text file received by email from our main server and then import the records into my database, each record consists of 20 fields abd the updated data is contained in 3 fields which are updated on the main server as the day goes on. I need to update the...

Thanks for all your help, I can only think the printer defaults must be overiding the code but thanks anyway Steve

Well thanks anyway regards Steve

Thanks but I tried True, False, 0, -1 , 1 but it just seems to make no difference. Steve

Ok I tried using the help and whilst I found the section I still cannot get the printouts to come out as non-colleated (False) below is the section of code which should print 2 copies of each together and then the next page. DoCmd.OpenReport "PlanningReport", acViewPreview DoCmd.PrintOut...

This now works great and I ask only one more question, when the notes printout can I insert a command so as the indivisual notes are colleated together, I can do this with printer controls but can it be built into the print options?? thanks Steve

Great, thanks a million Steve

Sorry to be a pain and thanks for the help, but the program now prints 1 copy of the selected report page and two copies of the form where the commond button is located. Steve

Private Sub Command12_Click() On Error GoTo Err_Command12_Click Dim stDocName As String stDocName = "PlanningReport" DoCmd.OpenReport "Planning Report", acViewPreview, , , acWindowNormal DoCmd.PrintOut acPrintAll, , , , 2 Exit_Command12_Click: Exit Sub Err_Command12_Click: MsgBox...

Thanks but when I use this I am getting an error "wrong number of arguments or invalid property assiognments" any ideas? Stev

ptint out Thanks, I have amended the sample as below but where do I use this? you'll have to excuse me as I can work around the basic OK but I not sure just where to put this. DoCmd.OpenReport "Planning Report", acViewPreview, , , acWindowNormal DoCmd.PrintOut acPrintAll, , , , 2 DoCmd.Close...

Is there an option to select how many prints will be printed from theaccess options I would like be to print 2 or 3 etc copies, I can do this through the print dialouge but can I select this option anywhere in the access options? Steve

Magic, it was the force new page which I could'nt find thanks Steve

I have a report where records are grouped by one field (order number) and I would like to print all the records under that order number on seperate pages totaled etc. for each order number. Where do I specify this, I have tried the sorting and grouping options but dosent seem to work, the...

thanks, sorry for being so thick Steve

thanks for that but what exactly do you mean Steve

I know this will be a simple soluation for most of you but any help for me would be appricated. How do I prevent spaces being entered in a feild withot having to speicify the exact validation rule. thanks

I have a DB that we import data from a spreadsheet every day. The spreadsheet can be of serval different names. I have a macro which can and does work well as long as the spreadsheet file is saved in the correct name. Is there a way I can use a wildcard to select which file and which sheet...