How can I make a field auto-populate the date??
My Database is linked to SQL tables.
I have a field called "Date Entered" that I would like to auto-populate the
date when the data (other fields) gets entered - then obviously retain that

Given:
1. Stand-alone Access 2003 mdb database.
2. Custom dialog form with two textboxes for user input (latitude &
longitude).

I'm using Access 2003 and have what at first seems like a common problem.  On
one of my forms if a user hits the scroll button on the mouse, it scrolls to
a new record which then causes problems.  I don't have sufficient rights to
deploy a dll file so I got around it by changing ...

I've been able to get data for one textbox from a bound control but
not an unbound control (except by using global variables as per the
below).  What am I missing?
Keeps returning a Null value, see the below.

I have a control that is bound to an OLE object in a table.  When i try to
reposition the control with the command  Me.ObjectName.Left = 4000, it does
not compile.  The error message "Invalid Qualifier" appears.  In addition,
when I normally enter the period after the name of the ...

Would someone please correct my code for me, please!  I' want to count a
field named "returned", in a table named "Table1" if both the fields
"Returned & Resent are true.
=DCount("returned","Table1","returned=true and "resent= true")

I have a button on a form and when I click it, I want it to execute some
coding.  I'm using some code that prints and converts a report to PDF and
then does something with that PDF.  My question is how do you reference a
field on that report being used, or a field in the query ...

I have a text box on a form called 'disAddress' with 'Enter Key Behavior'
set to 'New Line in Field'
I have 9 variables D(0) to D(8) that contains lines of addresses
for exmple D(0) could equal "123 Freet Street" D(1) could equal "Near

Happy New Year To Every One,
Can Some Point Me in the Right Direct On How to Achieve Having a
Default Message In My Combo Box
the Message I Would Like Is "Please Select" if a Item has not be

When I try to Compile I get the "Compile Error - Cannot find project or
library"
The error highlighted is at "TRIM" in this string:
If Len(Trim(Nz(stReviewerList, ""))) > 0 Then....

I've got a form that has a two combo boxes (cmbType and cmbStage).  I want to
populate cmbStage based on the value selected in cmbType. cmbType points to
the field tblMain.Type which is a lookup to tblType.ID_Type and tblType.Type.
There are four types in tblType. I figure I ...

Right, I've done lots of searching and I've been here:      
http://www.mvps.org/access/api/api0001.htm
And then I followed these instructions from Allen Browne:
 1. Click on the Modules tab of the Database Container.

I am using the following code to fill a line in one of my tables based
off what someone enters into a text box. The problem is whenever the
code runs a popup dialog box comes up asking the user to enter the
variable values over again. How can I set it up so the values are just

I have a VBA subroutine that gives the following error on the following string
Compile Error:
Can’t find project or library
MyString = LCase(MyString)

i get an error message:   method or data member  not found:
Assessment is a combo box and field name in which the user is storing  a
diagnosis test description.
maybe the problem is the AFTERupdate part of the code: