adding a new form

[mark kubicki]

(XL user crossing over to ACCESS...)

i'd like to add a form, totally unrelated to any information in the data
base, but soley for temporary programming variables...

within ACCESS, there doesn't seem to be a method (at least on the menu or
toolbar), to "add/insert forms"; is this correct?

-mark

 

[Rick Brandt]

(XL user crossing over to ACCESS...)

i'd like to add a form, totally unrelated to any information in the
data base, but soley for temporary programming variables...

within ACCESS, there doesn't seem to be a method (at least on the
menu or toolbar), to "add/insert forms"; is this correct?

-mark

If you look at the db window on the forms tab there is a big button labeled
"New". Press that and when the dialog comes up just don't specify a table.

 

[John Vinson]

(XL user crossing over to ACCESS...)

i'd like to add a form, totally unrelated to any information in the data
base, but soley for temporary programming variables...

within ACCESS, there doesn't seem to be a method (at least on the menu or
toolbar), to "add/insert forms"; is this correct?

A Form isn't a good place to park variables; a Form is really just a
user-interaction window letting the user view and update records in
some Table.

If you want to store some programming variables, consider creating a
Table for that purpose. In VBA code you can use the DLookUp function
to retrieve a value from the table. For example, you could have a
two-field table with a text field Varname and a Number (or Text, or
other appropriate datatype) field VarVal; your code could then say

TaxRate = DLookUp("[VarVal]", "[tblStash]", "[Varname] = 'Taxrate'")

John W. Vinson[MVP]