I have a form that uses a combo box to control the visibility of two tabs and
changes the ‘enabled’ for a third form.  This is my code I use to control the
tabs:
Private Sub cboStatus_AfterUpdate()

In a form called "Order" I have a text box to count the number of product
of the subform "Product_List":
=[subform Product_List].Form.RecordsetClone.RecordCount
and it works: for example 3.

I would like to set the value of a field on a form to the the value of a
field in the last record of a recordset the recordset is a query whose
parameter is set from a control on the form. I need to know how to refer to
the field in the last record of the recordset.

How to create a button that send email from Microsoft Access form using Lotus
Notes? Thank you so much for your help.

I am trying to use the following expression to search a table for possible
duplicates.  I am getting an #Name? error.
=IIf(DCount("*","[qryContactsExtended]","[Employee_ID]<>" &
Nz([Employee_ID],0) & " And [Contact Name] = '" & Replace(Nz([Contact

I built a database to track membership in our Club.  On the form that I
record payment of dues I manually change the default value the 1st week of
January for the field labeled ‘PdThrough’   e.g. #12/31/2008#.  
I want to hard code the PdThrough date to read m/d/yyyy.  The year ...

Hello Gang,
I look after events and would like to have a facility that would allow me to
generate recurring bookings, without having to enter each one manually.
For example, I have a Team that's booked the Rugby Pitch every Sunday for 8

Well I am still having fun with this problem. Thanks to " Marsh MVP
[MS Access] " for your help.
I am trying to be a little more specific with names as I describe the
problem again.

I'm attempting to generate a total based on these criterion;
Time Interval is > 10 minutes  (I'm willing to add a yes/no control instead
of having Access figure time differences)
ID # is ???  (Would like to make for example 3 Totals of 3 different ID

I need to copy the record on a form to another table.  I have tried various
versions of this statement both with and without brackets and parentheses
around the field names:
DoCmd.RunSQL ("INSERT INTO tblMembers (First , Last) SELECT Me.First ,

How can I format for DD/MM only

I've got a custom command bar (MyFileMenu), which contains Close and Quit
options.  On my Splash form, I want the Close option to only be visible if
I'm in debugging mode (I've got a function to determine if this is true or
false).  So in the forms Activate event, I have the ...

How do I load a picture into an *unbound* Image Control when I only have the
object itself (stored in a table field) and no filepath/filename?
I'm storing a few logos in a table within my mdb. I'm playing with the idea
of loading them into my forms & reports at Runtime for various ...

At some point in the execution of my program I open a dialog box were the
user is supposed to enter some info. Among other things he is asked to enter
a date in a textbox, but this is optional.
When I try to assign this date to a date variable I get the message “Invalid

I want to have a command button, on form frmDvd, open form frmDvdEdit
to the same record that is the current record on frmDvd. Also, I want to
be able to 'browse' using the frmDvdEdit (records not filtered). My Primary
Key is DvdMovieID.