I need to join two fields from the same table into one new field:
Field 1 = ProjectName
Field 2 = State
A co-worker needs the new field to contain the State ie. AZ, and the

I have a form which is based on a join query.  The join relationship is one
to many.  When a new record is added and the user enters a value for one of
the fields in the "many" records, I attempt to lookup (using DLOOKUP) the
parent record and set the join field in the subordinate ...

When is it appropriate to "close" objects?
Example. Which of these objects should be "closed"?
Dim Wsp as Workspace
Dim Dbf as DataBase

I just resolved a strange situation I was having with an ODBC linked SQL 7
view in an Access 2000 MDB file, and I'm trying to get some understanding as
to what happened.
The linked view was scrolling very slowly in the MDB file; however, it

I have a subform, where in the "on current" event, I display code that
is supposed to recognize which record I am pointing to, and then
display more specific info in another subform based on that one record
that I have highlighted.

I need to create a report from a form.  What I'm trying to do is create a
system where I can examine data for a single client on a form then print a
report on only that client - Any ideas??
Thank in advance

I have created a database in MS Access and wish to distribute it as an
.exe package.  Can this be done and what do I need to do it?
Thanks for any help.

Access 97
I'm trying to check a table and add fields if necessary using code to a BE
MDB.
At the moment I'm reconnecting to the BE using code based on code written by

I need to create a button which changes the back colour and the font colour
and type of several fiels in a form, This is the way I would normally do it:
[Date].Backcolor = 11112121
[Date].tabstop = True

When working in .adp there is a peculiar Resync command property in forms.
I have noticed that I can avoid resync when putting stored procedures as
record source instead of views or in-line functions. Also, it seems that I
van't use resync with stored procedures...

I have the following control on a report:
"Total " & [ProductCode] & " " & [Form] & "  --  " &
Format$(Sum([SumOfNetWeight]),"Standard")
I can't use the simple way because of the concatenated fields. How can

Can you help me on that:
I want to use OpenRecordset to open a query.
Normally, the query gets some parameters from a form.
How do I pass the same parameters to the Recordset I want to open?

This is Access/Office 2003.
I'm generating a Word doc, using a template, and attaching it to an
email message. When the users get the message and open the attached
doc by double-clicking in the Outlook message window, it defaults to

I'm getting "#Error" in a report's textbox where the control
source is the following:
=[lname] & (", "+[fname])   .
Both lname and fname are valid field names for the table assigned

I have a form in which I am trying to filter a query using up to 6
combo bixes.  The problem is, unless all 6 combo boxes are selected
properly, nothing will apear in the Subform.
I would like to be able to see the entire query until I select a