Search results

Hi All, I tried this topic in an original thread, but I posted some bum code and the thread got side tracked. In the meantime, having not received any replies toward the purpose of the thread, I have worked toward success on this and several other goals of the add-in. So, now I have a...

HI BOB!!! (gotta remember to go chug a beer x2) Thanks for the tip and the source. I was indeed able to make something like the referenced code work like a charm. Since some the DBs are ACCDB, I had to use ADO instead of DAO. (I was getting unrecognized database format errors when checking...

interesting... So, if I'm gathering correctly, the ghist here is to attempt a connection to the file. If it has a password, the connection will fail with an error code instead of opening the password dialog box?

There are two ways. First, I attempt to programmatically convert a file. If the file is encoded this process will result in an error I process in the On Error scenario. Technically, in order to convert the file, Access wants to open it if there is a password. So, in this one process I can...

HI BOB!!! Long time no see! I hope all is well for you! The database is bing opened from an Access Object running within an Excel Add-in. The purpose of the Add-in is merely to gather certain attributes of the file in advance of processing through an automated tool which will convert the file...

Hi All, Scenario: Programatically opening an Access database (any format). The file has been password protected. To be clear, this IS NOT a startup form prompting for login credentials. This is a password protected file prompting for the password when you open it. Question: Is there some way...

What version of Access are you and/or the users running? By "slow" do you mean the form loads, but the expected contents lag behind and are slow to populate?

Ok, so, the code I posted above, depends on the "connect" and "CloseDb" subs which are contained in mdlueck's posted at two places above^. It runs in Access and does require “Microsoft Visual Basic for Applications Extensibility 5.3”. However, as stated above, the clear goal was to get this...

mdlueck, THANKS! THANKS! THANKS! Well, you’re right the code does run, and it does work, but only indirectly achieves the objective. By that I mean it is trying to gather the protection property of a specific module, gets it if it can, or fires an error if it can’t (locked). Essentially, the...

mdlueck, Very interesting stuff in the pdf. Yes, I've seen and studies the extra two links. yes, I do have the "Visual Basic for Applications Extensibility 5.3" added, and yes, from any applicaitons VBA Window you can enter vbext_pp_locked in the immediate window and get the applicable value...

Yes, of couse the first link is where I originally located the code that got me started. I was able to modify it to work for Excel quite nicely. The second link I also have bookmarked as reference, but it doesn't really have anything I've found useful for this particular quest. Here is a set...

Again with the greatest respect, I wouldn't suggest assuming facts not in evidence. I have indeed opened the page you provided and am reading through it to see if any of it might be useful for this goal. Since I have the functional code to get the value, my hunch is, I'm looking for the object...

Confused. The act of "printing" from an application's point of view is really very quick. The print job goes to a Printer buffer and is actually printed from that buffer. Detecting if that buffer is still printing would seem to demand communicting with windows and or the printer's driver...

Are the variables being used within the same module? If so, set Dim the variable at the top, outside the actual Function, Private Sub, or Sub in which it is set. That way it is usable by all the code within that module. However, if they are being used across different modules, you need to make...

Dear mdluek, This is why I have enabled the Access Object Model in the Excel Project's library references. Thusly, creating an object within the Excel's VBA Project should allow me to run Access successfully from within Excel. For this particular challenge, it appears the big question might me...

oh my no, no no. Not one of those people.... OH My, not trying to programatically modify code. The code will be static and fire from a button on the ribbon inside Excel. I provided a sample piece of code which achieves the same purpose for testing the VBIDE.Protection of Excel files. I am...

HI ALL, From an Excel Add-In (XLAM) a slightly modified version of this code will open an Excel workbook, and determine if the VBA Project is locked, capture the result as well as a few other attributes and put the results in a worksheet. Here I have pasted a trimmed down version minus the file...

I took a look this morning on eBay and there are a ton of your usb Hauppauge WinTV units available for cheap. Or rewrite around a newer unit... Maybe somebody else has a different idea.

THANKS KEN! This was EXTREMELY interesting and a great exercise! But alas, no joy on my quest to learn the desired attributes. I was able to learn a lot though. In the databases I was working with: Access 2002-03 formatted DBs had 46 different properties Access 97 formatted DBs had 32...

What tells you these are now obsolete? What brings you to this point of concluding they are obsolete? In general, a lot of times, if you have the library files, you might be able to manually move/copy them to any new system as long as you update the references to a location change.