Recent content by Trash_Bandicoot

You. Are. Amazing. Thank you for the help!

I appreciate the response and suggestion! So would this be updating the query prior to defining it as the recordset? I'm trying to wrap my head around what's actually happening/not happening and how I need to incorporate it in the code.

I'm sorry yes I've got my wires crossed! It remains open the entire time.

The form is actually "Late Report: Database Search" but yes it remains open, and my excel doc opens but then I get Run-time Error 3421 and when i debug it points towards the following line of code. Set rs = CurrentDb.OpenRecordset("Shift Date Data Export")

I just need it on the first/only page of the workbook. That (for each ws) section dropped the data into every sheet so instead of finding a fix i just deleted the other sheets... (again im not great and this is largely Frankensteined so I improvise :D) The SQL works fine on its own (I actually...

I've been fighting this code for some time now and its finally broken me... I'm trying to export the data from my database to specific cells in a specific workbook. I was able to do this just fine until I took it one step further and created a query with perimeters dictated by form to act as a...

Hello Everyone! Just like you, I'm a veteran Access user who definitely didn't just join because hes no idea what hes doing and is now stuck on a problem... Totally the case. Browsing this forum has been a huge help so far, maybe one day I can make some sort of helpful contribution! Maybe...