How can I convert access table data types using macros?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to work out if there is a macro function that will allow me to
automate the process of changing a text data type to hyperlink on opening a
table that has been created from a make table query.
 
Limes,

I have not done this, so I don't know the details, but you can run a DDL
query using the ALTER TABLE statement. I think you will probably need
to add a new hyperlink field using an ADD COLUMN, then run an Update
Query to copy the data from the text field to the hyperlink field, and
then another DDL query with DROP COLUMN to remove the text field.
Something like that, anyway.
 
Back
Top