[AccessD] Macros (ugh)
Rocky Smolin
rockysmolin2 at gmail.com
Fri Nov 21 19:43:20 CST 2025
Dear List:
I am working with a database which was written in 97 and the client has
only the replica. So I managed to import all of the objects into a new
front end and display the data entry main form which (after creating an
abbreviated main menu) I have to get working.
First problem was that recordsetclone does not work. NoMatch is True.
Me.RecordsetClone.FindFirst "[case#] = " & Me![List283]
MsgBox Me.RecordsetClone.NoMatch & " " & Me![List283] & " " &
Me.List283.Column(1)
Me.Bookmark = Me.RecordsetClone.Bookmark
where case# is an autonumber field and Me![List283] is a list box of case
numbers and column (1) of that list box is the client name.
So I tried DoCmd.FindRecord ME![case#]
But I get an error:
A macro set to one of the current field's properties failed because of an
error in a FindRecord action argument.
So I deleted all the macros in the navigation pane.
Same error message.
Then I ran:
' Iterate through all macros in the AllMacros collection
Set dbs = Application.CurrentProject
For Each obj In dbs.AllMacros
Debug.Print obj.Name ' Print macro name in Immediate Window
Next obj
and it found no macros. Which I would expect as it's looking in the Macro
container.
So where could this macro be hiding?
MTIA
Rocky
More information about the AccessD
mailing list