Hi. Using the following code to emulate the record count
on the navigation buttons.
Dim RecClone As Recordset
Dim intCount As Integer

From VBA, inside a Subform, to retrieve :
1) my form's name , I use : Me.Parent.Name
2) my subform's name, I use : Me.Name
But how do I retrieve the object's name containing my subform ?

Why some times calling subform [or master form] public methods from inside
form works, and other times it gives runtime error 2455 "You entered an
expression that has invalid reference to the Property Form"
Private Sub aMainFormEventProcedure()

I have a form that has a combo box of valid dates. the user selects a data,
then clicks on a button, which opens another form in add mode.  the new form
has a combo box that is populated by selecting data from a table.  The date
selected on the first form is used in the "where" ...

Hi to All
I understand that when a form is opened from within a sub, the proc will
continue to execute after the DoCmd.Open unless the form is modal.
What happens when an action query (e.g. make table) is invoked within a sub?

See code below.  I figured I'd get the message box asking me to delete
the record twice if I hit errors 3022 or 3058.  But I don't.  I just
get it once.  How is this possible?
Thanks in advance,

I am trying to create a list box that shows a specific set of queries for
users to select from (click on) and print or view or whatnot.  Now, I have a
handy-dandy Access textbook that gives me the following SQL statement to use
(let the forehead slapping and eye-rolling begin, ...

I have tried to use an option group and a combo box as shown in the approach
by Martin Green at www.fontstuff.com CascadingListDemo4.  After days or work,
I cannot get it to work properly.  I am not using a table for the
ReportNumbers, but am using a union query "qryAllReports" ...

I am having trouble using a combo box to limit the parameters of my
query/report. I have a list of volunteers (2 fields, First Name and Last
Name) based on what program(s) they volunteer for (3 fields, Program Type,
Program Type 2, and Program Type 3). The programs use the same ...

I'm sorry to ask this "often asked question" again, but after 2 days of
reading thru posts I'm still stuck.
I have a small Form with 4 fields on it and a Command Button to "ADD RECORDS
to DATABASE":

I've got a parent form (frmParent) with a subform (sfrm1) on which another
subform (sfrm2) is embedded.  The subforms are displayed in datasheet view,
so the little + sign displays in order to expand the recordset.  What I would
like is when clicking on the + sign in order to get ...

I was revising my code as recommended to avoid using:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
and use:

I'm not quite sure what to ask.  I have a public function that, depending on
values such as expiration date, generates one of several text strings that
are used on faxes.  Here is a shortened version:
Public Function FaxText(NoExp As Boolean, CertType As String) As String

I am creating two applications and when I checkmark the box "cash & check
card", I would like all the personal information from the first application
to transfer to the 2nd application. Are there any ways to do this?

I have a macro with setvalue action:
Item: [Forms]![NewPartInputfrm]![Ref Part Weight lb]
Expression:  IIf([Ref Part QTY]<0.0001,0,DLookUp("[FIN
WTLB]","ExcelARefParts","[Part#]=Forms![NewPartInputfrm].RefPart AND [As