Search results

Hi! :) I have ventured into VBA for MS Access and am regretting it already. :) I've got a macro which deletes sheets in an excel spreadsheet and then exports data to excel, then kicks of a macro within the excel worksheet which opens another spreadsheet, saves the file and does some other...

Hi, I'm very stuck. :) I'm working with a table of financial transactions. I need to know the date a record relating to cash received actually arrived in our bank, but the software doesn't allow the user to enter this, so I've asked them to enter it into a text reference field, e.g. 'Other Text...

Hi, I have a Sub in Access that runs a macro in Excel, I had a bit of trouble getting it working and now despite working 90% of the time every so often it crashes my database at the point of running the Excel macro, so I'm trying to get the excel macro to run in Access to save it trying to jump...

[SOLVED] Run-time 1004 Error When Trying To Call Excel Macro Hi! I've been rummaging about online and trying to solve this for hours now and I've finally given up in the hope someone more endowed with brain cells can help me out.. I'm working in Access, and I have a few reports that I run and...