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

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

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