Delete a module

[Mac1206]

Can anyone provide me with the steps to delete this module off my form homepage in access...I'm receiving this error when it opens now but it won't let me delete module 5 nor do I know how...Right clicking won't work...

error message when database opens to form homepage: undefined function network username in expression

 

[Trevor G]

Try the following. Before you open the database hold down the Shift Key and then open the database that should bypass any automations, then you should beable to open the form in edit mode and find the module you want to delete, a warning though, do you really want to delete the module? I would take a copy of it before you delete it incase it is doing something vital. Or look to comment out the code line which provides the error until you understand what it should be doing.

 

[Mac1206]

Try the following. Before you open the database hold down the Shift Key and then open the database that should bypass any automations, then you should beable to open the form in edit mode and find the module you want to delete, a warning though, do you really want to delete the module? I would take a copy of it before you delete it incase it is doing something vital. Or look to comment out the code line which provides the error until you understand what it should be doing.

I see the module which is Module5 but when I try to remove it it gives the Error File Not Found but the module is still there...I made the mistake and deleted the code in the module first and then tried to delete it...Now I'm getting the Error "File Not Found". Rookie error...Still learning...uggh

 

[xenou]

Why do you think deleting module5 will fix the problem in the homepage? In regards to deleting a module I've never heard of this error before. If you want to you can just import all your database objects into a new database (forms, reports, tables, queries, modules). And essentially rebuild it. Without module5 of course.

 

[Mac1206]

Why do you think deleting module5 will fix the problem in the homepage? In regards to deleting a module I've never heard of this error before. If you want to you can just import all your database objects into a new database (forms, reports, tables, queries, modules). And essentially rebuild it. Without module5 of course.

I think that's my best course so I did that and it seems stable now...Module 5 was a button I created but didn't work and once I deleted the code out the module then tried deleting the module I got the error and when I tried opening the form this error came first "undefined function network username in expression" then it opened...Thanks

 

[xenou]

okay, cool. Normally no problem deleting all code out of a module - so its a weird problem with the file not found error.

 

[Trevor G]

Sounds as though thecommand button was calling something from somewhere else as it should have beenthe command button event you were looking to delete not the whole module asthat would relate to the form events. I would follow xenou suggestion, keep theold database in case there are things it was doing that you haven't imported intoa new one.

 

[Mac1206]

Sounds as though thecommand button was calling something from somewhere else as it should have beenthe command button event you were looking to delete not the whole module asthat would relate to the form events. I would follow xenou suggestion, keep theold database in case there are things it was doing that you haven't imported intoa new one.

I did and thanks for the help....