No problem 2 set Access up to get address data from tblClients then to
use a form as a letterhead and to keyboard in the letter content then
save the letter to a tblCorrespondence
Get a scanner. Scan in your letters received to pdf format.Now insert

I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for that
form field, in the control source drop down list it doesn't show the new
field from that table.

Can I do this in one SQL statement?  If so, please tell me how.  I
have wasted a ton of time on this but there has to be an easy way to
do it.  I should have done it with more than one statement and been
done with it but I can't stop thinkin about it.

I'm trying to use a "keypad" form (with command buttons for numbers 0
thru 9) I developed to allow users to first click a textbox on one
form, then click a number on the keypad and have the value entered in
the textbox. It's all seemingly working except that I have an

I have 2 fields in a subform that I want to clear called [Date]  - this
works and [Session] - which doesn't .  Session is populated by 4 choices
from a combo box.  All I want to do is clear the combo ready for
reselection.

Right now at work, I get forms e-mailed to me in an Excel chart with a
serial number in one column and a new expiration date for a device's
trial period in another column.
For a while, when people only sent forms with one or two lines, I

I am trying to take a dataset that looks like this:
     Table1   Table2
ID  Work    Hours
1    abc        123

I have a form that is not related with a table neither a query (unbound
form)
On this form I have a text field where the user can put a text or a
number

I have 2 separate queries, which effectively are the same except they
draw data from separate tables. Both tables are (design-wise)
identical, only the data is different. for each query, there are 2
tables with a standard LEFT JOIN. One field of the query is calculated,

I have a subform datasheet which holds hyperlinks to documents stored on
local disk.  Each database record has a series of documents associated it.
The link is stored in the table like this:
   resource.doc#file:C:\LinkedDocuments\resource.doc#

Hi,
Does anyone know how to make 1 date field 6 months ahead of another in
ms access?
Eg, I have a field called "startdate" where a date is entered. I want

I think the DeleteDuplicateRecords by Danny Lesandrini is amazing but
it doesn't seem to work on my table because I have a primary key
(autonumber).  Does anyone know a way around this?  Thanks.

In ODBC Data Source Administrator, there is a tab "Connection Pooling" and
option "PerfMon" Enable/Disable.
Could someone explain the meaning of the option and how it reflects to
Access when having ODBC linked tables, JET queries on linked tables and

This is probably a silly question that has been addressed already, but
I tried searching and found nothing. How do I join two fields into one?
Suppose I have a table that has this record:
JOHN     |     SMITH     |     555-1234

Now that it finally works, I'm in the process of converting my large
rapid-prototyped Access app into production VB, one DDE-linked piece at
a time. One piece now already in VB takes ~2 seconds to run all by
itself, but when I start running other gigantic resource hogs like