I am having difficulty finding the best method to do this so any help would
be appreciated.
Main form name is FrmReviewAccuracy312
SubForm name is FrmNCLocAccuracy312 or Child0 in the main form.

I declare a Variant in the module level code (above the procedures).
Public UName as variant
The value assigned is preserved between procedures but not between modules.
The help says that variables declared this way are available over all

how can i get the value of this particular text in a subform inside my
mainform?
i want to get the text in the subform to be displayed in another text in my
main form..help..

I receive 2 monthly files on members that contain 50+ fields of data.  
Each record already indicates either New, Change or Term.  
On a Change record, what I need to do is when I receive a record on a member
that already exists in my table, I want access to automatically check the ...

Can someone give me some advice on this.  I need to append tables together
for an Audit.  It can be up to as many as 4 tables. All the tables that will
be appended have 2 fields in common, Part and NHA.  When the fields are equal
in the tables all data must be on the same line as ...

I'm using public variables to store cumulative totals that are returned
to a query via a function.  For example, the query returns something
like this
Value     Total

I am relatively new to Access VBA coding and need some help.
QUESTION:
Using Access 2003 and VBA, how can I loop through a table and bring some of
a row's columns into VB variables?

I had a function set up to get the average of a certain field with matching
criteria. This was my code:
STRSQL = "SELECT Avg([" & cboWC & "]) AS Average, '" & cboWkCtr & "' AS
WorkCenter, txtTC " & _

i am currently creating a database in MS Access. Its an asset management
system, wherein users input various information pertaining to a certain
company asset. It generates an access number containing the year when the
asset was purchased, a number code to specify what kind of asset ...

I hope someone out there can help!!  I have an Access database for which I
have created a number of forms and done all of the programming for them.
These forms enable the user to search, edit and enter data in the database.
All of this work was done on a computer running Windows XP ...

hi, all !
what does above command actually do ?
In a form, usually the statusbar text of the currentcontrol (as stated in
the controls properties) is shown. Sometimes I want to change the message

I've got my shell command as below:
   Call fHandleFile(Application.CurrentProject.path & "\Documents\Maps\" &
DLookup("[txtMapPath]", "qryMaps") & ".pdf", WIN_NORMAL)
Where qryMaps.txtMapPath displays the filename (ie. "District_01").   I can

ok in a nutshell, i've got several combo boxes and textboxes in a form that
acts as a seach filter for a set of data. All criteria are optional so the
user can select any criteria he wants. The problem is i'm not capturing the
user input correctly...this is what i use:

Some languages allow you to force the interpreter to evaluate the contents of
a variable in a command  before the command is executed.  Is there a way to
do this in VBA.  Here is an example.
The objective is to develop a common routine to apply a set of

I am using VB.NET.
I just created a form where user enters information.  Once information is
entered, user clicks ok button.
While updating the table, I am getting an error and it does not update.  I