Re: MS Access 2000 run-time error '2465' "can't find the field 'Forms' referred"

If you are seeing lots of gibberish in MSysAccessObjects, I suggest you get
Access to recreate the database for you.

I should have qualified this. While there are recognizable strings in MSAO
rows,
most have an "wingding" graphic box in place of what I guess would be regular
characters
in each row. I might copy the DB and just try a mass edit to see if anything
breaks.

Follow steps for first symptom in: Recovering from corruption at: http://allenbrowne.com/ser-47.html

I did, and when I imported from the original DB to a test DB, the problem
came along. I went
incrementally, when I imported the forms, macros and modules, it broke the
same way.

There is a free utility to check your tables for bad field names etc here: Database Issue Checker
at: http://allenbrowne.com/AppIssueChecker.html

It found no probs.

If you open your form in design view, the left-end of the toolbar has a
drop-down for selecting the controls by name. Controls are listed
alphabetically, so you could find any control named Forms there. In the
form's module (code window), you can use Edit in the Find menu to find any
occurance of Forms.

I'm using Access 2000, and I can't find a drop-down for selecting controls as
you mention.

Back to the line of code that blows up (marked by <<<<):

Me.Bookmark = rs.Bookmark
If Not IsNull(Me.OpenArgs) Then
Dim strQueryOnID As String
Dim rs As DAO.Recordset

strQueryOnID = Me.OpenArgs
Set rs = Me.RecordsetClone
rs.FindFirst strQueryOnID

If Not rs.NoMatch Then
Me.Bookmark = rs.Bookmark <<<<
End If
End If

Comment: I'm a 'C' programmer, not an Access VB or Office VB programmer.
This line that
stops program execution, ...if this was in 'C' we'd be dealing with two local
structures (the dot
seperates the structure name from structure member), and whatever value is in
struct rs
variable Bookmark is assigned to struct Me variable Bookmark. No other
variables are
involved in the _assignment_. But, apparently, at this point in program
execution there's
something more than _assignment_ going on, manifest by the error message
talking not
about "Bookmark" variables, but some missing field:

Microsoft Access can't find the field 'Forms' referred to in your expression

Humor me in my 'C' vernacular. Ok, in "debug" mode, in the "Locals" window,
I poked around
in the variables listed on the RIGHT side of "Me." as well as the right side
of "rs." The closest
I can come is Me.Form (not Forms) and rs.Fields. If I poke further, I get
deep into a rat's nest
of (apparently) more Access intrinsic settings and (Form) control details.

Now, if I pay attention only to Me.Bookmark and its subordinate structure
"members",
compared to rs.Bookmark and its subordinate structure members, I get (in the
"Locals" view):

(column header)
(Expression) (Value) (Type)

Me.Bookmark
Bookmark(0) 0 Byte
Bookmark(1) 2 Byte
Bookmark(2) 0 Byte
Bookmark(3) 0 Byte

and

rs.Bookmark
Bookmark(0) 11 Byte
Bookmark(1) 2 Byte
Bookmark(2) 0 Byte
Bookmark(3) 0 Byte

Still, nothing about missing field "Forms". I have no idea what rs.Bookmark
(0) = 11 means,
but it doesn't match Me.Bookmark(0), which is 0.

If I just KICK the damn computer really hard, will it straighten out??
:(

This feature of my design I'm trying to fix is _critical_ and really _not
replaceable_, I need to
give the user a list of items, whereupon one is selected and it calls up
another window where
details on that item are displayed. A redesign of the database would only
produce a less
efficient table layout and loss of already-designed functionality.

<sigh>
I can't myself find any field "Forms" anywhere. HELP!
Thanks!

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: The Zen nature of a Delphi database application
    ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
    (comp.lang.pascal.delphi.misc)
  • Re: multiple subform images per main search form record
    ... Document ScreenDumps of: ... get a marker and label all controls with the Name property so when you ... save your word doc in the directory with the database you are documenting ... Show Images from Continuous Subform ...
    (microsoft.public.access.formscoding)
  • Re: When to (not) use the ADO data control
    ... > over is that you should use unbound controls in favor of bound controls. ... simple database program for your own use, ... > programmer that wrote the application used a mixture of DAO data controls ... I am by no means an advocate of bound controls. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADD method syntax for collections
    ... any database record was capable of displaying three photographs; ... I get "Photo4" highlighted in a line "If ... or is it a query? ... On that form, I guess you have controls that are, or are supposed to be, bound to the Photo fields. ...
    (microsoft.public.access.formscoding)
  • RE: Filling in form with recordset HELP
    ... Fields are bound to controls on a form, but not to the database itself. ... then bind fields from the Row Source (a table or query) to controls on the ... The example I posted is for use with an unbound form. ...
    (microsoft.public.access.formscoding)