Recent content by Kaulana

Indeed, Wayne, the first time I tried the link it didn't work, but after reading Ben's post, I tried it again, it worked, I downloaded the stuff, now I can scroll in the code window. Thanks. Bob aka kaulana Kaulana (aka New Daddy Bob) http://www.bobfarley.com

Did a search and came up with just about all the office documents and files I've ever made, along with these in the WINDOWS folder: SYSTEM.DAT USER.DAT SYSTEM.NAV USER.NAV system.rsc user.rsc prebak.reg I would guess the reg file is a good one to change. I opened the others in WordPad, which...

The document properties (Word 97) summary section always lists an old company name. I've changed the normal.dot, renamed it, deleted the old one, and renamed the new one normal.dot, but every time a blank document opens, the old name is still there. My MS Office has that old company name listed...

I've read the post on this not uncommon problem, but cannot find a driver for my Logitech Compaq mouse. The Control Panel control for the mouse doesn't even list a wheel to control or change settings for. The strange thing is that the scroll wheel *does* work in the Project and Properties...

I use Office 97, mostly Excel, programming Visual Basic for Applications. I've never updated the suite with the patches available. Was wondering what the success rate for that would be approximately, how many horror stories there are, or if it is as easy and simple as updating IE's browser. I am...

Thanks for try, Justin, but Refresh not an available option for labels in VBA. Kaulana (aka New Daddy Bob) http://www.bobfarley.com

Want to change a label when command button clicked to say "Processing" while it processes. Caption doesn't change till the processing is over and a message box stops the run. However, the caption does change as soon as the button is pressed when I step through it. Has to be something...

Thanks to windows xp, I am having to redo some printpreview code that now causes errors, apparently by closing the page it previews. I don't know because I'm 4500 miles away from the problem and I don't have xp. My workaround was going to be to simply have the page acquire the zoom value and...

I program VBA in Excel for a company 5,000 miles away. They previously used Win98 and Excel 97, which I still have. However, the company recently bought a new computer with Windows XP. I didn't. They're experiencing some problems with the VBA6.0 code. Me.Show seems to fire UserForm_Activate now...

In Windows 98 and using Excel 97, I had a bit of code to preview a sheet that the program had built. I found that if I hid the form first, using Me.Hide, then the preview acted as if it had been called from the File menu. If I left the form up, then the user had to key the Esc key to come back...

I used to have this problem, too, probably caused by a variety of issues as I was learning to code. But one thing I was doing was leaving object variables in place without making them Nothing. So when I'd be debugging and rechecking, I'd have the same object variable being called again. Don't...

I work remotely with Windows ME and Office 97. The people I work for upgraded to Windows XP, keeping Office 97. The problem is the print preview code I wrote for pre-xp fails to return to the same place it was. Here's the code: Me.Hide Application.Dialogs(xlDialogPrintPreview).Show...

Never mind. I found the answer, or at least one answer. It's the UserForm_QueryClose procedure. It has a Cancel As Integer bit that, if you set Cancel = True or -1(?) then it causes the x button not to work. I put a msgbox in it, too, to let the user know to use the Close button. Kaulana (aka...

Using VBA in Excel, would like to deactivate the "x" in the upper right of forms so that user "must" use the "Close" button to close the form. Any way to do that? Kaulana (aka Bob) http://www.bobfarley.com

Piece of cake. VBA for Excel will let you build a name for your workbook and save it as such. Here's code I use in an application. (This is basically the same thing as ratman wrote above, just different.) I'm not sure how you get your Access name into the mix, but if you're writing Access, I'm...