Adding a field to a table

B

belmontpines

I know how to add a field using code, I tried to insert a
hyperlink field into a table using the following but it
doesn't want to play, any ideas

dbs2.Execute "ALTER TABLE settings ADD COLUMN rc2ftp
hyperlink"

Nigel
 
T

Tim Ferguson

I know how to add a field using code, I tried to insert a
hyperlink field into a table using the following but it
doesn't want to play, any ideas
Click to expand...

Use a text field; and get the UI to do all the hyperjumping.

Tim F
 
Top