Table Documenter question

[giedrius]

Hello,

I am using A2K table documenter to print the fields and their definitions, however for some fields (with type Numeric Decimal?) the documenter says that the field type is ": Delete Query", size 16.

What could that mean?

Thanks,
giedrius

 

[a.sinatra]

Have you checked the field type on the database tables to see what they read?
________
Full melt hash

 

[giedrius]

They read Numeric Decimal.

ggv

 

[The_Doc_Man]

Your problem is the priority of translation of symbols. This is merely conjecture on my part, but somehow you have defined something in your references list that is higher in priority than it should be. So when the documenter does the translation, it obeys the priority that you set and finds a bit pattern that translates to DELETE QUERY before it finds the one that says NUMERIC DECIMAL.

Now, as to WHAT is in the wrong order, ... beats the heck out of me!

 

[giedrius]

I am not sure I know what translations symbols are?

ggv

 

[The_Doc_Man]

I'm not sure I know how to explain it but I'll try.

Didja ever wonder how Access knows what a CURRENCY field is? I mean, when you use the field-type drop-down, how does Access associate the code value with the text? The answer is that some library files that came with Office provide symbolic translation of name to code value. These are translation modules or, for us older wonks, symbol tables.

In order for you to reference those symbol tables, they have to be part of your list of references, which are accessible only from a Module screen, through Tools>>References to a complex dialog box. The items in that box that are checked are code or symbol modules that you have told Access you need to use. (Or, if they were installed by default, they are modules that Access told itself to use.)

When Access is trying to translate a code back into a name, which is what the Table Documenter has to do, it has to try to back-track its way through the referenced libraries to see what could have brought in that code. And the answer that you get is wrong for the case you mentioned. Which usually means that you have selected at least one extra reference.

Now, the priority of the reference is merely the order in which you tell Access to search the listed libraries. The up and down arrows on the References dialog box allow you to change the priority of a highlighted reference. And I suspect that the reason you get the wrong answer is because some reference is in the wrong position.

On the other hand, it could be just a screw-up on the part of an MS Office programmer. But they never do that, do they?

 

[giedrius]

OK, thanks. Looks quite complicated. In the meantime I found a small VB code, which after some modification allows to print field names and attributes the way I like.

giedrius