Search results

Gale - in the future when you import data from Excel, I've found the best way to control exactly what gets imported is to assign a named range to the cells you are importing. You can do that by selecting all of the cells that will be imported (don't include empty rows below or empty columns to...

Given that Microsoft is now defaulting installations to 64 bit, I'm revamping some 32 bit code to work in either 32 or 64 bit installations. I vaguely recall once reading that users should all be on the same platform - does anyone know if this is the case? As long as each user has their own...

Sure enough - the new version of the database used the asterisk wildcard in one of the base queries, which wasn't needed in the old version. Thank you pbaldy, and thanks dBguy for the outreach!

Oh gosh - I forgot all about the % as the wildcard with ADO. The Where clause gets dynamically generated, but the base query that I'm starting with does have a wildcard in it (which it did not have in the past). I'm guessing that points me in the right direction - will be able to test this by...

I'm not sure which category to post this in, since the code has been confirmed to be good - but a recordset is going out to lunch! My code is sitting in an Excel file. The excel code pulls in Access data - the source points to one Access file (which also serves as a front end user file), which...

I would recommend using custom functions. Something along this line (although you may need to add code to handle a null return!) Public Function GetSecondHighest() As Long 'return the second highest Drive ID from the table tblTest Dim lHighest As Long Dim lNextHighest As Long lHighest =...

Hi - I've been developing Access databases for years now - love it! I started playing around with it about 25 years ago (yeah, I'm sort of old...) - and what started as a fun evening pursuit turned into a thriving business. I've been fortunate to not see database corruption in my solutions...