Recent content by J3nny

:) Brilliant, thank you pbaldy, I'll give it a go now and no doubt be back in 10 minutes when I can't get it to work..

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

:) :) Thanks jdraw.. And Paul, I think Right() might be the easiest as I haven't shown it in my sample data but there might be (and probably would be) other spaces in the reference, I've asked users to enter dates in DD/MM/YY format so I'm hoping they stick to it, I did think about another...

Umm.. :) Yes you're right, I tried something which didn't work but was obviously doing something stupid, I think I maybe had CDate within the IsDate function as I thought it needed an actual date value. I've put in this...

Hi Paul, I tried IsDate, and it fixes the #Error issue, but it doesn't take the date from the text field, i think it looks at it but because it's just a string IsDate returns False and it continues on and takes DateAdded for every record instead. I've got a horrible workaround now that...

Hi jdraw :) Thanks, I know it's a rubbish workaround but it's because I'm using Access to query a 3rd party's database over an ODBC connection, it's the database of some very expensive financial software which should have a Received_Date field in the first place, which would be saving me a...

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

The option to mark as solved isn't there for me, so I give up. :)

Thanks David, I didn't know it was the same syntax and would work in either application, I actually just managed to get it working calling the Excel macro from Access, when I went to run the macro in Excel I noticed it refers to the macro as 'ThisWorkbook.SeasonTicketAnalysis', not just...

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