Software

Ask something
Discussion Locked

simplify access table format

0 helpful
1 reply

by bigjamee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by jmplancke

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,...)

This discussion is closed to new replies.