Search results

Hi, I am currently using transferspreadsheet to send a table to Excel. Currently, my code appends the current date (using Date) to the filename. I would like to have the current time appended as well, but when I use Now function, it fools up the filename because the time has colons in it...

I would like to adapt the code above, however, I get the same error that the original poster says he/she had. The poster appears to have fixed it ("Duh - I forgot to set the sheet"). I would like "set the sheet", but I don't know what this means. Can anyone help? Thanks, Vince

I'm not sure how to do that either. I'm good at automating Excel, however, I have no idea what to do with Access.

Hi, I would like to transfer records (all of them) from a table called COA_LOBJ to an Excel spreadsheet that is created by way of VBA. Here is the code I have so far (pilfered - I'm trying to adapt it). What you see below is the code to create the table and add titles in the first row. Now...

I found MY error. When I said I followed the instructions to a T, I meant that I had ASSUMED that I followed them to a T. I forgot to cut an paste one line of coding. Sorry to waste your time.

I followed the instructions on this page to a T. The major coding is provided in a link on the page http://allenbrowne.com/AppAudit.html The major chunk of coding is provided separately in a link on the page http://allenbrowne.com/AppAuditCode.html

Hi, I have successfully (for the most part) gotten Allen Browne's method of creating an audit trail. The issue I am having is that the audit log table should indicate in the "Audit Type" cell the word 'INSERT' when it's a new record that was added. I'm just getting the word "EditTo". Usually...