Search results for query: *

I am trying to use VBA to resolve Outlook recipients before before sending a message (like pressing the "Check Names" button when sending an Outlook e-mail. A name will be entered into a textbox on an access form. I will use the After Update event to run code that resolves the...

To somewhat disguise the MS Access backend of my VB app, I changed the "MDB" extension to "DAT." Crystal Reports 7 will not open my database file with the DAT extension, but if I rename the extension back to MDB, it works fine. The CR knowledge base (C2007870) shows what...

I need to connect Crystal Reports 7 to an Access database, but the database is secured for a multi-user environment (*.MDW). I am using the Report Designer Component (RDC) in VB6, but I have not been successful in connecting a secured database with it. Because the software will be used in a...

I did what strongm suggested and the result was impressive. I increased the record count to about 5000 and tried it using my old code - it took about 90 seconds to load. Then I tried it using the .List property and it loaded in under 2 seconds. I had to transpose the array before assigning it...

Thank you for the fast reply, John. The MS Forms 2.0 listbox does not have a sorted property. I have tried to make the listbox invisible during the build, but it takes roughly the same time (give or take 25ms). I have not been successful getting the "regular" VB listbox to do...

Sorry about the formatting in the last post... here's another try... For iCurRec = 0 To UBound(RSArray, 2) Me!lstWUCSubSystems.AddItem Me!lstWUCSubSystems.List(iCurRec, 0) = _ RSArray(0, iCurRec) Me!lstWUCSubSystems.List(iCurRec, 1) = _...

I am building a multi-column MS Forms 2.0 listbox from a 2D array. The array has 8 columns and approximately 1300 rows. It takes nearly 30 seconds to add the array items to the listbox. The build section of the code is listed below. The listbox must be requeried when the user reopens the...

As I mentioned in my first post, I tried to set the field equal to Null. I was unsuccessful a few days ago. I tried what you said and it worked great. I believe my error was occuring because I used a function call to assign Null to the variable if it saw that the textbox was equal to...

If I used the Empty variable, I would have to change all my data types to variants. Unfortunately, that is not an option. The variable must remain a single data type. Further elaboration: A field on form frmXYZ called [FIELD_ABC] has nothing in it (it is blank). I am using a recordset to...

Yes. That didn't work either. Sometimes VB can really be a pain.

In the process of saving data to a recordset from VB6, I need to store a blank in a Number (Single) field of an Access table. I do not want to store a '0' value, it must be completely blank. When I try to do this, I get a Data Type Conversion Error. I have tried setting the recordset field to...

I have not tried the Excel form export, so I can not help you there. To enable toggle boxes: Install the Microsoft Forms 2.0 Object Library (Under the Project Menu, then select components).

Is there a method to write to the Windows 2000 registry without having Admins privileges? Although I have local Admins permissions, the people that need to install the software do not. I would like for them to be able to install the software without the need for a system administrator. I am...

Strongm, we must have replied at the same time... I didn't get your post until I sent in my first reply. It worked great. Thank you for your help!

Sypher2 mentioned that no easy way exists to find out how many lines are in a wrapped multiline textbox, so I'll stick with strongm's method for changing scrollbar visibility on the focus events. Thank you both for your help.

I would like to hide the scrollbar on a multiline textbox if the amount of text does not exceed the visible bounds. For example, if the textbox height allows the display of two text lines, and up to two lines are typed in, I do not want the scrollbar to be visible (VB default is to disable the...

Thank you for your suggestion. Unfortunately, the above code only works if the user forces a new line with a CRLF. If the text is auto wrapped, it will not return the number of lines. After more consideration, I don't think that knowing the number of lines will help me because I can not set...

I would like to hide the scrollbar on a multiline textbox if the amount of text does not exceed the visible bounds. For example, if the textbox height allows the display of two text lines, and up to two lines are typed in, I do not want the scrollbar to be visible (VB default is to disable the...