General discussion


simplify access table format

By bigjamee ·
I am using omniform and microsoft access XP. I export with omniform to Access. The table is always re-written. When this happens, my formating of this table is also erased. I have a dummy table formated corectly that i copy and append to. I then copy and paste that table back over as the original table(rewrite). I have tried making a macro and i can not get it to work, is there anything easier to format my table?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

simplify access table format

by JMPlancke In reply to simplify access table for ...

You have to program (VBA code) the restore of some properties of the table and/or fields. You may see those properties using the documentor of Access on your table (examples for fields : columnorder, columnwidth, ordinal position, columnhidden,...)

Related Discussions

Related Forums