471,857 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,857 software developers and data experts.

Dynamically Created Tables that Can be updated and Stored in Access Memo Fields

I am working on a form with the basic textboxes, dropdowns, etc.; however, I have a need for the client side to have the option to create a table dynamically in the form. In essence, Joe User would determine rows and columns and then enter values into the the table. This information would then be stored in an Access database and would need to be retrieved and displayed as it was inputted by Joe User. Is it possible to build and capture the entire table as a string? Any help would be greatly appreciated. Would this be easier using the Datagrid function in asp.net?

Thanks in advance for any help.
Aug 4 '07 #1
1 1074
jhardman
3,406 Expert 2GB
I think this would be totally do-able, remember that an HTML table is constructed entirely as a string, as is a .csv file (plain text database). The tricky part is how to make a user enter data in this format. Probably the most straight-forward method would be to make a grid of text inputs, then on the form handler, interpret each of these as a HTML cell <td>, and each new row as a new <tr>, then concatenate them into one long string. Then this would be easily pulled up onto new web pages, since you already interpreted it as HTML.

On the other hand, csv files are also very well supported, and any spreadsheet can open them easily. If you wanted to make a csv file (the downside is a comma is a special character) you just need to separate each cell with a comma and each row with key word "vbNewLine". Let me know if this helps.

Jared
Aug 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Neo Geshel | last post: by
5 posts views Thread by rdemyan via AccessMonster.com | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.