I am performing a valdidation rule on a field on a subform in the form of:
DLookup("[Invoice #]","Query1","[amt] = &" Form.subform.control)
This is with Access 97.  What is the syntax to refer to the control on the
subform when using DLookup?

1-How can I use VBA Code To Copy (Ctrl+C) any think.
2- How can I paste the result on specific place on my H.D like D:\  (by VBA
Code)
Step should VBA Do

I can't be the first guy who wants to copy protect his access app.
Is there a nice tutorial out there somewhere about generating some kind of
computer-specific ID code at runtime, that I can use in concert with some
licence-specific code I create and email them to enable/disable ...

I need update or insert data in to memo field.
Docmd.RunSQL runing perfect, but does support transaction rollback or commit
DAO.QueryDef only accepts parameter up to 255 characters, but support roll
back.

Is there a VBA function that will return the
1st numerical value in a string?
E.g.,
val = FirstNo("ClassID = 8 AND bla bla bla")

i want to add a command that will update header.backcolor... in (all) of the
forms with in the current project...and am using the following code
(below)...
it loops thru the forms correctly, but does not change the color...

Hi can any body tell me why this code works for a table but not for a query
please
this works for a table.
Dim rst As DAO.Recordset

Hi,
I really need help with this.
I have two Table PatientRecordTb and PTRTransTb.
PTRTransTb is unbound Both Table are same .

It appears that the filter expression passed to
a report as a part of the DoCmd expression
is not available in the Open code.
I.e., Me.Filter is null.

It looks like it should work, and I have painstakenly looked over it for a
long time.  It runs, but the result is not what I want (checking if record
exists):  The primary key is the retort id & labor code & process_name &
employee_name

I'm using the following code in the Click Event of a list box in one form to
open another form and go to a specific record:
   stDocName = "frmActivity"
   stLinkCriteria = "[ProjectID]=" & Me!List2

I have a table with fields (Id primary key) and (d_object OLE)
The field d_Object contain (data base) as OLE
Dear all I want to use VBA To Copy OLE from the table and put it in specific
place on my H.D (D:\) for example

I was upgraded to 2007 and the following line throws an error:
Me.DateUpdated = Now()
This is the error I get:
Update or CancelUpdate without AddNew or Edit

I have the following code in the AfterUpdate event of a control.  It produces
the error.
"The expression you entered as a query parameter produced this error.  The
object doesn't contain the Automation Object Forms!frmOrderDetails!LoadedDate"

When an item entered into a drop down box is not found, I have the
application bring up a form so that the item with appripriate info can be
entered. When that form is closed I am returned to the original form which is
which is fine. However, the erroneously entered information ...