I have a saved export spec that I need to modify. I need to make one of the fields a memo instead of just text. The source table is definitely memo and storing the data correctly. I changed the table data type after I had already saved the spec.
I went in to use the export spec so I could tweak it and re-save, but nowhere does it give me options to specify data types. How to?
look at MSysIMEXColumns
while you cannot edit that table directly ... you can 1. create a make-table query with records for a particular spec (defined in MSysIMEXSpecs), 2. edit the table then 3. update/append
Overview: This article:
(a) explains one principle method to cross-reference invoice items in Quickbooks®
(b) explores the reasons one might need to cross-reference invoice items
(c) provides a sample process for creating a M…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…