How do I set up the code so that multiple selections in the list box are
displayed in the sub form?

I need a certain check boxes on a form to be checked if the corresponding
data is present in a table.
I.E. if the applicant type is a corporation, then the corporation checkbox
will be checked.  I will need to pull this information from applicationinfo

I'm trying to auto fill the district and Building Name based on the cc#
entered.
Here's the code:
Me.District = DLookup("[District]", "CostCenters", "[CCNum]=" &

Thanks in advance,
I am using  FileCopy to transfer files thru Access like:-      
strFrom = "c:\database\text.txt"
strTo = ?

Hi group,
Our company is using an Access database that is located on a network server.
The database is not split and it is an .mde.   Each user has a shortcut on
their desktop to open the database.  The database is used by many employees

I need to have a global  variable always contain the name of the
current form field.  This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
    gxCurrentField = Me.ActiveControl.Name

I am building a Workload Forecasting system. It is similar to a
monthly Time Card except, instead of caring about what they did last
month, I care about what they think they'll be doing within the next
12 rolling months.

I want to select field 1 from a table that I input in a form's textbox
(me.tablename).  What is wrong with the following syntax?
DoCmd.RunSQL "SELECT [1] FROM " & Me.tablename & ";"

I have an access database. I have designed several forms which shows
information retrieved by querries. I would like to share this forms
with my colleagues via server. But, i dont want my colleagues to
access tables and querries, because of security reasons.

I'm trying to filter a subform with multiple combo boxes and eventually some
text fields tied to one command button to execute the search/filter. I want
the user to determine which filter or combination of filters to use.
I started with the combo boxes and can get one to work, ...

Hi, all
I have a form "log" with tabs on it ,one of the tabs via a button opens a
form called "Date_Status_Form" embedded in this form I have a subform
"Top_Date_Status_Query" which displays data in a continues format. At the

The query below is the source of two forms; 1) frmPmhDX 2) frmPmhDXdetails
When the source for the forms is only from tblPmhDx the forms work fine. But
with join the frmPmhDXdetails won't allow me to edit the fields. If I go to
the underlying table, tblPmhDX, it gives the same ...

It just happened that all the command buttons in all the forms in my data
base don't work any more. The error message is "Module not found". Is this a
corruption? What can I do to solve the issue before I end up copying
everything to a new blank database?

I have built a DB that is based on three different "linked tables".  The
tables are actually Exchange Server folders full of email.  The subject line
has the Project# that I need to extract out.  I use several queries to do
this.  The three folders represent the different status' of ...

Any suggestions on why I would receive err.Description "Reserved Error"
(err.Number 3045) while using the DoCmd.TransferText?
The csv file to be imported is on the client PC, but was copied from a server.
The client PC has full control over the folder on the server.