Hello,
We have many, many stored procedures and I need to find a couple that have a specific piece of code in them. Is there any way to globally search the stored procedures in this manner? Thanks!
TextBox bound to a CombBox Text property similar to this:
TextBox1.DataBinding.Add("Text", ComboBox1, "Text")
If the ComboBox SelectedIndex is -1
1. Do I have to manually set TextBox1.Text property = ""
2. If I do that, does it impact the DataBinding in any way
Hello everyone,
Let's say that I have the following query populating a combobox:
Select CustomerID, CompanyName, Address, City, State From Customers
I have set the DataSource property to a DataTable from a DataSet and have also set the DisplayMember and ValueMember properties to CompanyName...
Hello All,
If VB6, you could access particular form controls by using Controls("ControlName"), etc. It appears you must use the index in .Net. but they can change if you add or delete a control on the form.
I am passing a form reference into a class so that I can read some of the control...
Hello,
I do more VBA than VB so please bear with me. I have several listboxes with similar data that I am keeping in sync manually. Is it possible to combine all of the data into one list box and have everything column aligned properly? Here is the type of thing I have:
lstFName lstLName...
Hello all,
I have a process that causes a whole bunch of events to fire. If I could temporarily disable event processing that would be very helpful. In Excel VBA you can do this, but I wasn't sure in VB6. Thanks for your help!
Hello All,
I have done mostly VBA. What are the equivalents for the BeforeUpdate(Cancel), AfterUpdate events for controls in VB? The Validate event fires only when a control loses focus and the Change event is every key stroke so I would have to check for Enter.
Also, in VBA there is a form...
Client has Access2000 database (.mdb) with SQL Server backend. The database has 40+ reports and 30+ forms and subforms. I have been developing them on my laptop which is Access2002 and copying them over. The client does NOT want to do individual object exports.
Somewhere along the line several...
Hello All,
I have a small client that has an Access front end to his SQL Server. I recently wrote a new Receiving form for him and rather than write SQL in the Access form code to update the linked tables, I created a Stored Procedure and called it using ADO from the Access code.
It is...
I have a client who runs 2 separate businesses on 2 databases on the same SQL Server. Everything is identical except the data. He is using Access as the front end to the data. The only difference between the Access databases is the SQL Server database to which it is being connected.
To avoid...
I have a combobox bound to a semicolon delimited list. Here is an example of the data:
0;04/12/2004;1;04/13/2004
The problem is the combo box displays empty and you have to click the drop down arrow to see the values. I need to have it display the first item in the list. I have tried all of...
I've read about triggers several times but now need to actually create one. Here is the scenario:
1. Receiving user pulls up PO Receiving form and enters qty received as appropriate for each detail line of the PO
2. When form is complete they click Update button and their entries are inserted...
Hello,
I set a reference to MSComCtl.ocx in my VB 6 project but now I can't find where to insert a TabStrip control on to my form in design view. I know this is something simple but I am drawing a blank. Can someone help me? Thanks!
Hello,
I am controlling Excel using automation but I am having trouble getting my vb form to behave modally.
An example of the built in functionality I am trying to emulate would be the Data Sort dialog box in Excel. This dialog box prompts the user for the sort columns they wish to use. It...
Hello all,
I want to use a series of combo boxes to allow my users to specify a custom sort order. As they select from various fields, I want succeeding comboboxes to display already selected choices first in the list but not be selectable again. Is this doable and if so, can someone point me...
Hello all,
I'm working on my first Microsoft Office Add-In. Even if there is no version specific code, must I still create a different one for each version (eg Excel97, Excel2K, etc)? Are there other issues I need to be aware of based on your experiences? Thanks in advance for any ideas...
I working on my first Add-In. Even if there is no version specific code, do I have to create a different one for each version (eg Excel97, Excel2K, etc)? Are there other issues I need to be aware of based on your experiences? Thanks in advance for any ideas, suggestions, reading resources, etc!
That's what I get for working in the middle of the night. I added a new control on the tools menu using with VBE, etc and copied the same with / end with pair down to where I was deleting the new control and neglected to extend the with / end with pair to .Controls, ect.
Any ideas out there...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.