Recent content by DJDave

Progress!! :D This indeed accomplishes the functional part of what I want! ...Now just trying to figure out a way to do it that it doesn't cause a new Access window to open and then disappear every time I click the button. I tried adding appAccess.Visible=False, but the window still shows up...

I've actually already tried that... :( Using db.Properties("AccessVersion") returns the wrong number for an .ACCDB (it gives 09.50 when that is the number for a 2002/2003 .MDB...)

Greetings once again... SHORT VERSION: Using Access 2007, can I return a value for CurrentProject.FileFormat WITHOUT opening the database? LONG VERSION: I'm looking for a way to determine the file version of a given Access database without actually "opening" the database in Access (I don't...

Thanks MarkK!! :D This is exactly what I was looking for! Seems Microsoft doesn't have a habit of documenting these little things too well... as I've learned after several months of learning and developing in Access/VBA. The set-then-restart convention doesn't bother me, it's actually key to...

Short and sweet version: Is there a way to programatically choose what RIBBON NAME is specified in the CURRENT DATABASE section of the ACCESS OPTIONS (Access 2007)? (See attached image) So I've been hunting for this for a couple hours and turned up nothing so far. I've hit a thread here on AP...

I'm trying to design a database that is fairly graphically detailed, with custom backgrounds assigned to each form to the end that everything looks nice and is easy to navigate. No problems there. But... When you minimize Access (2003), the background image is shifted ONE pixel upwards. This...