Could someone point me to the part of the access object model that allows me
to refer to fields in a table programatically by their name?  A code example
would be greatly appreciated.

I have several txtBoxes that I want to edit the Control Sources of each of
them.  If I set a variable to the name of the txtBox, can I somehow
dynamically call the control source of the txtBox by a variable as suppose to
writing out the code for each one in long form?  Confused?  ...

I need to rename a .dat file to a .csv file so I can work with it in Access
2003. The following code does not work... any ideas what I should do?
Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Function ChangeFile()

I have: A table with number fields.
I want: To change the format and number of decimal places for a specific
field, Col3.
e.g. Col3 is data type number (no specific properties). I want to

I have a text box with a subroutine event that runs "after update".
The subroutine checks for the validity of the input, and if it is bad, it
blanks the input value.  
What I can't find is how to go back to the input text box so the user can

I need to calculate the age of someone at the time that a test was taken. I
need the age to show years and percentage of year (3.9 years old at time of
test).
I'm putting this formula in a form in Access 2003

I've used this code a thousand times, but now I get a 'type mismatch' error
at the command 'set rs  = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)'.  
This is in a new access database.
(yeah I know, currentdb is temporary but it works)

I'm creating PDF's to be faxed, but the PDF needs time to create before it
can be faxed. How do I put a delay into the system to have it wait until the
PDF has been created? I know I can put a specific time to wait into the
system, but I'd rather only have it wait as long as ...

I just got a new computer at work and a piece of code that has always worked
is now giving me the 'User-defined type not defined' error.  I think it is
because I am am missing a reference library, but I don't know which one.  The
point it errors is between the => <=

I am trying to send a customized report to each of 650 field users that is
generated by Access.  The code creates the custom report and generates the
outlook item just fine.  But, I have one step left to automate.  The pushing
of the "Send" button 650 times was not fun today!  ...

I am attempting to import a report into a new database. One of the report
properties is....Has Module = yes....I belive that the problem I am having
involves the new databases inability to import the module associated with
this report. When I attempt the import I get 2 error ...

Good morning-
I am trying to incorporate Dev Ashish's code to place a form in the system's
tray in an Access 2000 application.  Utilizing the code found here:
http://www.mvps.org/access/api/api0045.htm I create a form, paste the code as

I have found a great bit of code on the Microsoft website on how to disable
the close button on Access 2000.
I need the equivalent code for Access 2007 and Access 2003. Can anyone help?
I know all the pros and cons of doing this and how else the user can close

Before I moved to Access 2007 and Vista I was using Open Source software
called PDFCreator which enabled me to print to PDF.   This software does not
work in Vista so I am stuck with using the PDF approach recently implemented
as an add on in Office.

I have tried several things to try to provide the user with a custom error
message when they enter a duplicate key into a key field when creating a new
record.  Access's own error message always pops up first, which I don't want.
I tried the following code in several different ...