Search results

Thanks a lot for all your help you have been a star. I read your post that you have had to change your username and i think i have found a way around it by changing my password. Worked for me.

Thanks for the code Bat17 that worked a treat don't suppose anyone knows how to put the headers on do they and also why the excel document will not open until access has been closed Cheers

Hiya, Just wondering if anyone knows how i go about deleting an excel sheet and then add a new one with specific headers ? I have spent 3 hours looking round this site with no luck either I am blind or you cannot do what I am asking. Cheers

Hiya, At present I am running a database which opens several queries and then I have to manually paste this informaiton into a spreadsheet. What I want to know is how do i go about pasting this information into a specific spreadsheet and then into the correct cell. I have had a look around...

Hiya, I have a database which on exit runs calls the following module and backs up the database to anther folder Public Function BackupCopy() 'This function will allow you to copy a db that is open, 'You must set a reference to the 'Microsoft Scripting Runtime' for the CopyFile piece to...

when i run this is works but then brings up "Run-time errror '424': Object required any ideas what might be going wrong Cheers

Thanks a lot that has worked a treat

Hiya, Bit stuck here but bet it is really stupidly simple I have the following code to export a query into a spreadsheet which worked fine but after I added the path name which is in bold it no longer works. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "NME With Company Code"...

Just wondered what was everyones opinion on how I should best included a graphic file (just for the eye it has no functional purpose). At the moment i have just pasted it in but it increases the size from 1mb to 17mb. Thank :cool: :) :cool: