 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / January 2006Template VBA form and Code Missing
Hi out there. I am Access programmer just learning VBA in Word. I spent last two days learning how to develop an input form use the VBE, controls, command buttons, etc. And I also added code to add data to combo boxes, initialize defaults, etc. This was all done at my client site. I returned to my office, and via gotomypc, I downloaded a copy of the template. When I open the template, the bookmarks are there, and document stuff. But no vbe form, or controls, or code. In access, I just move a database and everything goes with it. Help  Signaturemicrobus Henry: Sounds like you may have built the forms and controls in the PC's normal.dot file instead of in the document you fetched? ************ Hope it helps! Anne Troy www.OfficeArticles.com > Hi out there. > I am Access programmer just learning VBA in Word. I spent last two days [quoted text clipped - 13 lines] > > Help Okay, So I should be ok if get the normal.dot file. But, this template is to be distribute. So, how do I transfer to the code and data to the template? Thanks Signaturemicrobus > Henry: Sounds like you may have built the forms and controls in the PC's > normal.dot file instead of in the document you fetched? [quoted text clipped - 20 lines] > > > > Help In the VB Editor (Alt+F11), you should be able to drag modules from one document (or template) to another. Go to the Word MVP site at http://word.mvps.org/ and do a search for the word "distribute" to find out how to distribute macros to others. ************ Hope it helps! Anne Troy www.OfficeArticles.com > Okay, > So I should be ok if get the normal.dot file. [quoted text clipped - 28 lines] >> > >> > Help Thanks, I can't get to the desktop until tomorrow. So then, we shall see. The project is only half done. I am doing the other half(the form has a tab control with 8 tabs) that require bookmarks. So, I will build the tab control, and bookmarks. I hope to copy the tabcontrol, and bookmarks into the original work? Signaturemicrobus > In the VB Editor (Alt+F11), you should be able to drag modules from one > document (or template) to another. Go to the Word MVP site at [quoted text clipped - 37 lines] > >> > > >> > Help Well, you can click and drag, but you can also export modules and forms... :) Just right-click a module or userform and choose Export. Then you can even send the exported file and import to another file. ************ Hope it helps! Anne Troy www.OfficeArticles.com > Thanks, > I can't get to the desktop until tomorrow. So then, we shall see. [quoted text clipped - 51 lines] >> >> > >> >> > Help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.