Consider the following sample table and values:
Field1                         Field2
______                      ______
A

Hi, using Access 2003.
Does using the application.printer properties/methods work ok when run in
.mde mode?
Many thanks

I have an access database with forms. I was wondering if there was a
way to make a form field do an autocomplete action during data entry
based on values already in that field for other records? In other
words, if I were to enter the letter J into a field, an autocompletion

I am having a problem with DoCmd.OpenQuery syntax.  Can you help me with
proper syntax.  I want to open a query that is specified in a form list box
(users select the query they want and click submit).
[Report Generator] = Form name

I'm trying to import a text file containing file information, such as:
12/24/2005  01:00p       3,400,157,210 Mr. Magoo's-2005-12-24-0.mpg
11/10/2005  07:00p       3,400,249,370 Off-Shore Oil-2005-11-10-0.mpg
I created this file with the command:

Is there a way that I can sort the results that the
records are returned when using CurrentDb.OpenRecordset
("MyTable").
I have a field in 'MyTable' that I want to use to drive

I have an application which needs a number of reports to open either with
both modal and popup properties, or with neither modal nor popup properties
set, depending on the user type. However, when I try to set the modal
property from code in the report's open event I receive a ...

I have a table to store timesheet of employees. From the begining of the
cutoff date, I need to add EmploeeID and Date by extracting only the day and
append into the table. How can I loop and extract the day from two given
dates

If you have 2 instances of the same database opened is there any way to
programmatically close a specific instance. In other words how does access
identify which of the two instances you are working in? Is there a _1 and _2
put after the names such as what happens when you link ...

I have a subform with customer details in.....ie
'date product sent', 'product name', 'price' and a few other details.  What
I need to be able to do is to track clients who do not have a product sent in
the previous month, in order to keep on top of my forward planning for sales.

I've created an cross-tab query for visualisation my monthly expences, like
this:
              Feb 2006  Jan 2006   Dec 2005  ...
Clothing        45,00       60,00

I am creating a program that uses forms, tables and modules with lots of VB
code.  I want to have the program check for an update db and copy any form,
table or module from the update db to the currentdb.  I have seen the
CopyObject method but it seems it copies from the ...

I´m using Access 2002, in Windows XP.
When I close a database it is saved automatically, OK, but I want to get a
few more things done then, especially to make a safety backup copy of the
.mdb file to a different drive or folder.

has anyone got a step by step guide on how to  format a text cell, or gudie
me on the right direction to a book etc. (new to programming)
trying to highlight cells if they have different status i.e. to scene = Red,
Standby = Green etc. as the inbuild only allows upto 3

Can someone help me with this SQL line of code?
Dim strSQL                        As String
Dim lImporterID                  As Long
Dim strReference                As String