Search results

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

Hi Guys thank you for your suggestions. I had a bit of a brain wave insomuch as I created the percentages as a subreport and placed them at the bottom of the Chart with the totals in. Once again thank you for your help Cliff

I will try to get an hour or tow over the next few days to have a real good think and see what I'm doing wrong

Hi DbGuy Yes I've added them however my Maths is a bit messed up as I keep getting 100% or I'm referencing the field incorrectly. I'm going to be busy for a day or 2 doing image analysis so it doesn't mean I have forgotten you...

Hi DBGuy I have created a second query based on the crosstab with just the row totals, but I really want the percentages to put on a bar chart - does the charting tool allow you to do that when you make a chart?

Hello Everyone My main customer repairs database has a table for cameras with information like serial number, series, model, sensor type, memory and any additional configuration. I've made a crosstab query below (not got much experience in these) that gives me the result of the camera series...

The problem is you are binding your forms recordsource to the query. I normally use a list box and requery the list box for the search like the alterations to your form attached. Its simple and works to a point or searching on the first name only. Hope it helps