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

    Switch databases of CR9 report in VB6

    sorry problem already solved databases weren't as identical as i thought
  2. Gilske

    Switch databases of CR9 report in VB6

    Hi The problem i'm having is the following I've made a Crystal Report and as datasource i've used SQLA as server, vlinx as database. Now i'm need to acces this report trough vb6 which works, But SQLA is my test enviroment. SQLB is my working enviroment. But in the code the report won't accept...
  3. Gilske

    SheetAdressing Problem Excell

    Sorry Tony but i've checked all that no typo's, no blancs in front or in the back for both of them i've broke my head on it last week Can't figure it out.
  4. Gilske

    SheetAdressing Problem Excell

    I have to say that sometimes i forget to put that stuff in But here's my second change Labo(i,2) is an Array which contains String The value of Labo when it fails is a valid sheetname. Blablabla doesn't change any variables that use or have anything to do with the sheetadressing. The...
  5. Gilske

    SheetAdressing Problem Excell

    dear developers I have a very strange problem I use VB to adress a Excel Workbook. And i use a sheets name to adress it But it would only work with the first 7 sheets, after that he would give "subscript out of range" this is my code Private Sub ArrayRes() Dim strLabonaaam As...
  6. Gilske

    howto add a formula in a Sheet with VB 6.0

    Guys I don't want to offend you but your sollutions wouldn't work i didn't need to use .Formula but .FormulaLocal. oSheet1.Cells(TlRij, 9).FormulaLocal = "=IF(ISNUMBER($G" & TlRij & ");IF(ABS($H" & TlRij &...
  7. Gilske

    howto add a formula in a Sheet with VB 6.0

    Hi everybody how do you put a formula in a cell with VB 6.0 I tried making a macro and adapting the code but it still won't work I've got this none-working code oSheet1.Cells(TlRow, 9).Select ActiveCell.Formula = "=IF(ISNUMBER(G" & TlRow & ");IF(ABS(H" & TlRow &...
  8. Gilske

    Killing the Default Combo Box Edit Context Menu

    I've got help and found this page http://www.vb-helper.com/howto_disable_combo_popup.html Which works. So I thank you, all
  9. Gilske

    Killing the Default Combo Box Edit Context Menu

    Does anybody know how to kill the default Combo box Edit Context menu of multiple combo boxes on the same form? I've found some code but it won't work with more than 1 box on the form. Thnx in advance

Part and Inventory Search

Back
Top