Search results for query: *

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...

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...

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!

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.

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?

I've put simple msgboxes in the code and it doesnt fire, whereas the unload works fine. whats going on?

Hi there... Two questions: 1. Any suggestions on an effecient way of handing out MDE's to my collegues for placement on their C:\ drive? I've put in logging code to catch them if they log in with an old MDE.. but I want something more proactive. 2. My collegues are leaving access using the...