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
yes, that is why I wrote that you have to open database with tables, so you
have to change this line
Set dbsData = CurrentDb
to
Set dbsData = opendatabase(<path to mdb>)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
