OpenForm Action Cancelled after ugrading to Vista

  • Thread starter Thread starter Crossh
  • Start date Start date
C

Crossh

I have an 2003 access database that works fine on Windows XP, but errors out
on the docmd.openform line of code (OpenForm action was cancelled) after
upgrading to Vista. Strangely enough, this is only a problem for one form, so
far. All the other forms that have the same code work fine. Basically, I have
the user select a record from a subform and then click on a button (which
rebuilds the query for another form, saves it, and then opens the form to
allow editing of the selected record). Thanks for your help.
 
1. Yes it includes OpenArgs
DoCmd.OpenForm "frmNameOfForm", , , , , , "Edit"
2. No, it does not refer to a control on a form. It's used in the logic of
the processing.
3. The opening form refers to me.OpenArgs which in this case is "Edit".

The strange thing is that I have an almost identical set of forms, using the
same logic, and they work fine. Re-compiling in Vista everytime would not
work, only one of my users has it (not me), and this database gets
re-distributed with changes almost daily.
I always compact & repair before distributing
 
I just discovered something using the Vista OS, when I go into any ODBC
linked (SQL 2005) table and try to filter any date (just by clicking on the
Filter By Selection button) I get the error message, "Microsoft Access has
stopped working" and it closes the db down. Apparently Vista cannot filter
the date, which happens to be in the query that opens the form.
 
"AccessVandal via AccessMonster.com" wrote:
Yes, the problem is Vista. Is there no solution?
 
All the references are the same. Vista did not make any changes to the
references. I already tried to re-compile and repair the database. Are you
saying that you were able to re-create the error, but after recompiling and
repairing the Access db, the date error went away?
 
FYI, I decompiled then compiled all Access 2003 databases and now everything
works fine on the Vista machines.
 
Back
Top