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

    Checking whether a form, referenced in a form variable, is loaded

    How can I check that a form is open using the variable: public formVariable as Form After formVariable is assigned, I realise I could use: isLoaded(formVariable.Name) but this would only check if an instance of the form is loaded, ie it may be a different instance of the form referenced in...
  2. astraltango

    Passing a reference to a subform

    I have a parent form that has a subform (subForm1) that opens a form (form1) form1 then needs to reference subForm1 form1 is opened by multiple forms, so I can't hardcode the reference to subform1 in form1 I want to declare a public variable (callingFormVariable) in form1 (or as a global)...
  3. astraltango

    dynamically updating variable in different form

    ok, I have two forms: Form1 and Form2 I want to set a puiblic variable (str1) in Form1 from Form2. Works fine if I use the following: Forms!Form1.str1 = "blah" BUT, I need to do this dynamically where the form name is in a variable. For this I need the eval function right? But this does...
  4. astraltango

    initialization of database connection in VB

    How do I initialize a connection to my Access Database in VB? eg, how would I initialize cnMyDB to use in: cnMyDB.Execute("Select Value from Table where key=2") Cheers
  5. astraltango

    Storing value from sql query

    I want to run an SQL query to get a value from a table and store the result in a variable for further use. How do I do this? eg "select field1 from table1 where key = 121" may return one record: "fred" which I wish to store in a variable I have found the following code in...
  6. astraltango

    Storing value from sql query

    I want to run an SQL query to get a value from a table and store the result in a variable for further use. How do I do this? eg "select field1 from table1 where key = 121" Cheers
  7. astraltango

    Use of global variables

    I'm simply trying to set a global variable which is set by one form and accessed by another, but it is not working. I have declared it as public in the first module, but don't seem to be able to access it in another module. Any idea what I may be doing wrong? I have tried declaring it as...
  8. astraltango

    setting a value in form 1 from form 2 where form 1 opened form 2

    In some of my forms, I wish to select a customer. The way I have implemented this is, I have a button on the original form, to open up another form which displays a list of customers to choose from. What I want, is for the user to be able to select the appropriate customer which updates the...
  9. astraltango

    changing selection of a drop down box depending on condition

    I've having trouble restricting the selection of a drop down box depending on certain conditions (ie, depending on the value of another field). For example: If "A" is chosen in drop down box 1, I want the selection of drop down box 2 to be "queryA". If "B" is...

Part and Inventory Search

Back
Top