Access 2007 - black hole forms
-
I am noticing some freakiness in MS Access 2007. I had a DB application with 2 forms I use in a utility capacity (to produce a listing of tables within and properties, the other to produce a listing of objects - form names, macro names, query names, ...) I decided to copy those forms to another application so that DB application #2 can have the same utility features. I did a Ctrl-A select all on the controls from Form 1, db App#1 into new form, db App#2. Likewise for the other Form 2. Now in db App#1, i can't display Form 1 or Form 2. I even go directly to the Navigation pane and select Form 1, choose Open.... NOTHING :confused: I don't know what happened with Access 2007?!?!?!
-
I am noticing some freakiness in MS Access 2007. I had a DB application with 2 forms I use in a utility capacity (to produce a listing of tables within and properties, the other to produce a listing of objects - form names, macro names, query names, ...) I decided to copy those forms to another application so that DB application #2 can have the same utility features. I did a Ctrl-A select all on the controls from Form 1, db App#1 into new form, db App#2. Likewise for the other Form 2. Now in db App#1, i can't display Form 1 or Form 2. I even go directly to the Navigation pane and select Form 1, choose Open.... NOTHING :confused: I don't know what happened with Access 2007?!?!?!
-
I am noticing some freakiness in MS Access 2007. I had a DB application with 2 forms I use in a utility capacity (to produce a listing of tables within and properties, the other to produce a listing of objects - form names, macro names, query names, ...) I decided to copy those forms to another application so that DB application #2 can have the same utility features. I did a Ctrl-A select all on the controls from Form 1, db App#1 into new form, db App#2. Likewise for the other Form 2. Now in db App#1, i can't display Form 1 or Form 2. I even go directly to the Navigation pane and select Form 1, choose Open.... NOTHING :confused: I don't know what happened with Access 2007?!?!?!
-
A stupid question but, did you use cut (ctl-X) instead of copy (ctl-c)?
It's time for a new signature.
From DB App #1 (source), I selected all controls (Ctrl-A); copied (Ctrl-C); went into DB App #2, on a blank form; pasted (Ctrl-V). I had a co-worker look it over and he went into DB App #1, did a change to code (then undid it - basically forced a modification to be recognized), saved DB App #1. DB App #1 then worked as before! Craziness of MS Office products :~ Thanks for the reply
-
Might be a missing reference. Are you using any ActiveX-controls or other special controls in the first project? You can check the current references in the Visual Basic editor, first item in the "Tools" menu.
I are Troll :suss:
Both Apps (source copied from, DB App #1 and destination copied to, DB App #2) have the same referencing as they use similar Active X controls and reference similar objects (like Excel, etc...) It is the source, original DB App #1 that is experiencing the problem - only copied the controls from a form in DB App #1 and pasted them into a blank form in DB App #2 (Ctrl-A, select all controls; Ctrl-C, copy from DB App#1; Ctrl-V, paste into DB App #2). A co-worker took a look and did this: "faked a change" in DB App #1 VBA code (made change/undid change). Saved the VBA code that supports DB App #1. Then DB App #1 (the source copied from) worked as before! Craziness that is MS Office :~ Thanks, John John
-
Both Apps (source copied from, DB App #1 and destination copied to, DB App #2) have the same referencing as they use similar Active X controls and reference similar objects (like Excel, etc...) It is the source, original DB App #1 that is experiencing the problem - only copied the controls from a form in DB App #1 and pasted them into a blank form in DB App #2 (Ctrl-A, select all controls; Ctrl-C, copy from DB App#1; Ctrl-V, paste into DB App #2). A co-worker took a look and did this: "faked a change" in DB App #1 VBA code (made change/undid change). Saved the VBA code that supports DB App #1. Then DB App #1 (the source copied from) worked as before! Craziness that is MS Office :~ Thanks, John John