Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WantsToLearn

    Is there a way to scan StroredProcedure text looking for given string

    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!
  2. WantsToLearn

    TextBox Bound to ComboBox Text property when SelectedIndex = -1

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

    How do I bind textboxes to query behind combobox on SelIndexChg event

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

    How do you access the Return value from a Sql Server Stored Procedure

    Hello All, From where do you retrieve the Return value from a stored procedure in Sql Server? Thanks!
  5. WantsToLearn

    Newbie question from someone moving over from VB6

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

    Can you force a listbox to tab align multiple columns

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

    Can you temporarily disable and then reenable event processing

    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!
  8. WantsToLearn

    Coming over from VBA, need some Event and Property equivalents

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

    Where have all my forms and reports gone? Multiples have disappeared

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

    Would someone be willing to critique a working Stored Procedure for me

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

    Can you control the Linked Table Manager using VBA

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

    Problems preselecting ComboBox value with semicolon delimited list

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

    Update Products QtyOnHand using Trigger on POReceipts table

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

    How do I get TabStrip control on my form

    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!
  15. WantsToLearn

    Having trouble trying to make a form modal when using automation

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

    I have a series of linked combo boxes setting up sort parameters

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

    What does MDAC stand for - Thanks

    I ran across this somewhere recently and don't know what it means. Thanks for your help!
  18. WantsToLearn

    When writing Add-In, do I need 1 for each version even if no code chgs

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

    When writing Add-In, do I need 1for each version even if no code chgs

    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!
  20. WantsToLearn

    I accidently deleted Tools Menu Bar in VBE, any ideas to get it back

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

Part and Inventory Search

Back
Top