this is the proper way everyone says this should be done.
Private Sub Work_Order___DblClick(Cancel As Integer)
   Dim stDocName As String
   Dim stLinkCriteria As String

Thanks for helping.
I have two Access Mdb files.  Every once in a while, a function needs to run
that will take tabes from one Mdb and copy them into another.  One catch is
the table names in the two Mdb files are different as well as their layouts.  

Ok, I hope I am posting in the right group now...
I am very new to code, and need to make  a form uneditable to users who
are not the author of the record, as well as make uneditable to anyone
once a "completed" button is pushed which sets the date into a table.

Is there a function like SUM for use with arrays?
Like: "ASUM"
Dim MyArray(8) as long
Dim Total as Long

I have an If Statement that is giving me problems.
I have two kinds of Groups.
Group and SubGroup
The Group has different levels 1,2,3,etc.

I have a form that I want to keep a field hidden until a certain selection is
chosen within a drop-down combo box.  I know this can be down via visual
basics, but don't know where to start.  I am familiar with vb, but I don't
what event to call...a push in the right direction ...

I've got a button on a form that, when clicked, needs to copy all the files
from a certian directory on the network to the local drive.
There is a text box on that form that contains the Name of the Network
Directory in which those files are stored.

How can i create bitmap of a window form with all its child controls
without showing this form?
1. I am trying to create bitmap image of a window form.
2. I am creating a new instance of Form at runtime.

Hi, everyone,
I am writing a subroutine that may received one or more variables passed in
from the calling Subs. I use array in my subsroutine, my problem is how to
pass the variables (strItem1, strItem2….) to strAry(i) one at a time. Thank

I have set up a Task reminder form in my application that I want to open when
I start the database. However, if there are no tasks (Records) how do I stop
it from opening.

I'm trying to account for all possible errors related to the selection (or in
this case the non-selection) of an item in a combo box.  When the user tabs
past the TranType control, I've got a MsgBox in the Exit event notifying them
they must make a selection in TranType.  It ...

Can anyone tell me how to refer to a ComboBox on my child form from my main
form, I write the following codes in a Command button on my main form and it
doesn't work.
Me!MyChildFrom.cbxItem.Datasource = ‘1;2;3;’

Hi, I have a command button on my form that preforms a task (of course
right?).  The catch is that I have an alert message that I would like
to use to confirm or deny the action.  On the alert messages, you can
have it display yes and no buttons.  My question is how do you write

Given the code below where a user's selection
from a combo is being inserted into a text box
using a control varible. Can that control variable
also be used in some sort of calling syntax to

I don't know what I am doing here.
I have a recordset and I want to use the Recordset.Findfirst command to find
a record, but I can't seem to get my syntax correct.
I have an integer  variable I'll call TempComp.