Search results

Thank you both for the advices. I checked codecontextobject and tested its .name property, it display the form name the Sub is from, just like vbaInet said, it works the same as me.name. I guess I'll just have to hard code it.

Thanks Nigel. This indeed is my own notebook, I'm the only admin account. I can move folders and files in and out of C:\Program Files\, but can't modify the Access data file. So it's kind of mystery to me.

I used to be able to keep my Access program and data under C:\Program Files under Windows XP, under Windows 7 I get "not updatable" message, opening the data file under C:\Program Files shows "read-only". Does that mean I need to keep my data in other places? Thanks for your advice in advance.

When I use msgbox, I like to display which module this message comes from. Currently I hard code the module name in the message. Can anyone show me is there a system variable that has this module name so I can display it automatically? Thanks for your advice in advance.

Hi, Boyd - Thank you for your response. Enjoy your HiTechCoach website, bookmarked for future reference. The website you provided is more of new features rather than conversion procedure. So far I've converted my 2000 mdb version to 2007 accdb version, created a spreadsheet to log all macros...

I'm new with Access 2007 (what a mess), trying to convert my Access 2000 version system to 2007 version. The older version is all macro driven, I'm now much better with VBA, also need to add more functions (tables, queries, forms, reports, and of course class modules). How should I go about...