469,323 Members | 1,198 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

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 1048
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.

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
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.