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

    Want to Create Dynamic Form and label

    I know that that my recent posting will be quite different from what I have previously said. But if anyone noticed earlier, I did say that my office workstation does not have Visual Basic installed, which means I only have the weekend to actually test code before I post it and not because I...
  2. TerenceOu

    how do I get the coordinates of an ActiveX object?

    Alejandro Pls explain your problem in VB
  3. TerenceOu

    Want to Create Dynamic Form and label

    I'm so sorry I couldn't post this code earlier so you could have used it jmarler. 'Copy this code and paste it into your form. Run it to 'see the result Private Sub Form_Load() 'This variable need not be created Dim t As Control 'A textbox control is added to the form's control...
  4. TerenceOu

    control?

    open a form, get to the code and type "vb." and intellisense will tell you what controls there are I hope I understand the question you posted
  5. TerenceOu

    Want to Create Dynamic Form and label

    For your information jmarler, if you noticed, what I did was Set {control} = New {control} I did not do this: Set {obj} = New {control} These are 2 totally different statements. So, lets not confuse our friend here
  6. TerenceOu

    Getting "Constant Expression Required" for an Enum

    Did you close you connection object within your ccon class? Did you declare the arguement where you pass in "DBServer" as a "DBLoc"?
  7. TerenceOu

    IS THIS AN EASY ONE?

    Seems to me like you are referencing common values here. You could actually declare variables in a basic module and have the forms in your project use/reference the values rather than pass them directly like frmSummary.label = frmMain.label
  8. TerenceOu

    Getting "Constant Expression Required" for an Enum

    Pls show some code that tells of how you use the enumerators.
  9. TerenceOu

    Want to Create Dynamic Form and label

    You must always set the variable to a new type and not just any word you use. Remember that forms have control containers and any control created at runtime must be inserted into the form's control container and then loaded so you may see it in your form. Private sub Form_Click() Dim anytext...
  10. TerenceOu

    Public vars in ActiveX

    Could you pls paste some of that code on here so I may have a look and understand better what you want to do
  11. TerenceOu

    Web Pages in a VB App

    Add the webbrowser component to your form You can experiment with this: Private Sub Form_Load() WebBrowser1.Navigate2 "http://www.tek-tips.com" End Sub
  12. TerenceOu

    Numeric problem in ADO

    Mats are you trying to say that it doesn't really matter if the field is present in the second recordset since you say you just want to get info and thats it. Because if that is so, you can use disconnected recordsets and not try to copy info from an actively connected recordset to another...
  13. TerenceOu

    the Optional parameter

    I'm sorry Micheal but those might just be experimental code which is why "d" isn't referenced and tapeworm might not have finished the whole of the coding so..... nobody here wants to question if tapeworm is an amateur or know to much of what others are doing as long as they answer the...
  14. TerenceOu

    Recordset find

    recordset.Find (criteria, SkipRows, searchDirection, start) criteria = eg.(&quot;nvName = &quot; & strMyName) [Conditions you might want to state, <SQL>] skiprows = eg.(1-???) [How many rows in the recordset you would like to skip] searchdirection = eg.(adSearchBackWard, adSearchForward) [The...
  15. TerenceOu

    the Optional parameter

    It is a better practice to always use default values for any arguements which you declare as optional. Furthermore, I suggest you not check if the arguement is missing but instead set the default value as 1. example: Private sub inc(c as integer, optional b as integer = 1) c = c + b end sub...
  16. TerenceOu

    Accessing Common Dialog Control

    You don't have to actually click and drag the icons from the floating toolbox. For all controls, you can just click on them and move the cursor to the form. Once your mouse pointer is over the form, it changes into a crosshair and from there you can hold down the left mouse button to draw your...
  17. TerenceOu

    Class - Initialize & Terminate

    Based on what you wrote. Firstly, if you have need for the usage of ADODB Connection, there is no need for the use of the CreateObject() method. Second, based on what Mark Saunders said about a the connection method error, you might want to check if you have added the (Microsoft ActiveX Data...

Part and Inventory Search

Back
Top