How can I modify a Field Type from Text to Memo in a linked table?

  • Thread starter Thread starter Rob - IT Data Services
  • Start date Start date
R

Rob - IT Data Services

I have a linked table that I need to modify a field from Text to Memo...

Any thoughts?
 
Hi Rob, to make things easy can you just change the field to memo in the
table design or you are trying to accomplish this in VBA?
 
I need to do this via a VBA.

I have a project that has linked tables on Sales Rep's laptops.
However they started using a beta version and now have data in the tables.

Since the release it was realised that the Field was not correctly set and
now I need to produce a little standalone app that will link the table and
make the change and then the Rep's can log back into their existing system
and use the field to its full intention.

The File: NWQ_Quotes
The Table: tbl_QuoteDetail
The Field: InvoiceNotes
CurrentType: Text
RequiredType: Memo
 
I need to do this under VBA. I have a project that has been rolled out and we
have realised that there is a problem in that the InvoiceNotes Field should
have been a Memo but it was set as TEXT.

This needs to be done in a linked state..

I need to generate a small Access2007 VBA to run on the runtime.

File: NWQ_Quotes
Table: tbl_QuoteDetails
FieldName: InvoiceNotes
CurrentFieldType: Text
req'dFieldType: Memo

I have been able to use Alter Table when the table was in the same file as
the VBA code but when linked.. I get errors..
 
Hi,
you need to open database with tables using OpenDatabase, then open tabledef
or required table, add new field there, then run a query to copy data from
text to new memo field, delete text field and then rename new field to old
sample code to add/remove fields you can find in online help

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
I seem to be having some trouble working out the syntax on this - a hand
please.
 
Back
Top