Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel forms and the navigation buttons (Read 2994 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel forms and the navigation buttons
31.10.05 at 13:55:42
 
Jorma from Finland asked the following question:
 
Question:
How do I use Excel forms and how do I use the navigation buttons on the toolbar?
 
Answer:
This is all linked to the MergeField function and toolbar button.  
 
After you have executed a query you can opt not to display any output (you may actually output it somewhere without affecting this feature). The records will remain in memory and you can use the MergeField function to display the data for a field. You use the navigation buttons on the toolbar to move through the records.
 
Example:
Execute a small SQL statement like: select * from emp
Choose to display no output
Open the Insert MergeField menu and choose to Insert all Fields
SQL*XL will now put formulae into your worksheet like =sqlxl.xla!MergeField("EMPNO")
Excel will display the current value for the fields in Excel.
 
Now use the arrow buttons on the toolbar to scroll through the records. You will see that the new values will be displayed in the cell.
 
This can be useful if you want the data to be displayed inside a form. The mail merge button will copy the current sheet and insert the field data into it for each row. It inserts a page break between each row so you can do a mail merge of your form with data.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1