I need some help with the following:
I have a form with a subform.
The main form is linked to a table
On the main form, there is a text box

Hi to all,
On my Clients form I had a combo box, cboClientSearch,
which I used to locate a specific client. In its
AfterUpdate event I had the following code which worked

SELECT Shipment.PUDate, Shipment.SchedDelDate
FROM Shipment
WHERE (((Shipment.PUDate)=Date()) OR ((Shipment.SchedDelDate)=Date()));
I would like to filter my frmDispatchBoard based on the query above.

Windows XP, MS Access 2000
=======================
I have a form (frmEvent) to enter information for a Program Event, and it
has a subform (sfrmEventAttendee) to enter the names of attendees. The

I am trying to get the index of the current control that has focus.
I tried:
Index = Me.Controls(Me.SNDetailSubform.Form.ActiveControl.Name).TabControl
Index = Me.Controls(Me.SNDetailSubform.Form.ActiveControl.Name).Index

Why is the filter by form feature not available in the runtime version?  Is
there a workaround?
The right click dialog box when in a field in a form is so valuable to my
end users.  Especially the "Filter For" option.  Any workaround for this as

I want to add a day to a date and it seems like the following should work
LastSubmitted date is 1/12/2005
I want to return 1/13/2005 in StartDate
using

Using Access2000.
I have a form with a bunch of dropdowns. I know I can add
the Me.activecontrol.dropdown event to each dropdown event
(on the GotFocus event or something), but I was wondering

I have a frontend/backend database. Sometimes when I install the
program on a new machine I find out that there are reference problems.
Is there a way to trap this error in code?
Then perhaps I could delete the reference if I feel I can live without

I have a sum in the page header of my report that is a total from a subreport
(control source = =Reports!rptBOLHeader!rptBOLItems!ItemTotal) - it
works fine in Access 2002 and shows nothing in Access 2003 - can someone
point me in the right direction,please?

I have a form with a subform : on the form there is a control (textbox) wich
value should depend upon  the checking of another control 's value that's
located on the subform (If the value is Null then value1otherwise value2). I
think the IIf function is the one to use but I can't ...

How can I over ride an individuals color settings for
windows menu bars, command buttons, and tabcntrl objects
in an access form.
Some users on my network have chosen some hideously dark

Is there anyway to get the "No data" return value from a report?  I have all
my code that generates a report dynamically in the report so I want to grab
the "No Data" value in a form.  Only thing I can think of is in the report
"No Data" event creating a table to store the flag ...

I have a form that makes a copy of the backend database.  The code is below.  
However it works fine when I open the database with the shift key, but when
it is open in run mode (not .mde) it gives be an error box that says
"Permission Denied".  This is in Access 2000.  Anyone ...

I want to lock down some of the records on the form where the flag column for
that record is marked "yes".
for example I want to nobody can change the "Purchase Order table/query" via
"Purchase Order form" if one control/column named "Status" of the "Purchase