Hi Experts,
I wish to create a button to simplify my data export processes. I want to
export a
table using a query name myquery1 into "fixed width format text file". I

I am having difficulty in setting up a DLookUp function for a control on a
form.  I am using Access 2002.
I have a form (frmQuickEnterResourcesUsed), with subform, for users to enter
resource data.  The principal form has two fields (unbound), RefNo and

I am wanting to create code to open any form, but without using th
DoCmd.OpenForm construct. The code I am playing with looks lik
this
   Dim frm As For

Appreciate if someone could help me on the following problem. I have a
button to
export a table to text file with fixed width format.
1) How to write the code to export the field at the correct position ?

I need to display a message in a MsgBox.  Certain words must be BOLD and
Underlined.  I am having trouble with individuals not reading their messages!
I know this can be done with ActiveDocument.Scripts, but I cannot figure out
how to use it.

I have a field on a main form.  It contains a series of three digit codes
that each references a separate value.  I have a table that has these values
along with the descriptions for each value.  What I would like to do is that
when the main form is opened and a record is chosen ...

My conditions are:
Main form name = FAddTiers
Embedded subform name = FAddTiersSub
Controls in subform =  Tier1Connect, Tier1Sort

I have a form where I input facility information.
In the form's before update event I check the required fields to ensure
there is data there, among other things.
On the txtFacName ctr I use the Exit event to check if that FacName is

I am trying to use SQL to insert a text string that contains quotes into an
Access 2002 table.
My INSERT statement looks something like this:
INSERT INTO ResearchArticle (ResearchID, ArticleID, Summary) VALUES( 17,

I have a form set as my startup form.  However, it is not opening as
Maximized.  How do I set it to open maximized?
Thanks,

Access 2003. I have a subform on a form, where the subform has a collection
of 22 bounded checkbox controls. Three of these contols trigger the visible
property of three respective combobox contols on the same subform. Each of
these three checkboxes, when checked (same as Yes in ...

i have a table that needs renaming, but there are many queries that use that
table. I can remember a while back changing a table name and the associated
query changed the table name automatically when i changed the table name.
Is there a trick to make maual table name changes auto ...

I have a simple table "tblVendor" and another table "tblNotes".
The structure for tblvendor is:
coID
CoName

Does anyone know how to change the tab placement from top to bottom
placement? (similar to Excel spreadsheet where the tab are on the bottom)
Thanks,
Charles

I have a table with a range of dates.  I would like to select the minimum
date and assigned it to a label on a report when the report is opened.
the code I currently have is giving me a type mismatch on the  :set myset =
...