Search results

Further progress... Dim ReportDate As String Dim ReportDate1 As String Dim DDay As String Dim DMonth As String Dim DYear As String ReportDate1 = Forms![Start]![StartDate] DDay = Left(ReportDate1, 2) DMonth = Left(Right(ReportDate1, 5), 2) DYear =...

Further progress... Dim ReportDate As String ReportDate = Forms![Start]![StartDate] xlApp.ActiveWorkbook.SaveAs LPath & ReportDate & "GasReport.xlsx" Gets me the start date - but in the format dd/mm/yy... How do I cut out the "/", and preferably change the file name to yymmdd to...

Dim xlApp As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True xlApp.Workbooks.Open LPath & "GasReportBlank.xlsx", UpdateLinks:=xlUpdateLinksAlways 'Save as... xlApp.ActiveWorkbook.SaveAs LPath & "GasReport.xlsx" xlApp.Quit...

Hello again... More questions! I have a relatively complicated excel workbook where the information is pulled from data from an excel book created from multiple queries. That sounds a lot more complicated than it is, but basically to get the data into the required format my final book links to...

Can you see the ongoing thought processes? So now I've worked out how to append data to my master table... But how do I only add entries that have not been previously added? Rather than having to delete everything and then add all of the data again.

And I have googled it, but couldn't find an answer. If I've missed something obvious I do apologise!

Hi, Hopefully there will be a simple solution to this problem... Due to outside constraints on my design I have a set of databases from external sources, all with the same tables. Currently I have them all as linked tables in my master database, but what I want to do is take all of the data from...

Cheers! I'm sure I'll be back with more questions soon enough...

Hi Peter, It's running from a command button on a form in Access 2010, I'm running Windows 7 Enterprise. I take it I'd have to make a trusted location for the database on every computer that it runs on?

Right... I'm creating a table in another access database (which was created earlier in the code), and I'm getting an Access Security Warning every time. When the code is executed it creates 7 new tables, and so the user gets 7 consecutive popups. The text is (can't copy/paste): A potential...

Thanks a lot... That's cured it all! Learning all the time.

I've cheated, and got the first button click to open a form with 'Data Ready to Send' and an Ok button, which then closes the form and sends the email. It's not the most elegant solution in the world, but it works. If anyone has a better way of getting around this then I'd be pleased to hear it...

Thanks for the response, just tried DoEvents, no change :( Also just tried making the email creation part a seperate subroutine, and calling it from the original process. No joy either...

On further investigation it seems that the new database is still open when the code tries to attach the database to the email. I've tried putting a pause in the code (tried up to 10 seconds) after the last export command, but that has made no difference. Is there a command to close a non-active...

Hi, I'm pretty new to Access, and teaching myself as I'm going along, so any help will have to be explained in simple terms. Sorry. To the point... I'm trying to get access to export my tables to a new database, attach that to an email, send it and then delete the file once it's been sent...