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
How to automatically blank the insert form (Read 2768 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
How to automatically blank the insert form
14.07.06 at 17:27:21
 
How to automatically blank the insert form.
 
Jordi from Spain asked the following question:
 
Question:
My problem is the following one in the button that you have put in
inserting a single line does not clean the Sheet to introduced values once
to return to introduce values in repeating when doing insert.
 
Answer:
That is easy to achieve.
Use the single row insert feature of SQL*XL to generate the insert sheet.
Use Tools  | Protection | Unprotect Sheet
Right click the insert button and select "Assign macro"
It should say: sqlxl.xla!cmdInsertSingle_Insert_Click
Change it to a new macro, for example: mymacro
Go to the VB environment (Alt-F11)
Add a new module (if you have no modules in the VB Project already).
Code the following macro
Code:
Public Sub mymacro()
    Range("B6:B8").Select
    Selection.ClearContents
    SQLXL.cmdInsertSingle_Insert_Click
End Sub
 

Back to top
 
« Last Edit: 17.07.06 at 20:57:12 by Gerrit-Jan Linker »  

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