I added a field to a table and when I go to the form to add a textbox
control, I can't bind it to the field in the table.  It doesn't come up in
the list of fields in the control source dropdown.  What can I be doing
wrong?

Sometimes users (including myself) accidentally click on the application
close icon in the application menu bar when they meant to just click on the
'X' for the form. Of course the app closes and this is very annoying.
So, I added a messagebox to my hidden StartAppForm in the Unload ...

I have a database table, which is linked to a second table. I have some data
in Excel tables, but the data is in 1 spreadsheet, and needs to go into 2
tables, and keep the relationships intact.
The 2 tables are tblEmployees (which holds employee data), and the related

I am creating an Access 2000 database with a Web Front end that will
have around 150 questions with 148 questions having just one number
input (which will either be a 1 or a 2 or a 3 or a 4 or a 5).  All 148
questions will be short sentences such as:

Let me explain what I am trying to accomplish...
Two forms -- we'll call them "Main" and "Related"
A command button on "Main" runs a union query.
The union query results are shown in "Related" in Datasheet view.

I have 2 table; one for keep the Person Info;tblPerson, another one is date
for visit; tblVisit.
tblPerson : PersonID, PersonName, DOB,....
tblVisit: PersonID, Date,......

Now I have a picture in a Form and each record has a different picture.
How can I add this pictures in a Report ?
JDW
Belgium

I was designing an Access database and was playing around with the
startup options. Like a dumbass, I tuned off all the menus and
shortcuts etc. and now I cannot edit the database anymore!!
Is there any way to get th startup properties back!!!

Dear reader,
How can I use a command in the current mdn to compact and repair the mdb.
In which the source file is the current database.
Thanks for any help.

Thanks for helping.I have an A2K Appl.Recently,one of the groups agreed
to provide data which I download into the access table.The problem is
this data which is sent in a text file.I am unable to import it because
of the delimiter tab.The tab is present in places where it is unable ...

I need to reference each user's (many) home share on a network and tried
using the Wndows %username% to do so but this did not work to reference the
directory where my import tables will be using the import specification.
my syntax for file to import was

I have a very simple database containing one table called "tblProducts". The
fields are: ProductID, Description, Price.
I have a folder on my PC that contains image files. The image file names are
based on the associated ProductID, i.e. 2001.jpg is a picture of ProductID

Hoping one of you can tell me why my XML call is failing...
Private Sub Command2_Click()
Production.ShippingAPIs.com/ShippingAPI.dll
Dim msXML As Object, strPageContent As String, fh As Long, MyURL As

I'm looking for a list of what the MailObject can do.  Basically, can I
extract a sender's email address from an email using it.  I know I can
get the SenderName, To, Subject, Body and SentOn (date sent), does
anyone know what else I can get using MailObject?

Is there an easy way to export a continuous report with pictures (6 to a
page, all different) to Quark Express for publication. I may need to
manipulate the text and pictures somewhat. Also need to export page headers
and footers.