Just an update.........
The problem recurred after the original repair, possibly after using the app on a different computer (don't know the Jet version etc on that machine), and affected all users on all other machines that had previously been OK.
One particular form seemed to have a problem responding to events - records didn't save on closing etc - very deeply bizarre!
The fix that seemed to work and...
User Profile
Collapse
-
Just a reminder....
If combobox items never have to change they can be set when the form and control are designed and will always revert to the original design contents when the application is restarted.
If the combobox items have to be set or changed at runtime and then have to be saved for next time, the items will have to be saved outside the application. This can be either in a database or in a separate data/text...Leave a comment:
-
Handling MS Word events in VB.net
My app starts Word, opens a new document, gets data to fill in demographics, then hands the doc to the user to type the body text of a letter. User then returns to the app to get another set of demographics, then returns to to Word to type another letter, and so on till finished. So far so good.
At present the app checks if Word is running and Doc is open for each new letter and restarts or opens a new doc if required.The danger is... -
ENTBedford replied to After Access 2000 to 2003 upgrade event handlers that call VBA procedures don't workin AccessI had this from a colleague at work who was able to fix it:
This type of environment is "event-driven" and there are triggers attached to the events which will process routines with pre-determined names. At least, that’s how it appears. What actually happens is slightly different and it occasionally seems to go wrong in the linkage between the event and the coding that is supposed to be started by firing the trigger....Leave a comment:
-
ENTBedford replied to After Access 2000 to 2003 upgrade event handlers that call VBA procedures don't workin AccessAccording to the MDAC component checker I have MDAC 2.8 SP1 on Windows XP SP2 which is pretty up to date.
I have Jet 4 SP8 too.
I still can't get a handle on the problem.
Any other ideas gratefully received....Leave a comment:
-
ENTBedford replied to After Access 2000 to 2003 upgrade event handlers that call VBA procedures don't workin AccessThanks Puppydog.
I have checked for unsafe expressions - there are none. it's the actual event that triggers the error before the code runs.
Can you explain more about self certifying after recompiling please - that's all new to me.Leave a comment:
-
ENTBedford started a topic After Access 2000 to 2003 upgrade event handlers that call VBA procedures don't workin AccessAfter Access 2000 to 2003 upgrade event handlers that call VBA procedures don't work
Ive been using my Access 2000 database for years to run a surgical waiting list. It's on a shared drive and is accessed by several machines running a mixture of Access 2000 and 2003 under XP.
One of the 2000 machines was upgraded to 2003 and wham - "Event handlers that call VBA procedures don't function after upgrade to access 2003" (quote from http://office.microsof t.com/en-us/access/HA011225981033. aspx#030). This happens...
No activity results to display
Show More
Leave a comment: