Search results

I have an Export button and this is the line of code that I use to export a record DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_DetectionTraining", strBackUpDogNameFolder & "\BackUpTraining.xls", True So logic says that I should be using...

Yup and it was made with Excel 2010

That was my first thought, but I dont have anything open!

OK Ive had a look and I now have some code in place Dim sSource As String 'The name of the file to be copied sSource = "c:\GPandDetectionDogTrainingLogBackUpsandReports\" 'Copies the files from Excel DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9...

I have a form with a subform. In the footer of the subform I have a combobox that get the filenames of excel spreadsheets from a folder. I have a button (no code on it yet) that I want to press and import that spreadsheet into the table for the subform and associate it with the main form. How...

OK so that creates a problem, if leave the ID out of the query, how does the query know which one to export?

Thats what I was thinking, how do I export the table but not that field?

I have the ability on my database to export one record to excel. The raeson for this is so that I can email the record to another person. The record has an autonumber ID. The person that I share the information with my well have a different record with the same autonumber. If they try to...

Can you give me a heads up as to how you do that please?

Im backing up all the tables into one spreadsheet, they get renamed like this: GPandDetectionDogTrainingLogBackUp 2014_05_19.xls GPandDetectionDogTrainingLogBackUp 2014_07_20.xls and so on. Unfortunaly this is how they appear in the combobox, what I need is for the most recent to appear at...

Sorting a list of Files I have a BackUp and Restrore from BackUp procedure in my my database. I can backup to a spreadsheet and the spreadsheets are renamed to include the date of the backup. When I restore from the backup an unbound combo is populated Set SourceFolder =...

Figured it out, it was the two strings sDest and sSource, tey wernt quite the same. Many thanks for your time.

Many thanks

I have a procedure to export a record to excel. One of the fields is a date field and its set at medium format i.e. dd-mm-yyyy. That is how it appears i the associated tables and form. I want to include that date in part of the exported filename. I created a string: strday =...

Nearly, its created the file, but now errors on the line: FileCopy sSource, sDest Run-time error '52' Bad file name or number The Immediate Windo shows this: c:\GPandDetectionDogTrainingLogBackUp\Training\Chester

I get this: c:\GPandDetectionDogTrainingLogBackUp\Training\Chester I'm not sure why its invalid though.

Sorry for the delay Here is the code from the Immediate Window c:\GPandDetectionDogTrainingLogBackUp\Trainin c:\GPandDetectionDogTrainingLogBackUp\Training\'c:\GPandDetectionDogTrainingLogBackUp\Training\Chester'\GPandDetectionDogTrainingLogBackUpTraining. xls...

Same runtime error

Well I just noticed one error, I had the wrong path, but Im still getting the same error! Code should be: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_DetectionTraining", "c:\GPandDetectionDogTrainingLogBackUp\Training\" & strBackUpDogNameFolder &...

Yes, sorry, Run-time error '3436': Failure creating file Each of the folders gets created (if they havent been already) but the actual spreadsheet isnt. I've complicated it a bit by each dog having its own backup (there is a reason for this. When I was puting all the backups in one...