wedd
12-15-2011, 03:33 AM
Calling all vb6 for access experts!!!
Why does database keep crashing when code is added? :dunno I developed a database in ms access 2010 and added additional calendar functionality code. The calendar was created in access 2003, however I've noticed that since adding this functionality to my database, features such as drop down boxes have been automatically converted to text boxes, also a pop up box displaying compile error: variable not defined even though the field is in a table and query: it seems a field is causing an issue; and my databse keeps crashing, I use the compact and repair feature...but I'm not sure if it's the code triggering an issue or there is a conflict I'm not aware of...and can I change a field in a pre-existing database and incorporate it into the code? Could it be an issue with OLE automation library?Can this issue be resolved? If so, how and what can I do to resolve this issue? Would you have any good detailed examples from websites, books other resources or your experience on how to resolve this vba issue.
P.S In my references I checked Microsoft DAO 3.6 Object Library but still encounter this issue where a field is highlighted...I changed an initial field name with a new name and hence I encountered this issue.
Thanks for all your contributions!!!:friends:
Why does database keep crashing when code is added? :dunno I developed a database in ms access 2010 and added additional calendar functionality code. The calendar was created in access 2003, however I've noticed that since adding this functionality to my database, features such as drop down boxes have been automatically converted to text boxes, also a pop up box displaying compile error: variable not defined even though the field is in a table and query: it seems a field is causing an issue; and my databse keeps crashing, I use the compact and repair feature...but I'm not sure if it's the code triggering an issue or there is a conflict I'm not aware of...and can I change a field in a pre-existing database and incorporate it into the code? Could it be an issue with OLE automation library?Can this issue be resolved? If so, how and what can I do to resolve this issue? Would you have any good detailed examples from websites, books other resources or your experience on how to resolve this vba issue.
P.S In my references I checked Microsoft DAO 3.6 Object Library but still encounter this issue where a field is highlighted...I changed an initial field name with a new name and hence I encountered this issue.
Thanks for all your contributions!!!:friends: