embarrassing bug

  • Thread starter Thread starter Mark R
  • Start date Start date
M

Mark R

I have a "switchboard" form.
I click on command_button_openform
a dialog box then opens (enter paramter value) for Me.lname
if I just hit enter, it opens MAINFORM.

I know that the Me.lname is a bug I left in "somehwere" in
some bad code somewhere. I meant to take it out and then
got sidetracked, a few days went by, and I can't remember
where it is.

I looked at the properties RECORDSOURCE of the
switchboard and mainform. I looked in events ON OPEN of
switchboard and MAINFORM. I did a "find" in the VB/CODE
BUILDER through all the code of Mainform and Switchboard.
I ran all my queries and watched for the "enter value
parameter" dialog box - no luck there either.

For pete's sake I can't find this remnant Me.lname !!
How do I continue my search.

-embarrassed to leave a bug
 
Open the form is design view, and check the Filter and OrderBy properties.

Also check in the Control Name drop down in the Form Design toolbar.

If you are still stuck, and it is definately not in the query named in the
form's RecordSource, open the Immediate Window (Ctrl+G) and enter:
SaveAsText acForm "MyForm", "C:\MyForm.txt"
Then search in the text file to see where the name is.
 
Thanks Allen,

But I get a compile error if I type any of these

SaveAsText acForm "myform", "c:\myform.txt"
SaveAsText (acForm "myform", "c:\myform.txt")
SaveAsText(acForm "myform", "c:\myform.txt")
SaveAsText(acForm, "myform", "c:\myform.txt")
SaveAsText acForm, "myform", "c:\myform.txt"
 
OK, I searched that text file, which is like looking
through thecode builder VBcode. I didnot find Me.lname

Is there a fast way of creating a text file for every
piece of the mDB?

like:

saveastext AcALLmdb , TOTALDBNAME, C:\search.txt

?
 
Back
Top