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...
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)...
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...
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
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.