Home

Visual eForms User`s Guide

1. Parameter The following parameters are available Parameter Description ColumnName Name of the column in the Table object Notes e SUM function applies only to Table objects e If ColumnName is the name of an object other than a table column SUM function will return zero e Cells within a table column are indexed from to n where n is the number of rows in the table e An alternative to SUM is to add individual cells of a column For Example Cost 1 Cost 2 Cost 4 e Calculations that involve table cells can use a wild character i e Instead of separate calculations such as TOTAL 1 PRICE 1 TAX 1 for row 1 and TOTAL 2 PRICE 2 TAX 2 for row 2 use the same syntax on each row TOTAL PRICE TAX Filler will internally replace with the proper row number Enter SUM Cost1 Returns The total of every cell in the Cost1 column us Fe 2 00 anana ms ibisc ther H B H O Chapter 2 Function Syntax Explanation Notes See also Example Where Enter Returns Enter Returns Enter Returns Scripts 142 SUMDATE SUMDATE DateExpr NumExpr Calculates a date that is a specified number of days between or after another date e SUMDATE function returns a string e DateExpr is a string e NumExpr is a numeric value If NumExpr is a negative value the calculated date is before DateExpr If NumExpr is a positive value the calculated d
2. Show set to True to show non printable object on the form and False otherwise ShowNonPrintables affects the Visible properties of the object For example ShowNonPrintables FALSE will turn the Visible property of the object to FALSE making the object invisible True Call to this method was Successful False An Error was encountered Hide Non Printable objects Dim rv rv MmaFilll ShowNonPrintables FALSE Chapter 4 Description Syntax Parameter Description Remarks Advanced Programming 300 SignForm Signs the currently loaded form in Signature Field FieldName C BOOL SignForm LPCTSTR FieldName LPCTSTR DisplayVal short Flags Visual Basic form MmaFill SignForm FieldName As String DisplayVal As String Flags AsInteger The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method DisplayVal Reserved for future use Flags Reserved for future use FieldName can have one of the following 5 types NT Domain Entrust Hand Signature e PKI User Defined If signature field FieldName is of type NT Domain Entrust or PKI after a successful call to this method the full name of the signer will be displayed in FieldN
3. STREXTRACT Edit1 contains VISUAL EFORMS ENTERPRISE SERVER LOWER Edit1 visual eforms enterprise server Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 123 LTRIM LTRIM String Removes the leading spaces from a string The following parameters are available Parameter Description string any valid string expression If string contains Null Null is returned LTRIMO returns a string RTRIM Edit1 contains Visual eForms Toolbox is superior LTRIM Edit1 Visual eForms Toolbox is superior Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Enter Returns Scripts 124 MINUTE MINUTE time Returns the minute portion of the time from a string containing HH MM SS The following parameters are available Parameter Description time any expression that can represent a time If time contains Null Null is returned MINUTEO function returns a numeric value DATE TIME DAY MONTH YEAR HOUR SEC Edit1 contains 10 15 22 MINUTE Edit1 15 If current time is 10 23 then MINUTE TIME returns 23 NEO Z Oa ae 25 Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter
4. rv MmaFilll GetFieldProperty MmaFilll VarGetCurrField MmaFilll vfType Select Case rv Case MmaFilll vfBarCode MsgBox object is BARCODE Case MmaFilll vfButton MsgBox object is BUTTON Case MmaFilll vfCheckBox MsgBox object is CHECKBOX Case MmaFilll vfDate MsgBox object is DATE Case MmaFilll vfDropList Chapter 4 Advanced Programming 231 MsgBox object is DROPLIST Case MmaFilll vfEditableImage MsgBox object is EDITABLE IMAGE Case MmaFilll vfFillableText MsgBox object is FILLABLE FIELD Case Else MsgBox object is UNKNOWN End Select is the TOP border of the field in focus ON or OFF rv MmaFilll GetFieldProperty MmaFilll VarGetCurrField MmaFilll vfTop Border If rv 1 Then MsgBox TOP border is ON Else MsgBox TOP border is OFF End If Advanced Programming 232 Chapter 4 Description Syntax Parameter Remarks See Also Return Values GetFieldString Assigns the value of field FieldName to FieldData C BOOL CMmarFill GetFieldString LPCTSTR FieldName BSTR FAR FieldData Visual Basic form MmaFill GetFieldString Byval FieldName As String FieldData As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the Form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12
5. A B C D E F G H J K L M The unassigned column shows which form fields are not assigned to data sources Chapter 3 Databases 152 Primary and Secondary Data Sources You can create primary and optional secondary data sources and assign fillable form objects to those data sources gt To create a data source 1 Open the Database Relations screen The Database Relations screen appears Database Relations D Program Files WFORMS Sample Ma Ea 2 Double click on the Primary Data Source box The Primary Data Source dialog box appears Chapter 3 Databases 153 3 In the Database section click the Type drop down menu to select the type of database You can choose from databases that were listed in MmaADOi on page 148 4 Click the browse icon next to the Database field A dialog box appears allowing you to browse through data sources of the type that you have just selected 5 In the dialog box double click on the specific data source that you would like to use The data source file appears in the Database field Secondary Data Source 2 D Program Files FORMSAD at E 6 In the Table Name field enter a table name from the data source that is referenced e g Name Address or State 7 If necessary enter your User name and Password in the Login section 8 Click the OK button Chapter 3 Databases 154 A secondary data source is optional If your form requir
6. False An Error was encountered Set Background Color of the field SSN to RED Dim rv rv MmaFilll SetFieldProperty SSN 8 255 0 0 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 293 SetFieldSize Sets resets the size of a field in the form C BOOL CMmaFill SetFieldSize LPCTSTR FieldName short Size Visual Basic form MmaFill SetFieldSize Byval FieldName As String Byval Size As Integer The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as Field Name Paramater of this method Size Maximum number of characters the user is allowed to enter into this field PropertyVal New Property Value being assigned to Property If Size is set to zero there will be no limit to the number of characters allowed in this field True Call to this method was Successful False An Error was encountered Set size of the field SSN to 11 characters max Dim rv rv MmaFilll SetFieldSize SSN 11 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 294 SetFocus Sets the focus of the Windows environment to this ActiveX Control C void CM
7. False An Error was encountered Copy the first 5 characters of LAST_NAME field and Paste it into LAST_NAME 2 field Use DisableRedraw to eliminate flickering if any Enable Redraw after the procedure Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DisableRedraw True rv MmaFilll GotoField LAST_NAME rv MmaFilll SetCursorPosition 0 5 rv MmaFilll CopyQ rv MmaFilll GotoField LAST_ NAME 2 rv MmaFilll Paste rv MmaFilll DisableRedraw False Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 198 DropListAddString Appends string ChoiceString along with corresponding ChoiceValue to the end of DropList field FieldName C long CMmaFill DropListAddString LPCTSTR FieldName LPCTSTR ChoiceString LPCTSTR Choice Value Visual Basic form MmaFill DropListAddString Byval FieldName As String Byval ChoiceString As String Byval ChoiceValue As String The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method ChoiceString Choice String to be appended to the end of DropList Choice Value Choice Value corresponding the ChoiceString None The zero based index to the string in the DropLi
8. Notes See also Examples Enter Returns Enter Returns Enter Returns Scripts 136 STR STR Number decimal places Returns a string representation of a number The following parameters are available Parameter Description Number any valid expression Accepts an optional second parameter for the number of digits after a decimal point to be converted to string NUM STR 1 2 139 STR 54321 54321 STR 12345 678 2 12345 67 Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Enter Returns Scripts 137 STRAT STRAT string startposition Returns a string beginning at the specified position The following parameters are available Parameter Description string String expression being searched startposition Numeric expression that sets the starting position for the search Startposition is offsetted at zero meaning that the first character of string is at position zero the next character is at position 1 etc LEFTO RIGHT STRO STREXTRACT STRINSTR STRLEN UPPER LOWER Edit1 contains Visual eForms Enterprise Server STRAT Editl 3 ual eForms Enterprise Server 66599 Note that V is in position zero i is position 1 s is position 2 and u is position 3 In the above example STRAT returns
9. This value determines what the check box looks like when it is On 4 In the Off Character section do one of the following e Click the drop down menu to select a character to appear in the check box in the Filler e Select Custom from the drop down menu and enter a character in the field This value determines what the check box looks like when it is Off 5 In the Empty Character section do one of the following e Click the drop down menu to select a character to appear in the check box in the Filler e Select Custom from the drop down menu and enter a character in the field This value determines what the check box looks like when it is Empty 6 Click the OK button Chapter 2 Form Design Guide 68 Radio Buttons Checkboxes are used to to create radio buttons that is mutually exclusive checkboxes Radio buttons are called this because like the car buttons on a radio only one can be selected at a time LT a Dn Character Off Character Empty Character TOK OK o jo jo Cancel gt To create radio buttons using the checkbox Follow the same steps as above but be certain to 1 Turn off the borders of each checkbox 2 Select Wingdings as the fill font 3 Select the empty circle and filled circle with a dot as the fill characters for off and on D Select Tab Accessibility Order Nn Ensure that the radio buttons are in uninterrupted tabbing order and are consecutive an Hig
10. YEAR 03 22 2005 2005 YEAR DATE 2005 Chapter 3 Databases 147 Databases Database Connectivity ActiveX is a a component A based standard created by Microsoft Please refer to sample applications to learn more about database connectivity A database is a collection of data records that can be used and updated by different forms and different applications Visual eForms forms can connect to several different types of databases in one of two ways Coding e MmaADOi Multimedia Abacus Database ActiveX Coding By coding around the Filler ActiveX control methods within a given programming environment you can connect to any data source Using third party database connectivity software makes this process even easier Coding is best suited for users with a good programming background and previous database programming experience Chapter 3 MmaADOi Databases 148 MmaAD0Oi is built on top of the Microsoft ActiveX Data Objects ADO The ActiveX Control when used in conjunction with the database relations function of the Visual eForms Designer makes it easy to connect forms to a variety of databases The ADOi currently supports the following database types e MS Access ODBC e dBASE III e dBASE IV dBASE 5 e Paradox 3 x e Paradox 4 x e Paradox 5 x e FoxPro 2 0 e FoxPro 2 5 e FoxPro 2 6 e Excel 3 0 Excel 4 0 e Excel 5 0 Excel 95 Excel 97 e Text Note MmaA
11. You can also assign fields in the Data Source dialog box gt To assign fields in the Data Source dialog box 1 Right click the Primary or Secondary Data Source window 2 Select Properties from the menu 3 When the dialog box appears click the Fields icon 4 In the fields section select the data source from the Other Data Sources drop down menu Chapter 3 Databases 156 Fields Other Data Sources Fields tt ata Source Primary Data Source 4 Currency Fields in Primary Data Source abl d d ress ab Name lt lt Remove 5 Select a field in either Data Source field and click Add or Remove 6 Click the OK button when you have finished defining the Link Fields gt To link the Primary and Secondary Data source boxes 1 Click the field that you want to define as the link key in the Primary Data Source window 2 Hold down the CONTROL key while dragging the selected field to the Secondary Data Source window A chain bar and key denote that the fields are linked The highlighted field name with the key icon next to it indicates which field in the table is used to link the two data sources Primary Data Sourd Secondary Data Sd 1 Rec Size 8 Repeat this process for any further links You can link a primary to a secondary data source or link two secondary data sources You can also define or change links in the Data Source dialog box Chapter 3 Databases 157 gt To define links in
12. 255 0 0 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 167 v BottomBorder ID for Bottom Border property of a field C long GetVfBottomBorder void SetVfBottomBorder long Visual Basic form MmaFill vfBottomBorder Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Bottom Border of a field Long 13 The following Visual Basic code returns the value of this property Msgbox mmafill vfBottomBorder returns 13 To turn ON the bootom border of field PhoneNumber use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 13 1 gt Or rv mmafill SetFieldProperty PhoneNumber mmafill vfBottomBorder 1 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 168 v Button Property ID of a Button field C long GetVfButton void SetVfButton long Visual Basic form MmaFill vfButton Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about object type Long 32 In the following Visual Basic example the type of field Cancel is examined If Cancel is a button object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill vfButton then do something En
13. BOOL CMmaADOi MoveFirst MoveLast MoveNext movePrevious Visual Basic form MmaADOi MoveFirst MoveLast MoveNext movePrevious None Use the Move methods to move from record to record without applying a condition If you edit the current record be sure you use the Update method to save the changes before you move to another record If you move to another record without updating your changes are lost without warning True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Caution Return Values See Also Advanced Programming 348 Update Saves the contents of the copy buffer to the table C BOOL CMmaAD0Oi Update Visual Basic form MmaADOi Update None Use Update to save the current record and any changes you ve made to it Changes to the current record are lost if You use the AddNew method and then move to another record without first using Update e You use AddNew and then use AddNew again without first using Update True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Advanced Programming Events RecordAdd Occurs when the AddNew Method is invoked C afx_msg void RecordAddMmaADOi Visual Basic Sub MmaADO RecordAdd
14. In the Copies section select the number of copies to print Click the OK button Chapter 2 Form Design Guide 89 Previewing Forms Data on the form during Preview Mode becomes the default data in each object Be certain to clear this data prior to your final save To clear the form in Preview mode press Control E The system asks for confirmation before clearing When you have finished creating your form you can test it in Preview mode to see how it will appear to users gt To go to preview mode 1 On the File menu click Preview or Click the Preview Mode icon on the Standard Toolbar or press Cntrl F2 Your current position is noted by a turquoise field and red arrow WP Form2 Of x 2 Enter the desired data in the field After entering data in the first field proceed to the remaining fields To Press go to next field TAB go to previous field SHIFT TAB go to next line in field ENTER clear data in the form CNTRL E Sticky Notes Text can be added to the form while in Preview mode This is helpful to users during testing Chapter 2 Form Design Guide 90 gt To add sticky notes 1 While in Preview mode press Control N 2 The cursor changes to sticky note icon 3 Enter text Any text added in this manner will be included in the database information as an XML string gt To see the options for this feature right click on the sticky note he Iconi
15. MmaFilll EnableFields 1 False Chapter 4 Description Syntax Parameter Remarks Advanced Programming 209 FileDialog The FileDialog provides a standard dialog box for operations such as opening and saving files C VARIANT CMmarFill FileDialog BOOL bOpenFileDialog LPCTSTR Filter LPCTSTR Options Visual Basic form MmaFill FileDialog bOpenFileDialog As Boolean Filter As String Options As String The following parameters are available Parameter Description bOpenFileDialog Show the OpenFile Dialog box Filter The Filter parameter Syntax has these parts Object An object expression that evaluates to an object in the Applies To list Description A string expression describing the type of file Filter A string expression specifying the filename extension Options The Following parameter value pairs are separated by a semicolon e InitialDir lt Initial Directory gt FileDialog will initially show the contents of lt Initial Directory gt Title lt Dialog Caption gt Sets FileDialog caption to lt Dialog Caption gt A Filter specifies the type of files that are displayed in the dialog box s file list box For example selecting the filter txt displays all text files Use this property to provide the user with a list of filters that can be selected when the dialog box is displayed Use the pipe symbol ASCII 124 to separate the description and filter value
16. XMLString XML encoded data stream Chapter 4 Remarks Return Values Examples Advanced Programming 319 Parameter Description Options EncryptPwd lt password gt EncryptPwd the password to decrypt the data with ClearData 0 or 1 0 Do NotClear Data 1 ClearData If ClearData parameter is omitted by default all form fields are cleared prior to processing the XML String FormLoad 0 or 1 O Do NotLoadForm 1 Load Form If FormLoad parameter is omitted by default the form referenced in the XML string will be loaded prior to processing the XML string if the currently loaded form in the Filler ActiveX is different from the one referenced by XML String VersionCheckWarning 0 or 1 If 0 a Version Check Warning will not be displayed in case the XML data being passed as a parameter to this method belongs to an older version of the currently loaded form If not present defaults to 0 See XMLGetFormData on page 316 for a DTD Document Type Definition True Call to this method was Successful False An Error was encountered XMLSetFormData XMLString XMLSetFormData XMLString Formload 1 ClearData 0 XMLSetFormData XMLString ClearData 1 Chapter 4 Advanced Programming XMLSetFormData XMLString Formload 1 EncryptPwd mypassword 320 Chapter 4 Description Syntax Parameter Remarks Advanced Programming 321 Eve
17. Y cerenade Visual eForms Designer Visual eForms ToolBox User Manual June 2005 Contents i Contents INTFOU CtION ion iaa 1 How to Use This Mamialtraio Aaa tates 1 Conventions AA res A A AAA 2 Help add Support iia 2 Installation and Setup icenen e E E A EEE RE ERER E 3 Screen COMPONENIS an sia he E ER AEAEE T Rah aes aeons OTEN 6 Mens a A E E E an 6 TOD eaea r a A a a tant tel ensed 6 Object Toi ca 6 Standard Loba io ke ae 9 11 POH ii vl wetsedesiase eacut E a a days ae aS e 11 Properties Window ii adici n i 11 Alternative Properties Window csccsccsssessceseesceseeeseeseecsecaseeseeaeeseeereneeeenes 11 Properties Control Baricco 12 Status Bal ias atoness heeds 12 Form Design Guide vio comio ii eweececdereeees 14 Design Mode versus Fill Mode oooonconccionnocccocconnonnconononconononono non coonconncon non rn nr ron ri nnnnnnnnss 14 Working with Forms chia ia 15 Opening Fo uta odas 15 NeW omita ai 16 Defining Form Setup sii sta 17 Defining Page SED iii adidas 18 SAVING OMS ts aba 19 Setting Form Options ii aida cobencees 20 Setting Form ZOOM keenean e aso Aa 21 Adding and Removing Pages 0 ccccecsesssssseesecsceesecsecaeceeceseeseceseeeeeseeneeenseneeeaes 22 GOTO Paris O E A AS 22 Setting Form Properties 100 iia 24 Import EXPO ti a a 26 Working With Objects ici iii 28 Non Elllable Ob Cts viii 28 Fillable Objects iii eee A EE 29 Drawing Objects eases beets eh eee tae esses a ie am
18. e Click executes the macro when the user clicks the button e DbIClick executes the macro when the user double clicks the button Chapter 2 Form Design Guide 70 Images Use the Image object to add images and logos to forms E Image ImageFile ScaleType AspectFit Scalex 100 Scaley 100 Cropx 0 CropY 0 Embedded False gt To define the properties of an image 1 Open the Properties window 2 Under the Image heading click the drop down menu in the ImageFile field The Open File dialog box appears Supported 3 Search to find the image in the file directory a image BMP WMF TIFF JPEG Look in a Screen Shots Al E PCX EPS PNG mi ES check box dialogue box bmp date tool bmp es check box bmp digital signature tool bmp E font dialogue se circle tool bmp E drawing object bmp function tool re color box bmp E drop list bmp E grid bmp E create help bmp ES edit field tool bmp ES image tool b E currency tool bmp ES edit image tool bmp BES image bmp 2 File name Jedit bmp Files of type Bitmap Files bmp y Cancel ZA 4 Select the file and click the Open button The image appears on the form Chapter 2 Form Design Guide 71 5 In the ScaleType field select one of the following from the drop down menu Aspect Fit This selection maintains the original proportions of the image file and the image is sized to fit the outline of the box dr
19. extension MMAFill ActiveX Control supports an Ascii format for object definition and properties This method is particularly useful for converting forms from a proprietary electronic form environment to MMAFill s far format True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 253 IsFormChanged Returns the internal Modified Flag of the currently loaded form C BOOL CMmaFill IsFormChanged Visual Basic form MmaFill IsFormChanged None None True Form has been modified since it was loaded or AbandonChanges was last called False Form has NOT been modified since it was loaded or AbandonChanges was last called Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 254 IsFormLocked Returns the internal Locked Flag of the currently loaded form C BOOL CMmaFill IsFormLocked Visual Basic form MmaFill IsFormLocked None The internal Locked Flag can be set via LockForm Method Note that these semantics associated with a Locked Form are entirely up to the application developer True Form has been Locked False Form has NOT been Locked Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 255 LockForm Sets the internal Locked Flag of the currently load
20. long GetVfEnabled void SetVfEnabled long Visual Basic form MmaFill vfEnabled Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Overwrite Property of a field Long 28 The following Visual Basic code checks if the field Cancel is enabled Var FieldState as String FieldState mmafill GetFieldProperty Cancel mmafill vfEnabled If FieldState 28 then field is enabled i e user can type into the field End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 173 vfFillableText Property ID of Fillable field C long GetVfFillableText void SetVfFillableText long Visual Basic form MmaFill vfFillableText Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long In the following Visual Basic example the type of field Cancel is examined If Cancel is an edit object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill vfFillableText then do something End If or Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 8 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programmi
21. 1 ALERT edit1 CLEARDATAO Validation OnClick OnDbIClick OnModify OnGotFocus OnLostFocus OnMouseEnter OnMouseLeave FieldHelp FillChar None Default Value The appropriate dialog box appears The name of the field that you have selected is not displayed in the dialog box Calculation xj TRIM SETPROPERTY z _ Cancel STR x Function Description ROUND lt expr gt lt opt num expr gt Numerically rounds the specified expression An optional precision parameter may be specified Chapter 2 Scripts 103 3 Double click a function name in the Functions section The Function in this case ROUND and its syntax appears in the calcu lation field 4 Replace lt expr gt with Currency1 as shown here ROUND Currencyl lt opt num expr gt 5 Replace lt opt num expr gt with 2 as shown here ROUND Currencyl 2 6 Click the OK button The script is placed in the field that you had selected and is executed in Fill mode The action that will occur is the currency amount shown in the Currency field will be rounded to two decimal places gt To force a line break in your calculation display 1 While in a Calculation press CNTL Enter at the point where you want to force a new line OnClick Handler DIFFDATE Function Description tert This demo pisces manual line break after the word manual 2 Go to Preview Mode to check the result This demo places 4 manual
22. 131 Line Thickness 43 Lower function 123 Ltrim function 124 Index 356 M Mandatory changing 52 Mandatory enabling and disabling 52 Margin properties 47 Margin width determining 47 Mask object button 7 Mask example of a social security 60 Masks 59 Menus 6 Miscellaneous properties changing name nonprintable 40 MmaADOi 147 Modifying objects 38 Move an object 38 Multiline enabling and disabling 52 N New form button 9 New forms 16 Next page button 10 Non fillable objects 28 Notify flags 57 Notify properties 57 Num function 127 Number object button 7 O Object buttons explained 7 Object toolbar 6 Objects 28 Opaque making an object 44 Open form button 9 Operators 102 Overwrite enabling and disabling 53 P Page Setup 18 Paste button 9 Position properties 42 Positioning objects 32 Positioning objects by coordinates 42 Previous page button 10 Primary and secondary data source 151 Print button 9 Printing forms 86 Properties window 11 Properties window using 39 Property control bar 12 80 R Redo button 9 Resize an object 38 Right align button 10 Right function 129 Round function 130 Rtrim function 131 S Same height button 10 Same height making objects 37 Same width button 10 Same width making objects 37 Save form button 9 Saving forms 20 Screen Components 6 Scripts 94 Select object button 7 Selecting multiple objects 32 Selecting objects 32 Select
23. Cancel mmafill vfType If FieldType CStr mmafill vfSignature then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 182 v TextColor ID for Text Color property of a field C long GetVfTextColor void SetVfTextColor long Visual Basic form MmaFill vfTextColor Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Text Color of a field Long 26 The following Visual Basic code returns the value of this property Msgbox mmafill vfTextColor returns 26 To turn the text color of field PhoneNumber to BLUE use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 26 0 0 255 Or rv mmafill SetFieldProperty PhoneNumber mmafill vfTextColor 0 0 255 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 183 vfTopBorder ID for Top Border property of a field C long Get VfTopBorder void SetVfTopBorder long Visual Basic form MmaFill vfTopBorder Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Top Border of a field Long 11 The following Visual Basic code returns the value of this property Msgbox mmafill vfTopBorder returns 11 To turn ON the top border of field PhoneNumber use this Visual Basic code rv mmafill SetFieldPropert
24. Description Occurs when the filler ActiveX loses its focus to another application or object Syntax C afx_msg void OnLostFocusMmaFill Visual Basic Sub MmaFill_ LostFocus Remarks This event occurs as user switches from the eForms ActiveX to another object or application Chapter 4 Description Syntax Parameter Advanced Programming 331 OnChar Occurs when the user presses and releases a key or key combination C Visual Basic afx_msg void OnChar long FAR nChar short FAR nRepCnt long FAR nFlags BOOL FAR bCancel Sub MmaFill_OnChar nChar As Long nRepCnt As Integer nFlags As Long bCancelAs Boolean The following parameters are available Parameter Description nChar Contains the character code value of the key NRepCnt Contains the repeat count the number of times the keystroke is repeated when user holds down the key nFlags Contains the scan code key transition code previous key state and context code as shown in the following Table bCancel TRUE Inhibit the character to be passed on to filler FALSE Default Table Description of nFlags bits 0 15 nFlag Bits Bits Description 0 7 Scan code OEM dependent value 8 Extended key such as a function key or a key on the numeric keypad 1 1f it is an extended key otherwise 0 9 10 Not used 11 12 Used internally by Windows 13 Context code 1 if the ALT key is held down while the key is pressed otherwise 0 14 Previous
25. Examples Enter Returns Where Enter Returns Scripts 139 STRINSTR STRINSTR stringl string2 Returns the position of the first occurrence of one string within another The following parameters are available Parameter Description stringl String expression being searched string String expression searched for None LEFT RIGHTO STRO STRATO STRLEN UPPER LOWERO STREXTRACT STRINSTR forgotten g gotten Edit1 contains Enterprise Server STRINSTR Edit1 s se Server Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Enter Returns Scripts 140 STRLEN STRLEN String Returns the number of characters in a string The following parameters are available Parameter Description String Any valid string expression If string contains Null 0 is returned STRLEN function returns a numeric value LEFT RIGHT STRQ STRAT STRINSTR UPPER LOWER STREXTRACT Edit1 contains Visual eForms Edit2 contains Toolbox STRLEN Edit1 13 STRLEN This is a test 14 STRLEN Edit1 STRLEN Edit2 20 Chapter 2 Scripts 141 Function SUM Syntax SUM ColumnName Explanation Returns the sum of a cells in a table column excluding the header if applicable Cells should be Number or Currency
26. GOTOFIELD Q12 GOTOFIELD Q18 In the above example MALE is the name of a CheckBox field If MALE is checked then cursor moves to field Q12 otherwise the cursor will move to field Q18 Chapter 2 Function Syntax Explanation Parameter Remarks Return Values Example Scripts 118 GOTOPAGE GOTOPAGE PageNumber NoScroll Sets the current page of the form to PageNumber and sets the focus to the first field of the new page The following parameters are available Parameter Description PageNumber Page we are switching to PageNumber is a numeric value NoScroll 1 Do Not reset the scrollbar to the top of the page 0 Set scrollbar to the top of the page None None IF MALE 1 GOTOPAGE 2 0 GOTOPAGE 3 0 In the above example MALE is the name of a CheckBox field If MALE is checked then move cursor to the first field of page 2 otherwise the cursor will move to first field of page 3 Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Scripts 119 HOUR HOUR Timestr Returns the hour portion of the time The following parameters are available Parameter Description Timestr string expression in this format HH MM SS HOUR function returns a numeric value DATE TIME DAY MONTH YEAR MINUTE SEC Edi
27. LastErrorCode A iaa 163 ER NN 165 NA ENE E 166 yfBottoMBorder orarie E E a reas 167 VIBU oeeie a E E E A AA E eres 168 ViCheck Box A A AREA 169 A eta dice ts dice ce Ni eet E es EN 170 viEditablelmia ge id 171 ATA 8 210710 or 6 A Ne EE ne i ey ne ee 172 Contents iv VEE Table TERE vce AS 173 VELADO a e ase 174 VEL NE COLO 522536 e eee BA RE e os dd A es 175 v MaxFillChars oo eee cceesscsssccssscessecescccsseeeeccsseceeseceseecsaecesseeeeecseceeeecesecesaeceeees 176 VEIN DEL Serco hse seca ese ee ce Eee A 177 viPage Number A gona de eC TS 178 VERIGHtBOrdeT coa hh ie E SIA eee ee aoe 179 vfRoundedBorder 0 cecccesccecceessceescessecessecescecsseceeecaeceseeceseecsesseeeesesesaeceeeess 180 VISI NAUTE EN 181 A a O OOO 182 Vi LOpBOrden ic sece5 cb scp E E EA ER EE A E NE 183 MS o oh Ie Moe 184 VI A rra 185 LOOME eNe a AEE EE O E et eased uh eeseaklatedheasaenedeweeees 186 We tho Sic sick liada ORE ged A cath SRT dos 187 INTE 187 ADUBO a ota cla 188 Append Field va dla di 189 AttoReduce OMS A e Sao 190 AD A cadet Has sts ee 191 Closer ert a A TS 192 COPY A AE E 193 Create Nolens cect 25h asp ec aS 194 T REE TE O noes A ET RAN piste 196 DISA ble REA w tonna A cae eat 197 DropListAddS tring dai 198 DropListElie a eas ee E E a i 200 DropListDeleteStridg ooooononioninonnoninoninnonnconncnnnon non nonnnnnn ron ronnrnnnonn cnn non neon ron nnnnnns 201 DrophistGetCount ii rin 202 Drop GEGACU ena 203 DropListSetCu
28. T Match case I Search current page only 2 If desired check the necessary Match and Search boxes to narrow the search In the Direction section choose to search Up or Down 3 Click the Find Next button gt To find and replace text 1 On the Edit menu click Replace Enter the desired text in the Find dialog box Find what Address finden O EC En FF Match whole word only Close I Match case I Search current page only 2 Enter the replacement text in the Replace with field 3 If desired check the necessary Match and Search boxes to narrow the search In the Direction section choose to search Up or Down 4 Click on Find Next Chapter 2 Form Design Guide 5 When the text is found do one of the following e Click Replace to replace the given text occurrence e Click Replace All to replace all text occurrences in the form 87 Chapter 2 Printing Forms Form Design Guide 88 gt To print a form 1 On the File menu click Print The Print dialog box appears Printer Name Samsung ML 1750 Series v Properties Status Ready Type Samsung ML 1750 Series Where USBOO1 Comment TF Print to file Print range 1 r Copies e Al Number of copies MA Dw Rw N Cancel In the Printer section select a printer from the drop down menu In the Print range section select pages to print To print to a file check the Print to file box
29. is examined If Cancel is a date object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill VfDate then do something End If or Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 2048 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 171 vfEditablelmage Property ID of Editable Image field C long Get VfEditableImage void Set VfEditableImage long Visual Basic form MmaFill vfEditableImage Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long 512 In the following Visual Basic example the type of field Cancel is examined If Cancel is an editable image object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill vfEditablelmage then do something End If or Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 512 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 172 v Enabled ID for Overwrite Property of a field C
30. large increment 5 Enable show the vertical scroll bar 6 Disable hide the vertical scroll bar 7 Scroll horizontally to the left small increment 8 Scroll horizontally to the right small increment 9 Scroll horizontally to the left large increment 10 Scroll horizontally to the right large increment 11 Enable show the horizontal scroll bar 12 Disable hide the horizontal scroll bar None None scroll the form down Call MmaFill1 Scroll 2 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 287 SetCursorPosition Positions the cursor or marks a block of text within the current field C BOOL CMmarFill SetCursorPosition short StartChar short EndChar Visual Basic form MmaFill SetCursorPosition Byval StartChar As Integer Byval EndChar As Integer The following parameters are available Parameter Description StartChar Specifies the starting position index is zero based EndChar Specifies the ending position If StartChar is 0 and EndChar is 1 all the text in the edit control is selected If StartChar is 1 any current selection is removed True Call to this method was Successful False An Error was encountered Copy the first 5 characters of LAST_NAME field and Paste it into LAST_NAME 2 field Use DisableRedraw to eliminate flickering if any Enable Redraw after the procedure Dim rv rv MmaFilll OpenFormDialog rv MmaFilll
31. line break after the word manual Chapter 2 Scripts 104 Built In Functions Function Syntax Explanation Parameter Notes See also Example Enter Returns Enter Returns The following is a list of all available functions in Visual eForms Designer their explanations and syntax as well as script examples ALERT ALERT Prompt Displays a message in a dialog box waits for the user to click a button The following parameters are available Parameter Description Prompt String expression displayed as the message in the dialog box The maximum length of prompt is approximately 1024 characters depending on the width of the characters used If prompt consists of more than one line you can separate the lines using a carriage return character r a linefeed character n or carriage return linefeed character combination r n between each line Since Alert is a function it is not available in the list of available functions for Calculation scripting None ALERT Signature is Verified Signature is Verified ALERT Please Enter Your Name rYour Date of Birth nand PhonetrinThanks Please Enter Your Name Your Date of Birth and Phone Thanks Chapter 2 Function Syntax Explanation Notes See also Example Where Enter Returns Scripts 105 CLEARDATA CLEARDATA Erases data stored in the Default property Also erase
32. pass 12 as FieldName parameter of this method FieldData Holder for value of field FieldName None VarGetFieldString True Call to this method was Successful False An Error was encountered Chapter 4 Advanced Programming 233 GetFieldTextWidth Description Returns the width of Text according to the Font attributes of the field FieldName Syntax C long CMmaFill GetFieldTextWidth LPCTSTR FieldName LPCTSTR Text Visual Basic form MmaFill GetFieldTextWidth Byval FieldName As String Byval Text As String Parameter The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method Text String of text for which this method calculates its width Remarks None Return Values True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 234 GetFirstField Returns the name of the first field in tabbing order on the form C VARIANT CMmarFill GetFirstField Visual Basic form MmaFill GetFirstField None none See Also GetNextField Variant Name of the first Field Null An Error was encountered or no fields were
33. 1178 cannot access MY cert store 1179 no certificate found to sign with 1180 certificate was not issued by a trusted entity 1181 certificate was self signed 1182 an error occurred while performing an Entrust function 1183 CRL could not be retrieved 1184 certificate is not valid because of a date problem 1185 certificate is revoked 1200 error creating a font 1225 an invalid date was entered 164 Chapter 4 Description Syntax Remarks Data Type See Also Advanced Programming LastErrorDesc Error description of last unsuccessful operation C CString GetLastErroDesc Visual Basic form MmaFill LastErrorDesc None String LastErrorCode 165 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 166 v BackColor ID for Background Color property of a field C long GetVfBackColor voidSetVfBackColor long Visual Basic form MmaFill vfBackColor Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Background Color property of an object Long The following Visual Basic code returns the value of this property Msgbox mmafill VfBackColor returns 8 To turn the background color of field PhoneNumber to RED use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 8 255 0 0 or rv mmafill SetFieldProperty PhoneNumber mmafill VfBackColor
34. Available in the Filler application Double click LostFocus to select True or False from the drop down menu e When the user s mouse hovers out of this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application Double click MouseEnter to select True or False from the drop down menu e When the user enters this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application Chapter 2 Form Design Guide 7 Double click MouseExit to select True or False from the drop down menu e When the user exits this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application 62 Chapter 2 Form Design Guide 63 Special Properties Fillable objects with special properties include Hyperlinks Masks Check Boxes Buttons Images Drop Lists Tables Bar Codes and Digital Signatures Although these fillable objects have special properties they are drawn the same as any other object gt To draw a fillable object 1 Click a fillable object icon on the Object toolbar 2 Move the cursor into the form window where you would like to place the object 3 Hold down the mouse button and drag to draw the object on the form 4 When the object is the size you want release the mouse The outline of the object is displayed in the form window Hyperlink Hyperlinks are used to insert an electronic
35. Description Syntax Parameters Remarks Return Values Example Advanced Programming 192 CloseForm Closes the currently loaded form and terminates work with it C BOOL CMmarFill CloseForm Visual Basic form MmaFill CloseForm None Before calling this method it is wise to check for any unsaved changes to the current form and notifying the user of the application if necessary True Call to this method was Successful False An Error was encountered Close the form Dim rv rv MmaFilll CloseForm Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 193 Copy Copies currently selected text onto the clipboard C BOOL CMmaFill Copy Visual Basic form MmaFill Copy None None True Call to this method was Successful False An Error was encountered Copy the first 5 characters of LAST_NAME field and Paste it into LAST_NAME 2 field Use DisableRedraw to eliminate flickering if any Enable Redraw after the procedure Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DisableRedraw True rv MmaFilll GotoField LAST_NAME rv MmaFilll SetCursorPosition 0 5 rv MmaFilll Copy Q rv MmaFilll GotoField LAST_ NAME 2 rv MmaFilll Paste rv MmaFilll DisableRedraw False Chapter 4 Description Syntax Parameters Remarks Advanced Programming CreateNote 194 Creates
36. DisableRedraw True rv MmaFilll GotoField LAST_NAME rv MmaFilll SetCursorPosition 0 5 rv MmaFilll Copy Q rv MmaFilll GotoField LAST_ NAME 2 rv MmaFilll Paste rv MmaFilll DisableRedraw False Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 288 SetFieldData Sets the value of field FieldName to FieldData C BOOL CMmaFill SetFieldData LPCTSTR FieldName LPCTSTR FieldData Visual Basic form MmaFill SetFieldData Byval FieldName As String Byval FieldData As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the Form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName parameter of this method FieldData New Data for field FieldName None True Call to this method was Successful False An Error was encountered Put 523 09 2134 into the SSN field Dim rv rv MmaFilll SetFieldData SSN 523 09 2134 Chapter 4 Advanced Programming SetEnterpriseParams Description RESERVED FOR FUTURE Syntax Parameter Remarks Return Values Example 289 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 290 SetFieldDataEx Sets the value of field FieldName to
37. Exporting to HTML 1 Select the HTML button 2 Click the Save button The form is saved as an html document and can be opened with any web brower program Chapter 2 Form Design Guide 28 Working With Objects The electronic forms that you create are comprised of the objects that you draw They can contain text graphics or other design elements of your choice The Object toolbar allows you to draw both fillable and non fillable objects Non Fillable Objects Non fillable objects are designed not to be modified by a user in the Filler The following tools are used to draw non fillable objects Icon Name Use To Aa Text O Box O Circle re Image Z Line To drawa E straight line N perfect square or perfect circle hold ALT while drawing the object create a text object where fill text cannot be added draw squares rectangles and round cornered box objects draw circles and ellipses incorporate an embedded or linked image into a form draw straight lines in any direction Chapter 2 Form Design Guide 29 Fillable Objects Fillable objects are designed for users to enter information in the Filler The following tools are used to draw fillable objects Icon Name Use To Aa Hyperlink add a hyperlink field to the form abl Edit Field create a fillable text and number object E Number create a fillable number object ES Currency create a fillable currency object E Date create a filla
38. FieldData C BOOL CMmafFill SetFieldDataEx LPCTSTR FieldName LPCTSTR FieldData BOOL bRecalcDependants Visual Basic form MmarFill SetFieldDataEx FieldName As String FieldData As String bRecalcDependants As Boolean The following parameters are available Parameter Description FieldName Name of the Form Field FieldData New Data for field FieldName BRecalcDependants True to allow for fields dependant on this Field s value to be recalculated after the call to SetFieldDataEx False otherwise None True Call to this method was Successful False An Error was encountered Put 523 09 2134 into the SSN field and Recalculate all dependencies Dim rv rv MmaFilll SetFieldData SSN 523 09 2134 TRUE Chapter 4 Description Syntax Parameter Advanced Programming 291 SetFieldProperty Assigns PropertyVal to the field property PropertyID C BOOL CMmarFill SetFieldProperty LPCTSTR FieldName long PropertyID LPCTSTR PropertyVal Visual Basic form MmaFill SetFieldProperty Byval FieldName As String Byval PropertyID As Long Byval PropertyVal As String The following parameters are available Parameter Description FieldName Name of the Form Field applies the method to ALL fields of the form PropertyID ID of the property whose value is being reset See below for valid IDs Property Val New Property Value being assigned to Property Following is a
39. FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 256 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 178 v PageNumber Property ID of Page Number C long GetVfPageNumber void SetVfPageNumber long Visual Basic form MmaFill vfPageNumber Must be used with GetFieldProperty to Get the page number for a field Long 40 The following Visual Basic code returns the value of this property Msgbox mmafill VfPage Number returns 40 Which page of the form is the field PhoneNumber located on rv mmafill GetFieldProperty PhoneNumber 40 Or rv mmafill GetFieldProperty PhoneNumber mmafill VfPageNumber Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 179 vfRightBorder ID for Right Border property of a field C long GetVfRightBorder void SetVfRightBorder long Visual Basic form MmaFill vfRightBorder Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Right Border of a field Long 12 The following Visual Basic code returns the value of this property Msgbox mmafill vfRightBorder returns 12 To turn ON the right border of field PhoneNumber use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 12 1 Or rv m
40. Font size gt To create a new form Quick key CTRL On the File menu click New N Or D Click the New icon on the Standard toolbar A blank form window appears to begin designing your form Form2 Al x A Chapter 2 Form Design Guide Defining Form Setup Before creating a new form you should plan the Form Setup You might want to make a rough sketch on paper Some form components may include the following e Company name Corporate logo and address e Form Identification Descriptive title and reference number e Filling Instructions Section headings for fields Once you have determined the information that you would like to include in your form you can define the layout or Form Setup gt To define the form setup 1 On the File menu click Form Setup The Form Setup dialog box appears Form Setup x Height j 1 000 m Measurement System Inches z Orientation Portrait C Landscape Paper Margins size ETM Top 0 250 Let 0 250 Right 0 250 r Background Color OK Cancel Password ll 2 list of paper sizes then do either of the following e Select one of the standard sizes In the Paper section click the Size drop down menu and scroll through the e Select Custom and specify the Width and Height of your form UY amp button Nn In the Measurement System section click th
41. Library and drag it to the Object Library window A copy of the object will be placed The original on the form is not affected 4 Right click on the object in the Object Library and select Rename gt To place form objects from the Object Library 1 On the Objects menu click Object Library 2 Scroll through the list of objects and click on the object you want to add to the form 3 Drag the object to the form A copy of the object remains in the Object Library gt To delete form objects from the Object Library 1 On the Objects menu click Object Library 2 Scroll through the list of objects and click on the object you want to delete 3 Right click and select Delete You can have multiple Object Libraries accommodating varying standard design requirements gt To create multiple Object Libraries 1 On the Objects menu click Object Librar Click the ellipsis and open Object Library TE the Object Library dialog box 2 Chapter 2 Form Design Guide 41 3 Click the Add button and enter the name of the Object Library Object Library Object Libraries lt default gt Add Rename 4 Click OK 5 Return to the Object Defaults dialog box and select Set The name of the active object default group now appears in Active Defaults 6 Click Close 7 New default properties are ready to be created within the new defaults group Go to set default object properties abov
42. None None 349 Chapter 4 Description Syntax Parameters Remarks Advanced Programming RecordDelete Occurs when the Delete Method is completed C afx_msg void RecordDeleteMmaADOi Visual Basic Sub MmaADO RecordDelete None None 350 Chapter 4 Description Syntax Parameters Remarks Advanced Programming RecordMove 351 Occurs when any of the Find or Move methods is invoked causing the current record to change C Visual Basic None None afx_msg void RecordMoveMmaADOi Sub MmaADO RecordMove Chapter 4 Description Syntax Parameters Remarks Advanced Programming RecordUpdate Occurs when the Update Method is completed C afx_msg void RecordUpdateMmaADOi Visual Basic Sub MmaADOi RecordUpdate None None 352 Index Symbols 28 A Accessibility 90 ActiveX 147 Adding pages 22 Aligning objects 37 Appearance properties 43 Assigning database relations 154 Auto tab 52 B Background color objects 44 Bar code object button 8 Bar codes 73 Borders 45 Bottom align button 10 Box object button 7 Breaking a group of objects 38 Built in functions 98 Button object button 7 Buttons 64 changing properties 64 C Calculations 54 details 96 Changing the properties of objects 39 Character Spacing 50 Check box object button 7 Check boxes 62 Circle object button 7 Coding 147 Conventions in this manual 2 Convertin
43. Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method None Returns the zero based index of the currently selected item if call to this method was successful Returns 1 in case an error was encountered Field Marital Status is a droplist object and has these choices Married Single Divorced Widowed dim RV RV DropListGetCurSel Marital_ status If user selects Divorced then this command will return 2 i e RV is set to 2 which is the 2nd choice Married is Oth choice Single is 1st choice and Divorced is 2nd choice is deleted If there is an error then this command returns 1 i e RV is set to 1 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 204 DropListSetCurSel Selects a string in the DropList field FieldName C long CMmaFill DropListSetCurSel LPCTSTR FieldName short nSelect Visual Basic form MmaFill DropListSetCurSel Byval FieldName As String Byval nSelect As Integer The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method nSelect Specifies the zero based index of the string to select If 1
44. a Sticky Note or TypeAnywhere object on the loaded form C void CMmarFill CreateNote BOOL TypeAnywhere LPCSTR Options Visual Basic form MmaFill CreateNote byval bTypeAnywhere As Boolean byval Options As String The following parameters are available Parameter Description bTypeAnywhere TRUE Add a TypeAnywhere field FALSE Add a Sticky Note field Options a set of parameters in the following format None option value option value option value option Opaque Callout Printable Font FontFamily FontSize FontBold FontItalic FontUnderline Spacing Border TextColor BackColor CalloutColor CalloutThickness value True or False True or False True or False Courier New Arial ete Swiss Roman etc in units eg 9 0 1 or True 1 or True 1 or True 0 Single Point size 1 or True RGB value eg 255 0 255 RGB value RGB value No of points Advanced Programming 195 Chapter 4 Return Values Example None The following Visual Basic code adds a Type Anywhere object to the form The TypeAnywhere object is Opaque with Font Size of 12 Call MmaFill CreateNote True Opaque True FontSize 12 The following Visual Basic code adds a TypeAnywhere object with default properties Call MmaFill CreateNote True The following Visual Basic code adds a Sticky Note object to the form The Sticky Note object is Opaque with Font Size of 12 C
45. appropriate text to FieldHelp property of form fields GetFieldHelp on page 220 Variant Help Text for field FieldName Null An Error was encountered Chapter 4 Description Syntax Parameter Remarks See Also Return Values Advanced Programming 309 VarGetFieldString Returns the value of field FieldName C VARIANT CMmaFill VarGetFieldString LPCTSTR FieldName Visual Basic form MmaFill VarGetFieldString Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field None GetFieldString on page 232 Variant Value of field FieldName Null An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values See Also Example Advanced Programming 310 VarOpenFormData Opens a Form Data File and displays it in the ActiveX control C VARIANT CMmaFill OpenFormData LPCTSTR FileName LPCTSTR FormsDir LPCTSTR FormExt Visual Basic form MmaFill OpenFormData Byval FileName As String Byval FormsDir As String Byval FormExt As String As String The following parameters are available Parameter Description FileName Full Pathname or URL address of the Data File FormsDir Directory in which corresponding Form for the Data File resides FormExt Extension of the Form File excluding the period Example far Used in conjunction with SaveFormData these two meth
46. data and the form by using the digital signature The digital signature 1 creates a 128 bit encrypted fingerprint or hash of the form and 2 links the data in the form fields to the form s encrypted fingerprint The digital signature is invalid if the form is changed The digital signature is invalid if the data is changed Several types of digital signatures are supported e NT Domain Digital signatures are created using the login name password information of the user The NT Domain server holds the login name password and acts as a Certificate Authority e Hand signatures Digital Signatures are created using the actual hand signature of the user This is drawn using a regular mouse or a pen mouse e PKI Verisign Digital signatures are created using a public key signature algorithm An example of this is the RSA public key cipher Any public key Certificate Authority supported by the Microsoft CryptoAPI such as Verisign can be used with PKI digital signatures Entrust Entrust digital signature verification is based on Entrust X 509 version 3 certificates Cerenade is an Entrust Partner e TOPAZ Digital signatures are created using a signature pad from TOPAZ REQUESTOR APPROVAL DELEGATED 4 O Vernsign he OU O U y e ris ga coms Ret LIAB LTO SS OU OU Dighal ID Class 1 a CN Pillip Y Eph ilp Signature Valid on 26204 10 18 35 AM Chapter 2 Form Design Guide 81 REQUESTOR
47. drop down menu in the RTL to select an option True makes the object read from right to left False makes the object read from left to right Chapter 2 Form Design Guide 56 Edit Edit allows you to determine how the fill object functions when the user enters information in the Filler E Edit MaxFillChars Auto Tab Mandatory Multiline Overwrite TabOrder Calculation FieldHelp FillChar gt To determine the number of text characters allowed in an object Enter a value in the MaxFillChars field MaxFillChars determines the maximum number of characters that a user can type while in the Filler gt To change auto tab Double click Auto Tab or click the drop down menu to select True or False When the user is in the Filler Auto Tab causes the cursor to jump automatically to the next field as soon as the user enters valid information True enables Auto Tab False disables it gt To change mandatory Double click Mandatory or click the drop down menu to select True or False When the user is in the Filler Mandatory prevents the user from moving to the next field until valid information has been entered Note This property is not active while the designer is testing so the results of True are not immediately obvious True enables Mandatory False disables it gt To change multiline Double click Multiline or click the drop down menu to select True or False When the user is in the Filler Multiline allows t
48. editable text state the field is in sch as Checked or unChecked for checkbox fields gt Drop lists are handled automatically by Visual eForms gt You can drag and drop the same object text edit etc into Accessibility Tags as often as you need to gt Tables are handled automatically by Designer which treats the text from column headers of the Table as Accessibility Tags Row numbers are also handled automatically There is no need to add them to the Accessiblity Tags section gt As you make changes to the text on the form caption on a field or the field help this same information is automatically updated in the Accessibility Tag gt Select the items in the order you want them read so that the list within Accessi bility Tags does not have to be resequenced gt To test your form you need to have accessibility software installed and running Then switch the Visual eForms Designer from Design Mode to Preview Mode and test Chapter 1 Accessibility 94 Note On windows NT 2000 and XP you can test accessibility using Microsoft Narrator a FREE screen reader To access Narrator click on Start Programs Accessories Accessibility Narrator Chapter 2 Scripts 94 Scripts Scripts build intelligence into forms They enable users to create powerful customized forms Visual eForms Designer supports three types of Scripts 1 Calculations Scripts These scripts are used to calculate a field dynamically based
49. form using the password encryption algorithm and key length specified Provides support for password based encryption decryption of forms at runtime C BOOL CMmarFill SaveFormPasswordEncrypt LPCTSTR FileName LPCTSTR Password short AlgID short KeyLen Visual Basic form MmaFill SaveFormPasswordEncrypt FileName As String Password As String AlgID As Integer KeyLen As Integer As Boolean The following parameters are available Parameter Description FileName Full Pathname or URL address of the Form File Password User Defined Password used to Encrypt the file AlgID Encryption Algorithm 3DES or RC4 to use Default is 3DES KeyLen Number of bits for the encryption key note some Algorithms such as 3DES ignore this parameter Default is 128 None True Call to this method was Successful False An Error was encountered OpenFormPasswordEncrypt Chapter 4 Description Syntax Parameters Remarks Return Values Example Scroll Advanced Programming 286 Provides for manipulation of the Scroll Bar in the Filler window C void Scroll short ScrollType Visual Basic form MmaFill Scroll ScrollType As Integer Specifies the type of operation on the Scroll Bar according to the following table Value Operation 1 Scroll vertically upward small increment 2 Scroll vertically downward small increment 3 Scroll vertically upward large increment 4 Scroll vertically downward
50. in the Properties window 44 Chapter 2 Form Design Guide 3 When finished create an object to ensure your default properties have been set The default properties are now set on this object Return to step 1 to change the default properties on another object After you set the default properties every time you create a new object of the same type it will retain your default properties gt To create multiple object default groups 1 On the Objects menu click Object Defaults Object Defaults Defaults Default m Active Defaults Default 2 Click the Add button and enter the name of the new object defaults group New Object Defaults n P Cancel 3 Click OK 4 Return to the Object Defaults dialog box and select Set The name of the active object default group now appears in Active Defaults 5 Click Close New default properties are ready to be created within the new defaults group Go to set default object properties above to change the default properties on the individual objects Chapter 2 To optimize this feature YY make sure that the View Ruler option is selected Form Design Guide 45 Position The position of the object details the coordinates of the object and the size of the object Left and Top determine where your object is positioned on the page Width and Height determine the size of the object By looking at the Properties window below you can t
51. in the mask that the user will enter 7 Click the Add button to place the operator in the Mask field The Constant and Operator appear in the Mask field 8 Repeat steps 4 7 as often as necessary to create the Mask 9 Click the OK button to create the mask Example of a Mask gt To create a mask for a Social Security Number 1 Click the Mask button on the Object toolbar 2 Draw the Mask object 3 Open the Properties window 4 Click the drop down menu in the Mask field Properties xj Mask1 Mask MaxFillChars Auto Tab Mandatory Multiline The Mask dialog box appears Chapter 2 As you enter the operators or constants watch the top of the dialog box You can see the mask being created there as well Once you know the coding you can add it directly to the Edit Mask property without going to the dialog box If you a directly a modify the Mask property insert before each constant in the mask sequence Form Design Guide 66 5 Click the Constant radio button and entera in the Constant field 6 Click the Operator radio button 7 Click Clear if there is any text in the Mask field 8 Select Number and click the Add button three times 9 Click the Constant radio button ask HHHS HHS HHHH x C Constant j Operator Alpha Uppercase Alpha OK Cancel Cancel Lowercase Alpha Insert Space Punctuation ua Any Modity Enter Password Remove C
52. key state 1 if the key is down before the call 0 if the key is up 15 Transition state 1 if the key is being released 0 if the key is being pressed Chapter 4 Remarks Advanced Programming 332 Although the OnChar event occurs when most keys are pressed they are typically used to recognize or distinguish between Extended character keys such as function keys e Navigation keys such as HOME END PAGE UP PAGE DOWN UP ARROW DOWN ARROW RIGHT ARROW LEFT ARROW and TAB Combinations of keys and standard keyboard modifiers SHIFT CTRL or ALT keys The numeric keypad and keyboard number keys Chapter 4 Description Syntax Parameters Remarks Advanced Programming 333 OnError This event will be fired for all asynchronous error situations such as entering incorrect date format into a date field This new feature enables programmers to fully customize the behavior of their applications in error situations C afx_msg void OnErrorMmaFill long FAR ErrorCode LPCTSTR ErrorDesc Visual Basic Sub MmaFilll_OnError ByVal ErrorCode As Long ByVal ErrorDesc As String The following parameters are available Parameter Description ErrorCode Numeric value of the Error ErrorDesc Textual description of the Error None Chapter 4 Description Syntax Parameter Remarks Advanced Programming 334 PageChange Occurs when the user moves to a different page C afx_msg void OnPag
53. local or network hard disks e g c myforms form1 far or g formsdir form2 far or nt_server all forms form3 far in addition to forms residing on the intranet or the internet e g http www myfirm com forms form4 far or ftp ftp mycomany com formsdir formS far True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 261 OpenFormData Opens a Form Data File and displays it in the ActiveX control C BOOL CMmaFill OpenFormData LPCTSTR FileName LPCTSTR FormsDir LPCTSTR FormExt BSTR FAR Header Visual Basic form MmaFill OpenFormData Byval FileName As String Byval FormsDir As String Byval FormExt As String Header As String The following parameters are available Parameter Description FileName Full Pathname or URL address of the Data File FormsDir Directory in which corresponding Form for the Data File resides FormExt Extension of the Form File excluding the period Example far Header Information previously saved into the Data File Used in conjunction with SaveFormData these two methods provide a simple mechanism for saving and retrieving data entered on a form For simple applications these two methods provide an excellent substitute for an elaborate database as the data repository True Call to this method was Successful False An Error was enc
54. method can be used to open forms either from the local or network hard disks e g c myforms form1 far or g formsdir form2 far or nt_server all forms form3 far in addition to forms residing on the intranet or the internet e g http www myfirm com forms form4 far or ftp ftp mycomany com formsdir formS far True Call to this method was Successful False An Error was encountered SaveFormPasswordEncrypt Chapter 4 Description Syntax Parameter Remarks Return Values See Also Advanced Programming 266 OpenInternetForm Opens a Form File on the Internet and displays it in the ActiveX control C BOOL CMmaFill OpenInternetForm LPCTSTR ServerName LPCTSTR RemoteFile LPCTSTR LocalCacheDir Visual Basic form MmaFill OpenInternetForm Byval ServerName As String Byval RemoteFile As String Byval LocalCacheDirAs String The following parameters are available Parameter Description ServerName FTP Server Name Example ftp mmacorp com RemoteF ile RemoteFile Example pub mma myform far LocalCacheDir Local Directory in which the downloaded form will be cached This method supports previous versions of Visual eForms ActiveX True Call to this method was Successful False An Error was encountered OpenForm on page 260 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 267 Paste Inserts t
55. number of hours between two time expressions The following parameters are available Parameter Description TimeExprl Begin time String formatted as HH MM SS TimeExpr2 End time String formatted as HH MM SS DIFFTIME function returns a numeric value rounded up DATE TIME DAY MONTH YEAR MINUTE SEC DIFFTIME 07 12 55 15 55 55 9 DIEETLMECUO ALZAS MLO IDO 8 Chapter 2 Function Syntax Explanation Notes See also Examples Where Enter Returns Scripts 110 GETCURRFIELD GETCURRFIELD Returns the name of the current field in focus GETCURRPAGE Add field SSN to your form Set the OnGotFocus action of field SSN to ALERT GETCURRFIELD Go to Fill Mode Move your mouse over the SSN field You will get an Alert box with the name of the current field that has focus Chapter 2 Function Description Syntax Parameters Remarks Return Values Example Scripts 111 GETCURRPAGE Returns the current page number of the currently loaded form GETCURRPAGE None GETCURRPAGE returns a Numeric value Current page number of the currently loaded form Add a button to your form Set the OnClick action of this button to ALERT Current Page No STR GETCURRPAGE Go to Fill Mode Click on the button The above example uses the STR function to convert the Numeric value returned by GETCURRPAGE
56. on values of other fields on the form Changing the value of any of the fields with which the calculation is built will automatically recalculate the value of the field with the Calculation Script For example the form designer can set the value of field A to be calculated automatically by adding the value of field B to value of field C and dividing the result by 3 with the following Calculation Script B CJ 3 x Button1 Button Misc Position Appearance Borders Margins E Edit MaxFillChars 0 Auto Tab False Mandatory False Multiline True Overwrite False NoAddendum False TabOrder 1 Calculation Walidation OnClick ALERT GETFIELDHELPC phone OnDblClick OnModify OnGotFocus OnLostFocus OnMouseEnter OnMouseLeave 2 Validation Scripts These scripts provide a mechanism to validate the value of a field whenever the value is changed For example the form designer can enforce the changes to value of field A to be accepted validated only if the new value falls between integers 5 and 10 inclusively with the following Validation Script 5 lt A and A lt 10 Chapter 2 Scripts 95 Uyeryrite False NoAddendum False TabOrder 1 Calculation Walidation OnClick ALERT GETFIELDHELP phone s OnDblClick Onmodify OnGotFocus OnLostFocus OnMouseEnter OnMouseLeave Dinatealiato 3 Action Scripts These scripts handlers allow the form designer to specify actions taken upon triggering of event
57. screen Chapter 1 Accessibility 90 Accessibility Visual eForms Designer meets all MSAA requirements with its own assistive accessibility feature This feature complies with Section 508 regulations mandating accessibility for visually impaired users No additional components or third party plug ins are required for Designer s accessibility features All forms created in designer are instantly compatible with all audio enabled assistive technology systems with support for MSAA Every fillable object within a form can be created easily with accompanying computer generated audio to meet the needs of visually impaired users For true accessibility all objects on the form must be heard Thus instructions form title form number section headings and so forth all should be read to the user All images must be identified as well for example The seal of the State of Texas Chapter 1 Accessibility 91 Making Forms Accessible Visual eForms Designer simplifies the process of making forms accessible The general process of making a form accessible involves associating accessibility text with each and every fillable field on the form Once a field on the form gets the filler s focus its accessibility text will be verbalized to the visually impaired user While this process is simple in concept if features in the Designer providing support for creating Field to accessibility text association are not carefully designed making a form access
58. the background color of a form is white and the object borders are white a border can be set to True but still not be visible to the eye Form Design Guide 49 True makes all borders of the object visible False does not gt To choose square or round corners for the object Double click on Rounded or click on the drop down menu in the Rounded field to choose True or False True creates rounded borders for the object False creates squared corners for the object Chapter 2 Keep in mind a that there a are two kinds of Fonts Text Font and Fill Font Text Font is used in the text or label portion of a field Fill Font is used for data users enter into a field while in the Filler Form Design Guide 50 Margins Margins determine how text in an object is positioned relative to the borders of the object The smaller the number the smaller the space between the text and the border 0 019444 0 000000 0 019444 0 000000 gt To set the width of the margins 1 Enter a value in the Left field 2 Repeat in the Top Right and Bottom fields Text The text property allows you to define the alignment and font of the text in the object Properties x El Text Orientation Left Spacing points 12 000000 JustHorz Left Justvert Middle TextFont Arial Regular 10 FillFont Arial Regular 9 gt To select text orientation Click the drop down menu in the Orientation field to select one of
59. the dialog box 6 Drag and drop one or more text fields from the form into the Accessibility Tags section of the dialog box The text appears in the Accessibility Tags section of the dialog box Note If the text changes int he form Designer will automatically update all tags using the text 7 If you wish to include the field s Help text as part of the text announced when the field is entered click the Field Help icon A This adds lt FieldHelp gt to the list of current Accessibility Tags for the Field Chapter 1 Accessibility 93 8 If you need to change the order of the tags use the Up and Down buttons to move tags up or down Use the Delete icon to delete a tag from the list of Accessibility Tags With any change made to the Accessibility Tags note the Text announced when field is entered section 9 Repeat steps 3 through 7 for all of the fields on the form HINTS TO IMPROVE ACCESSIBILITY DESIGN gt For items such as instructions section headings form title or number which must be read but not filled in simply drag and srop them to the Accessibility Tag section of the field before or after the item gt For formatted fields such as Dates or Mask you need to add text to FieldHelp property of the field in order to describe the typing format to use Make sure FieldHelp is added to the Accessibility Tag section of the field gt Accessibility reads in this sequence accessibility tags field type such as
60. the Data Source dialog box 1 Right click the Primary or Secondary Data Source window 2 Select Properties from the menu 3 When the dialog box appears click Links 1 Select Data Source to Link With ba Cancel 2 Select Link Fields 4 Select the data source from the Select Data Source to Link With drop down menu 5 Select a field within Select Link Fields 6 Click the OK button when you have finished selecting the links Chapter 3 Databases 158 Using Database Relations For infor mation on lt a syntax See Database ActiveX on page 337 gt To see how the Database Relations function works with forms 1 Open a container application A container application is a programming environment capable of containing ActiveX controls These may include any of the following e Visual Basic e Visual C e Delphi HTML e Lotus Notes e FrontPage 2 Drop the Filler ActiveX control and the Database ActiveX control into your container 3 Add an Open icon 4 Add the connectivity code 5 Click the Open icon to view the form that you have just connected Example of code in Visual Basic dim rv rv MmaDbasel Connect App Path test far MmaFilll Chapter 4 Advanced Programming 159 Advanced Programming Visual eForms is a component based electronic forms engine built around the Microsoft ActiveX technology and Microsoft Foundation Classes MFC The component approach allows fo
61. the File menu CA a r Auto Reduce Fonts Auto Reduce Fonts by E E Points r Form Backup J Create Backup Copy on Save gt Auto Reduce Fonts This ensures the fill font will reduce automatically to fit inside the field up to the number of points specified Thus if Auto Reduce Fonts is set to 4 a 10 point font will be reduced successively to 9 point then 8 then 7 then 6 in order to fit text into a space Once the maximum 4 point reduction is reached the font will not reduce further Chapter 2 Form Design Guide 21 gt Form Backup Designer can automatically backup forms you create to avoid losing your work Forms saved with Auto Backup are stored with the bak extension in your eForms directory gt To set Auto Backup 1 On the File menu click Options 2 In the Options dialog box click the Create Backup Copy checkbox 3 Click the OK button Note Auto Backup is not a timed function Each time you save your work the old instance is saved with a bak extension Setting Form Zoom Visual eForms Designer provides options for resizing the view of the form that you are creating gt To zoom do either of the following On the View menu click Page Width 200 100 or 50 Or On the Standard toolbar select one of the following from the drop down menu e Page Width 200 100 50 or 25 Standard xl Dad dt BE O24 3 width AAD OS S 5 ii m lu e HyS
62. the blue handles to resize the table 2 Resize a single column which will resize all cells within the column e Select the table e Position your cursor over the dividing line between two columns Watch the cursor change to two parallel lines and two arrows Click and drag to right or left to resize the column width or e Select the table e Select the column number and enter a new value in Field Width 3 Resize a single row which will resize all cells within the row e Select the table e Position your cursor over the dividing line between two rows Watch the cursor change to two parallel lines and two arrows Click and drag to top or bottom to resize the row height gt To change the properties of a table cell 1 Click a table once to select it Chapter 2 Form Design Guide 77 2 Click again to select an individual table cell Or 3 Hold SHIFT and click a table cell to select all of the table cells 4 Change the properties of the table cell as described in Changing Object Properties on page 42 gt To change the position of a table 1 Right click the table to display the table position Properties window 2 Enter the Left Top Width and Height values to change the position and size of the table Or 1 Select the table 2 Drag and drop to the new location Chapter 2 Form Design Guide 78 Bar Codes Bar codes consist of a series of vertical bars of varying widths in which each of the digits zero throu
63. to avoid resetting of the scrollbar to the top of the page otherwise set to False None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 251 HighlightFields Disables or enables highlighting of fields on the currently loaded form C BOOL CMmarFill HighlightFields BOOL Enable Visual Basic form MmaFill HighlightFields Byval Enable As Boolean The following parameters are available Parameter Description Enable set to True to highlight fields otherwise set to False This method is used to give the user a visual contrast between editable fields on the form and static text and graphic areas Once this method is called the changes remain in effect for subsequent forms loaded into the control until the next call to this method True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 252 ImportAscii Opens a Form File in Ascii format and displays it in the ActiveX control C BOOL CMmaFill ImportAscii LPCTSTR FileName Visual Basic form MmaFill ImportAscii Byval FileName As String The following parameters are available Parameter Description FileName Name of the Form File In addition to its binary format for Form Files i e forms with far
64. unsuccessful ActiveX operation C long GetLastErroCode Visual Basic form MmaFill LastErrorCode None Long LastErrorDesc 163 Error Code Error Description 1000 an invalid property ID was specified 1001 a passed field name was not found within the current form 1002 the operation requires a fillable field 1003 a file was not found 1004 a file could not be created 1005 an attempt was made to duplicate a field name 1006 no form was loaded 1007 an exception occurred 1008 an invalid date and or time was specified 1009 an operation could not be performed since the form was not saved 1010 an invalid value was specified 1011 an attempt was made to modify a read only property 1012 a file name was needed but missing 1013 invalid name for a form object 1050 error drawing barcode 1051 barcode library not found or unavailable 1075 error parsing 1076 error with parsing table Chapter 4 Advanced Programming Error Code Error Description 1077 error with field validation 1100 not enough colors to contrast 1101 embedding an image failed 1125 need newer version of software to open the specified file 1150 a form archive is corrupt 1151 error reading from a temp file 1175 error attempting to encrypt data 1176 error attempting to decrypt data 1177 crypto library not found or unavailable
65. value DATE TIME MONTH YEAR HOUR MINUTE SEC DAY 03 22 2004 22 DAY DATE If today s date is April 28 2004 the above script returns 28 Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Enter Returns Enter Returns Enter Returns Scripts 108 DIFFDATE DIFFDATE DateExprl DateExpr2 Returns the number of days between two dates The following parameters are available Parameter Description DateExprl Begin date Date expression formatted as MM DD YYYY DateExpr2 End date Date expression formatted as MM DD YYYY DIFFDATE function returns a numeric value Sequence dates so that the earlier date is first and the most recent date is second DATE TIME DAY MONTH YEAR MINUTE SEC DIFFDATE 02 14 1959 02 14 2004 12462 DIFFDATE 02 14 1959 DATE If today s date is February 13 2004 then the above script returns 12461 SETFIELDDATA MyAge STR ROUND DIFFDATE MyBirthdate DATE 365 3 0 If today s date is January 18 2005 and MyBirthdate is February 27 1915 then MyAge is 89 rounded according to the parameters set in the calculation Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Scripts 109 DIFFTIME DIFFTIME TimeExprl TimeExpr2 Returns the
66. vfFillableText 16 vfCheckBox 32 vfButton 256 vfNumber 512 vfEditableImage 2048 vfDate 16384 vfBarCode 65536 vfMask 131072 vfDropList 262144 vfSignature 2097152 vfHyperlink Line Width 7 Returns the LineThickness property of the field Advanced Programming 225 Property ID Returns Back Color 8 String representing the RGB value of the Color e g 255 0 0 for Red Line Color 9 String representing the RGB value of the Color e g 0 255 0 for Green Left Border 10 1 if the Field has its Left Border enabled and 0 otherwise Top Border 11 1 ifthe Field has its Top Border enabled and 0 otherwise Right Border 12 1 if the Field has its Right Border enabled and 0 otherwise Bottom Border 13 1 if the Field has its Bottom Border enabled and 0 otherwise Rounded Border 14 1 if the Field has Rounded Borders and 0 otherwise Opaque 15 Returns 1 if the Opaque property is TRUE Otherwise Returns 0 Non Printable 16 Returns 1 if the NonPrintable property is TRUE Otherwise Returns 0 Repeat On All Pages 17 Returns 1 if the RepeatAllPages property is TRUE Otherwise Returns 0 Text Orientation 18 Returns the value of the Orientation property of a field Left Margin 19 Returns the value of the Left Margin assigned to the field Top Margin 20 Returns the value of the Top Margin assigned to the field Right Margin 21 Returns the value of the Right Margin assigned to the field Bottom Margi
67. 3 LOLOT al Ko a a a DETE EEEE seed aa tenadavien ad et teatbandeee a eet 304 ValidateSignatuire es eka aa eRe Sa 306 VarGetCutt Field ooooconocnnococononionnconncconoconnonnnncnnnnnnn con nnconnnnnn cnn nn nonn nc nn cnn nnrann conan 307 VarGethieldAddenditm Text id iio 308 Varadero 309 VarGetPieldString ii is a a ida 310 VarOpenFormData Ti s cestcctasticevsscesnetiesagecasss cidendesecesscesnctastesusnedeoseetiessasdenticnseds 311 VarOpenFormDataDialog iii eee E Pawns ceeds 313 MR ahve Mh ai el Ca ede 314 MIES IS A a EE 315 MIRE seine E ESEE E eid a Rie Ge Hee I Le hoot ees 316 XML GetForm ata 6c scceossstececcscxieectic sti savesbent eesti heehee epi coien 317 XML SetFormDat a a aae E e a E aaa aa 320 E RR SS EE eee a eS 323 SY AAA A A NTE 323 A G1 Ve cepa eR ee era ren gt RO N E NO 324 Field M Oditi ed yy s2 3 eccasecssacdectes aa 325 BAS ld GOL OGUS AA Esa 326 HAGA OStHOCUS sco A E eee AA 327 FAG UMOUSCE MSE anneanne cesta tase ies a a ities Ree e 328 Ficld MOUSSERIL eer RR er pe ee ee 329 Fillerkoidd a a A a ee 330 E E E A 331 LOStEOCUS ti nta 332 ONCAT eee ene ie ena lee cad att e ee oer Cee eee ee 333 OMEDOR 2 5 e A ee BS 335 Page lange is cts iste A ead A OE 336 Database ActiveX irnn o a E E sees soee nous E E oie eu aoaeasaeice elec 337 Properties A es e ate ae ih nl ees 337 Caption Property sss ava hoe A A I acia 337 Methods tra at OEE E A aa hee edad esa AER E A A 338 ADOUBOX ad dato 338 AIN ra Vn
68. 4 0 5 0 iPlanet Chili Soft add on Minimum Client Requirements Pentium 75 MHz with 64MB RAM 1 MB available hard disk for WYSIWYG forms and no hard disk requirements for HTML forms Supported Forms Formats HTML and Visual eForms file format In addition FormFlow 1 x 2 x OmniForm 4 0 file formats are supported after an import to Visual eForms Chapter 2 Form Design Guide 14 Form Design Guide This chapter covers the basics of creating forms with Visual eForms Designer It discusses the following topics Opening saving and renaming existing forms e Creating new forms and defining their setup e Drawing fillable and non fillable objects e Changing the appearance of objects e Changing the properties of objects e Previewing forms Design Mode versus Preview Mode versus Filler Visual eForms Designer has two modes Design mode and Preview mode This chapter explains how to create forms and objects in Design mode After you have created your form you may want to view the form in Preview mode Preview mode allows the form designer to see what the document will look like to the user Preview mode is explained at the end of this chapter Previewing Forms on page 89 The term Filler used in this document refers to the end user completing or filling out the form using the Filler application Chapter 2 Form Design Guide Working with Forms Quick key CTRL 0 Opening Forms You can open and m
69. APPROVAL DELEGATED Invalid Signature Invalid Stl lt lt vo Enhanced Digital Signature Support Chapter 2 Form Design Guide 82 gt The form signing process A one way 1 A one way hash of the document is produced hash B function is a 2 The hash is encrypted with the means of squeezing e user s password for NT Domain signatures or messages into a short digest that preserves data integrity like a fingerprint e internal representation of the Hand Signature or user s private key in case of PKI digital signatures 3 A copy of the original document plus the encrypted and signed hash are transmitted 4 The recipient produces a one way hash of the document 5 Using the digital signature algorithm the recipient decrypts the signed hash with the sender s encrypted information 6 If the signed hash matches the recipient s hash the signature is valid and the document is intact Properties E Signature1 Signature E Signature Type NT Domain Mode Text Form Fields Lock Fields False Chapter 2 On your form B you can FW have as many signature fields as you want Each signature must have at least one form field assigned to it Form Design Guide 83 gt To draw a digital signature 1 Click the Digital Signature object on the Object toolbar 2 Move the cursor into the form window where you would like to place the Digital Signature object 3 Hold down the mouse butt
70. ActiveX control C CString CMmaFill GetDefaultPath void CMmaFill SetDefaultPath LPCTSTR DefaultPath Visual Basic form MmaFill DefaultPath By default objects referring to filenames e g an Image object referring to a bmp or wmf file without a full pathname are resolved relative to the directory of the application You may use this property to change the default path to an alternate address another directory on the network or a URL on the internet String Chapter 4 Description Syntax Remarks Data Type Advanced Programming 161 FormName Gets or sets the Form Name associated with the currently loaded form C CString CMmaFill GetFormName void CMmaFill SetFormName LPCTSTR FormName Visual Basic form MmaFill FormName You may use this property to identify the name of a form within the context of an application String Chapter 4 Description Syntax Remarks Data Type Advanced Programming 162 FormVersion Gets or sets the Form Version associated with the currently loaded form C CString CMmaFill GetFormVersion void CMmaFill SetFormVersion LPCTSTR FormVersion Visual Basic form MmaFill FormVersion You may use this property to identify the revision of a form within the context of an application String Chapter 4 Description Syntax Remarks Data Type See Also Advanced Programming LastErrorCode Get or Set the error code of last
71. Chapter 2 Form Design Guide 22 Adding and Removing Pages You can add a page to your document before or after the current page gt To add a page On the Page menu click either of the following Add Before Current to add a page before the current page Add After Current to add a page after the current page gt To delete the current page On the Page menu click Delete You will be asked to confirm the deletion GoTo Page You can create forms that have up to 99 pages In multiple page forms you can add or delete pages The Goto page function allows you to jump to a specific page gt To go to a specific page in a form 1 On the Page menu click Goto Page First Page Cancel 7 C Last Page C Page fi 2 When the dialog box appears you have the following options e Click the First Page option icon to go to the first page of a document e Click the Last Page option icon to go the last page of a document e Click the Page option icon and scroll to find the desired page or enter the desired page number directly 3 Click the OK button gt To go to the previous page in a document Click the Previous Page icon on the Standard toolbar gt To go to the next page in a document Click the Next Page icon on the Standard toolbar Chapter 2 rd By 15 Form Design Guide 23 gt To go to the first page in a document Click the First Page icon on the Standard toolbar gt To go to
72. DOi Properties and Methods are discussed in Database ActiveX on page 335 Chapter 3 Databases 149 Choosing a Database Format As mentioned previously a database is a collection of data records that can be used and updated by different forms and different applications Visual eForms forms can connect to several different types of databases gt When choosing a database consider these factors e Data storage standards to interface with other widely used applications e Formats that others are using to fill the same form e Data storage capacity Some formats require more disk space than others e Applications that you may need to perform independently from the form Chapter 3 Databases 150 Database Relations Database relations is the mechanism of assigning fields on the forms to fields in databases Before creating database relations you must first save the form gt To save a form Quick key On the File menu click Save CTRL S or Click the Save icon on the toolbar Database Relations Screen The Database Relations Screen provides a graphic representation of a form s database structure in which you can drag and drop fields to create links between form fields and data sources e Data sources are tables in databases that contain information For example in a Microsoft Access database you may have several tables such as a name table an address table and an occupation table From the Database Rela
73. Don t Skip 1 Skip If SkipBlanks parameter is omitted by default only fields without empty value will be included in the return XML string The DTD Document Type Definition is as follows lt ELEMENT FORMDATA VERSION FORMNAME FORMLOC FORMVERSION HEADER ENCRYPTIO N FIELDDATA gt lt ELEMENT VERSION PCDATA gt lt ELEMENT FORMNAME PCDATA gt lt ELEMENT FORMLOC PCDATA gt lt ELEMENT FORMVERSION PCDATA gt lt ELEMENT HEADER PCDATA gt lt ELEMENT ENCRYPTION PCDATA gt lt ELEMENT FIELDDATA F gt lt ELEMENT F PCDATA gt lt ATTLIST F NAME CDATA REQUIRED gt String XML encoded stream of data XMLString XMLGetFormData XMLString XMLGetFormData Pages 1 SkipBlanks 1 XMLString XMLGetFormData pages 2 XMLString XMLGetFormData Pages 1 SkipBlanks 1 Encrypt 1 EncryptAlg 3D ES EncryptKeyLen 128 EncryptPwd mypassword Chapter 4 Description Syntax Parameter Advanced Programming 318 XMLSetFormData Populate fields on the form with data from an XML encoded data stream The XML encoded data stream if password encrypted is compliant with the current W3 org draft standard for XML encryption C BOOL CMmarFill XMLSetFormData LPCTSTR XMLString LPCTSTR Options Visual Basic form MmaFill XMLSetFormData XMLString As String Options As String The following parameters are available Parameter Description
74. E SEC Current time is 04 20 08 TIME 04 20 08 IF HOUR TIME gt 9 STR HOUR TIME 0 STR HOUR TIME IF MINUTE TIME gt 9 STR MINUTE TIME 0 STR MINUTE TIME IF SEC TIME gt 9 STR SEC TIME 0 STR SEC TIME 042008 Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 145 UPPER UPPER String Returns a string that has been converted to uppercase The following parameters are available Parameter Description String any valid string expression If string contains Null Null is returned None LEFT RIGHT STRO STRAT STRINSTR STRLEN LOWER STREXTRACT Edit1 contains Visual eForms is Great UPPER Edit1 VISUAL EFORMS IS GREAT Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Enter Returns Scripts 146 YEAR YEAR String Returns a whole number representing the year The following parameters are available Parameter Description String any expression that can represent a date in MM DD YYYY format If date contains Null Null is returned YEAR function returns a numeric value DATE TIME DAY MONTH HOUR MINUTE SEC Edit1 contains 03 22 2005 The current year is 2005 YEAR Edit1 2005
75. If string contains Null Null is returned length Numeric expression indicating how many characters to return If 0 a zero length string is returned If greater than or equal to the number of characters in string the entire string is returned None LEFT STRQ STRAT STRINSTR STRLEN UPPER LOWER STREXTRACT t Edit1 contains Visual eForms Designer can import your forms RIGHT Edit1 3 ce rms Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Enter Returns Enter Returns Scripts 130 ROUND ROUND expression decimalplaces Rounds a number to the number of decimal places The following parameters are available Parameter Description expression Required Numeric expression being rounded decimalplaces Optional Number indicating how many places to the right of the decimal are included in the rounding If omitted no rounding takes place Returns a numeric value None ROUND 1234 561 no rounding truncates to whole number displays 1234 ALERT STR ROUND 1 234 561 2 rounds up or down by 2 digits precision factor displays 1 234 56 Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 131 RTRIM RTRIM String Removes the trailing spaces from the string The following parameters are available Param
76. If you attempt to disable a field that currently has the focus the field will be disabled and focus will be given to the next field in tab order True Call to this method was Successful False An Error was encountered Following shows how to ENABLE the LAST_NAME field on the form ONLY First Disable ALL fields on the form Second Enable the LAST_NAME field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll EnableFields 0 False rv MmaFilll EnableField LAST NAME True Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 207 EnableFieldAddendumTag Disables or enables appearance of the words Addendum Tags for FieldName C BOOL CMmafFill EnableFieldAddendumTag LPCTSTR FieldName BOOL Enable Visual Basic form MmaFill EnableFieldAddendumTag Byval FieldName As String Byval Enable As Boolean The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method Enable set to True to enable overwrite for field FieldName and False otherwise When EnableFieldAddendumTag is invoked for FieldName and text of FieldName exceeds its size the field will be tagged with See Addendum in its lower right corn
77. LAST_NAME field and Paste it into LAST_NAME 2 field Use DisableRedraw to eliminate flickering if any Enable Redraw after the procedure Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DisableRedraw True rv MmaFilll GotoField LAST_NAME rv MmaFilll SetCursorPosition 0 5 rv MmaFilll Copy Q rv MmaFilll GotoField LAST_ NAME 2 rv MmaFilll Paste rv MmaFilll DisableRedraw False Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 249 GotoFieldByTabOrder Resets focus to the field with TabOrder FieldTaborder C BOOL CMmaFill GotoFieldByTabOrder long FieldTabOrder Visual Basic form MmaFill GotoFieldByTabOrder Byval FieldTabOrder As Long The following parameters are available Parameter Description FieldTabOrder TabOrder of the desired Form Field None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 250 GotoPage Sets the current page of the form to PageNumber and sets the focus to the first field of the new page C BOOL CMmaFill GotoPage long PageNumber BOOL NoScroll Visual Basic form MmaFill GotoPage Byval PageNumberAs Long NoScroll As Boolean The following parameters are available Parameter Description PageNumber Page Number to which we are switching to NoScroll Set to True
78. LPCTSTR FieldName BSTR FAR AddendumText Visual Basic form MmaFill EnableFieldAddendumTag Byval FieldName As String AddendumText As String The following parameters are available Parameter Description FieldName Name of the Form Field AddendumText Holder for Addendum Text of field FieldName Addendum text of a field refers to excess text that cannot be fit within the bounds of that field VarGetFieldAddendumText True Call to this method was Successful False An Error was encountered We have two forms AnyForm far and AddendumForm far We want to open fill and print the AnyForm far We also want to print the excess data that user has typed into the fields of AnyForm far to be printed via our addendum form AddendumForm far for this to happen we add two instance of Visual eForms ActiveX to our Visual Basic project MMAFilll Will hold the original form AnyForm far and is accessible to the user AddendumFiller Will house the Addendum form AddendumForm far and is NOT visible to the user Dim rv i FormFieldName As String AddendumFieldName As String Dim AddendumCounter As Integer FieldAddendumText As String Chapter 4 Advanced Programming 216 Dim FormAddendumText As String Dim PrinterDC TotalPages As Integer Open Form This routine opens AnyForm far You could also use OpenFormDialog to allow user to select and then open a form This routine also sets the Overwrite
79. MsgBox RTrim FieldName has now focus MsgBox MmaFilll VarGetCurrField has now focus Chapter 4 Description Syntax Parameter Remarks See Also Return Values Advanced Programming 307 VarGetFieldAddendumText Returns Addendum Text of field FieldName C VARIANT CMmarFill VarGetFieldAddendumText LPCTSTR FieldName Visual Basic form MmaFill VarGetFieldAddendumText Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field Addendum text of a field refers to excess text that cannot be fit within the bounds of that field GetFieldAddendumText on page 215 Variant Addendum Text of the Field FieldName Null An Error was encountered Chapter 4 Description Syntax Parameter Description Remarks See Also Return Values Advanced Programming 308 VarGetFieldHelp Returns Help Text of field FieldName C VARIANT CMmarFill VarGetFieldHelp LPCTSTR FieldName Visual Basic form MmaFill VarGetFieldHelp Byval FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method Help Text for form fields are set at Design time by assigning
80. OL CMmaFill PrintForm long printerDC short StartPage short EndPage Visual Basic form MmaFill PrintForm Byval printerDC As Long Byval StartPage As Integer Byval EndPageAs Integer The following parameters are available Parameter Description printerDC Printer Device Context StartPage Starting page to be printed EndPage Ending page to be printed This method is similar to Print with the only difference that this method does not print an Addendum sheet True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 275 PrintFreeDC Frees a printer DC Device Context previously created by PrintGetDC C VOID CMmarFill PrintFreeDC Visual Basic form MmaFill PrintFreeDC None This method is used in conjunction with PrintGetDC None See GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 276 PrintGetDC Returns a printer DC Device Context C LONG CMmafFill PrintGetDC LPCTSTR Options Visual Basic form MmaFill PrintGetDC Byval Options as String As Long The following parameters are available Parameter Description Options The Following parameter value pairs are separated by a semicolon PrinterName lt UNC Prin
81. Oi GetRecordCount None A table with no records has a Record Count of 0 The return value is a Long data type GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 346 Lookup Displays a Lookup Dialog containing a selectable list of all records matching a Search Criteria C VARIANT CMmaADOi Lookup SHORT DataSourcelndex LPCTSTR FieldName LPCTSTR SearchCriteria LPCTSTR DialogCaption Visual Basic form MmaADOi Lookup DataSourceIndex As Integer FieldName As String SearchCriteria As String DialogCaption as String The following parameters are available Parameter Description DataSourceIndex Use 0 for Primary Data Source 1 for Secondary Data Source 1 etc FieldName This Field is updated with the user s selection SearchCriteria Criteria by which a list of records are displayed DialogCaption Caption of the Lookup Dialog If the user cancels out of the Lookup Dialog FieldName will not be updated True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Caution Return Values See Also Advanced Programming 347 MoveFirst MoveLast MoveNext MovePrevious Move to the first last next or previous record in a specified table and make that record the current record C
82. Or On the Edit menu click Check Spelling Check Spelling x Unknown Word Phonne conas Ta Change Ignore Suggestions Ph A pal Change All Ignore All Suggest Add The Check Spelling dialog box appears with the first questionable word in the Unknown Word field The suggested spelling if there is one appears in the Change To field Other suggested spellings appear in the Suggestions list box gt To change your spell checking options 1 Click the Setup button in the Check Spelling dialog box The Spelling Setup dialog box appears Spelling Setup x Language English hd Custom Dictionary CUSTOM DCT y Options Cancel if J Ignore words in UPPERCASE Y Ignore words with Numbers IV Always Suggest 2 Click the Language and Custom Dictionary drop down menus to specify your preferences for checking the spelling of your form 3 Click the OK button Chapter 2 Form Design Guide 86 gt To add custom words to your dictionary 1 Click Setup Select Custom dct as the default 2 Ifa questionable word is correct and you use it often click the Add button to add it to the Custom dct Find and Replace The find and replace text function allows you to locate text within your current displayed form and replace it with other text gt To find text 1 On the Edit menu click Find Enter the desired text in the Find dialog box Find what Name Match whole word only
83. PERTY function returns a string SETFIELDPROPERTY Add 2 fields to your form Name these fields Phone and Dummy Set the OnClick action of field Dummy to ALERT GETFIELDPROPERTY Phone vfTextColor pue eu RTL False a FillF ont Arial Regular 10 E Edit MaxFillChars 0 Auto Tab False Mandatory False Multiline True Overwrite True NoAddendum False TabOrder 2 Calculation Validation OnClick ALERT GETFIELDPROPERTY Phone vfTextColorn OnDblClick OnModify OnGotFocus In the Fill Mode click on field Phone The Alert screen will display the RGB value of the Text Color of field Phone Chapter 2 Scripts 114 To specify RGB for a Custom color go to the appropriate color property instructions such as To Change an Object s Background Color On the color dialog box note the numbers in the lower right hand corner for red green blue These are the numbers used to represent a custom color for parameter PropertyVal Chapter 2 Function Syntax Explanation Parameters Remarks Return Values Example Scripts 115 GETNUMPAGES GETNUMPAGES Returns the total number of pages for the currently loaded form None None GETNUMPAGES returns a numeric value Add a button to your form Set the OnClick action of this button to ALERT This Form has STR GETNUMPAGES pages Go to FillMode Click on the button The above example uses the STR func
84. Returns Enter Enter Returns Scripts 125 MONTH MONTH date Returns the month portion of the date from a string containing MM DD Y Y Y Y The following parameters are available Parameter Description date any expression that can represent a date If date contains Null Null is returned MONTHO function returns a number DATE TIME DAY YEAR HOUR MINUTE SEC Edit1 contains 03 22 2001 MONTH Editl 3 If current date is February 28 2004 then MONTH DATE returns 2 MONTH 12 04 2001 12 Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Enter Returns Enter Returns Scripts 126 NUM NUM string Converts an expression into a numeric value The following parameters are available Parameter Description string any valid expression Use equal number of left and right parentheses Returns a numeric value NUM rounds to the number of decimal points specified in the decimal points property of the receiving number field of a calculation STRO Edit1 contains 20 Edit2 contains 3 Edit3 contains 4 Edit5 contains 2 NUM Edit1 NUM Edit2 NUM Edit3 27 NUM converts the strings 20 3 and 4 to numbers and then adds them Edit1 Edit2 Edit3 2034 Contents of fields Edi
85. Second Clear data from all fields on the form Dim rv rv MmaFilll OpenFormDialog rv MmaFilll1 FillTestData rv MmaFilll ClearData Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 212 GetCurrField Sets FieldName to the name of the current field in focus C BOOL CMmarFill GetCurrField BSTR FAR FieldName Visual Basic form MmaFill GetCurrField FieldName As String The following parameters are available Parameter Description FieldName Holder for the name of the form Field in focus none VarGetCurrField for VB or Java scripting True Call to this method was Successful False An Error was encountered Two ways of capturing the name of field that has Focus GetCurrField and VarGetCurrField Dim rv Dim FieldName As String 255 rv MmaFilll OpenFormDialog rv MmaFilll GetCurrField FieldName MsgBox RTrim FieldName has now focus MsgBox MmaFilll VarGetCurrField has now focus Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 213 GetCurrPage Returns the current page number of the currently loaded form C short CMmaFill GetCurrPage Visual Basic form MmaFill GetCurrPage None None Current page number of the currently loaded form What page am I on now How many fields does this form have Dim rv Dim PageNu
86. System selected from Form Setup gt To display the ruler On the View menu click Rulers E Form2 Al ES O A AAA AA AA APTA A AAA Grid A grid is a series of intersecting horizontal and vertical lines When displayed the grid looks like a sheet of graph paper You can create a grid with small divisions geometric settings for precise placement or large divisions geometric settings for more general placement The grid allows you to position objects in your form window gt To display the grid 1 On the Arrange menu click Grid Grid Settings x G t gii A 0 50 Width J inches Ss Height 0 50 inches Show Nothing C Dots C Lines I Snap to arid 2 In the Geometry section enter a value for the Height and Width of the grid coordinates The smaller the value the smaller the grid boxes 3 In the Show section click a radio button to show Lines Dots or Nothing Lines display intersecting lines Dots display dots at every intersection 4 If you wish enable Snap to grid See the next section for a full explanation of this feature Chapter 2 Form Design Guide 5 Click the OK button E Form2 Of x The grid with lines is displayed in the form window 35 Chapter 2 Form Design Guide 36 Using Snap to Grid A grid is a set of horizontal and vertical lines that act as a guide when moving or resizing objects Each dot or line intersection represen
87. T M The Properties window appears Misc Position Appearance Borders Margins Text Edit Notify Chapter 2 Form Design Guide 43 gt To change object properties 1 Select the object to be changed 2 Open the Properties window 3 Identify the Property that you would like to change Miscellaneous Position Appearance Borders Margins Text Edit or Notify Miscellaneous Properties Lx Name Edit NonPrintable False Position Appearance Borders Margins Text gt To name the object Enter a name for the object in the Name field The Name defaults to whichever object you have selected such as Edit Text or Line but you may want to change it to a name that is meaningful to you such as Label Logo etc gt To designate which objects print on your form Click the drop down menu in the Non Printable field If True is selected the object does not print as a part of the form If False is selected the object does print Setting Default Object Properties Default object properties can be set for each object these properties then appear each time you create a new object The object properties can be set and retained as a group accommodating varying standard design requirements gt To set default object properties 1 Click the object icon for which you want to set the default properties The Properties Window is now in Defaults mode as indicated 2 Set the properties of your choice
88. The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as Field Name Paramater of this method If the Signature does not validate in addition to setting the return value to False an error message may also be displayed SignForm UnsignForm GetSignerName GetSignatureTimestamp True Signature Validated False Signature Did Not Validate Add a signature field to your form and name it Signaturel Call this method to Validate Signaturel Dim rv If ValidateSignature Signaturel TRUE then MsgBox Signature is Validated Else MsgBox Signature is NOT Validated End If Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 306 VarGetCurrField Returns the name of the current field in focus C VARIANT CMmafFill VarGetCurrField Visual Basic form MmaFill VarGetCurrField None none GetCurrField on page 212 Variant Name of the Current Field Null An Error was encountered Two ways of capturing the name of field that has Focus GetCurrField and VarGetCurrField Dim rv Dim FieldName As String 255 rv MmaFilll OpenFormDialog rv MmaFilll GetCurrField FieldName
89. a string starting at u which is in position 3 STRAT January 2000 6 y 2000 79 TEL The J is in position 0 the a is position 1 the n is position 2 etc Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Returns Scripts 138 STREXTRACT STREXTRACT string startposition length Returns a string beginning at the specified position and for the specified length The following parameters are available Parameter Description string String expression being searched startposition Numeric expression that sets the starting position for the search length Numeric expression that sets the number of characters to return startposition is offsetted at zero meaning that the first character of string is at position zero the next character is at position 1 etc LEFT RIGHT STRO STRATO STRINSTRO STRLEN UPPER LOWER Edit1 contains 0123456789 STREXTRACT Edit1 3 4 3456 In the above example startposition is set to 3 which points to the 4th character from left of the string 1 e 3 STREXTRACT exceptional 2 3 ce cep In the above example startposition is set to 2 which points to the 3rd character from left of the string i e c Chapter 2 Function Syntax Explanation Parameter Notes See also
90. address a field at Tab Order 12 pass 12 as FieldName Paramater of this method nIndex Specified the zero based index to the string to be deleted None Returns a count of strings remaining in the DropList if call to this method was Successful Returns 1 in case an error was encountered Field Marital Status is a droplist object and has these choices Married Single Divorced Widowed dim RV RV DropListDeleteString Marital_status 2 After this command is executed field Marital Status is left with these choices Married Single Widowed Divorced which is the 2nd choice Married is Oth choice Single is Ist choice and Divorced is 2nd choice is deleted RV contains the return value from this command which is the number of remaining choices which will be 3 after the command is executed therefore RV will be set to 3 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 202 DropListGetCount Returns the number of items in the DropList field FieldName C long CMmaFill DropListGetCount LPCTSTR FieldName Visual Basic form MmaFill DropListGetCount Byval FieldName As String The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pa
91. all MmaFill CreateNote False Opaque True FontSize 12 The following Visual Basic code adds a Sticky Note object with default properties Call MmaFill CreateNote False Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 196 Cut Moves a marked block of text to the Windows clipboard and deletes it from the field C BOOL CMmaFill Cut Visual Basic form MmaFill Cut None None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 197 DisableRedraw Disables or enables repainting of the form when field values are being updated via SetFieldData or AppendField methods C BOOL CMmaFill DisableRedraw BOOL Disable Visual Basic form MmaFill DisableRedraw Byval Disable As Boolean The following parameters are available Parameter Description Disable set to True to disable redraw repaint and False otherwise This method is primarily used in situations where a great number of fields on the form are being updated together e g data from a large database table is being loaded onto the form fields In order to avoid a redraw on each field update you can disable redrawing in the beginning of the data load process and re enable redraw once the data load process is complete True Call to this method was Successful
92. alues See Also Advanced Programming 342 FindFirst FindLast FindNext FindPrevious Locate the first last next or previous record in the database that satisfies the specified criteria and make that record the current record C BOOL CMmaADOi FindFirst FindLast FindNext FindPre vious LPCTSTR Criteria Visual Basic form MmaADOi FindFirst FindLast FindNext FindPre vious Criteria As String Criteria A string expression the WHERE clause in an SQL statement without the word WHERE used as the Find condition Use the Find methods to locate records that satisfy a specific condition If you want to include all the records in your search not just those that meet a specific condition use the Move methods to move from record to record If table contains more than one record that satisfies criteria FindFirst locates the first occurrence FindNext locates the next one and so on Using one of the Find methods isn t the same as using MoveFirst or MoveNext however which simply makes the first or next record current without applying a condition You can follow a Find operation with a Move operation True Call to this method was Successful False An Error was encountered GetLastError MoveFirst MoveLast MoveNext MovePrevious Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 343 GetAbsolutePosition Returns the relativ
93. am if password encrypted is compliant with the current W3 org draft standard for XML encryption C VARIANT CMmaFill XMLGetFormData LPCTSTR Options Visual Basic form MmaFill XMLGetFormData Options As String The following parameters are available Parameter Description Options The following parameter value pairs are separated by semi colon EnableExtAttr 0 1 Setting EnableExtAttr to 1 will allow modified properties of the fields to also be included in the returned XML string The default value of this parameter is 1 Encrypt lt enable gt enables encryption of the data default is false For Example Encrypt 1 EncryptAlg lt encryption algorithm type gt encryption algorithm Choices are 3DES or RC4 default is 3DES For Example EncryptAlg 3DES EncryptKeyLen lt No of Bits gt number of bits for the encryption key note some algs such as 3DES ignore this parameter default is 128 For Example EncryptKeyLen 128 EncryptPwd lt password gt password used to encrypt the XML data with Chapter 4 Parameters Remarks Return Values Example Advanced Programming 317 Parameters continued Parameter Description Options The following parameter value pairs are separated by semi colon Pages lt Page Number gt lt Page Number gt is a single page number If Pages parameter is omitted by default all pages will be included in the returned XML string SkipBlanks 0 or 1 0
94. ame Turn ON the DbIClick Notify flag of the signature field and then call the SignForm method on this event If type is Hand Signature SignForm method is automatically called as soon as the Signature field loses focus and the signature drawn by the user into FieldName will be finalized If type is NT Domain FieldName will get the value from login user account name in the NT Domain If type is Hand Signature user can write into sign FieldName using mouse or mouse pen If type is PKI the user s signature will be taken from My Store DigitalCertificate repository on the system Chapter 4 Return Values See Also Example Advanced Programming 301 Signature Type of User Defined is reserved for future use True Success False An Error was encountered UnSignForm ValidateForm GetSignerName GetSignatureTimestamp Add a signature field to your form and name it Signaturel turn the DbIClick Notify property of Signaturel to ON When user DbIClicks into Signaturel I want to do one of 2 operations 1 If Signaturel is empty then I want to Sign 2 If Signaturel is NOT empty it is already signed I want to Unsign When user DbIClicks onto the Signaturel field the FieldDbIClick event is called Within the FieldDbIClick event we will perform our operation Note that FieldDb1Click event returns the name of the fi
95. an edit field allows the user while in the Filler to change the Fill Font attributes for the entire field only Chapter 2 Form Design Guide 84 Editing Text in Forms Text may be entered only into text objects fillable text objects or other fillable objects such as tables Text cannot be entered into image objects bar code objects or shapes such as lines circles or boxes Your current position within the text is indicated by a flashing vertical text cursor gt To enter or edit text within an object Select the Edit icon or Double click the object that you want to edit When selected for text entry or editing the object is surrounded by a red dashed line gt To select a portion of text Just like in most word processing programs you can select a portion of text within an object for editing 1 Select the Edit icon 2 Move the pointer to the text you want to select 3 Hold down your mouse button and drag the pointer over the entire portion of text As you drag the pointer the text you select becomes highlighted appearing as white text on a dark background Chapter 2 Form Design Guide 85 Check Spelling Use the Check Spelling feature to ensure that all text on your form is spelled correctly You can check the entire form including field help and default data entered in Preview Mode or individual objects gt To check the spelling of your document Click the Spell Check icon on the Standard toolbar
96. anges when he she is attempting to load a new form or is exiting the application True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming AboutBox Displays box containing Visual eForms Copyright details C void AboutBox Visual Basic form MmaFill AboutBox None None None 188 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 189 AppendField Appends string AppendString to the contents of field FieldName C BOOL CMmaFill AppendField LPCTSTR FieldName LPCTSTR AppendString Visual Basic form MmaFill AppendField Byval FieldName As String Byval AppendString As String The following parameters are available Parameter Description FieldName Name of the Form Field AppendString String to be appended to contents of specified Form Field None True Call to this method was Successful False An Error was encountered Change the value of LAST_NAME field by appending ABCDEF to it Dim rv rv MmaFilll OpenFormDialog rv MmaFilll AppendField LAST_ NAME ABCDEF Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 190 AutoReduceFonts Changes the automatic Font Reduction settings of the Filler control C BOOL CMmaFill AutoRedu
97. any current selection in the DropList is removed and the field is cleared None Returns the zero based index of the item selected if call to this method was Successful Returns 1 in case an error was encountered Field Marital Status is a droplist object and has these choices Married Single Divorced Widowed dim RV RV DropListSetCurSel Marital_status 3 After this command is executed Widowed will display in the droplist field as the user s choice Note that Widowed is the 3rd choice in the droplist If there is an error then this command returns 1 i e RV is set to 1 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 205 EnableAddendumTag Disables or enables appearance of the words Addendum Tags for fields whose text exceed their size This command applies to all fields on the form C BOOL CMmarFill EnableAddendumTag BOOL Enable Visual Basic form MmaFill EnableAddendumTag Byval Enable As Boolean The following parameters are available Parameter Description Enable set to True to enable drawing of Addendum Tags and False otherwise When EnableAddendumTag is invoked any field on the form with its text exceeding its size will be tagged with See Addendum in its lower right corner At print time you can give the option of printing an Addendum page containing a cross reference to the Addendum Tags and the spil
98. apter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 242 GetNextField Returns the name of the next field in tabbing order on the form C VARIANT CMmarFill GetNextField Visual Basic form MmaFill GetNextField None None GetFirstField Variant Name of the next Field Null An Error was encountered or no more fields were found on the form See GetFirstField on page 234 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 243 GetNumPages Returns the total number of pages for the currently loaded form C short CMmaFill GetNumPages Visual Basic form MmaFill GetNumPages None None gt 0 the Number of pages in the form 0 an error occurred See GetFirstField on page 234 Chapter 4 Description Syntax Parameter Remarks See Also Return Values Advanced Programming 244 GetSignatureTimestamp Returns a string holding Date and Time the Signature field was signed C VARIANT CMmarFill GetSignatureTimestamp LPCTSTR FieldName Visual Basic form GetSignatureTimestamp FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field a
99. ary Data Source and SecondaryDS lt gt for the corresponding Secondary Data Source For example PrimaryDS Database c DBs db1 mdb SecondaryDS1 Da tabase c DBs db2 mdb The parameters used to create the Database are set at form design time using the Database Relations facility of the Designer True Call to this method was Successful False An Error was encountered GetLastError Connect Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 340 Delete Delete the current Record from the database C BOOL CMmaAD0Oi Delete Visual Basic form MmaADOi Delete None Use this method if you do not want to use the ActiveX s own User Interface for Deleting the current record from the database True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 341 Disconnect Closes connection to the database C BOOL CMmaADOi Disconnect Visual Basic form MmaADOi Disconnect None To re establish connection between the form and the database you need to invoke the Connect method True Call to this method was Successful False An Error was encountered GetLastError Connect Chapter 4 Description Syntax Parameters Remarks Return V
100. ate is after DateExpr DATE DAY MONTHO YEAR HOUR MINUTE SECO DIFFDATE DIFFTIME SUMTIME Current date is 02 14 2004 SUMDATE DATE 4 02 18 2004 SUMDATE 03 30 2004 5 04 04 2004 SUMDATE DATE 4 02 10 2004 Chapter 2 Function Syntax Explanation Notes See also Example Where Enter Returns Enter Returns Enter Returns Scripts 143 SUMTIME SUMTIME TimeExpr NumExpr Calculates a time that is a specified number of hours between or after another time e TimeExpr is a string e NumExpr is a numeric value e SUMTIME function returns a string If NumExpr is a negative value the calculated time is before TimeExpr If NumExpr is a positive value the calculated time is after TimeExpr DATE DAY MONTHO YEAR HOUR MINUTE SEC DIFFTIME DIFFDATE SUMDATE Current time is 04 20 08 SUMTIME TIME 5 09 20 08 SUMTIME 11 20 53 3 14 20 53 SUMTIME TIME 2 02 20 08 Chapter 2 Function Syntax Explanation Notes See also Example Where Enter Returns Enter Returns Scripts 144 TIME TIME Returns the current system time in HH MM SS format TIME function returns a string TIME function is an automatic script The value of the field will automatically be set to current system time DATE DAY MONTH YEAR HOUR MINUT
101. awn with the object tool e Fit In Box Regardless of the original proportions of the image file this selection resizes the image to fit the image outline of the box drawn with the object tool e By Factor not operable at this time 6 The functions for ScaleX ScaleY CropX and CropY are inoperable at this time 7 Click on the drop down menu in the Embedded field to select an option Select True to embed the image into the form This places a copy of the image into the form and becomes a part of the form Select False to reference the image as a separate file This selection calls the image file from a hard drive or a server Only the pointer to the image is maintained as a part of the form the actual image is not part of the form If using the Visual eMerge product False is the correct selection Using this method makes it easier to change images across a large number of forms at one time without changing each individual form Editable Images Editable images allow insertion of pictures logos sketches images of signatures product pictures etc into a form while in the Filler These images can come from anywhere e g web user s hard disk floppy server After drawing the editable image outline you can define the properties Edit Borders Margins and Text just as you did when drawing Fill objects gt To define the properties of an editable image 1 Open the Properties window 2 Under the Image heading click
102. ble date object create a fillable mask object format a Mask defined by designer v Check Box create a fillable check box object al Button create a button to execute a macro create an image where the user types the pathname for the image in the Filler R Editable Image E Drop List create a scrolling drop list E Table create a fillable table object Bar Code create bar code object ss e add a digital signature to the form so Rich Text add a rich text object Chapter 2 Form Design Guide 30 Drawing Objects Identical steps are used to create most objects they are drawn the same way whether they are fillable or non fillable gt To draw an object 1 Click the desired object on the Object toolbar Objects x k I Ar da abl sl PAP OOO EE S 2 Move the cursor into the form window where you would like to place the object 3 Hold down the mouse button and drag to draw the desired object in the form window E Form2 Al E 4 When the object is the size you want release the mouse The object is displayed in the form window Chapter 2 Form Design Guide 31 Crosshairs When drawing or positioning an object you can use crosshairs to precisely measure the size of the object gt To enable crosshairs 1 On the View menu click Crosshair The Crosshair Properties dialog box appears Crosshair Properties x I Enable Crosshair Crosshair Color 2 C
103. c show the note in its entirty or as an icon 2 Transparent selected or not selected 3 Printable selected or not selected 4 Callout associate the note to text using an arrow 5 Delete remove the note Cust INVOICE amp Add Sticky Notes to INVOIC cerena d e your form t 9800 S La Cienega Blvd Suite 411 Inglewood CA 90301 SALES P SHIPPINI Ahhh thhsssssssshhittn ype Anywhere on the form Q N BILL TO SHIP TO CAAA EAA 7 7 7 6 4 7 7 Z a AEREA AAA ARA tithe Type Anywhere Text can be added to the form while in Preview mode This is helpful to users when additional text is required and there is no fill in space made available or the fill in space is too small gt To add text using Type Anywhere 1 While in Preview mode press Control shift N Chapter 2 Form Design Guide 91 2 The cursor changes to a text Type Anywhere icon 3 Enter text Any text added in this manner will be included in the database information as an XML string gt To see the options for this feature right click on the Type Anywhere border 1 Transparent selected or not selected 2 Printable selected or not selected 3 Callout associate the note to text using an arrow 4 Delete remove the note Exiting Visual eForms Designer gt To exit Visual eForms Designer do either of the following On the File menu click Exit or Click the X in te top right corner of the
104. ceFonts short Points BOOL Repaint Visual Basic form MmaFill AutoReduceFonts Byval Points As Integer Byval Repaint As Boolean The following parameters are available Parameter Description Points of point sizes to Auto Reduce the fill fonts Repaint set to True to effect a repaint Once this method is called the changes remain in effect for subsequent forms loaded into the filler until the next call to this method True Call to this method was Successful False An Error was encountered Set AutoReduceFont property of the form to 3 Dim rv rv MmaFilll OpenFormDialog rv MmaFilll AutoReduceFonts 3 True Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 191 ClearData Clears the contents of all fields on the currently loaded form C BOOL CMmarFill ClearData Visual Basic form MmaFill ClearData None Before calling this method it is wise to check for any unsaved changes to the current form and notifying the user of the application if necessary True Call to this method was Successful False An Error was encountered First Fill form fields with test data Second Confirm clearing Third Clear data from all fields on the form Dim rv rv mmafill OpenFormDialog rv mmafill FillTestData rv MsgBox Clearing Data Chr 10 Are You Sure vb YesNo If rv vbYes Then mmafill ClearData End If Chapter 4
105. ch IF Salary1 lt 100 GOTOFIELD Poor GOTOFIELD EverybodyElse The nested IF statement moves the cursor to the appropriate field depending on the salary Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 121 LEFT LEFT string length Returns a string containing a specified number of characters from the left side of a string The following parameters are available Parameter Description string String expression from which the leftmost characters are returned If string contains Null Null is returned length Numeric expression indicating how many characters to return If 0 a zero length string is returned If greater than or equal to the number of characters in string the entire string is returned None RIGHT STR STRATO STRINSTR STRLEN UPPER LOWER STREXTRACT Edit1 contains Visual eForms Designer is Powerful LEFT Editl 4 Visu Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 122 LOWER LOWER String Returns the lower case representation of the string The following parameters are available Parameter Description string any valid string expression If string contains Null Null is returned None LEFT RIGHT STRO STRATO STRINSTR STRLEN UPPER
106. checks to see if there is a Mandatory field that is left blank If so then the user is prompted and focus is placed back on to the Mandatory field Sub SaveMyForm Dim FieldName FieldName mmafill GetUnfilledMandatory If FieldName lt gt then rv mmafilll GotoField FieldName MsgBox This is a Mandatory field and cannot be blank End If End Sub Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 247 GetVersion Returns the Version Number of Visual eForms Filler ActiveX C CString CMmarFill GetVersion Visual Basic form MmaFill GetVersion None None String Version of the Visual eForms ActiveX e g 1 2 0 7 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 248 GotoField Resets focus to field FieldName of currently loaded form C BOOL CMmaFill GotoField LPCTSTR FieldName Visual Basic form MmaFill GotoField Byval FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method None True Call to this method was Successful False An Error was encountered Copy the first 5 characters of
107. ckBox field EMPTY String 39 Returns the value of the StrEmpty property of a CheckBox field Page Number 40 Number String representing the Page Number a given field appears on Chapter 4 Advanced Programming 227 Property ID Returns Calculation 41 Returns the value of the Calculation property of a field Fill Font 43 The string describing a Fill Font has the following format name height bold italic underline char spacing mode char spacing points where name font name height font size in points bold True or False italic True or False underline True or False char spacing mode Normal 0 Expanded 1 Condensed 2 Fixed 3 char spacing points increments of 1 10th of point applied to Expanded Condensed or Fixed mode Field Help 44 Returns the value of the FiedHelp property of a field Date Format 45 Returns the value of the DateFormat property of a DATE field Date Auto 46 Returns 1 if the DateAuto property of a DATE field is TRUE Otherwise Returns 0 Decimal Points 47 Returns the value assigned to DecPoints property of a Number or Currency field Advanced Programming 228 Property ID Returns Decimal Character 48 Returns the character assigned to DecChar property of a Number or Currency field Comma Separated 49 Returns 1 if the CommaSep property of a Number or Currency field is TRUE Otherwise Returns 0 Imeg File 50 Returns the value of the ImageFile property of an Image field Scale T
108. cters starting from the left of the string Chapter 2 Scripts 98 Function Description LOWER Returns the lower case representation of the string LTRIM Removes the leading spaces from the left of a string MINUTE Returns the MM portion of time in HH MM SS MONTH Returns the MM portion of a date in MM DD YY YY NUM Converts an expression into a numeric value PRINTDIALOG Invokes the print dialog box in order to print the form RIGHT Returns a specified number of characters starting from the right of the string ROUND Numerically rounds the expression The number of decimal places is specified as part of the function RTRIM Removes the leading spaces from the right of a string SEC Returns the SS portion of time in HH MM SS SETFIELDDATA Sets the content of the specified field SETFIELDPROPERTY Sets a property of the specified field SETPROPERTY Modifies properties of a field STR Converts an expression into a string STRAT Returns a string beginning at the specified position STREXTRACT Returns a subset of a string STRINSTR Searches and returns the string within a text STRLEN Returns the length of a string SUM Returns the sum of the cells of a table column Chapter 2 Scripts 99 Function Description SUMDATE Returns a date that is specified number of days i e lt num exp gt before or after another date i e lt date exp gt SUMTIME Returns a time that is specified number of hours i e lt num exp g
109. d If or Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 32 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 169 v CheckBox Property ID of CheckBox field C long GetVfCheckBox void SetVfCheckBox long Visual Basic form MmaFill vfCheckBox Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long 16 In the following Visual Basic example the type of field Cancel is examined If Cancel is a checkbox object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill vfCheckBox then do something End If or Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType 16 then do something End If Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 170 v Date Property ID of Date field C long GetVfDate void SetVfDate long Visual Basic form MmaFill vfDate Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long 2048 In the following Visual Basic example the type of field Cancel
110. e Advanced Programming 176 v MaxFillChars ID for MaxFillChars property of a field C long GetVfMaxFillChars void SetVfMaxFillChars long Visual Basic form MmaFill vfMaxFillChars Must be used with GetFieldProperty or SetFieldProperty to Get or Set the MaxFillChars of a field Set MaxFillChars to Zero for an unlimited number of characters Long 27 The following Visual Basic code returns the value of this property Msgbox mmafill VfMaxFillChars returns 27 Set the maximum number of characters one can type into field PhoneNumber to 80 rv mmafill SetFieldProperty PhoneNumber 27 80 Or rv mmafill SetFieldProperty PhoneNumber mmafill VfMaxFillChars 80 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 177 v Number Property ID of Number field C long GetVfNumber void SetVfNumber long Visual Basic form MmaFill vfNumber Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long 256 In the following Visual Basic example the type of field Cancel is examined If Cancel is a number object then do something Var FieldType as String FieldType mmafill GetFieldProperty Cancel mmafill vfType If FieldType CStr mmafill vfNumber then do something End If or Var FieldType as String
111. e e Horizontal Center to align the objects by their horizontal center e Right to align the objects by their right side e Top to align the objects by their top side e Vertical Center to align the objects by their vertical center Bottom to align the objects by their bottom side For more Sizing Objects to Match a information a about the Standard gt toolbar see with the last object selected Standard Toolbar on page 9 gt To make objects the same height or width You can quickly make two objects exactly the same size All objects are sized 1 Select the desired objects 2 On the Arrange menu do one of the following point to Make Same Size and then click Width point to Make Same Size and then click Height or On the Standard toolbar e click the Same Width icon e click the Same Height icon jm Layering overlapping objects You can move overlapping objects from front to back or back to front gt To layer overlapping objects 1 Select the object 2 On the Objects menu click Bring to Front or Send to Back Chapter 2 Modifying Objects Form Design Guide 38 When an object is selected you can modify it When resizing and moving the cursor changes shape depending on where the cursor is placed gt To 1 2 3 4 gt To N a U amp gt To N e U 4 gt To N e A U resize an object Select the object Click any handle on
112. e to change the default properties on the individual objects Chapter 2 Form Design Guide 42 Changing Object Properties All objects have common properties that can be changed Changing their properties changes the way they look and function in the form Not every object has every property Some like masks have additional properties This section explains how to change properties in objects Using the Properties Windows To display a the alter a native Properties window right click an object See Alternative Properties Window on page 80 for more infor mation To change the properties of an object you must first open the Properties window which contains property sections such as Appearance Borders Calculations Color Fill Characteristics Font Justify Lines Margins Name Position and Text gt To open the Properties window To set the properties of a form you must open the Properties Window The form properties are viewable from the Properties Window only To open the Properties window ensure Properties is checked in the View menu On the View menu click Properties This will hide show the Property control bar me e Property control bar handle To display the Properties Window do one of the following e On the View menu click Toggle Properties Mode e Double click on the Property control bar handle e Click the Property control bar handle and drag it to the form window e Press AL
113. e 252 Import A Se ereat potest eden Ain ae oe E A a 253 TsForm hanged EE E E A E NEEE 254 EIo niat roe aS e A E A E E E E 255 Lock e da 256 MAP ISendMeail A a EE E E aes usatecseenagueaee she 257 Nexthiel dic a A a i ito ai 258 AA E E 259 Oper OM As i 261 OpenFormData id AS 262 OpenFormDataDialog ii AS Me 264 OpenFormDialos Aid 265 OpenFormPasswordDecry pt manita aoa 266 Openlntemet FOr ira 267 E NN 268 1 ta KEDA LE K RAET O RR 269 Prnt a a E o 270 PrintA DOTE e raene E es E A de ee 271 PAAA d an dia dad 272 PEDIA a e A Mee ei teh lest es As 273 Pritt ln A in 274 A ee ee oe eee ee 275 PrinthreeDG iii Rico hg eect haves eee in od anid OR ER 276 AAA A RO E 277 Pants A a 278 PantP are a a hla pesca lee test Ve eo bios ch ate tenga aaa 279 Panta A MS Bae ee 280 Redraw A E cede atte oes Madea le eee ae tte 281 SAVE MM A A das 282 SACO DIKE ARRERA ET gene cusnees sncuaesses oatisues nea tacwonseonegeveaeay 283 SaveFormDataD talog iia Ao RT 284 SaveFormDialog a EEE 285 SaveFormPasswordENCrypt encerio an e E o eiee 286 SLEI no i ANNE EEEE E ETE aa A E E A 287 SECUELA e nd BREA 288 SetPield Data S e E E BMA T E 289 SetEnterprise Params a 290 SetPieldDataE A E Seana tibdernaseenytee eee 291 SethieldProperty secesscicck ei he hes as ee 292 SIN A E A E 294 O E O 295 SetFOrMPrOpETtY teii nE E EE EEA EERE AE 296 SetNotiiyOnCalc ii e o 298 SetSharedFontTable A 299 ShowNonPrintables ii ind 300 Sd an 301 Contents vi as Ones 30
114. e 94 In the error message Offset refers to the number of characters from the beginning of the line where the error has occured Form Design Guide gt To enter a calculation 1 Click the drop down menu in the Calculation field The Calculation dialog box appears Fields 5208b7_err 5208b8_err 5208b9_err Barcode2 Btn1 Btn2 STRINSTR Btn3 Checkbox Checkbox2 Coverage_4 Function Description STREXTRACT lt str expr gt lt num expr gt lt num expr Coverage_4_1 Extracts a string from a string expression given the Coverage_4_2 starting and ending position within the string Democity y STREXTRACT State _List 0 2 2 Double click the Field in which to place the calculation 3 Double click the Function that you would like in the Field 4 Click any Operators necessary for the Function 5 Click Check Syntax to determine if your syntax is correct If not a message indicating the problem will appear ERROR 1075 Parsing Failure for Calculation Script of Field Number2 on or near Line 1 Offset 7 The Fields Functions and Operators appear in the Calculations field 58 Chapter 2 If you are familiar with N calculations syntax you can quickly enter the calculation in the Control Bar as shown to the right To view B Field Help in EEN the Filler right click on the field select the Help option and the Field Help dialog appears The Filler application general
115. e available Parameter Description Notify set to True to disable performing form level calculations This method is primarily used to perform the form level calculations in the application code instead In order to restore the default behavior of the ActiveX Control i e performing form level calculations automatically call this method with Notify set to False True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 298 SetSharedFontTable Sets the Shared Font Table to provided FontFile C BOOL CMmarFill SetSharedFontTable LPCTSTR FontFile Visual Basic form MmaFill SetSharedFontTable Byval FontFile As String The following parameters are available Parameter Description FontFile Name of the Font File This method is primarily used for forms whose Font Table is separate form the Form File and is shared between a set of forms True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 299 ShowNonPrintables Shows or hides the non printable objects on the currently loaded form C BOOL CMmaFill ShowNonPrintables BOOL Show Visual Basic form MmaFill ShowNonPrintables Byval Show As Boolean The following parameters are available Parameter Description
116. e drop down menu to select inches centimeters or picas In the Orientation section click either the Portrait or Landscape radio In the Margins section enter the width of page margins for Top Bottom Left and Right The margins appear as a dotted line around the edge of the form window Chapter 2 Form Design Guide 18 6 On the drop down menu select a Background Color for your form This applies to every page in the form that you create 7 If you wish password protect your form by clicking Password then entering and confirming a password The B password is EN case Form Password x sensitive so check your Form Password ox Caps Lock Key Cancel Confirm Password 8 Click the OK button Defining Page Setup Page setup give you the ability to customize forms on each individual page of a multi page form Using this new feature you can have mixed page orientations and page sizes within the same form gt To Define Page Setup 1 Go to the form page you wish to customize 2 On the File menu click Page Setup The Page Setup dialog box appears r Paper Orientation Portrait C Landscape Background Color o L Size A Width 8 50 Height fi 1 00 3 Make the necessary choices and click the OK button The choices you make apply to the current form page only Chapter 2 Form Design Guide Saving Forms A new or existing form can be saved by doing
117. e following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify MouseEnter property of the desired Form Field to True for the FieldMouseEnter event to occur for that Form Field Chapter 4 Description Syntax Parameter Remarks Advanced Programming 327 FieldMouseExit Occurs when the user moves the mouse out of a form field C afx_msg void OnFieldMouseExitMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldMouseExit Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify MouseExit property of the desired Form Field to True for the FieldMouseExit event to occur for that Form Field Chapter 4 Advanced Programming 328 FillerLoaded Description Occurs when the filler ActiveX is instantiated Syntax C afx_msg void OnFillerLoadedMmaFill Visual Basic Sub MmarFill_FillerLoaded Remarks FillerLoaded event occurs when the ActiveX is fully loaded and instantiated Chapter 4 Advanced Programming 329 GotFocus Description Occurs when the filler ActiveX gets the focus Syntax C afx_msg void OnGotFocusMmaFill Visual Basic Sub MmaFill_ GotFocus Remarks As user switches between applications the ActiveX can lose and regain focus This event occurs as soon as the ActiveX regains the focus Chapter 4 Advanced Programming 330 LostFocus
118. e record number of the current record C LONG CMmaADOi GetAbsolutePosition Visual Basic form MmaADOi GetAbsolutePosition None You can determine the current record number by checking the GetAbsolutePosition method setting You can determine the number of populated records in the table by using the GetRecordCount method If there is no current record as when there are no records in the table GetAbsolutePosition returns 1 If the current record is deleted the GetAbsolutePosition method value isn t defined New records are added to the end of the sequence The return value is a Long integer from 0 to one less than the number of records in the table It corresponds to the ordinal position of the current record in the table GetLastError GetRecordCount Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 344 GetLastError Returns the message corresponding to the most recent run time error generated by a call to one of MmaADOi methods C VARIANT CMmaADOi GetLastError Visual Basic form MmaADOi GetLastError None None Message corresponding to the most recent run time error None Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 345 GetRecordCount Returns the total number of records in a table C LONG CMmaADOi GetRecordCount Visual Basic form MmaAD
119. e weet 30 Crosshairs cia eh eles toes Boge raed Teel dea eh irae oma el 31 Positioning Object a 32 Selecting Obs iii il 32 Rule a e ida AES 34 FA Ad A A 34 USE Shap OA ropas teta 36 Aligning Objects ii s n 37 Modifying Objects iii ona 38 Changing Object Properties cion iii 39 Using the Properties WindOwS csccescsscsssesecescesecesceeeeeseeseecsecseecaecsaeeseeneenaeeneeees 39 Miscellaneous ii aa 40 40 Setting Default Object Properties 20 0 ceccsseesecseceseeeeceseeeceseeeseeseecseceeeseensenaeens 40 PO el a id ds 42 43 APPO ia ts ici 43 BOS A A A A ci irte 45 Contents ii Mi a chee ee ee ee O 47 LOR booed RO RA 48 Mixed Fonts s nondest tain hai Aia 51 Resale gett Mie deel a Be LNs a Gea ES 51 NON 52 Not e E E A 57 Special Properties At ARRAS 59 ET E EE E piba AE 59 Example ofa Mask A en eee 60 Check Boxes ci To 62 Radio Buttons camina laos 63 BULLONS id A AA i 64 TMA SES rinda ai 65 Editable Images ii sia 66 DroprListS ii a da 67 Val EEE a EEE TE Se Ausasensessted 69 Bat CodeS sci A E EE E EENE 73 Digital Signatures nainen e titi 75 Alternative Properties Window cssccscessssssceseesceseeesceseecaecssesaecsensecerentearenes 79 Property Control Bart a a ais 80 Editing Text in For A a eee 83 Check Spelling mei ai eE het esbe oct cacethduaes E E oie R ees 84 Find and Replace ea iaa 85 Printing Oris 2 0 c 6 5400s co E E iacteiusagtnas easbaiteatantecatesets 86 Filling For
120. eChangeMmaFill short PageNum Visual Basic Sub MmaFill_PageChange Byval PageNum As Integer The following parameters are available Parameter Description PageNum Page number to which the user has moved to None Chapter 4 Advanced Programming 335 Database ActiveX Properties Caption Property Description Gets or sets the CAPTION associated with the ActiveX control Syntax C CString CMmaADOi Caption void CMmaADOi Caption LPCTSTR caption Visual Basic form MmaADOi Caption Remarks By default Caption is set to the name of the object Data Type String Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 336 Methods AboutBox Displays the About box for the control C VOID CMmaADOI AboutBox Visual Basic form MmaADOi AboutBox None This is the same as clicking About in the Properties window True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 337 AddNew Adds a New Record to the database C BOOL CMmaAD0Oi AddNew Visual Basic form MmaADO1 AddNew None Use this method if you do not want to use the ActiveX s own User Interface for adding a record to the database Note that modifications to the form are not committed to the database until t
121. eater than lt gt Not equal to lt Less than or equal to gt Greater than or equal to amp or And And or Or Or or Not Not IF Number1 Number2 1 0 This is read as If field number 1 equals field number 2 then yes else no Quantity 1 Quantity 2 IF Edit2 lt 4 Red Blue IF Edit2 gt 4 Red Blue IF Edit2 lt gt 4 Red Blue IF Edit2 lt 4 Red Blue IF Edit2 gt 4 Red Blue Edit1 amp Edit2 Edit1 And Edit2 Edit1 Edit2 Edit1 Or Edit2 Edit1 Edit2 Edit1 Not Edit2 Note Operators must be outside the expressions separating expressions For example these are valid scripts Number2 Number3 Number4 e NUM Number2 Number3 NUM 12 4 This is an invalid script Number2 Number3 Number4 Chapter 2 Scripts 102 Creating the script Creating a script for calculation validation or any of the user events OnClick OnDbIClick OnModify et requires the function expression and operator gt To create a script 1 Select a fillable field in the form and open the Properties window 2 Under the Edit heading click the drop down menu in the Calculation Validation OnClick OnDbIClick etc field Properties ES Edit2 Edit E Edit MaxFillChars 0 Auto Tab False Mandatory False Multiline True Overwrite True NoAddendum False TabOrder 2 Calculation IF editl gt
122. ed for later use This method is used in conjunction with PrintPage PrintAbort PrintEnd Qjand PrintAddendum methods to provide full control over the printing process True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 280 Redraw Redraws 1 e repaints the current page of the currently loaded form C void CMmaFill Redraw Visual Basic form MmaFill Redraw None None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 281 SaveForm Packages the currently loaded form and data entered on the form into a new Form File C BOOL CMmafFill SaveForm LPCTSTR FileName Visual Basic form MmaFill SaveForm Byval FileName As String The following parameters are available Parameter Description FileName Name of the new Form File None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 282 SaveFormData Saved the data on the currently loaded form into a Form Data File C BOOL CMmafFill SaveFormData LPCTSTR FileName LPCTSTR Header Visual Basic form MmaFil
123. ed form C BOOL CMmaFill LockForm Visual Basic form MmaFill LockForm None The semantics associated with a Locked Form are entirely up to the application developer True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks See Also Return Values Advanced Programming 256 MAPISendMail Creates a New e mail message and attaches the currently loaded form to it C BOOL CMmaFill MAPISendMail LPCTSTR Subject LPCTSTR Text LPCTSTR Recipient short Flags Visual Basic form MAPISendMail Subject As String Text As String Recipient As String Flags As Integer As Boolean The following parameters are available Parameter Description Subject Subject portion of the email message Text Text Body of the email message Recipient email address of the recipient Flags Set to 0 to allow the user to edit the message set to 1 to disallow editing MAPISendMail is MAPI compliant 1 e 1t ONLY works with MAPI compliant email programs such as OutLook None True Success False An Error was encountered Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 257 NextField Advances the focus to the next field in the Tabbing Order of the currently loaded form C BOOL CMmaFill NextField Visual Basic form MmaFill NextField None None True Call to this method
124. ees ce onde Ravn oasis 339 Connect a ei RAR alee Re BE EG 340 Create Database AE EE EE S E IE E IE E deca atte te eae 341 Dil eS iaa 342 IBAI a E E EE a e ar neto eg 343 FindFirst FindLast FindNext FindPrevious ooocooconccnonococncononnnononanancnnnunonons 344 GetAbsolutePosition ccccccsccsscescecsscesseceeecesseceseccececsseeeesessecesseceseecsseeeseeenees 345 GetLAStETOL A A ane Moree 346 GetRecord COUTO oases I aE ORES 347 1 Eola ai o E E Ripe Se ene aie teens EE EEE 348 MoveFirst MoveLast MoveNext MovePrevious 0oooociocioncoonconnconccnncnnocnnons 349 Und aci 350 IAA EE heise eels ee eet rn ast thst ico Neder glues tata al hee 351 RECOLDAUG aiii 351 AA E O 352 IRECORAM OVE ces casos Bases da Cong as 353 Record Update a stage 354 Introduction Introduction Using This Manual Conventions This Installation Manual contains procedures for installing the Visual eForms Enterprise Server This manual accompanies the Visual eForms Enterprise Server User Manual Admin Manual and Specifications Manual The Visual eForms Designer and ToolBox User Manual provides detailed information on creating forms for use with the Enterprise Server This preface provides an overview of the Visual eForms Enterprise Server Installation Guide explaining conventions used in this manual As you work with Visual eForms Enterprise Server and its manual remember that the text format indicates a specific action or meaning The follo
125. eesecssesesaeeseeeeaees 134 SETPROPERTY ita 135 A TN 136 STRAT cis IA a 137 SEREX ERA CT N ens n E AEN E A A A A E E ETEA O E AT ATES 138 STRINSTR lar oeio oi EOE A 139 SEREEN mt ri 140 SUM A A 141 SUMDATE o iaa E aaa 142 SUMTIME soni 143 TIME A A iras 144 UPPER ciao a anes Aen aid is in 145 AFA R in AA reia 146 Databases EEA TT 147 Database Connectivity A E E ent aoe EE E a E E E 147 Eae t a Ve O e os E EE 147 Alane VAA DIO oia A T O A TT 148 Choosing a Database For Mat 0 ccccccceseesecescesecesceseeeecessensecaeeesecseeaecneenseentees 149 Database Relations ti 150 Database Relations Screen aci ii a iaa da 150 O A pe ere 151 A eteeeraethc Becta vs tease a tetes Beate leche 151 Primary and Secondary Data Source Windows ccccesseeseesceeseeeseeeeneenteeeees 151 Unassigned Colm ia 151 Primary and Secondary Data Sources cscceccesecesceseeeecesceeeeeseeseesaeeseeeseeeeeaees 152 Assigning Database Relations cccecccesseeseesseseeeseeseecsecsceesecneceseceeeesereeneeneeenes 154 Using Database Relations 0 ccceccceesesseesecsseesececeseceeceseeeceseeeeeneeneeeaeeaeeeneeaeeaees 158 Example of code in Visual Basic ccsesccessesscesceseeeeceseeesecseeesecseeeseceenseeneens 158 Advanced Programming cccconnnonccnnnnnanncnnnnnnncnnn rca correr 159 Filler ActiveX Geroren a Peo eee i IG 160 A aeneeash EAE E EE E E ae AE 160 Deal e e ae e 160 EOTMN AO ooo derriten RAEE ATE E 161 EMO a 162
126. eld that user DbIClicks on Signature1 Private Sub MmaFilll_FieldDbIClick ByVal FieldName As String Dim rv Read the data in FieldName If empty Sign else Unsign If VarGetFieldString FieldName lt gt then rv SignForm FieldName 0 Else rv UnsignForm FieldName End If End Sub Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 302 Undo Reverses the last edit in the current field C BOOL CMmaFill Undo Visual Basic form MmaFill Undo None None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 303 UnsignForm Unsigns an already signed Signature field C BOOL CMmarFill UnsignForm LPCTSTR FieldName Visual Basic form UnsignForm FieldName As String As Boolean The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as Field Name Paramater of this method If Lock Fields property of the Signature field is set to TRUE in the Designer UnsignForm will unlock all fields associated with the Signature fields SignForm ValidateForm GetSign
127. ell that the selected object is positioned 3 inches from the Left of the page and 2 inches from the Top of the page It has a Width of 2 inches and a Height of 1 inch Edite Edit 3 000000 2 000000 2 000000 1 000000 gt To position an object by coordinates Enter values in the Left and Top fields These numbers determine where your object is positioned on the form Entering 3 in the field Left and 2 in the field Top makes the top left corner 3 inches from the left and 2 inches from the top Chapter 2 The best B way to align EN two objects or to make them the same size is to use the numerical values in Position or use the alignment and sizing icons Eyeballing doesn t work The a selection 1 YY 300 is comparable to a hairline rule The selection 1 72 is comparable to a 1 point rule Form Design Guide 46 gt To change the object to an exact size Enter values in the Width and Height fields These values determine the size of your object Entering 2 for the Width and Height values create an object 2 inches high and 2 inches wide Appearance Appearance refers to the way the object looks on the page including its colors and outline E Appearance LineThickness 0 006944 BackColor erre LineColor Moooo000 Opaque False RepeatAllPages False TextColor Moooo000 PenStyle Visible True gt To change the thickness of the outline of the object In the LineThic
128. er True Call to this method was Successful False An Error was encountered Following shows how to Enable Addendum Tags for ONLY the LAST_NAME field First Disable ALL Addendum Tags Second Enable Addendum Tag for ONLY the LAST_NAME field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll EnableAddendumTag False rv MmaFilll EnableFieldAddendumTag LAST_ NAME True Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 208 EnableFields Disables or enables overwrite property of all the fields on page PageNum If PageNum is zero then disabling enabling process is applied to all of the fields on all of the pages on the currently loaded form C BOOL CMmafFill EnableFields short PageNum BOOL Enable Visual Basic form MmaFill EnableFields Byval PageNum As Integer Byval Enable As Boolean The following parameters are available Parameter Description PageNum Page number of the form Enable set to True to enable overwrite for fields on page PageNum and False otherwise At the completion of the call to this method the focus will be set to the first field of first page True Call to this method was Successful False An Error was encountered Disable ALL fields on the form Dim rv rv MmaFilll OpenFormDialog rv MmaFilll EnableFields 0 False Disable ALL fields on page 1 of the form Dim rv rv MmaFilll OpenFormDialog rv
129. erName GetSignatureTimestamp True Success False An Error was encountered Add a signature field to your form and name it Signaturel turn the DbIClick Notify property of Signaturel to ON When user DbIClicks into Signaturel I want to do one of 2 operations 1 If Signaturel is empty then I want to Sign 2 If Signaturel is NOT empty i e it is already signed I want to Unsign When user DbIClicks onto the Signaturel field the FieldDbIClick event is called Within the FieldDbIClick event we will perform our operation Note that FieldDb1Click event returns the name of the field that user DbIClicks on 1 e Signature 1 Private Sub MmaFilll_FieldDbIClick ByVal FieldName As String Dim rv Read the data in FieldName If empty Sign else Unsign If VarGetFieldString FieldName lt gt then rv SignForm FieldName 0 Else Chapter 4 Advanced Programming rv UnsignForm FieldName End If End Sub 304 Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 305 ValidateSignature Validates the Digital Signature in the Signature field against the form and the field data associated with that Signature field C BOOL CMmaFill ValidateSignature LPCTSTR FieldName Visual Basic form ValidateSignature FieldName As String As Boolean
130. es you to use more than one data source you can create one gt To create a secondary data source 1 Click the New icon A Secondary Data Source dialog box appears 2 Repeat the same steps to select a secondary data source as you did to select a primary data source The Secondary Data Source window appears Secondary Data Source Field Name Fields 0 Rec Size 0 Assigning Database Relations After designing your form fields use the Database Relations screen to assign the appropriate databases to your form The Unassigned window contains all of the fields in your form that have no assigned relationships to data sources Unassigned Field Nan A B C D E F G H J K L M Chapter 3 Databases 155 gt To assign fields to the primary data source 1 Click a field in the Unassigned column 2 Hold down the mouse button and drag the field to the Primary Data Source window 3 Repeat this process until all of the desired fields are contained in the Primary Data Source window Primary Data Source Fields 2 Rec Size 0 gt To assign fields to the Secondary Data Source 1 Click a field in the Unassigned column 2 Hold down the mouse button and drag the field to the Secondary Data Source window Secondary Data Source 1 Currency2 Date Fields 2 Rec Size 16 3 Repeat this process until all of the desired fields are contained in the Secondary Data Source window
131. eter Description string any valid string expression If string contains Null Null is returned RTRIMO function returns a string LTRIM a Edit1 contains Visual eMerge merges forms and data RTRIM Edit1 Visual eMerge merges forms and data Chapter 2 Function Name Syntax Explanation Parameter Notes See also Examples Where Enter Returns Enter Enter Returns Enter Returns Scripts 132 SEC SEC time Returns the seconds portion of the time from a string containing HH MM SS The following parameters are available Parameter Description time any expression that can represent a time If time contains Null Null is returned SECO function returns a numeric value DATE TIME DAY MONTH YEAR HOUR MINUTE Edit1 contains 10 15 22 Current time is 04 20 33 SEC Edit1 22 If current time is 04 20 33 then SEC TIME returns 33 SsECc 10 15 09 9 if HOUR TIME gt 9 STR HOUR TIME 0 STR HOUR TIME if MINUTE TIME gt 9 STR MINUTE TIME 0 STR MINUTE TIME if SEC TIME gt 9 STR SEC TIME 0 STR SEC TIME 042033 Chapter 2 Function Syntax Explanation Parameter Remarks Return Values Example Scripts 133 SETFIELDDATA SETFIELDFATA FieldName FieldData Sets the value of field FieldName to FieldData The following
132. evel of the current form to enlarged mode which is approximately double the actual form size C BOOL CMmaFill ViewEnlarge Visual Basic form MmaFill ViewEnlarge None None ViewFitSize ViewRealSize ZoomFactor True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Remarks See Also Return Values Advanced Programming 314 ViewFitSides Changes the Zoom level of the current form so that the form is displayed with both sides flush against the form window sides C BOOL CMmafFill ViewFitSides Visual Basic form MmaFill ViewFitSides None None ViewRealSize ViewEnlarge ZoomFactor True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Remarks See Also Return Values Advanced Programming 315 ViewRealSize Changes the Zoom level of the current form so that the form to the actual form size C BOOL CMmarFill ViewRealSize Visual Basic form MmaFill ViewRealSize None None ViewFitSize ViewEnlarge ZoomFactor True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameters Advanced Programming 316 XMLGetFormData Returns an XML encoded data stream in the form of a string containing the Form Data The XML encoded data stre
133. field SSN to round corners Chapter 2 Function Syntax Explanation Parameter Examples Where Enter Returns Enter Returns Enter Returns Scripts 135 SETPROPERTY SETPROPERTY Propertyld Property Values Changes the property of the field that is calling this script The following parameters are available Parameter Description PropertyIDStr One of the following properties vfBackColor vfBottomBorder vfEnabled vfLeftBorder vfLineColor vfMaxFillChar vfPageNumber vfRightBorder vfRoundedBorder vfTextColor vfTopBorder vfVisible A string value 1 or 0 for ON OFF 255 0 255 for setting the RGB color values PropertyVal Salary1 contains 125 000 A contains 1 B contains 5 IF A B gt 4 SETPROPERTY vfBackColor 255 0 0 If adding the contents of A and B returns a number greater than 4 then the background color property of the field is changed to RED IF Salary1 gt 99999 SETPROPERTY vfTextColor 255 0 0 If the content of field Salary1 is greater than 99999 then the font color of the field is changed to RED IF Salary1 gt 99999 SETPROPERTY v TextColor 255 0 0 SETPROPERTY vfBackColor 0 255 0 If the content of field Salary1 is greater than 99999 then change the font color of the field to RED otherwise change the backcolor to GREEN Chapter 2 Function Syntax Explanation Parameter
134. found on the form We have two forms AnyForm far and AddendumForm far We want to open fill and print the AnyForm far We also want to print the excess data that user has typed into the fields of AnyForm far to be printed via our addendum form AddendumForm far for this to happen we add two instance of Visual eForms ActiveX to our Visual Basic project MMAFill Will hold the original form AnyForm far and is accessible to the user AddendumFiller Will house the Addendum form AddendumForm far and is NOT visible to the user Dim rv i FormFieldName As String AddendumFieldName As String Dim AddendumCounter As Integer FieldAddendumText As String Dim FormAddendumText As String Dim PrinterDC TotalPages As Integer Open Form This routine opens AnyForm far You could also use OpenFormDialog to allow user to select and then open a form Chapter 4 Advanced Programming 235 This routine also sets the Overwrite property of all fields in this form to TRUE rv MmaFilll OpenForm App Path amp AnyForm far rv MmaFilll EnableFields 0 True FieldAddenmText holds the addendum for a field in AnyForm FormAddendumText holds the addendum for all fields in the AnyForm FormFieldName name of a field in AnyForm AddendumFieldName name of the addendum field in AddendumForm Print Form This routine prints the original form AnyForm far and then moves the addendum data for all fie
135. fy The Notify properties are referred to as Notify Flags If the Notify Flags for a fillable field are set to True a Notify Message is sent to the Filler application that controls the form Notify is processed only in the application and not in the Filler itself Because the action occurs only in the application nothing can be tested in Preview Mode On the form the only response is true or false For example if the Click Notify Flag for a given field is set to True the Filler application receives a Notify Message when a user clicks into that field gt To change the notify flags 1 N LoS amp Nn an Double click Click to select True or False from the drop down menu e When the user clicks into this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application Double click Modify to select True or False from the drop down menu e When the user modifies this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application Double click DbIClick to select True or False from the drop down menu e When the user double clicks into this field the Notify Message is sent if the Notify flag is set to True e Available in the Filler application Double click GotFocus to select True or False from the drop down menu e When the user s mouse hovers into this field the Notify Message is sent if the Notify flag is set to True e
136. g objects 38 Copy button 9 Creating forms 16 Crosshairs 31 Index 355 Currency object button 7 Cut button 9 D Database connectivity 147 Database format 149 Database relations 150 Database toolbar 151 Date object button 7 Default value creating 55 Defining form setup 17 Deleting objects 38 Digital signature object button 8 Digital signatures 75 77 creating 75 drawing 77 Drawing a fillable object 59 Drawing an object 30 Drop down object button 8 Drop lists 67 E Edit field object button 7 Edit object button 7 Edit properties 52 Editable image object button 8 Editable images 66 Editing text 83 Editing text in an object selecting 83 Editing text in forms 83 Entering text in a form 83 Export 26 Expressions 101 F Fill button 9 Fill character creating 55 Fill font 50 formatting 50 Fill mode 87 Fillable objects 29 Filling forms 87 Finding and replacing text 85 Font format button 10 Fonts resizing 50 selecting fonts 50 style 50 Form design guide 14 Form Properties 24 Form setup 17 Formatting tables 69 FormFlow 26 Functions 96 G Grid displaying 34 Grouping objects 38 H Help and support 2 Help button 9 Horizonal center align button 10 Hour function 113 I If function 121 Image object button 8 Images 65 defining properties 65 Import 26 Installation and setup 3 L Layering overlapping objects 37 Layout See also Form setup Left align button 10 Left function 122 123 124 129
137. ges False TextColor Mooooo0 PenStyle Visible True E Borders Left False Right False Top False Bottom False Rounded False E Margins Chapter 2 Form Design Guide 25 In this properties window you can enter information such as form name description author etc This information helps categorize the form and can be used in many ways Examples Enterprise Server or other tool to develop a forms catalog As part of an document management system for archived retrieval Version tracking Property Description Name Form name Description Form description Version The form version must be set if the form will be used with Visual eFlow Enterprise Server Author Name of the form creator Category Category for the form if applicable keywords o for locating the form in a search Copyright Form copyright year Comments Any form comments IndexFields Selects fields that will be indexed ArchiveFormat The file format for archiving the form AllowContentSearch Allows users to search content TrackHistory Allows users to track form history Modified Date the form was modified or created Width Page width can also be set in Form Setup Height Page height can also be set in Form Setup BackColor Color of the form s background Chapter 2 Form Design Guide 26 Import Export The Import and Export functions allow you to use Designer with other programs FormFlow 1 x and 2 x files can be imported into des
138. gh nine are represented by a different pattern of bars They are commonly found on consumer products and are used especially for inventory control When you first create a bar code object Visual eForms Designer uses the Code 3 of 9 bar code format This bar code is intended for placement only and is overwritten as soon as you specify your own bar code symbology Properties xj Barcode1 Bar Code E Bar Code Code 3 of 9 Full BarwWvidth 0 007639 Ratio 2 5 1 Checksum False CaptionAlign Below center gt To change the properties of a bar code object 1 Ze Open the Properties window Under the Bar Code heading click the drop down menu in the Symbology field to select an option The bars and spaces in each symbol are grouped in such a way to represent a specific ASCII character or function The interpretation of these groups is based on particular sets of rules called symbologies See the following page for a list of bar code symbologies Enter a value in the Bar Width field This is a value indicating the width of the narrowest bar specified in inches Click the drop down menu in the Ratio field to select an option The Ratio sets a value that specifies the wide to narrow bar ratio Click the drop down menu in the Checksum field to select an option This sets a value indicating whether to add a check digit to the bar code Click the drop down menu in the CaptionAlign field to select an option Thi
139. he Update method of the ActiveX is invoked True Call to this method was Successful False An Error was encountered GetLastError on page 344 Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 338 Connect Establishes a connection between a form and its designated Database C BOOL CMmaADOi Connect LPCTSTR FormPath LPDIS PATCH FillerControl LPCTSTR ConnectStr Visual Basic form MmaADOi Connect FormPath As String FillerControl As Object ConnectStr As String The following parameters are available Parameter Description FormPath Full path of the form far file to which Database connectivity is to be established FillerControl Filler ActiveX control in which the form referred to by FormPath will be loaded ConnectStr Used to override the Database Relations parameters set in the Designer To override database for all of the Data Sources assigned to a form use the following syntax Database lt New Value gt For example Database c mydatabases clients mdb To override individual Data Sources prefix the Database keyword with PrimaryDS for the Primary Data Source and SecondaryDS lt gt for the corresponding Secondary Data Source For example PrimaryDS Database c DBs db1 mdb SecondaryDS1 Da tabase c DBs db2 mdb Use this method at application startup time to initiate loading of a form and establish
140. he contents of Windows clipboard into the current form field C BOOL CMmaFill Paste Visual Basic form MmaFill Paste None None True Call to this method was Successful False An Error was encountered Copy the first 5 characters of LAST_NAME field and Paste it into LAST_NAME_2 field Use DisableRedraw to eliminate flickering if any Enable Redraw after the procedure Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DisableRedraw True rv MmaFilll GotoField LAST_NAME rv MmaFilll SetCursorPosition 0 5 rv MmaFilll Copy Q rv MmaFilll GotoField LAST_ NAME 2 rv MmaFilll Paste rv MmaFilll DisableRedraw False Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 268 PrevField Advances the focus to the previous field in the Tabbing Order of the currently loaded form C BOOL CMmafFill PrevField Visual Basic form MmaFill PrevField None None True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 269 Print Prints the currently loaded form with Addendum if any onto the supplied PrinterDevice Context C BOOL CMmarFill Print long printerDC short StartPage short EndPage LPCTSTR Addendum Visual Basic form MmaFill Print Byval printerDC As Long Byval StartPage As I
141. he user to press ENTER in a field in the Filler True enables Multiline False disables it Chapter 2 Overwrite a allows a a user to overwrite the default values that you have assigned Form Design Guide 57 gt To enable overwrite Double click Overwrite or click on the drop down menu to select True or False Overwrite allows a user in the Filler to enter a field and change its value True enables Overwrite False disables Overwrite Note Setting Overwrite to False is useful when you have a fillable object with a pre deter mined value and it is used in a calculation gt To change the tab order By default the first object drawn on the form is at Tab order 1 To change this you must change the tab order 1 Click the drop down menu in the TabOrder field The Tab Order dialog box appears Tab Accessibility Order x Tab Name Pg Button5 1 Button2 1 Button3 1 5 Button4 1 Move To 6 Atty IBP 1 7 AttyFor 1 Set Fill Group 8 County 1 9 plainname 1 Clear Eill Group 10 def name 1 11 casenum 1 12 1 Accessibilit 1 3 B 1 I i Up Down 2 Select the object to be changed and do either of the following e Click either Up or Down depending on the position of the object e Click Move To and enter the position in the New Tab Order field 3 Click the Close button when finished Chapter 2 For more B information N on creating calcula tions see Scripts on pag
142. heck the Enable Crosshair box and select a crosshair color from the drop down menu or it can be left as the default grey color 3 Click the OK button when finished The pointer now includes a vertical and horizontal crosshair Chapter 2 Form Design Guide 32 Positioning Objects By holding B CTRL N while creating a rubberband only the objects that fall within the rubberband are selected Creating an effective form requires the ability to position objects precisely Visual eForms Designer provides you with a variety of tools and guides to help you do this These include a ruler grid and position and align commands Selecting Objects To position objects you must first select those objects gt To select an object Click on the object Or Hold down the mouse button and drag the pointer around or through the object thus creating a rubberband This selects any object touched by the rubberband When you draw or select an object blue boxes surround the outside borders of the object These are referred to as handles The handles reveal the position of the object When an object is selected the pointer is displayed as crosshairs inside the selected object gt To select multiple objects do any of the following e Hold down the SHIFT key and click on the objects e Hold down the mouse button and drag the pointer around or through the objects to rubberband them On the Edit menu click Selec
143. hlight the radio button fields that are mutually exclusive Click Select Fill Group Chapter 2 Form Design Guide 69 Buttons Buttons can execute a script or a macro Scripts are form level functions Scripts are executed internally by the form Scripts just like macros are triggered by a user generated event such as a Double Click Scripts can be built into the form by using Edit Calculation Macros are application level functions Forms do not execute macros instead user generated events such as Click are forwarded to the application to execute the proper macro Macros are built into the application using the development language used by the appliaction Macros can be developed in C Visual Basic JavaScripts VB Scripts Delphi and many more gt To run a script with the button object 1 Open the Properties window 2 Under Edit Calculation write an action script Example ALERT Routing Information Send to district clerk who will match up approval with drawings and send to District Manager r nApproval Information District manager approval is required Note the use of r n within the text to force the information to a new line as returns are not recognized within the script gt To trigger an event using a button object 1 Open the Properties window 2 Use the button object name within your application coding 3 Under the Notify heading double click the appropriate Notify Flag to execute the macro
144. ible can be a lengthy cumbersome and painful task to undertake gt To create a Field to accessibility text association With Visual eForms Designer the Tab Accessibility Order dialog box is used to create all Field to accessibility text associations on the form 1 On the Objects menu click Tab Accessiblity Order The Tab Accessibility Order dialog box appears Tab Accessibility Order Eg Tab Name Pg E 2 Edit12 1 3 Edit13 1 4 Your_first_name_and_initi 1 5 Editl 1 Move To 6 Edit3 1 7 If_a_joint_returm_spouses 1 Set Fill Group 8 Edit2 1 9 Edit4 1 Clear Fill Group 10 Home_address_number_and_s 1 11 Apt no 1 12 City town_or_post_office 1 Accessibility 13 gt Yesi 1 El Pecos Up Down 2 Click the Accessibility button to enable Accessibility mode 3 In the dialog box list select the field for which you want to set up accessibility text The text field is highlighted in the list AND on the form itself Chapter 1 Accessibility 92 4 On your form locate the selected field for which you want to set up accessibility text Move the dialog box if you cannot see the entire form Selecting a field in the dialog box also selects the field on the form as shown below mua are x qe tt 5 Drag the field s from the form and drop it into the Accessibility Tags section of the dialog box The name of the field s appears in the Accessibility Tags section of
145. ield on the Form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName parameter of this method None True Call to this method was Successful False An Error was encountered How much text have I typed into this field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll AppendField LAST_ NAME Add this Text to the end of Last_Name field rv MmaFilll GetFieldLen LAST_ NAME MsgBox LAST_NAME now has 8 rv amp characters in it Chapter 4 Advanced Programming 222 GetFieldLineCount Description Returns the number of lines of text in field FieldName s data Syntax C short CMmaFill GetFieldLineCount LPCTSTR FieldName Visual Basic form MmaFill GetFieldLineCount Byval FieldName As String Parameter The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method Remarks None Return Values True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 223 GetFieldLong Assigns the value of field FieldName to FieldData C BOOL CMmarFill Ge
146. igner Forms created in Designer can be exported as PDF and html files gt To import a FormFlow file 1 On the File menu point to Import and then click FormFlow The Open File dialog box appears 2 Select the appropriate FormFlow file frp and click the Open button The FormFlow file is imported into your Designer document gt To export a form 1 On the File menu point to Export Visual Form Designer Formi File Edit View Page Objects Arrange Window He New Ctrl N R Open Ctri O Close Save Ctrl S Save As Import b Export Print Ctrl P Print Setup The Export dialog box appears Format Dutput HTML File Name ul HASALES1ProposalstH awali Edu 128550 pdf ES E Acrobat E pdf Options PDF Type Filable Accessible y Security Options No Security y Display Settina I Convert non printables V Add Enterprise Server Extensio When 2 Select the output format HTML or PDF B exporting an PQ accessible 3 Name the file and select a location in which to save the form form be sure to select accessible PDF 27 Chapter 2 Form Design Guide gt Exporting to PDF 1 Select the Acrobat button 2 Select the PDF Type one of Flat Form Data Fillable and Fillable Accessible 3 Select the Security Option Default is No Security the PDF Security dialog box appears PDF Security General Editing Comment and Form Field Authoring Fully Allowed y gt
147. ing a connection to its designated Database Note that Connect will fail if the Database Relations file 1 e the file with drf extension which is created by Database Relations facility of the Designer is not in the same directory as the form file i e far file True Call to this method was Successful False An Error was encountered GetLastError Disconnect Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 339 CreateDatabase Create a new instance of the database associated with the form FormPath C BOOL CMmaADOIi CreateDatabase LPCTSTR FormPath LPDISPATCH FillerControl LPCTSTR ConnectStr Visual Basic form MmaADOi CreateDatabase FormPath As String Filler Control As Object ConnectStr As String The following parameters are available Parameter Description FormPath Full path of the form far file to which Database connectivity is to be established FillerControl Filler ActiveX control in which the form referred to by FormPath will be loaded ConnectStr Used to override the Database Relations parameters set in the Designer To override database for all of the Data Sources assigned to a form use the following syntax Database lt New Value gt For example Database c mydatabases clients mdb To override individual Data Sources prefix the Database keyword with PrimaryDS for the Prim
148. ing special objects 32 Selecting tables 32 Set property function 135 Setup 3 Sizing objects 43 Snap to grid using 36 Special properties 59 Spell check button 11 Spell Checking 84 Standard toolbar 9 Straight line object button 7 Strat function 137 138 Strextract function 138 Strinstr function 139 Index 357 Strlen function 140 Sum function 141 System requirements 3 T Tab order of objects changing 53 Table object button 8 Tables 69 Tables defining the properties in 69 Text characters maximum 52 Text font 50 formatting 50 resizing 50 Text justification selecting 49 Text object button 7 Text orientation selecting 48 Text properties 48 Text spacing selecting 48 Time function 142 143 144 Top align button 10 U Undo button 9 Upper function 145 146 Using database relations 158 Vv Vertical center align button 10 Viewing forms 21 Visible outline 45 Visual eForms Designer Installing 3 Starting 5 Z Zoom 21 Zoom page button 10
149. intAbort methods to provide full control over the printing process True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 272 PrintDialog Displays a Print Dialog allowing the user to first select a Printer Destination and then print the currently loaded form based on the Print Dialog settings C BOOL CMmarFill PrintDialog Visual Basic form MmaFill PrintDialog None None True Call to this method was Successful False An Error was encountered Dim rv rv MmaFilll PrintDialog Chapter 4 Description Syntax Parameters Remarks Return Values example Advanced Programming 273 PrintEnd Marks the end of the current Print Job C BOOL CMmarFill PrintEnd Visual Basic form MmaFill PrintEnd None This method is used in conjunction with PrintStart PrintAbort PrintPage and PrintAddendum methods to provide full control over the printing process True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 274 PrintForm Prints the currently loaded form without Addendum onto the supplied PrinterDevice Context C BO
150. kness field click the drop down menu and select a line Each line is labeled in fractions of an inch and determines the width of the border around the object Chapter 2 Form Design Guide 47 gt To change the object s background color 1 Click the drop down menu in the Back Color field 2 Select a color from the Color dialog box and click the OK button Basic colors MT eT a eee ADETE E ITE I ee A A A EEE eee ee EEE E Custom colors S S i i ig g g EEn E Hue 60 Bed Sat fo Green jo Lum fo Blue jo Cancel gt To select a Custom color 1 Click your cursor on a part of the spectrum window 2 Click the arrow in the vertical value selector to indicate the amount of white or black that is mixed with your color 3 The color you have selected will display in the ColorSolid window 4 Adjust the color and value by moving the cursor or the arrow 5 Click OK to select this color for your object gt To change line color Click on the drop down menu in the LineColor field to select a color gt To create opaque objects Double click Opaque or click the drop down menu in the Opaque field to select an option True makes the object opaque False makes the object transparent gt To have the object appear on every page Chapter 2 Form Design Guide 48 Double click Repeat All Pages or click the drop down menu in the Repeat All Pages field to select an option True places
151. l SaveFormData Byval FileName As String Byval Header As String The following parameters are available Parameter Description FileName Name of the Data File Header Header Information to be saved into the Data File Used in conjunction with OpenFormData these two methods provide a simple mechanism for saving and retrieving data entered on a form For simple applications these two methods provide an excellent substitute for an elaborate database as the data repository True Call to this method was Successful False An Error was encountered Dim rv Dim header As String 100 FormsDirectory As String Dim FormsExtension As String header this is optional FormsDirectory this is optional FormsExtension this is optional The following two methods could be used to save form s data to a DAT file rv MmaFilll SaveFormData c test dat header If Not rv Then MsgBox Save Data Failed End If Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 283 SaveFormDataDialog Displays a Save Form Dialog allowing the user to save the data on the currently loaded form into a Form Data File C BOOL CMmarFill SaveFormDataDialog LPCTSTR Header Visual Basic form MmaFill SaveFormDataDialog Byval Header As String The following parameters are available Parameter Description Header Header Information to be saved into the Data File U
152. l over text for the corresponding fields to the user Once this method is called the changes remain in effect for subsequent forms loaded into the control until the next call to this method When this is not invoked the addendum is still there but there is no visual cue on the screen with the text See Addendum True Call to this method was Successful False An Error was encountered Following shows how to Enable Addendum Tags for ONLY the LAST_NAME field First Disable ALL Addendum Tags Second Enable Addendum Tag for ONLY the LAST_NAME field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll EnableAddendumTag False rv MmaFilll EnableFieldAddendumTag LAST_ NAME True Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 206 EnableField Disables or enables overwrite property of the field FieldName C BOOL CMmarFill EnableField LPCTSTR FieldName BOOL Enable Visual Basic form MmaFill EnableField Byval FieldName As String Byval Enable As Boolean The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method Enable set to True to enable overwrite for field FieldName and False otherwise
153. lds to a separate form AddendumForm far GetFirstField Returns the name of the first field in the Tabbing order FormFieldName MmaFilll GetFirstField Print the AnyForm We will ask the user to select a printer using PrintGetDC method PrintGetDC method returns the Device Context DC of the selected printer We then call PrintForm method to print from page 1 to page N of the AnyForm PrinterDC MmaFilll PrintGetDC If PrinterDC 0 Then Exit Sub user selected the CANCEL button Exit TotalPages MmaFilll GetNumPages rv MmaFilll PrintForm PrinterDC 1 TotalPages We will now traverse using GetNextField method through all of the Fillable Fields of AnyForm As we land on each Fillable Field we examine it for addendum data We build an addendum string by adding all of these field based addendum data We will place all addendum data for all fields of AnyForm into Chapter 4 Advanced Programming 236 FormAddendumText Construct the whole addendum text for the AnyForm AddendumCounter 1 FormAddendumText For i 1 To MmaFilll GetFieldCount DoEvents FieldAddendumText MmaFilll VarGetFieldAdden dumText FormFieldName If FieldAddendumText lt gt Then FormAddendumText FormAddendumText amp This is _ Addendum amp AddendumCounter amp Chr 13 amp Chr 10 FormAddendumText FormAddendumText amp FieldAd _ dendumText amp Chr 13 amp Chr 10 amp Chr 13 am
154. lear IV Repeat last mask 10 Click the Add button 11 Click the Operator radio button 12 Select Number and click the Add button twice 13 Repeat this sequence until the Mask field contains the entire Number and Operator sequence for a Social Security Number mask object 14 Click the OK button Chapter 2 If you select a an option on a the drop list for the character you must select Wingdings as the fill font If you define the character as custom you can use any font you want Programati cally the value of on 1 and off 0 or stated another way true 1 and false 0 This is true for check boxes and other objects that have a true false option Form Design Guide 67 Check Boxes Use the Check Box object to create Fill objects that can toggle between two or more different options such as Yes No Undecided On Off True False Correct Incorrect Male Female etc gt To define the properties of the checkbox 1 Open the Properties window 2 Click the drop down menu in the StrOn field under the Edit heading The Check Mark dialog box appears Check Mark x On Character Off Character Empty Character Custom v Space X Space X fx 3 In the On Character section do one of the following e Click the drop down menu to select a character to appear in the check box in the Filler e Select Custom from the drop down menu and enter a character in the field
155. link that provides access from one document to another or from within one document to another place in that same document When you move the mouse over this type of field the cursor changes to a Hand image If you want the text to become blue or underlined you must do this at design time gt To define a URL LinkType 1 Click the drop down menu in the LinkType field under the Edit heading 2 When the object is clicked you must define the correct action e To visit a web page select the Show URL in default browser option and type the URL in the area provided When the user clicks on the the hyperlink field the user s default browser is launched and the web page referenced by is visited To move to another field on the same form select the Goto form field option and type the name of the field in the area provided When the user clicks on the hyperlink field the user s cursor is placed on the field specified If the field does not exist then the hyperlink field will not change focus Chapter 2 Form Design Guide 64 e To handle user click programmatically select the Custom option Then a notify event if one is set is generated for the Filler application to act on xi When clicked Show URL in default browser Cancel Goto form field m Custom Masks A mask formats data to match a standardized predefined format It is useful for fields such as telephone numbers Social Security n
156. list of all available Property IDs and their values Action ID Value Back Color 8 RGB of the Color e g 255 0 0 for Red Line Color 9 RGB of the Color e g 0 255 0 for Green Left Border 10 1 Left Border ON Top Border Right Border Bottom Border Rounded Border Text Color Overwrite 0 Left Border OFF 11 1 Top Border ON 0 Top Border OFF 12 1 Right Border ON 0 Right Border O 13 1 Bottom Border ON 0 Bottom Border O 14 1 Rounded Borders ON 0 Rounded Borders OFF 26 RGB of the Color e g 0 0 255 for Blue 28 1 Overwrite property ON 0 Overwrite property OFF Chapter 4 Remarks Return Values Example Advanced Programming 292 Action ID Value Visible 76 1 if the Field is Visible 0 otherwise NotifyClick 29 1 turn NotifyClick property ON 0 otherwise NotifyModify 30 1 turn Notify Modify property ON 0 otherwise NotifyDblClick 31 1 turn NotifyDbIClick property ON 0 otherwise GotFocus 32 1 turn GotFocus property ON 0 otherwise LostFocus 33 1 turn LostFocus property ON 0 otherwise MouseEnter 34 1 turn MouseEnter property ON 0 otherwise MouseExit 35 1 turn MouseExit property ON 0 otherwise MaxFillChars 27 Set Reset the MaxFillChars property of the field SetFieldProperty can be used to set all fields on a form with the specified new property value by using for the field name parameter True Call to this method was Successful
157. ly decides the manner in which the Field Help displays Form Design Guide 59 gt To create field help Field help allows you to create a message that appears at fill time In order to add Field Help to a field follow these instructions 1 Click the drop down menu in the FieldHelp field 2 When the dialog box appears enter your message in the Field Help Text field Field Help x Field Help Text Enter any names used within 5 Notifications IV Click T GotFocus MV Mouse Enter IV DblClick M Lost Focus Y Mouse Exit T Modify 3 In the Notifications section select actions to execute the help message such as click double click etc 4 Click the OK button when finished Select All Font Chapter 2 If you enter a 2 as the fill FW character the field will be filled with 2 s The best fill character is an underscore Form Design Guide 60 gt To create a fill character 1 Click the drop down menu in the FillChar field 2 When the dialog box appears enter a character to appear in the field while in the Filler 3 Click the OK button gt To view the default value Enter a value in the Default Value field Text entered in this field is displayed as the default value in the Filler Note The Default Value can be overwritten in the Filler if Edit Overwrite is True The find and replace feature does not find text in the Default Value Chapter 2 Form Design Guide 61 Noti
158. m FieldCount rv MmaFilll OpenFormDialog PageNum MmafFilll GetCurrPage FieldCount MmaFilll GetFieldCount MsgBox You are currently on page amp PageNum amp and there are amp FieldCount amp fields on this form Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 214 GetFieldAddendumLen Returns the length of field FieldName s Addendum i e number of characters in Addendum part of field FieldName C short CMmaFill GetFieldAddendumLen LPCTSTR FieldName Visual Basic form MmaFill GetFieldAddendumLen Byval FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method None Short Length of field FieldName s Addendum dim rv rv mmafilll GetFieldAddendumLen Description After this command is executed rv will contain the number of charaters that are placed into the addendum for field Description Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 215 GetFieldAddendumText Assigns Addendum Text of field FieldName to AddendumText C BOOL CMmarFill GetFieldAddendumText
159. maFill SetFocus Visual Basic form MmaFill SetFocus None None True Call to this method was Successful False An Error was encountered Set focus to the form Call MmaFill1 SetFocus Chapter 4 Description Syntax Parameter PropertylD Advanced Programming SetFormProperty 295 Assigns PropertyValue to the form property PropertyID BOOL CMmarFill SetFormProperty long PropertyID C LPCTSTR PropertyValue Visual Basic form MmaFill SetFormProperty Byval PropertyID As Long Byval PropertyValue As String The following parameters are available Parameter Description PropertyID ID of the property whose value is being assigned See below for valid IDs PropertyValue new Property Value being assigned to Property The following Property IDs are available ID Action Value 106 Set Active Field Color RGB of the Color e g 255 0 0 for Red 107 Set Background Color RGB of the Color e g 0 255 0 for Green 108 Set Form Orientation 1 set the Form Orientation to Portrait 0 set the Form Orientation to Landscape 109 Show 1 display Progress Window TCPIP Progress Window 0 do not display Progress Window 115 Allow Content Search ao 116 Track History Aa a 103 Set Form Width Width of the form in inches 104 Set Form Height Height of the form in inches 100 Set Form Name Name property of the form 101 Set Form Description Description property of the form 102 Set F
160. mafill SetFieldProperty PhoneNumber mmafill vfRightBorder 1 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 180 v RoundedBorder ID for Rounded Border property of a field C long GetVfRoundedBorder void SetVfRoundedBorder long Visual Basic form MmaFill vfRoundedBorder Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Rounded Border property of a field Long 14 The following Visual Basic code returns the value of this property Msgbox mmafill VfRoundedBorder returns 14 To set all orders of field PhoneNumber rounded use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 14 1 gt in or gt rv mmafill SetFieldProperty PhoneNumber mmafill VfRoundedBorder 1 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 181 vfSignature Property ID for Signature field C long GetVfSignature void SetVfSignature long Visual Basic form MmaFill vfSignature Must be used with GetFieldProperty to qualify the return value of GetFieldProperty when inquiring about Field type Long 262144 In the following Visual Basic example the type of field Cancel is examined If Cancel is a signature object then do something Var FieldType as String FieldType mmafill GetFieldProperty
161. mater of this method None True Call to this method was Successful False An Error was encountered Add new entries to DROP_LIST field First Clear all entries in DROP_LIST field Second Add new entries Third Display how many entries we have added to the DROP_LIST field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DropListClear DROP_LIST rv MmaFilll DropListAddString DROP_ LIST I am Married Married rv MmaFilll DropListAddString DROP_LIST I am Divorced Married rv MmaFilll DropListAddString DROP_LIST I am Widowed Widowed rv MmaFilll DropListAddString DROP_LIST I am Single Single rv MmaFilll DropListAddString DROP_ LIST I am Separated Separated MsgBox Field DROP_LIST has MmaFilll DropListGetCount DROP_LIST entries Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 201 DropListDeleteString Deletes a string at the zero based index nIndex of DropList field FieldName C long CMmarFill DropListDeleteString LPCTSTR FieldName short nIndex Visual Basic form MmaFill DropListDeleteString Byval FieldName As String Byval nIndex As Integer The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to
162. ms sess ie ses e eae ese tn oa ecese 87 Sticky Notes o ee ea dl l E e aa 88 II O O 88 ACCESSIDIN ity uu ridad 90 Making Forms Accessible icici ence ee eR sti 91 A O 94 Det lls of Scripts ia iaa paisa 96 BUN CHOMS tt cds ae RA Ani Ri dE beis 96 Built in Funct ns it a 98 EEXPFESSIOMS ar E sae cand tesa ech asec RE ied Seaa dee a tebeoete E A ates 101 OPM iii da AE Ea E G 102 KARTTA aA E a o EEE E E E E ETE A 103 Built In Funictons 2 105 ALERT cts E AEE aaa ete aid 105 CELEARDATA ai nai a 106 DATE AAE EEA EEA Ee ias 107 DAY iii 108 DIFEDA TE minnin A A E EO T REA 109 DIFETIME AR 110 GETCURRETE ED ad a tt 111 GETCURRPAGE 00 ia 112 GETFIELDHELP Onr E EE EERE E AE A NAT T E 113 GETFIELDPROPER TV oinin a tine ated nein E a 114 GETNUMPAGES EE aE Ee TEE NE EASA E ar EEE EA Co NTER aA E ET AT 116 GETUNFILLEDMANDATOR ceeessesesesseseescseeeeneeecneeecneecneeeeneescneescneenenees 117 GOTOFTE LD E ENE ENE RE di 118 GOTOPAGE HA A A 119 OUR aaa Sedetvecsen ss 120 TE A AA as 121 Contents 111 LOWER iinta a eke atin eda eta oes 123 LIRA E OE RRE E tases 124 MINUTE unload iia 125 MONTA es isc eg sli oe E EE iets et GUA NII oa Mes es 126 NUM arapen o E E A 127 PRINTDIALOS oona EE EE NRE ORA R E A E 128 RIGHT nearne nsei is io ias 129 ROUND RE A EE E E O E 130 RE RIM aeeiiaii en E e EER ERE EEN EA iets ede R ete 131 ME iaa 132 SETEELDDA TA a e rene E 133 SETFIELDPROPERTY o ceccccccsscsesscsscssescesecsecseescssesecsecsecseesees
163. n 22 Returns the value of the Bottom Margin assigned to the field Line Spacing 23 Returns the Spacing property assigned to a field Advanced Programming 226 Property ID Returns Horizontal 24 Returns the value of the JustHorz property of a Justification field Vertical Justification 25 Returns the value of the JustVert property of a field Text Color 26 String representing the RGB value of the Color e g 0 0 255 for Blue Max Fill Chars 27 Number String representing the Maximum Fillable Characters e g 25 Overwrite 28 1 if the Field is Enabled and 0 otherwise Notify Click 29 Returns 1 if the Click Notify event is ON Otherwise Returns 0 Notify Modify 30 Returns 1 if the Modify Notify event is ON Otherwise Returns 0 Notify DbIClick 31 Returns 1 if the DbIClick Notify event is ON Otherwise Returns 0 Notify Got Focus 32 Returns 1 if the GotFocus Notify event is ON Otherwise Returns 0 Notify Lost Focus 33 Returns 1 if the LostFocus Notify event is ON Otherwise Returns 0 Notify Mouse Enter 34 Returns 1 if the MouseEnter Notify event is ON Otherwise Returns 0 Notify Mouse Exit 35 Returns 1 if the MouseExit Notify event is ON Otherwise Returns 0 TAB Order 36 Returns the value of the TabOrder property of a field ON String 37 Returns the value of the StrOn property of a CheckBox field OFF String 38 Returns the value of the StrOff property of a Che
164. ng 174 vfLeftBorder ID for Left Border property of a field C long GetVfLeftBorder void SetVfLeftBorder long Visual Basic form MmaFill vfLeftBorder Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Left Border of a field Long 10 The following Visual Basic code returns the value of this property Msgbox mmafill vfLeftBorder returns 10 To turn ON the left border of field PhoneNumber use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 10 1 gt ines or a rv mmafill SetFieldProperty PhoneNumber mmafill vfLeftBorder 1 Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 175 v LineColor ID for Line Color property of a field C long GetVfLineColor void SetVfLineColor long Visual Basic form MmaFill vfLineColor Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Line Color of a field Long The following Visual Basic code returns the value of this property Msgbox mmafill vfLineColor returns 9 To turn the border color of field PhoneNumber to GREEN use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 9 0 255 0 or rv mmafill SetFieldProperty PhoneNumber mmafill vfLineColor 0 255 0 Chapter 4 Description Syntax Remarks Data Type Property ID Exampl
165. nteger Byval EndPage As Integer Byval Addendum As String The following parameters are available Parameter Description printerDC Printer Device Context StartPage Starting page to be printed EndPage Ending page to be printed Addendum Addendum Header to be printed on Addendum pages None True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 270 PrintAbort Aborts the current Print Job C BOOL CMmarFill PrintAbort Visual Basic form MmaFill PrintAbort None This method is used in conjunction with PrintStart PrintEnd PrintPage and PrintAddendum methods to provide full control over the printing process True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 271 PrintAddendum Prints the Addendum in the current Print Job C BOOL CMmarFill PrintAddendum LPCTSTR Addendum Visual Basic form MmaFill PrintAddendum Byval Addendum As String The following parameters are available Parameter Description Addendum Addendum Header to be printed on Addendum pages This method is used in conjunction with PrintStart PrintEnd PrintPage and Pr
166. nto FormAddendumText Construct the whole addendum text for the AnyForm AddendumCounter 1 FormAddendumText For i 1 To MmaFilll GetFieldCount DoEvents FieldAddendumText MmaFilll VarGetFieldAdden dumText FormFieldName If FieldAddendumText lt gt Then FormAddendumText FormAddendumText amp This is _ Addendum amp AddendumCounter amp Chr 13 amp Chr 10 FormAddendumText FormAddendumText amp FieldAd _ dendumText amp Chr 13 amp Chr 10 amp Chr 13 amp Chr 10 AddendumCounter AddendumCounter 1 End If FormFieldName MmaFilll GetNextField Next 1 We now have traversed through all the Fillable fields It is time to print the AddendumForm We collect all addendum text for all fields of AnyForm and then paste amp print it into the AddendumForm one chunk at a time until all Addendum data is processed properly y Open the Addendum form into a separate container Chapter 4 Advanced Programming 218 another instance of Filler component Set the Addendum Tag for all fields of this form to FASLE rv AddendumFiller OpenForm App Path amp AddendumForm far rv AddendumFiller EnableAddendumTag False VarGetCurrField returns the name of the field that has the focus 1 e the addendum field AddendumFieldName AddendumFiller VarGetCurrField 1 Paste the addendum text we collected from AnyForm into the AddendumForm 2 Print the form 3 Check to see if
167. nts FieldClick Occurs when the user presses and then releases a mouse button over a form field C afx_msg void OnFieldClickMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldClick Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify Click property of the desired Form Field to True for the FieldClick event to occur for that Form Field Chapter 4 Description Syntax Parameter Remarks Advanced Programming 322 FieldDbIClick Occurs when the user presses and then releases a mouse button and then presses and releases it again over a form field C afx_msg void OnFieldDbIClickMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldDbIClick Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify DbIClick property of the desired Form Field to True for the FieldDbIClick event to occur for that Form Field Chapter 4 Description Syntax Parameter Remarks Advanced Programming 323 FieldModified Occurs when the user leaves a form field that has been modified C afx_msg void OnFieldModifiedMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldModified Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must
168. odify existing forms in the Visual eForms Designer gt To open an existing form On the File menu select Open Or Click the Open icon on the Standard toolbar 1 Specify the drive and directory location of the form Ce a Look in E My Computer e O ex EJ Home on Mmaserv_nt40 H 2 Apps on Mmaserv_nt40 P 2 Administrator on Mmaserv_nt4t Old_nw41 on Mmaserv_nt40 G EJ Files of type FAR Files far y Cancel File name 2 Locate the file that you want to open and select it in the Open dialog box Look in a Sample Forms Ej ex 2 AA00400H far Wn129 far 4 Kq003719 far 1 Agreement far E Kq01040d far E P3740 far LA Vn130 far Dapw15 far A Kq01045d far 7 P4664 far E n131 far Dapwl5a far J P3611 far E P4667 far A vn132 far Fer603 far 7 P3632 far E Sched l far A vn133 far J4110 far A P3667 far SA Sched far gt Files of type FAR Files tar gt _ Cancel y Je The file name appears in the File name field File name 3 Click the Open icon The form appears in the designer window Chapter 2 Form Design Guide 16 New Forms A form is an arrangement of objects on a page Designing a new form involves defining the following e Form setup Size Margins and Orientation of the form e Drawing the outline of the objects Box Line or Button e Defining the object s appearance Borders or no Borders
169. ods provide a simple mechanism for saving and retrieving data entered on a form For simple applications these two methods provide an excellent substitute for an elaborate database as the data repository String The Header information stored in the Form Data File Null Failure occured OpenFormData on page 261 Dim rv Dim FormsDirectory As String Dim FormsExtension As String FormsDirectory this is optional FormsExtension this is optional User must first Open the Form filename far before opening the data c test dat file rv MmaFilll VarOpenFormData c test dat FormsDirectory FormsEx tension Chapter 4 Advanced Programming If rv Then MsgBox Open Data Failed Possible Problems are amp Chr 10 amp Chr 13 amp 1 Form is not open End If 311 Advanced Programming 312 Chapter 4 Description Syntax Parameters Remarks See Also Return Values VarOpenFormDataDialog Displays a dialog allowing the user to select a Form Data File to be opened in the ActiveX Control C CString CMmaFill VarOpenFormDataDialog Visual Basic form MmaFill VarOpenFormDataDialog None None OpenFormDataDialog on page 263 String The Header information stored in the Form Data File Chapter 4 Description Syntax Parameters Remarks See Also Return Values Advanced Programming 313 ViewEnlarge Changes the Zoom l
170. oints In the Effect section click the Underline checkbox if you want underlined text 8 Click the OK button when finished Chapter 2 A Font icon Form Design Guide 54 gt To select fill font 1 Click the drop down menu in the FillFont field The Font dialog box appears 2 Complete FillFont values as you completed TextFont values Note While in the Filler user can change the Fill Font Simply right click on a field and select Font from the drop list Paste Delete Select All Help Mixed Fonts After you have created an object and added text you can then mix fonts to add style and emphasis For example if you d like to emphasize a point you could display text as shown here Sign your name last name first In this example last is a larger font italicized and bold gt To mix fonts 1 Select the text you wish to modify and then click the Font icon on the Standard toolbar 2 In the Font dialog box make any modifications necessary 3 When finished click the OK button You may repeat this process as often as you d like with any text Note You can mix fonts in this manner You cannot mix text colors in this manner All text colors within one field must be the same RTL RTL stands for Right to Left Some languages such as Arabic are read right to left gt To select Right to Left reading Chapter 2 Form Design Guide 55 Double click RTL or click the
171. on and drag to draw the object on the form 4 When the object is the size you want release the mouse The outline of the Digital Signature object is displayed in the form window gt To associate form fields to a digital signature object Your electronic signature approves data contained in certain fields on the form Therefore you need to specify which fields on the form your signature will approve To do this you must assign one or more fields to the signature field 1 Open the Properties window 2 Under the Signature heading click the drop down menu in the Type field to select an option 3 Click the Mode drop down menu to select an option Available options are Text and Enhanced e If Text is selected the signature field places the name of the signer into the signature field when the field is signed If Enhanced is selected the signature field places a signature certificate into the signature field when the field is signed REQUESTOR APPROVAL DELEGATED O VerSign het 0U m a OU wa ue ris a mA Ret LIQ8 LTO SF OL OU Dighal ID Class 1 a CN Pillip Y E pbilit Signature Valid 01 26200 10 18 35 AM Enhanced mode produces a Signature Certificate Rich Text Objects Rich text objects allow the user while in the Filler to change Fill Font attributes for one or more characters in the field This object type should be used sparingly as it adds a large amount of overhead to XML data In contrast
172. on visible use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 76 0 or n rv mmafill SetFieldProperty PhoneNumber mmafill vfVisible 0 To make field PhoneNumber visible use this Visual Basic code rv mmafill SetFieldProperty PhoneNumber 76 1 gt e Or rv mmafill SetFieldProperty PhoneNumber mmafill vfVisible 1 Chapter 4 Description Syntax Remarks Example Advanced Programming 186 ZoomFactor Gets or sets the Zoom value for the currently loaded form C short CMmaFill GetZoomFactor void CMmaFill SetZoomFactor LPCTSTR ZoomFactor Visual Basic form MmaFill ZoomFactor The following settings are available for ZoomFactor Setting Constant Description 1 Whole Page View the entire page in the window 2 Page Width View the entire page width in the window 3 to 400 Set the Zoom Factor to the specified percentage 3 to 400 The following Visual Basic code sets the Zoom level for the form to 100 mmafill ZoomFactor 100 Advanced Programming 187 Chapter 4 Description Syntax Parameters Remarks Return Values Methods AbandonChanges Resets the internal Modified Flag of the currently loaded form to False C BOOL CMmaFill AbandonChanges Visual Basic form MmaFill AbandonChanges None Use this method in conjunction with IsFormChanged method to notify the user regarding unsaved ch
173. orm Version Version of the form used by version control facility of Visual eForms Enterprise Server 112 Set Author Set to the name of the person who designed the form Chapter 4 Remarks Return Values Example Advanced Programming 296 ID Action Value 113 Set Category Assign a category to the form 114 Set Search Keywords Comma delimited list of keywords used by search facility of Visual eForms Enterprise Server 117 Set Copyright Copyright clause to be added to the form 118 Set Comments Comments of the designer 119 Index Fields Comma delimited list of fields used by the archiver facility of Visual eForms Enterprise Server 120 Set the Archive Format File format used by the archiver facility of Visual eForms Enterprise Server None True Call to this method was Successful False An Error was encountered Set Active Field color to RED Dim rv rv MmaFilll SetFormProperty 106 255 0 0 Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 297 SetNotifyOnCalc Modifies the default behavior of the ActiveX Control on performing form level calculations If Notify is set to True instead of doing the calculations at the form level only a NotificationEvent is sent to the holder of the Control C BOOL CMmarFill SetNotifyOnCalc BOOL Notify Visual Basic form MmaFill SetNotifyOnCalc Byval Notify As Boolean The following parameters ar
174. ountered Dim rv Dim header As String 100 FormsDirectory As String Dim FormsExtension As String header this is optional FormsDirectory this is optional FormsExtension this is optional User must first Open the Form filename far before opening the data c test dat file rv MmaFilll OpenFormData c test dat FormsDirectory FormsExtension header Chapter 4 Advanced Programming If Not rv Then MsgBox Open Data Failed Possible Problems are amp Chr 10 amp Chr 13 amp 1 Form is not open End If 262 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 263 OpenFormDataDialog Displays an Open Form Data Dialog allowing the user to select a Form Data File to be opened in the ActiveX Control C BOOL CMmaFill OpenFormDataDialog BSTR FAR Header Visual Basic form MmaFill OpenFormDataDialog Header As String None None True Call to this method was Successful False An Error was encountered or the User pushed the Cancel button of the Dialog Dim rv Dim header As String 100 FormsDirectory As String Dim FormsExtension As String header this is optional FormsDirectory this is optional FormsExtension this is optional User must first Open the Form filename far before opening the data filename dat file rv MmaFilll OpenFormDataDialog header If Not rv Then MsgB
175. ox Open Data Failed Possible Problems are amp Chr 10 amp Chr 13 amp 1 Form is not open End If Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 264 OpenFormDialog Displays an Open Form Dialog allowing the user to select a Form File to be opened in the ActiveX Control C BOOL CMmaFill OpenFormDialog Visual Basic form MmaFill OpenFormDialog None None True Call to this method was Successful False An Error was encountered or the User pushed the Cancel button of the Dialog Display the Open a Form Dialog box so that user can select and open a form Dim rv rv MmaFilll OpenFormDialog Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 265 OpenFormPasswordDecrypt Opens the form using the password specified The filler will automatically prompt the user for the password to decrypt the file Provides support for password based encryption decryption of forms at runtime C BOOL CMmarFill OpenFormPasswordDecrypt LPCTSTR FileName LPCTSTR Password Visual Basic form MmaFill OpenFormPasswordDecrypt FileName As String Password As String As Boolean The following parameters are available Parameter Description FileName Full Pathname or URL address of the Data File Password Password used to Encrypt the file using the SaveFormPasswordEncrypt call This
176. p Chr 10 AddendumCounter AddendumCounter 1 End If FormFieldName MmaFilll GetNextField Next 1 We now have traversed through all the Fillable fields It is time to print the AddendumForm We collect all addendum text for all fields of AnyForm and then paste amp print it into the AddendumForm one chunk at a time until all Addendum data is processed properly f t Open the Addendum form into a separate container another instance of Filler component Set the Addendum Tag for all fields of this form to FASLE rv AddendumFiller OpenForm App Path amp AddendumForm far rv AddendumFiller EnableAddendumTag False Chapter 4 Advanced Programming 237 VarGetCurrField returns the name of the field that has the focus 1 e the addendum field AddendumFieldName AddendumFiller VarGetCurrField 1 Paste the addendum text we collected from AnyForm into the AddendumForm 2 Print the form 3 Check to see if there is any more addendum text left 4 if so then go to step 1 5 continue until all addendum text is processed and printed If FormAddendumText lt gt Then Do DoEvents rv AddendumFiller SetFieldData Addendum FiledName FormAd _ dendumText rv AddendumFiller PrintForm PrinterDC 1 Addendum _ Filler GetNumPages FormAddendumText AddendumFiller VarGetField _ AddendumText AddendumFiledName Loop Until FormAddendumText End If NOTE Always FREE the Device Con
177. parameters are available Parameter Description FieldName Name of the Form Field FieldData New Data for field FieldName None None SETFIELDDATA Currency1 1234 56 This example will put 1234 56 into the Currency1 field SETFIELDDATA Currency1 This is a joke This example will try to put This is a joke into the Currency1 field but fails because Currency1 is a Numeric field The value of Currencyl is set to 0 Chapter 2 Function Syntax Explanation Parameter Remarks Return Values Example Scripts 134 SETFIELDPROPERTY SETFIELDPROPERTY FieldName PropertyID Property Val Make changes to the properties of a field one property at a time The following parameters are available Parameter Description FieldStr Name of the field on the form PropertyIDStr One of the following properties vfBackColor vfBottomBorder vfEnabled vfLeftBorder vfLineColor vfMaxFillChar vfPageNumber vfRightBorder vfRoundedBorder vfTextColor vfTopBorder vfVisible PropertyVal A string value 1 or 0 for ON OFF 255 0 255 for setting the RGB color values None SETFIELDPROPERTY SSN vfVisible 0 Make the field SSN invisible SETFIELDPROPERTY SSN vfBackColor 255 0 0 sets the background color of field SSN to RED SETFIELDPROPERTY SSN vfRoundedBorder 1 changes the corner borders of
178. property of all fields in this form to TRUE rv MmaFilll OpenForm App Path amp AnyForm far rv MmaFilll EnableFields 0 True FieldAddenmText holds the addendum for a field in AnyForm FormAddendumText holds the addendum for all fields in the AnyForm FormFieldName name of a field in AnyForm AddendumFieldName name of the addendum field in AddendumForm Print Form This routine prints the original form AnyForm far and then moves the addendum data for all fields to a separate form AddendumForm far GetFirstField Returns the name of the first field in the Tabbing order y FormFieldName MmaFilll GetFirstField Print the AnyForm We will ask the user to select a printer using PrintGetDC method PrintGetDC method returns the Device Context DC of the selected printer We then call PrintForm method to print from page 1 to page N of the AnyForm PrinterDC MmaFill1 PrintGetDC If PrinterDC 0 Then Exit Sub user selected the CANCEL button Exit TotalPages MmaFilll GetNumPages rv MmaFilll PrintForm PrinterDC 1 TotalPages Chapter 4 Advanced Programming 217 We will now traverse using GetNextField method through all of the Fillable Fields of AnyForm As we land on each Fillable Field we examine it for addendum data We build an addendum string by adding all of these field based addendum data We will place all addendum data for all fields of AnyForm i
179. r ease of programming and integration with popular programming environments such as Visual Basic Visual C Delphi PowerBuilder and Lotus Notes In general Visual eForms Filler ActiveX control can be integrated into any 32 bit Windows application which can act as an ActiveX Control Container ActiveX control can also be integrated into HTML to empower and add additional functionality to it This very important capability enables you to develop powerful Web based applications using Cerenade s Filler Control Sample codes provided in this chapter are written in Visual Basic An understanding of Visual Basic or a similar programming language is necessary to understand the methods discussed in this chapter In all functions where FieldName can be used you can replace the FieldName with the TAB ORDER of the field if known You would then put a character in fron of it Examples GotoField 12 which takes you to the field that is on Tab Order 12 or e GotoField SSN which takes you to the field that is named SSN Note that if is missing the function will act on a field that is named 12 which can produce different results This section contains the lists of all Visual eForms properties and methods built around Filler ActiveX Chapter 4 Filler Active X Description Syntax Remarks Data Type Advanced Programming 160 Properties DefaultPath Gets or sets the Default Path associated with the
180. r set to an empty string 1 e Once this method is called the changes remain in effect for subsequent forms loaded into the control until the next call to this method Call this method before printing You can call this method once If called more than once ONLY the last call takes effect Advanced Programming 259 Chapter 4 Return Values Example True Call to this method was Successful False An Error was encountered Dim rv Open a form rv MmaFilll OpenFormDialog Add a DEMO watermark with the following characteristics X position 4 4x1440 twips Y position 4 4x1440 twips Font Type Times New Roman or Arial Font Height 1 1x1440 twips Angle 45 Degrees 45x0 1 increments Bold Italic and Underline characters Color Green RGB value 0 255 0 f rv MmaFilll OnPrintText DEMO 4 1440 4 1440 times new roman 1 1440 450 True True True RGB 0 255 0 rv MmaFilll PrintDialog End Sub Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 260 OpenForm Opens a Form File and displays it in the ActiveX control C BOOL CMmarFill OpenForm LPCTSTR FileName Visual Basic form MmaFill OpenForm Byval FileName As String The following parameters are available Parameter Description FileName Full Pathname or URL address of the Form File This method can be used to open forms either from the
181. rFill GetFieldHelp LPCTSTR FieldName BSTR FAR FieldHelp Visual Basic form MmaFill GetFieldHelp Byval FieldName As String FieldHelp As String The following parameters are available Parameter Description Field Name Name of the Form Field FieldHelp Holder for Help Text of field FieldName Help Text for form fields are set at Design time by assiging appropriate text to Edit FieldHelp property of form fields VarGetFieldHelp True Call to this method was Successful False An Error was encountered Display the FieldHelp for the field that the user is in now Two methods can be used GetFieldHelp and VarGetFieldHelp Dim rv Dim FieldHelp As String 256 Dim CurrentField As String rv MmaFilll OpenFormDialog CurrentField MmarFilll VarGetCurrField rv MmaFilll GetFieldHelp CurrentField FieldHelp MsgBox FieldHelp is using methid 1 amp RTrim FieldHelp MsgBox FieldHelp is using methid 2 amp MmaFilll VarGetFieldHelp Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 221 GetFieldLen Returns the length of field FieldName s data i e number of characters entered into field FieldName C short CMmaFill GetFieldLen LPCTSTR FieldName Visual Basic form MmaFill GetFieldLen Byval FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList F
182. rSeluniin ce eterna it eh ein did a aid SRR RR 204 EnableAddendumTag 0 ccceecceseesecesceseeeeceseeseceseeseeeecesseeeecseecaeceeeaeeneeneeeneees 205 Enabled O AR cie 206 EnableFieldAddendumTag 0 cccceccsccesessecescesecesceeeeeceseeeeecaeeeseceeeaeeeenseeneens 207 Enabled a e e e cl ed 208 MEU AE 209 DER WED sts 0B en a A n a N a 211 GETS A EE A 212 Getur Pape iaa iaa di olaa db 213 GetFieldAddendumLen ccccccccccssccssesesccssscecseceeecseceseeseeeeseceeeecssesesaeensees 214 GetFieldAddendumT ti A doce ea 215 GretB1eld GOunty foes iii 219 ETA ETA is E E E S A E kn Pe A AA a EE 220 EA AAA EERE TEE AE IEA E A tates das 221 Crethicl dmca a a n A E E E 222 A T E needed 223 GetFieldProperty tucan tdo S hoes 224 a EAE N Rucetinote 233 GetFieldFext Width a and 234 GetFifstEie ld tana A T E RT AE R EE 235 GetForm Path ariar a tada 239 Y assess ee aces Sada sac EE thane O NN 240 AECI A ie I ir Ia 242 GeNeRaL e o 243 Contents 4 GetNUMP ari hedesteasteensavunecuens couvetraveniate aves 244 GetSignatureTimestamp 0 ccccccccseescescecsecscecseceseesececeseceeeeeeeeeseeeeeeseeeseeseenaees 245 GetSignerName ca Shahid eek a Naa As 246 GetUnfilled Mandatory o cc eccescecsccesecseceseeseceeceeceeceeeeeceseeeeecseeeseceesseeeenseensee 247 GetV CISION 3 5555s cere ae eto ee Se 248 GotoField da eek eee 249 GotoFieldByTabOrder 02000 detest tec RAN eis hai Shei dah 250 GOLOP RS O ANT 251 HighliehtFields A ned eee a
183. s Do not include spaces before or after the pipe symbol because these spaces will be displayed with the description and filter values The following code shows an example of a filter that enables the user to select text files or graphic files that include bitmaps and icons Text txt txt Pictures bmp ico bmp icol Chapter 4 Example Advanced Programming 210 When you specify more than one filter for a dialog box use the Filter Index property to determine which filter is displayed as the default Note that terminates the Filter string Open a form using the Generic FileDialog method First Use FileDialog to get the name of the form Second Use OpenForm to the actual opening of the form Dim FileName As String Dim rv FileName FormFiller FileDialog True Visual eForms far far Data Files dat dat AIl INITIALDIR c temp TITLE My Title rv MmaFilll OpenForm FileName Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 211 FillTestData Fills all the fields on the currently loaded form with test data C BOOL CMmarFill FillTestData Visual Basic form MmaFill FillTestData None This method could be used to examine evaluate the look and feel of a filled form True Call to this method was Successful False An Error was encountered First Fill form fields with test data
184. s Visual eForms Designer supports the following Action Scripts handlers OnClick OnDbIClick OnModify OnGotFocus OnLost Focus OnMouseEnter and OnMouseLeave For example the form designer can effect the display of a Hello World message whenever field A is clicked with the following OnClick Handler Alert Hello World A Button1 Button MaxFillChars 0 Auto Tab False Mandatory False Multiline True Overwrite False NoAddendum False TabOrder 1 Calculation Validation OnClick ALERT GETFIELDHELPCphone OnDblClick OnModify OnGotFocus OnLostFocus OnMouseEnter OnMouseLeave FieldHelp FillChar None Default Value Chapter 2 Scripts 96 Details of Scripts Each script has three parts e The function determines what the script does such as ROUND or NUM NUM Edit1 NUM Edit2 NUM Edit3 e The expression determines the values or fields used in the script NUM Edit1 NUM Edit2 NUM Edit3 e An operator determines how expressions and functions interact with each other NUM Edit1 NUM Edit2 NUM Edit3 Functions A function is a formula for a specific kind of script The functions make it quicker and easier to create scripts For example if you need to add a column of numbers like the one below you could write a script like this Cost 1 Cost 2 Cost 3 Cost 4 Cost 5 Cost 6 Rather than enter a lengthy script you can use the SUM function to achieve the same re
185. s sets a value indicating the location of the caption characters relative to the bar code Off Below Left Below Center Below Right Above Left Above Center or Above Right Chapter 2 Form Design Guide 79 Bar Code Symbologies Code 3 of 9 Full 90301 3045 e Interleave 2 of 5 e Codabar e MSI Code 93 Full ASCII Set e UPC A e UPCE e PostNet bhh bhnth hanah hhh hl 90301 3045 EAN JAN 88 EAN JAN 13 Code 128 Standard Code 3 of 9 90301 3045 Note Edit Default Value Property is used for bar codes with pre defined values If Default Value is empty the value can be entered by the user or come from the form scripts or application macros If you select a value in conflict with the Symbology this message appears Barcode value contains invalid characters for current symbology Chapter 2 Form Design Guide 80 Digital Signatures A digital signature is used when you want to distribute a form and enable the recipient s to authenticate your identity the signer of the form It can also be used to ensure that the original content of the form is unchanged Additional benefits of the use of a digital signature are that it is easily transportable can be time stamped cannot be easily repudiated or imitated by someone else To ensure form and data integrity use several features of Visual e Forms in combination Protect the form design by using the password feature in Form Setup Protect the
186. s the data entered into the form and blanks out the form NONE Clear data in the form CLEARDATA Chapter 2 Function Syntax Explanation Notes See also Example Where Enter Returns Enter Returns Scripts 106 DATE DATE Returns the current system date in MM DD Y Y Y Y format e DATE returns a string e DATEO is an automatic script The value of the field will automatically be set to today s date e DATE returns a string and therefore the field where a call to DATE takes place must be an EDIT object e DATE returns zero if called from a NUMBER object TIME DAY MONTH YEAR HOUR MINUTE SEC Extract the month portion of today s date STREXTRACT STR DATE 0 2 Display today s date ALERT DATE Assume that today is November 18 2004 STREXTRACT STR DATE 0 2 11 ALERT DATE The above script displays today s date Alert ES 11 18 2004 Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Enter Returns Scripts 107 DAY DAY DateExpr Returns a whole number between 1 and 31 inclusive representing the day of the month The following parameters are available Parameter Description DateExpr any expression that can represent a date If date contains Null Null is returned DateExpr is formatted as MM DD YYYY DAY function returns a numeric
187. sed in conjunction with OpenFormDataDialog these two methods provide a simple mechanism for saving and retrieving data entered on a form For simple applications these two methods provide an excellent substitute for an elaborate database as the data repository True Call to this method was Successful False An Error was encountered or the User pushed the Cancel button of the Dialog Dim rv Dim header As String 100 FormsDirectory As String Dim FormsExtension As String header this is optional FormsDirectory this is optional FormsExtension this is optional The following two methods could be used to save form s data to a DAT file rv MmaFilll SaveFormDataDialog header If Not rv Then MsgBox Save Data Failed End If Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 284 SaveFormDialog Displays a Save Form Dialog allowing the user to package the currently loaded form and data entered on the form into a new Form File C BOOL CMmaFill SaveFormDialog Visual Basic form MmaFill SaveFormDialog None None True Call to this method was Successful False An Error was encountered or the User pushed the Cancel button of the Dialog Dim rv rv MmaFilll SaveFormDialog Chapter 4 Description Syntax Parameters Remarks Return Values See Also Advanced Programming 285 SaveFormPasswordEncrypt Saves the
188. senting the RGB value of the Color e g 0 255 0 for Green Orientation 108 1 if the Form Orientation is Portrait 0 if the Form Orientation is Landscape TCPIP 109 1 if the Progress Window is to be displayed 0 Progress Window otherwise Allow Content Search 115 a Track History 116 1 Form Width 103 Width of the form in inches Form Height 104 Height of the form in inches Form Name 100 Get the Name property of the form Form Version 102 Get version of the form Author 112 Get the name of the person who designed the form Category 113 Get the category to the form Search Keywords 114 Get a comma delimited list of keywords included in the Search Keyword property of the form Copyright 117 Get the Copyright clause of the form Comments 118 Get Comments of the designer Chapter 4 Advanced Programming 240 Property ID Returns Index Fields 119 Get a Comma delimited list of fields included in the Index Fields property of the form Archive Format 120 Get the file format used by the archiver facility of Visual eForms Enterprise Server Chapter 4 Description Syntax Parameters Remarks Return Values Advanced Programming 241 GetFormWindow Returns the handle of the form window in the ActiveX Control C long CMmarFill GetFormWindow Visual Basic form MmaFill GetFormWindow None None True Call to this method was Successful False An Error was encountered Ch
189. set the Notify Modify property of the desired Form Field to True for the FieldModified event to occur for that Form Field Chapter 4 Description Syntax Parameter Remarks Advanced Programming 324 FieldGotFocus Occurs when the user sets the focus to a form field C afx_msg void OnFieldGotFocusMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldGotFocus Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify GotFocus property of the desired Form Field to True for the FieldGotFocus event to occur for that Form Field Chapter 4 Description Syntax Parameter Remarks Advanced Programming 325 FieldLostFocus Occurs when the user leaves a form field C afx_msg void OnFieldLostFocusMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill_FieldLostFocus Byval FieldName As String The following parameters are available Parameter Description FieldName Name of the Form Field You must set the Notify LostFocus property of the desired Form Field to True for the FieldLostFocus event to occur Chapter 4 Description Syntax Parameter Remarks Advanced Programming 326 FieldMouseEnter Occurs when the user moves the mouse over and into a form field C afx_msg void OnFieldMouseEnterMmaFill LPCTSTR FieldName Visual Basic Sub MmaFill FieldMouseEnter Byval FieldName As String Th
190. set vertical which positions the copy a specified distance from the top edge of the original object If more than one duplicate is specified subse quent copies are placed the same distance from the top edge of the previous copy Duplicate Copies Position C Next to Below Offset Horizontal 19 5 inches Vertical 0 5 inches gt To delete an object 1 Select the object 2 On the Edit menu select Delete or press the Delete key on your keyboard gt To group objects 1 Select the objects 2 On the Objects menu select Make Group gt To break a group of objects 1 Select the group of objects 2 On the Objects menu select Break Group gt To convert an object into another type of object 1 Select the object 2 On the Edit menu click Convert 3 Click the radio button that corresponds to the desired object 4 Click the OK button Chapter 2 Form Design Guide 40 Creating an Object Library An object library is a collection of form objects that you have created and want to use repeatedly This can be an individual field or a group of fields The desired objects are placed into the Object Library by drag and drop You can give each object a name You can scroll through the objects in the library and then copy them to your form gt To add form objects to the Object Library 1 Create the object 2 On the Objects menu click Object Library 3 Click on the object you want to add to the Object
191. sk property of a Mask field User Modify 71 Returns 1 if the UserModify property of a Bar Code field is TRUE Otherwise Returns 0 List Height 72 Returns the ListHeight property of a Drop List field List Width 73 Returns the ListWidth property of a Drop List field List Choice 74 Returns a list of choices values assigned to the List property of a Drop List field Embeded 75 Returns 1 if the Embedded property of an Image field is TRUE Otherwise Returns 0 Visible 76 1 if the Field is Visible and 0 otherwise Signature Type 77 Returns the value assigned to Type property of a Signature field Signature Mode 78 Returns the value assigned to Mode property of a Signature field Signature Dependant 79 Returns the list of fields assigned to Form Fields Fields property of a Signature field Signature Lock 80 Returns 1 if the Lock Fields property of a Fields Signature field is TRUE Otherwise returns 0 Chapter 4 Example Advanced Programming 230 What are the properties of this field NOTE if NONE of the objects on the form are Enabled overwrite true then the GetFieldProperty routine will fail Dim rv On Error Resume Next rv MmaFilll OpenFormDialog what is the background color of the field in focus rv MmaFilll GetFieldProperty MmaFilll VarGetCurrField MmaFilll vfBack Color MsgBox The RGB value of the BackColor is amp rv what type of object is the field that has the focus
192. ss 12 as FieldName Paramater of this method None Returns the number of items in the DropList if call to this method was Successful Returns 1 in case an error was encountered Add new entries to DROP_LIST field First Clear all entries in DROP_LIST field Second Add new entries Third Display how many entries we have added to the DROP_LIST field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DropListClear DROP_LIST rv MmaFilll DropListAddString DROP_LIST I am Married Married rv MmaFilll DropListAddString DROP_ LIST I am Divorced Married rv MmaFilll DropListAddString DROP_LIST I am Widowed Widowed rv MmaFilll DropListAddString DROP_LIST I am Single Single rv MmaFilll DropListAddString DROP_LIST I am Separated Separated MsgBox Field DROP_LIST has MmaFilll DropListGetCount DROP_LIST entries Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 203 DropListGetCurSel Returns the zero based index of the currently selected item in the DropListfield FieldName C long CMmaFill DropListGetCurSel LPCTSTR FieldName Visual Basic form MmaFill DropListGetCurSel Byval FieldName As String The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab
193. st if call to this method was Successful 1 in case an error was encountered Add new entries to DROP_LIST field First Clear all entries in DROP_LIST field Second Add new entries Third Display how many entries we have added to the DROP_LIST field Dim rv rv MmaFilll OpenFormDialog rv MmaFilll DropListClear DROP_LIST rv MmaFilll DropListAddString DROP_ LIST I am Married Married rv MmaFilll DropListAddString DROP_LIST I am Divorced Married rv MmaFilll DropListAddString DROP_LIST I am Widowed Widowed rv MmaFilll DropListAddString DROP_LIST I am Single Single rv MmaFilll DropListAddString DROP_LIST I am Separated Seprated Chapter 4 Advanced Programming MsgBox Field DROP_LIST has MmaFilll DropListGetCount DROP_LIST entries 199 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 200 DropListClear Clear the current selection and all the entries in DropList field FieldName C long CMmaFill DropListClear LPCTSTR FieldName Visual Basic form MmaFill DropListClear Byval FieldName As String The following parameters are available Parameter Description Field Name Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Para
194. sult SUM Cost The SUM function is only one of forty one built into Visual eForms Designer Chapter 2 Built in Functions Scripts 97 All forty one functions are listed below but not every function is available in Calculation Validation or the Action Scripts such as OnClick OnDbIClick etc Function Description ALERT Displays a message box containing the specified text CLEARDATA Clears the Default property of all fields DATE Returns today s date in MM DD YY YY format DAY Returns the DD portion of a date in MM DD Y Y Y Y DIFFDATE Returns the number of days between two date expressions DIFFTIME Returns the number of hours between the two time expressions GETCURRFIELD Returns the current field in focus GETCURRPAGE Returns the current page number GETFIELDHELP Returns the help text of the specified field GETFIELDPROPERTY Returns the value for the requested property of the specified field GETNUMPAGES Returns the number of pages on the form GETUNFILLEDMANDATORY GOTOFIELD GOTOPAGE HOUR IF LEFT Returns the name of the first field on the form that has been marked Mandatory and has not been filled with any value Moves focus to the specified field Displays the specified page Returns the HH portion of time in HH MM SS Evaluates a condition and returns one of two different values depending on whether the condition is met true or not met false Returns a specified number of chara
195. t before or after another time i e lt time exp gt TIME Returns the current time in HH MM SS format UPPPER Returns the uppercase representation of the string YEAR Returns the YY portion of a date in MM DD YYYY Chapter 2 Scripts 100 Expressions An expression can be any of the following e A field that you want to reference in a script In this instance the expression is enclosed in parenthesis and if there are two or more in a row separated by commas Edit1 Number1 Number2 e Data that you want to reference does not require parenthesis 99 999 00 4 A string that you want to reference does not require parenthesis Address 12 25 2001 Examples e TOTAL SALES NUM TOTAL NUM TAX 0 75 DOLLARS ROUND SALARY 2 STREXTRACT CERENADE 0 2 IF Cerenade_Check gt 0 http www cerenade com if eForms_Check gt 0 http www visualeforms com Chapter 2 Operators Scripts 101 Operators determine how expressions and functions interact with each other Operator Explanation Example Addition Number1 Number2 _ Subtraction Number1 Number2 Division Number1 Number2 Multiplication Number1 Number2 Remainder or modulus IF Number3 gt 12 Number3 12 Number3 A To the power of Number1 4 Equal to IF Number1 Number2 1 Expression separation Table cell specification lt Less than gt Gr
196. t All gt To select special objects 1 On the Edit menu click Select Special 2 In the Select Special dialog box check all of the objects that you would like selected 3 Click the OK button Chapter 2 Select multiple Y WY tables as you would select multiple objects Form Design Guide 33 gt To select tables 1 Click on the table once 2 Click again inside the table to select an individual table cell gt To select table columns or table rows 1 Click the table once to select it 2 Position the cursor on the table border of the column or row you want 3 The mouse changes to an arrow Click and all cells in the the column or row are selected gt To change the width of columns or rows 1 Click the table once to select it 2 Position the cursor on the line between two columns or rows 3 The mouse changes to parallel lines and an arrow Click hold and drag the cursor to change the width of the column or height of the row gt To select all cells of a table 1 Click the table once to select it 2 Hold the SHIFT key and click on a blank area outside the form Ruler When the ruler is displayed the pointer is referenced by guides on the ruler that follow the coordinates of the mouse This allows you to select an object and drag the handles to position the object at exact coordinates in your form window Chapter 2 Form Design Guide 34 The increments on the rule change according to the Measurement
197. t Tab Order 12 pass 12 as FieldName Paramater of this method None SignForm UnsignForm ValidateForm GetSignerName True Success False An Error was encountered Chapter 4 Description Syntax Parameter Remarks See Also Return Values Advanced Programming 245 GetSignerName Returns name of the person who signed into a Signature field if available C VARIANT CMmarFill GetSignerName LPCTSTR FieldName Visual Basic form GetSignerName FieldName As String The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName Paramater of this method None SignForm UnsignForm ValidateForm GetSignatureTimestamp True Success False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 246 GetUnfilledMandatory Returns the name of the first field on the form that has been marked mandatory and has not been filled with any value C VARIANT CMmaFill CMmaFill GetUnfilledMandatory Visual Basic form MmaFill GetUnfilledMandatory None none Variant Name of the first unfilled Field on the form Null An Error was encountered Following example
198. t1 Edit2 and Edit3 are concatenated NUM is not used and the strings are placed one after another in sequence NUM Edit5 4 24 Content of field Edit5 is concatenated with string 4 resulting a new string 24 NUM is then used to convert the string to a number and the result is number 24 NUM Edit5 sun 2 Chapter 2 Scripts 127 Content of field Edit5 is concatenated with the string sun resulting a new string 2sun NUM returns the number portion of the 2sun string and 2 is the only number in the string Chapter 2 Function Syntax Explanation Parameters Remarks Return Values Example Scripts 128 PRINTDIALOG PRINTDIALOG Displays a Print Dialog allowing the user to first select a Printer Destination and then print the currently loaded form based on the Print Dialog settings None None None e Set the OnClick action of a button to PRINTDIALOG e Go to Fill Mode e Click on the button and the print dialog appears Chapter 2 Function Syntax Explanation Parameter Notes See also Example Where Enter Returns Scripts 129 RIGHT RIGHT string length Returns a string containing a specified number of characters from the right side of a string The following parameters are available Parameter Description string String expression from which the rightmost characters are returned
199. t1 contains 10 15 22 and the current time is 9 25 22 HOUR Edit1 10 HOUR TIME 9 Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Enter Returns Enter Returns Enter Returns Scripts 120 IF IF condition statementl statement2 The IF function evaluates a condition and executes one of two different statements depending on whether the condition is met true or not met false The following parameters are available Parameter Description condition A numeric or string expression that evaluates to True or False statementl a single statement executed if condition is True statement2 a single statement executed if condition is False e Nested IF statements are supported e statement2 is OPTIONAL None IF Salary1 gt 99999 SETPROPERTY vfVisible 1 SETPROPERTY vfVisible 0 The above IF statement is added to the CheckSalary field In the above example CONDITION is set to Salary1 gt 99999 If this condition is TRUE then the first SETPROPERTY statement is executed which will makes the CheckSalary field visible otherwise the second SETPROPERTY statement is executed which will make the CheckSalary field invisible IF Salary2 gt 99999 SETPROPERTY vfVisible 1 In theabove example there is no statement to execute for the FALSE condition IF Salary1 gt 99999 GOTOFIELD Ri
200. tFieldLong LPCTSTR FieldName long FAR FieldData Visual Basic form MmaFill GetFieldLong Byval FieldName As String FieldData As Long The following parameters are available Parameter Description FieldName Name or TabOrder of the DropList Field on the Form For TabOrder prefix the number representing the Tab Order with a for example to address a field at Tab Order 12 pass 12 as FieldName parameter of this method FieldData Holder for value of field FieldName Since this method coerces the value of field FieldName to a Long integer the method should be primarily used for numeric or checkmark fields True Call to this method was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 224 GetFieldProperty Returns the field property value corresponding to PropertyID C BSTR CMmafFill GetFieldProperty LPCTSTR FieldName long PropertyID Visual Basic form MmaFill GetFieldProperty Byval FieldName As String Byval PropertyID As Long The following parameters are available Parameter Description FieldName Name of the Form Field PropertyID ID of the property whose value is of interest See below for valid IDs None Valid Property IDs and their Return values Property ID Returns Type 1 Number String representing the Type of the object represented by FieldName Possible Values are 8
201. ter Path gt Specifies the printer This should be in UNC format e g SomeServer Printer1 Prompt 0 or 1 If 1 the user is prompted for a printer dialog If 0 the user is not prompted and either the default or specified printer DC is returned If not present defaults to 1 This method is used in conjunction with PrintStart PrintForm or Print method to provide full control over the printing process DC to the selected printer 0 if a DC could not be created See GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameter Remarks Return Values Example Advanced Programming 277 PrintGetParams Returns users selection on the print dialog that is produced by PrintGetDC function C VARIANT CMmarFill PrintGetParams Visual Basic form MmaFill PrintGetParams As String None This method is used in conjunction with PrintGetDC PrintStart PrintAbort PrintEndQand PrintAddendum methods to provide full control over the printing process An XML string that includes the page range and number of copies selected by the user MmaFill PrintGetDC MsgBox MmaFill PrintGetParams if the user selected pages 2 to 5 then this XML string is returned lt xml version 1 0 gt lt PRINTPARAMS gt lt FROMPAGE gt 2 lt FROMPAGE gt lt TOPAGE gt 5 lt TOPAGE gt lt COPIES gt 1 lt COPIES gt lt PRINTPARAMS gt if the user leave the default se
202. text DC using PrintFreeDC method q MmaFilll PrintFreeDC Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 238 GetFormPath Returns the Form Path associated with the currently loaded form C VARIANT CMmaFill GetFormPath Visual Basic form MmaFill PrintGetDC As Variant None This method can be used to return the full Form Path associated with the currently loaded form or to test whether there is any form currently loaded Form Path associated with the currently loaded form If mmafilll GetFormPath then MsgBox Warning No Form Currently Loaded End If Chapter 4 Description Syntax Parameter Remarks Return Values Advanced Programming 239 GetFormProperty Returns the form property value corresponding to PropertyID C VARIANT CMmarFill GetFormProperty long PropertyID Visual Basic form MmaFill GetFormProperty Byval PropertyID As Long The following parameters are available Parameter Description PropertyID ID of the property whose value will be returned by GetFormProperty None GetFormProperty returns values of the following properties Property ID Returns Form Description 101 String representing the Description of the currently loaded form as set in the Designer Active Field Color 106 String representing the RGB value of the Color e g 255 0 0 for Red Background Color 107 String repre
203. the following Left e Up Down J LEFT dl z Chapter 2 Within a text a block text FW spacing is measured from the baseline of one line of text to the baseline of the text below it The default text spacing is 2 points Form Design Guide gt To select text spacing Click in the Spacing field and enter a value This determines the spacing between lines of text or data 51 Chapter 2 Form Design Guide 52 gt To select text justification 1 Click the drop down menu in the JustHorz field to select one of the following Left e Right e Full e Center LEFT LEFT LEFT LEFT RIGHT RIGHT RIGHT LEFT RIGHT FULL FULL FULL FULL CENTER CENTER FULL CENTER 2 Click the drop down menu in the JustVert field to select one of the following e Top e Middle e Bottom TOP MIDDLE BOTTOM Chapter 2 Form Design Guide 53 gt To select text font You may 1 Click the drop down menu in the TextFont field choose to FW have the Fill The Font dialog box appears font different from the Text font N In the Font section select the desired font A sample is displayed for you W In the Font style section select a font style 4 In the Size section select a font size Nn In the Character Spacing section select Normal Expanded Condensed or Fixed m If you wish to have the text condensed expanded or fixed click the drop down menu and select the appropriate number of p
204. the drop down menu in the ImageFile field The Open File dialog box appears 3 Search to find the image in the file directory 4 Select the ImageFile and click the Open button 5 Define the remaining values just as you would for an Image object Chapter 2 Form Design Guide 72 Drop Lists A drop list defines the correct choices for the end user When used in its original format this restriction assures that the answer given will always fit the parameters and is self validating In its original format the drop list is closed so that the only choices available are the only choices shown Or the drop list can be made an editable field In this format the user can add an answer that is not predefined in the drop list 1 Open the Properties window 2 Under the Appearance heading enter a value in the ListWidth field This value refers to the width of the drop down menu in the Filler You can enter a value or let the width be determined by the text you enter 3 Under the Appearance heading enter a value in the ListHeight field This value refers to the height of the drop down menu in the Filler You can enter a value or let the height be determined by the text you enter 4 Click the drop down menu in the List field The List Choices dialog box appears List Choices Ed Choice Value ee Modify Move Up 7 aa Add _Move lip Move Down Move Down 5 Click the Add button The Add Choice dialog bo
205. the following gt To save a form Quick key CTRL 1 On the File menu click Save s Or 2 Click the Save icon on the Standard toolbar If you are saving a new form the Save As dialog box appears 2134 Save in vid E e Ed eForms Old 2 2 0 0 samples lex lol v2 012 buat far new Designer Old 42 04 E Form1 far new help Old v2 05 E test1 far Old Y1 01 old v2 01 Old 41 2 old 2 101 Save as type FAR Files far y Cancel 3 Enter the file name as you would like it to appear in the file directory 4 Click the Save icon gt To save an existing form under a different name 1 On the File menu click Save As Make sure The Save As dialog box appears B FAR Files N far is selected in the Save as type drop down list Chapter 2 Form Design Guide 20 Save in a Sample Forms Ej ex 2 AA00400H far P3675 far 4 Kq003719 far Agreement far E Kq01040d far LA P3740 far E Yn130 far Dapw15 far 7 Kq01045d far E P4664 far A n131 far Dapw15a far 7 P3611 far E P4667 far A vn132 far Fer603 far E P3632 far A Sched far B m133 far J Jv110 far E P3667 tar A Sched j far Filename P4667 fal Save as type FAR Files far y Cancel hh 2 Enter the file name as you would like it to appear in the file directory 3 Click the Save button Setting Form Options The Options dialog box appears when you select Options on
206. the header Set the row header and the width of the header 5 Click Ok Chapter 2 Form Design Guide 75 Position FEA Let AER width 1 80 To 4 70 Height 1 50 _ Cancel m Dimensions Columns 2 Rows 2 m Headings T Text Column Headings Height M Text Row Headings Column Atributes Column Column Type Edit v 2 Field Name Edit1 Field Width 0 90 gt Accessing objects in a table Access to objects within a table is available by 1 Selecting a single cell e Select the table e Click on to the cell you want to select The cell will be selected 2 Selecting all cells in a single column e Select the table e Move the cursor to the upper most edge of the table cursor will turn into Chapter 2 Form Design Guide 76 an arrow pointing down e Click and the column pointed to by the arrow will be selected 3 Selecting all cells in a single row e Select the table e Move the cursor to the left most edge of the table cursor will turn into an arrow pointing right e Click and the row pointed to by the arrow will be selected 4 Selecting all cells in the table e Select the table e Hold SHIFT and click on any of the cells All cells within the table are selected gt Resizing tables You can resize the table in many ways 1 Resize the entire table object which will resize all cells proportionally e Select the table e Slick and drag on
207. the last page in a document Click the Last Page icon on the Standard toolbar Undo The Undo feature allows you to cancel a previous action There are ten 10 levels of undo That is you can undo up to ten consecutive previous actions Note All changes inside a dialogbox such as Tab Order Accessibility and Properties are regarded as one single action Therefore UNDO revert sall changes user makes while inside a dialogbox Click the Undo button as many times as needed Clicking the opposite arrow enables you to Redo the most recent Undo action Chapter 2 Form Design Guide 24 Setting Form Properties To set the properties of a form you must open the Properties Window The form properties are viewable from the Properties Window only To open the Properties window ensure Properties is checked in the View menu On the View menu click Properties This will hide show the Property control bar la ppearance Property control bar handle To display the Properties Window do one of the following e On the View menu click Toggle Properties Mode Double click on the Property control bar handle e Click the Property control bar handle and drag it to the form window e Press ALT M x County Edt E Misc Name County NonPrintable False E Position Left 3 293800 Top 1 406300 Width 2 183300 Height 0 175000 E Appearance LineThickness 0 006900 BackColor Cierre LineColor Mooooo00 Opaque False RepeatAllPa
208. the object on every page of the form Double click on the Pp Property gt To change text color name that has a True i False choice suchas Click on the drop down menu in the TextColor field to select a color Visible or Opaque This acts as a toggle to change the existing state This toggle gt To change the outline style action works with many property names Click the drop down menu in the Pen Style field to select a style You may choose from a series of solid or dotted lines Pen Style determines if the outline of your object is a solid or dotted line gt To determine if the object is visible on the form Double click Visible or click the drop down menu in the Visible field to select an option True makes the object visible on the page False makes the object invisible on the page Borders Borders refer to the outline of the object and how that outline functions Properties x Edit6 Edit gt To create visible borders 1 Double click on Left or click on the drop down menu in the Left field to select True or False True makes the left border of the object visible False does not 2 Repeat this step for Right Top and Bottom borders selecting True or False from the drop down menu 3 Double click on All Borders or click on the drop down menu in the All Borders field to select True or False Chapter 2 If round corners are YY selected all borders are automati cally set to True If
209. the selected object Hold down the mouse button and drag to resize the object as needed Release the mouse button move an object Select the object Hold down the mouse button and drag the selected object to another location If desired constrain the movement to horizontal or vertical by holding SHIFT while dragging the object Release the mouse button copy an object Select the object On the Edit menu select Copy or press CNTL C on your keyboard On the Edit menu select Paste or press CNTL V on your keyboard Hold down the mouse button and drag the copy to a new position duplicate an object Select the object On the Edit menu select Duplicate or press CNTL D on your keyboard Enter the number of duplicate copies Determine the position e Next to which positions the copy immediately to the right of the original with adjacent edges touching e Below which positions the copy immediately below the original with adjacent edges touching Chapter 2 When a changing YY properties of grouped objects only common properties are available for change Form Design Guide 39 e Offset horizontal which positions the copy on the right side of the original a specified distance from the left edge of the original object If more than one duplicate is specified subsequent copies are placed the same distance from the left edge of the previous copy e Off
210. there is any more addendum text left 4 if so then go to step 1 5 continue until all addendum text is processed and printed If FormAddendumText lt gt Then Do DoEvents rv AddendumFiller SetFieldData Addendum FiledName FormAd _ dendumText rv AddendumFiller PrintForm PrinterDC 1 Addendum _ Filler GetNumPages FormAddendumText AddendumFiller VarGetField _ AddendumText AddendumFiledName Loop Until FormAddendumText End If NOTE Always FREE the Device Context DC using PrintFreeDC method MmaFilll1 PrintFreeDC Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 219 GetFieldCount Returns the total number of fields on the currently loaded form C short CMmaFill GetFieldCount Visual Basic form MmaFill GetFieldCount None None Short Total number of fields on the currently loaded form What page am I on now How many fields does this form have Dim rv Dim PageNum FieldCount rv MmaFilll OpenFormDialog PageNum MmaFill1 GetCurrPage FieldCount MmaFilll GetFieldCount MsgBox You are currently on page amp PageNum amp and there are amp FieldCount amp fields on this form Chapter 4 Description Syntax Parameter Remarks See Also Return Values Example Advanced Programming 220 GetFieldHelp Assigns Help Text of field FieldName to FieldHelp C BOOL CMma
211. tion to convert the Numeric value returned by GETNUMPAGES to a String value Chapter 2 Function Syntax Explanation Notes See also Examples Enter Returns Scripts 116 GETUNFILLEDMANDATORY GETUNFILLEDMANDATORY Returns the name of the first mandatory field left blank on the form GETUNFILLEDMANDATORY function returns a string Add 2 Edit fields Phone and Dummy to your form Add 1 Button Btn to your form Set the Mandatory property of field Phone to TRUE Set the OnClick action of field Btn to ALERT GETUNFILLEDMANDATORY OnClick Handler xj Functions GETFIELDHELP GETFIELDPROPERTY GETNUMPAGES Gal GETUNFILLEDMANDAT GOTOFIELD GOTOPAGE Function Description GETUNFILLEDMANDATORY Returns the name of the first field on the form that has been marked Mandatory and has not been filled with any value Script ALERT GETUNFILLEDMANDATORY In the Fill Mode click on Btn The Alert screen will display the name of the first mandatory fiel that is left blank i e Phone Chapter 2 Function Syntax Explanation Parameter Remarks Return Values Example Scripts 117 GOTOFIELD GOTOFIELD FieldName Resets focus to field FieldName The following parameters are available Parameter Description FieldName Name of the field on the form None None IF MALE 1
212. tions screen you can assign or reassign form fields to data sources e define new data sources Data Sources can be assign existing data sources to your form cretaed using Create Databse method of e define relationships between multiple data sources Database ActiveX See CreateDatabase on gt To open the Database Relations screen page 339 Click the Database Relations icon on the Standard toolbar Or Quick key ALT D On the File menu click Database Relations The Database Relations screen appears Chapter 3 Databases 151 Toolbar a S amp 2 Save New Edit Arrange Legend Close Help The toolbar allows you to Save Edit Arrange and Close the data source relations that you create It also allows you to receive Help create New data sources and display the Legend Legend 3 Data source containing key field s OO Linked data source KeyField E Table Field NI BarCode 4 Currency EN Drop List 44 Number C Button EN Date Field abl Edit Field GQ Mask Field IV Check Box Digital Signature Editable Image The Legend explains the symbols used in this screen Primary and Secondary Data Source Windows Primary Data Source Secondary Data Source _ Field Name __ Field Name Fields 0 Rec Size O Fields 0 Rec Size 0 The Primary Data Source window is an individual data source window as is the Secondary Data Source window Unassigned Column Unassigned
213. to a String value The String value is then prefixed with Current Page No before it is displayed Chapter 2 Function Syntax Explanation Parameter Notes Examples Where Enter Returns Scripts 112 GETFIELDHELP GETFIELDHELP FieldNameStr Returns the FieldHelp property for a field on the form The following parameters are available Parameter Description FieldNameStr Name of the field on the form Field name is expressed as a string or an expression that returns a string 1 Add an edit field Phone to your form 2 Add a button to your form 3 Set the FieldHelp property of Phone to Please enter your Home Phone Number 4 Set the OnClick action of the button to ALERT GETFIELDHELP phone Go to Fill Mode e Click the button Alert 86x Please enter your Home Phone Number Scripts 113 Chapter 2 Function Syntax Explanation Parameter Notes See also Examples Enter Returns GETFIELDPROPERTY GETFIELDPROPERTY FieldStr PropertyIDStr Returns the specific property of a field on the form The following parameters are available Parameter Description FieldStr Name of the field on the form PropertyIDStr One of the following properties vfBackColor vfBottomBorder vfEnabled vfLeftBorder vfLineColor vfMaxFillChar vfPageNumber vfRightBorder vfRoundedBorder vfTextColor vfTopBorder vfVisible GETFIELDPRO
214. ts a point on the grid When you enable Snap to grid objects are automatically shifted to the nearest point on the grid as they are resized created or moved gt To test the snap to grid feature 1 Create a grid using the previous instructions 2 In the Grid Settings dialog box make sure that Snap to grid is selected 3 Draw an object 4 Select the object and drag the handles to resize the object The object borders snap to align with the grid lines Note The object s size is influenced by the size of the grid The borders snap to align with the grid lines gt To test objects created without the grid 1 In the Grid Setting dialog box make sure that Snap to grid is not selected 2 Draw an object 3 Turn the grid on 4 Move the object Notice that the original object size remains but the borders snap to align with the nearest grid 5 Resize the object Notice that the object snaps to align with the nearest grid Chapter 2 Form Design Guide 37 Aligning Objects You can align selected objects by their left or right sides top or bottom edges or align the object centers either vertically or horizontally All objects are aligned with the last object selected The last object selected has solid blue handles the other objects have hollow blue handles gt To align objects 1 Select the objects 2 On the Arrange menu click Align 3 Select one of the following options e Left to align the objects on the left sid
215. ttings then this XML string is returned lt xml version 1 0 gt lt PRINTPARAMS gt lt FROMPAGE gt 1 lt FROMPAGE gt lt TOPAGE gt 1 lt TOPAGE gt lt COPIES gt 1 lt COPIES gt lt PRINTPARAMS gt notice that both FROMPAGE and TOPAGE values are set to 1 Chapter 4 Description Syntax Parameter Description Remarks Return Values Example Advanced Programming 278 PrintPage Prints one page to current Print Job C BOOL CMmarFill PrintPage short PageNum Visual Basic form MmaFill PrintPage Byval PageNum As Integer The following parameters are available Parameter Description PageNum Page to be printed This method is used in conjunction with PrintStart PrintAbort PrintEndQand PrintAddendum methods to provide full control over the printing process True Call to this method was Successful False An Error was encountered GetFieldAddendumText on page 215 Chapter 4 Description Syntax Parameters Remarks Return Values Example Advanced Programming 279 PrintStart Marks the start of a Print Job C BOOL CMmarFill PrintStart long printerDC LPCTSTR DocName short Options Visual Basic form MmaFill PrintStart Byval printerDC As Long Byval DocName as String Byval OptionsAs Integer The following parameters are available Parameter Description printerDC Printer Device Context DocName Name of the Document being printed Options Reserv
216. umbers employee numbers accounting codes that require a standard format Masks also eliminate typing characters such as or when entering this type of data When you eneter data in a mask Visual eForms Designer automatically organizes the data in a manner that can include the following e Inserting constant symbols or characters e Converting text to upper or lower case e Adding spaces between characters gt To define the properties in a mask 1 Select the mask object 2 Open the Properties window 3 Click the drop down menu in the Mask field under the Edit heading Properties xj Mask1 Mask Mask MaxFillChars Auto Tab Mandatory Multiline Overwrite TabOrder Calculation FieldHelp Chapter 2 Constants B that are built EN into a mask will always appear regardless of the specific data entered into the field A constant is any individual character A Alpha U Uppercase alpha L Lowercase alpha Number S Space Punctuation Any Form Design Guide 65 The Mask dialog box appears C Constant j Mask Operator Uppercase Alpha Lowercase Alpha Number Insert Space Punctuation Modify Clear lt IV Repeat last mask 4 Click the Constant radio button and enter a character in the field 5 Click the Add button to place the constant in the Mask field 6 Click the Operator radio button Operators are the placeholders in a field mask used for the variables
217. ure is not supported Create the E table and a define the field properties without the header Once this is completed then add the header In this manner you don t have to go back and change the properties in the fields that make up the header row Form Design Guide 74 Tables Table is a collection of objects that are arranged and aligned neatly in a grid The main purpose of the table object is to maintain objects within it Note Cells in a column of a table are of the same type of object gt To create a table 1 Before you add a table to your form you should know the answer to the following e Number of columns in the table e Number of rows in the table e What is the width of each field e What type of objects should each column be Edit Text Number CheckBox etc e What names you want to give to each column Should tha table manage the header for columns If so what should the height of the column header be Should the table manage the header for the rows If so what should the width of the row header be 2 Locate the table icon on the Object Bar and click on it 3 Position size and place the table object on to your form as you would with any other object The table dialogbox appears 4 Set table properties e Select the number of rows and columns e Set the object type for each column e Give each column a name Set the field width e Set the column header and the height of
218. was Successful False An Error was encountered Chapter 4 Description Syntax Parameter Remarks Advanced Programming 258 OnPrintText Sets the Print Text and its corresponding attributes Once set the PrintText will be reflected on all form printouts There is no effect on the screen view of the form C BOOL CMmaFill OnPrintText LPCTSTR Text short x short y LPCTSTR FontName short Height short Escapement BOOL Bold BOOL Italic BOOL Underline long TextColor Visual Basic form MmaFill OnPrintText Byval Text As String Byval x As Integer Byval y As Integer Byval FontName As String Byval Height As Integer Byval Escapement As Integer Byval Bold As Boolean Byval Italic As Boolean Byval Underline As Boolean Byval TextColor As Long The following parameters are available Parameter Description Text Print Text to be reflected on printouts x x Position of the text in twips 1440 twips 1 inch y y Position of the text in twips FontName Name of the Font to be used for Print Text Height Font Height in twips Escapement angle in 0 1 degree units between the escapement vector and the x axis Bold Set to True for Bold Font Italic Set to True for Italic Font Underline Set to True for Underlined Font TextColor Color of Text as an RGB value This method is primarily used for adding watermarks to form printouts and it does not change the on screen form To disable call the method with Text paramete
219. wing table lists the conventions used in this manual Convention Meaning Bold In procedures indicates text that you type or the name of screen objects such as icons or buttons gt Bold Identifies a procedure SMALL CAPS Refers to keys such as SHIFT CONTROL Or TAB Quotation marks Web links and folder names System Requirements Client PC For the web application to function properly the following must be installed on each client PC IE Supported Versions of Windows and IE e Windows 95 98 Me NT 2000 and IE 4 0 or higher e Netscape Supported Versions of Windows and Netscape e Windows 95 98 Me NT 2000 and Netscape 4 X 5 X Netscape 6 X is not yet supported e Mac Unix The client PC can be a Non Windows PC Forms are presented in HTML to this group of PCs Introduction Minimum Server Requirements Pentium II 300 MHz with 256 MB RAM 10 MB available hard disk and one of the following operating systems e Microsoft Windows 2000 e NT Server 4 0 SP 4 and above e Solaris 2 6 7 amp 8 e Variety of Linux distributions e AIX 4 3 3 or HP UX 11 0 Database Requirements Microsoft SQL Server 6 5 7 0 or 2000 Oracle 7 3 or 8 0 Messaging Microsoft Exchange 5 x Lotus Notes 4 5 and 4 6 Novel Group Wise Directory Services Active directory LDAP server Exchange 5 5 or iPlanet directory server Application Development Windows 9x 2000 Me or Windows NT Web Server Microsoft IIS
220. x appears Add Choice Ed Cancel Chapter 2 Width and Height PR properties control the size of the Drop List field on the form ListWidth and ListHeight properties control the size of the selection window that appears when users click the drop down menu Form Design Guide 73 6 Enter the information in the Choice field Choice represents what the form user will see In this example US states are used 7 Check the Specify Value box then enter the value in the field below Value represents the actual text stored in the database or the information displayed on the screen when the drop down dialog is closed By doing so the drop down menu will offers a choice of states When the user selects a state from the list the value returned will be the two letter abbreviation 8 Click the OK button 9 Click the Add button to enter another choice 10 Repeat until all of the choices have been added 11 Click the OK button These are the choices that the user has in the Filler Arizona California T This is the value that is returned when the user selects California gt gt gt To create an editable drop list The drop list can become a an editable drop list in which the user can add his own information 1 Open the Properties window 2 Under the Edit heading change User Modify to True Chapter 2 If you have E imported a a form from FormFlow the scollable tables feat
221. y PhoneNumber 11 1 Or rv mmafill SetFieldProperty PhoneNumber mmafill vfTopBorder 1 Chapter 4 Description Syntax Remarks Data Type Return Values Property ID Example Advanced Programming 184 vfType TYPE of a field C long GetVfType void SetVfType long Visual Basic form MmaFill vfType When used with GetFieldProperty vfType returns the type of a field Long v BarCode BarCode Field v Button Button Field v CheckBox CheckBox Field v Date Date Field vfDropList DropList Field vfEditableImage Editablelmage Field vfFillableText FillableText Field vfMask Mask Field vfNumber Number or Fixed Field vfSignature Signature Field 1 The following Visual Basic code tells us what type of field Phone Number is rv mmafill GetFieldProperty PhoneNumber 1 Or rv mmafill GetFieldProperty PhoneNumber mmafill vfType Chapter 4 Description Syntax Remarks Data Type Property ID Example Advanced Programming 185 v Visible ID for Visible property of a field C long GetVfVisible void SetVfVisible long Visual Basic form MmaFill vfVisible Must be used with GetFieldProperty or SetFieldProperty to Get or Set the Visible property of a field Long 76 The following Visual Basic code returns the value of this property Msgbox mmafill vfVisible returns 76 To make field PhoneNumber n
222. ype 51 Returns the value assigned to ScaleType property of an Image field Scale _X 52 Returns the value assigned to ScaleX property of an Image field Scale _Y 53 Returns the value assigned to ScaleY property of an Image field Crop_X 54 Returns the value assigned to CropX property of an Image field Crop_Y 55 Returns the value assigned to CropY property of an Image field Fill Char 57 Returns the value assigned to FillChar property of a field Symbology 58 Returns the value assigned to Symbology property of a Bar Code field Bar Width 59 Returns the BarWidth property of a Bar Code field Ratio 60 Returns the value assigned to Ratio property of a Bar Code field Checksum 61 Returns 1 if the CheckSum property of a Bar Code field is TRUE Otherwise Returns 0 Caption Align 62 Returns the value assigned to CaptionAlign property of a Bar Code field Value 63 Returns the DefaultValue of a field Mandatory 65 Returns 1 if the Mandatory property of a field is TRUE Otherwise Returns 0 Auto Tab 66 Returns 1 if the AutoTab property of a field is TRUE Otherwise Returns 0 Left Arrow 67 Returns 1 if the ArrowLeft property of a Line field is TRUE Otherwise Returns 0 Advanced Programming 229 Property ID Returns Right Arrow 68 Returns 1 if the ArrowRight property of a Line field is TRUE Otherwise Returns 0 Pen Style 69 Returns the value assigned to PenStyle property of a field Mask 70 Returns the Ma

Visual eForms User`s Guide

Contents

Download Pdf Manuals

Related Search

Related Contents