Using a macro to change design view of a table Tuxla 12/31/2008 11:12:01 AM Hi I have inherited a few databases and there are regular reports I now have to run from them. Macros have been set up, but I would like to make the report easier. Is it possible to change the design view of a table by using a macro? I know how to open the table in design view using a macro, but there are fields that I need to change the data type each time I run the report which is a pain. Can a macro do this for me? I'm using Office 2000 Thanks for your help

Re: Using a macro to change design view of a table "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/31/2008 2:24:56 PM What you seek to do generally is not a good plan -- changing the design view of an object via macro or VBA code as part of the normal operation of the database is prone to all types of problems, including bloat, design errors, etc. Tell us why you need to change the table's design view, and likely we can suggest an alternative approach. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Tuxla" <Tuxla[ at ]discussions.microsoft.com> wrote in message news:57C3F42A-5128-4420-BAB2-1F4ABE04EAB5[ at ]microsoft.com... [Quoted Text] > Hi > I have inherited a few databases and there are regular reports I now have > to > run from them. Macros have been set up, but I would like to make the > report > easier. > > Is it possible to change the design view of a table by using a macro? I > know > how to open the table in design view using a macro, but there are fields > that > I need to change the data type each time I run the report which is a pain. > Can a macro do this for me? > > I'm using Office 2000 > > Thanks for your help