Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Using VBA with Custom FormsExpand / Collapse
Author
Message
Posted 11/14/2005 1:49:57 PM


Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 6/1/2006 9:16:25 AM
Posts: 53, Visits: 123
Can anyone educate me, or point me to a location that can educate me on how I can use VBA with custom forms? I heard some of you are using it and I just can't figure out how.

Are you using word forms or merging straight into VBA? If you just want to send me an example I could go from there if that will be easier.

Thanks in advance

Post #1205
Posted 11/21/2005 9:59:48 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242
The best method I have found is to write your subroutines in VBA (using the VBA editor within Word) then using the onload event to call your routines. That way, they get executed right away. The problem is, you may have to wait for other processes to complete so make sure you use the appropriate event to call your routines.

There are several books on how to use VBA with word. Depending on the version of Word you're using, you'll want to select the book that matches your version. There are also lots of resources and examples at http://www.support.microsoft.com/?scid=kb;en-us;826531&spid=2530&sid=global. Unless you are familiar with VBA programming (or masochistic or have nothing better to do or you've lost a few marbles or you're willing to work for nothing or ...), it will be cheaper to hire somebody. If you do have the skills, this is a great way to get some control over your custom forms.

Be careful not to preempt the Calyx routines in each document.

- Mike
mike@mtig.biz

Post #1247
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Emmanuel Huna, Bryan Telford, Jason Beck, Mike Thompson, BetaFisch

PermissionsExpand / Collapse

All times are GMT -8:00, Time now is 4:23am

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.078. 12 queries. Compression Enabled.
© 2005 Calyx Software. All rights reserved.