Recent content by sochidog

Think on it this way.... I give you an excel document.. and you assign a password to it. Then, using code, you copy the document, and open it (using your password) so that both are side by side. The problem is that is you type in the password wrong - so it throws an error trying to open it. I...

Hi There, Im saving an excel workbook using VBA that is password protected... I have turned off every known event and handled all errors, however when someone provides the wrong password to open the workbook, I get "password error". I dont like popups and want to handle it but its not...

There is massive code all over the place... the master sheet creates "lite" versions of itself. A few sheets here and there, certain modules, certain lines, etc. "SaveAs" is not what i want. I just want to copy the code from the "ThisWorkbook" object to the "NewWorkbook" object. How to do?

Afternoon All! I've got this macro that copies all the sheets from a source workbook into a new workbook. However, I am missing the code in the "ThisWorkbook" object. Y'know the workbook_open and close stuff that I've added. How do I copy and paste that over. :-)

I have a vb app that opens a pre-made html file on a shared drive. I think the shared drive doesnt like the line... Dim FileToRun As String FileToRun = CurDir & "\XYZ.html" Shell ("cmd /c " + Chr(34) + FileToRun + Chr(34)) Is there an alternate way to open the html file without using the cmd...

I've got a guy who has his system tray filled with 10 copies of word, 5 excel, bunches of outlook and msn messager (which he doesn't use) random-like. Since hes not an idiot i give him credit that hes not opening an entire directory... Any spyware or viruses that act in this fashion? Our...

Found it on microsoft. The answer start "" "Space Filled.mdb

I have a bat file with a START command. How do you get the start command to recognize files with spaces in it? r: cd WeeDatabase start Document Management.mdb Thanks tons!

Guess I will have to be content that people will not "double-click" too often. Thank you for your help.

Splitting the database is an option for some, but the person who created this app, coded it so that the split would require heavy re-coding. We are upgrading away from access soon anyhow (thank goodness) so there is no point in starting the endeavor. So i have a shortcut on everyones desktop...

Thanks bob, The trick is that its a networked database, which means multiple people in it at once. I just want to prevent the single user from opening two copies of access. Is there something like this (pseudocode) If access is already running skip it else fire it up end if

I have a bat file that opens my database. However, if you click it twice, you can open the database twice. What is the dos command to see if access is already running? "C:\Program Files\Microsoft Office\Office\msaccess.exe" "Y:\OfficeDatabase\xyz.mdb

Hi there, I have a form with a bound object frame. We usually insert pdf's in there. I noticed that it shows up faithfully on xp access but is sometimes invisible on access 2000. Any thoughts on how to make it appear all the time on 2000? K.

I've compacted all over the place. Its a real oddity. The only changes that i've made is to expand a query - which should have no impact on the overall size of the database. Yet, everytime i run it - it jumps 500kb. The database has almost doubled in size in a week...

Hi there, I adjusted some queries the other day - now i note that everytime i run it - the database size increases dramatically. Whats going on?