Search results

I promise this is to ethical ends!

Hi Minty, I can't believe I never replied to say thank you. Yet, I didn't. So... thank you! I was moved away from this project in a stupid rush at the time, by way of explanation. Anyway, am back now where I belong (in space?) so will proceed with this :)

Hi UncleGizmo, in the unlikely event this becomes a thing, I've created and attached it! No what's needed is for slightly more down to earth reasons. Thanks Minty, I will look that up tomorrow and who knows I may reply before you.

That's great thanks Minty. Of course, it's flawless (except the If line but I've annotated that out as it won't ever happen). I can see the spaceship names safe and sound in the immediate window as the code is stepped through. Now I'm trying to export the cargo records for each spaceship to...

Thanks Uncle Gizmo!

Hi Minty et al, thanks for taking the time to help. Hope this message gets to you through the space debris. Let's see if I'm following you correctly. I've saved a SELECT DISTINCT query to return each SpaceShipName once and its EmailAddress. It's named qryselectdistinctSS . Hopefully that's the...

...but I do use Access day in, day out, at work! Hi, my real name's Leo. I'm a renewable energy analyst and have been using Access, SQL and light Access VBA for a couple of years, and heavy Excel and Excel VBA for a few more. I never considered my Access and SQL knowledge as being good enough...

As a low ranking member of the Space Federation, I'm looking for an automated solution to export different selections of an Access table to a unique file for each selection. The difference with each selection is the value in one of the fields of the table. There needs to be as many files...