Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Splitting up "If... End If", just need a hint.
Greetings and happy (early) Sunday, Did the following to the "too large" function: 1. Typed "Public" in front of the function name - this was a SWAG on my part and I hope it thereby makes the declarations and such available for all functions. 2. Bookmarked all the Do...Loop sections... seven...- Zeke269
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Splitting up "If... End If", just need a hint.
Sorry about not posting the code... it wasn't handy when I posted the question. This is a mess - and yes it needs re-written... but our office is inheriting work faster than we can handle and we just don't have the time right now to do a complete redesign. How many lines do you want to see? The...- Zeke269
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Splitting up "If... End If", just need a hint.
Greetings, I've inherited an Access 97 database that I'm trying to convert to 2003. One of the Functions appears to have been written by Leo Tolstoy and it will not compile (too large). I know the function needs to be split up, but I'm not familiar enough with VBA to recognize logical break...- Zeke269
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
