Hey all,
I am trying to make a form update a table over an ODBC driver on the fly.
Once text in a text box changes, I need to stamp the time, date, security level, and username into some form fields, and they need to be saved under a specific record in the table. The problem is... this table I'm saving into has 253 columns (the max. allowed is 255) so I had to create a comma-delimited column (I know, ick) to keep track of these 4 different pieces of data. So the fields in the form are parsing the data in this column on the fly... so they are bound to an expression. When I try updating my recordset, it gives me some weird "clipboard" jibber-jabber.
So I'm wondering... is there any good way of approaching this?
I am trying to make a form update a table over an ODBC driver on the fly.
Once text in a text box changes, I need to stamp the time, date, security level, and username into some form fields, and they need to be saved under a specific record in the table. The problem is... this table I'm saving into has 253 columns (the max. allowed is 255) so I had to create a comma-delimited column (I know, ick) to keep track of these 4 different pieces of data. So the fields in the form are parsing the data in this column on the fly... so they are bound to an expression. When I try updating my recordset, it gives me some weird "clipboard" jibber-jabber.
So I'm wondering... is there any good way of approaching this?
