Search results

Thanks for that, I stepped through it but once it starts to print it tries to print all the records not just the selected one so I have to cancel the print

sorry arnelgp I know it sounds silly after using Access for donkeys years I've never used DoCmd.RunCommand acCmdPrint How do I specify the tray on the property?

Hi everyone So I'm trying to do the same here, my report needs to be printed on blue paper in tray 4 (don't ask I don't know why). So far I Have Private Sub CmdPrint_Click() Dim TempRpt As TempVars Dim TempNo As TempVars TempVars!TempRpt = Me.ID.Value TempVars!TempNo = Me.RMANo.Value On Error...

Thanks Pat that is great I will give it a try but it might not be for a while at the moment due to my work load. The Database is working after a fashion and the boss wants me to do my real job ;)

Hi Gemma Yes it was calling the cmdlg32.dll I think it was called Windows 10 doesn't support it

that's quite alright, I have yours running in parallel so I'm moving 2 loads at the same time, my network admin guy is doing his nut at the traffic lol

that seems to have done the trick, many thanks it is much appreciated

Hi Gemma Its a bit strange as my PC is a 64 bit machine but Access is the 32 bit version (others within the company have 32bit machines) and I didn't have a problem on my old laptop, running Access 2007 but who knows with Microsoft

that's Ok I do my testing with local copies of the spreadsheets from our repository, if it messes up I delete and re-download them again

slight problem, It creates all the folders but then copies all the files to the target folder only

That works a treat, testing it through and I've almost finished the first product range. Many many thank

Update to this, I opened up the source folder and found some early .doc test results, do I add cn.Add Replace$(s, ".doc", "") to the code? many thanks Cliff

arnelgp you absolute hero, that works like a dream, that has saved me days and days of work, I can't thank you enough

Thanks islasdogs, I found that with the autofill that VBA does and it works well. What I need to do now if figure out how to make a new folder in that view if the destination folder does not exist

It would appear that the Common dialog box I use is no longer supported and kills access when run - so this has been removed. thanks to everyone who looked it this for me

Hi Moke, how would I cycle through the source files? there are multiple excel spreadsheets in the folder. I thought I could use the common dialog box to select the folder name and pass it through, but Access 13 does not support the dialog box anymore. I've found by stepping through my old code...

there are no subfolders. It is structure as Name of PCB, then the serial number of the PCB that has been tested

could this be used to select a folder too?

Hi BDG no I haven't. I just wonder how to parse the names of the files to create the folders

Hi All So not really related to Access but I thought It would be quicker to do this programmatically then by long hand So what I'm doing is kind or related to a Database. We have board that we test and results are recorded in excel spreadsheets like shown in the Excel results image. What I...