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

    displaying mandatory fields

    I agree with kbuc6. I display some visual indicator on the form showing that the field is mandatory (ie asterik, bold label, symbol, etc...) I also validate all information when the user attempts to save the information. If any fields are blank, or the information is invalid, I take the user...
  2. jcalcoa

    Drop Down Combo

    set the textbox equal to the value selected in the combo box Example: Text1 = Combo1.Text
  3. jcalcoa

    supreport linking

    First of all, create a parameter field in your sub-report for the date. Then in you main report, right click on the sub report and select Change Subreport Links menu item. Mapp the date field in the main report to the parameter field you just created. A report selection formula will be built for...
  4. jcalcoa

    Common dialog control problem

    You can use the InitDir property of the CommonDialog control to tell it which directory to start in: CommonDialog1.InitDir = "c:\dos"
  5. jcalcoa

    How does one connect to Oracle from VB with ODBC?

    Call this subroutine on startup. Pass the userid, password and database server name. You could also use Microsoft's OleDB for Oracle driver. If connection is not successful, application ends. Be sure to close your connection when the application ends. (gCnn.Close) Public Sub sExecuteLogon() Dim...
  6. jcalcoa

    vb/sql communication problem

    If PI is a numeric value remove the single quotes. WHERE(PI_Value = " & cint(txtSearch) & ")"
  7. jcalcoa

    Problem when executing in other machines

    Try .LogOnServer "pdsodbc.dll", "server", , "userid", "password" I use this when accessing an Oracle database. Also, are the users mapped to the same drive as you are for the report location?

Part and Inventory Search

Back
Top