Search results for query: *

For a textbox, use PasswordChar property.

Which driver is residing on their system? Is that the correct driver?

Questions like this are the reason that .Net will not support MsgBox. Forces people to think.

Create a UserForm, leave the name as "UserForm1" On that form, create a large TextBox, leave the name as "TextBox1" Change the following TextBox properties: EnterKeyBehavior to True. MultiLine to True. Add this code to userform: Option Explicit Private Sub...

I take that as a "no", since it would be extremely difficult.

Does the window have to be "always on top"?

The need to minimize Excel and still have a small (child) window present, and always on top (always on top, right?) might be doable. I run two monitors, so that situation never occurs. I just park Excel on one monitor, let it do what it wants to do, and proceed with another application located...

Are you currently serving the Excel? Meet the guy halfway, scrounge up some older system and dedicate it to Access. Actually, the skeptic should allow a short-term test to see if anyone can truly perceive the difference.

From Excel VBA, take a look at References, see what shows up. If you don't have the proper References, you won't have access to the object.

Try the workbook on another machine.

Have all the field names obey a naming convention, perhaps the textboxes all start with "Text", all the listboxes start with "List", etc. For my example I use the first four characters of each name. If you don't want to clear the field, then don't name it according to your...

http://www.lacher.com/toc.htm Take a look at that page, if you need more help, I will continue Googling. Steve

Yes I do. Provide more detail (which application?), any restrictions (is a userform with large textbox OK?), what has failed, etc. I will respond. Steve

More detail, please. Have you Googled the exact phrase? What comes back? What exactly is the code doing? It works on other machines, right? What are the differences between the problem machine and the good machines? What are the additional references, if any, the project requires?

If that's the only modification, reset the menu.

They are both in the same project, correct? If so, and the variable is module-level and declared Public, you shouldn't be having any trouble. Show the code, if you think you did all of the above.

You can do a For Each loop, test for a specific name. You can test Workbooks.Count for the desired value. Sub IsThisWorkbookOpen(LookingForThisWorkbook As String) Dim OfTheWorkbooks As Workbook Dim Hits As Integer For Each OfTheWorkbooks In Application.Workbooks If InStr(1...

I think you are out of luck, in reality. Please explain the exact situation, and why this is a problem. You can put code in Workbook_BeforeSave, checking Application.Version. You can prevent the save or allow the save. But saving to a specific Excel 97 version? Not exactly sure about that...

Intercept the save, save as you desire, set Cancel to True.

So, this is a fresh install, and you are having problems? Since this is XP, and XP wants to call home, do you have your internet connection available for the program? I had some issues, they went away when the cable modem was connected. So, if you have a modem in the system, or a network card...