Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srxr9
Starting Member
15 Posts |
 Posted - 2006-10-19 : 17:59:59
|
| I have a table (generally with < 50 rows) that needs to be validated by the clients monthly.Currently I export the table in Excel and send an email to clients with the attachment.The clients review the attachment and populate the ValidIndicator field in the spreadsheet (But very inconsistently like 'Y'/'Yes'/1...etc)Is there a way to create switch/button (like a VALID switch) in excelsheet for every row, which the client can click, so when I import the excel back, I can import only the valid rows.Note: I will have to do this in ActiveX scripts.Any advice will be helpfulThanksRam |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-19 : 18:35:24
|
| You can add a checkbox from the Forms toolbar to each row and set the linked cell for each checkbox to a cell in the row, then when you read the data the value in the cell will be true for checked checkboxes and false for unchecked checkboxes. |
 |
|
|
|
|
|
Excel question