Hi How can i use public variables. These variables i wand to use in
different places on a form (like a button) and are neccessery to write the
type of variable like:
Public VAR1, var2 as integer

Is it possible to use multiple statements in SQL?? (I’ve never used it before)

I have one query that i'm working with, The statements I want to use are as
below, they all work individually, but not together, Access help is as much

Hope someone can help.
Table structure: Name : tbl_Runs
Fields are:
Run_ID

I've searched through the posting and found what should be the solution
to changing the value of a label....
Private Sub Report_Open(Cancel As Integer)
Me.lblTest.Caption = "I love Access"

The following example may further clarify the question,
Select fieldA, filedB, fieldC

Where fieldD = Forms!formName!controlName

How can I vary this?
There doesn't seem to be anything in Tools->Options other than query
design font under the Tables/queries tab and that is for the query
design grid...

I have an A97 module called modWorkdayFunctions in:
http://www.oakland.edu/~fortune/WorkdayFunctions.zip
It allows the counting of workdays taking into consideration up to 11
U.S. holidays.  More holidays can be added easily.  Also, there is a

How do I concatenate two fields in the same table... For example, I
have two tables, first one is called familynametable that has a
familyID and familyname field.  This table is connected to a
individualnametable that contains three fields: individualnameID,

I've got to questions.
First.  I have a form that works off of dates.  Plug in a start and end date
and it triggers a query then displays a report.  The problem is when I close
the report it goes back to the form but the form is no longer mazimized.  I

A friend of mine was given a database a couple of years ago. With a
change in her job requirement, she now would like to use it, but needs
to modify it. At the moment it just opens up at the switchboard, with
limited options in the File menu etc.  I tried going to the Window -

I cant seem to get this to work!  Basically, what I want to do is
format some text boxes bases on the following:

-5.00 to -7.99 = Yellow

I cant solve my problem, I wish to transer all .dbf files from
directory, into one access table ?
All files have same structure.

I have a report that uses snaking columns to generate four  2.5  inch
columns in landscape mode.  It is used to print a double-sided document
whch is then cut down the middle and bound.
The problem is that I need to be able to make the spacing between

I have been away from ACCESS for a couple of years so I can't remember
how to do the following.  Please give me so advice if you can.  What I
want to do it make it so that table 1 will have a + at the beginning of
the row and will allow me to click on that plus and it will display ...

I have
Function  myFunction(myArgument) as string(myInteger)
The line
    myFunction(myInteger) = myString