Changing the format of table fields with code

[Guest]

Hello there,

I'm building a macro that basically runs several queries. However, one of
the queries creates a table (only the structure, not the data) in which 3
fields are dates. These fields are by default formatted as text (since the
original table has the dates in text format). I need help with a piece of
code that would open the new, empty table and change the format of those 3
fields to date/time. Anybody around that can help me out with this?

Thanks!

 

[Alex Dybenko]

Hi,
better option - if you change format to date for that field before you
create table.
Not sure you can even do this (change type of field) using macro, this
requires VBA coding

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Guest]

Hello Alex,

I'm not able to work on the original table. It's kind of the master data
table and we are not allowed to touch it since it is live data from an SQL
application.

I agree with you, this cannot be done with macros, that is why I was asking
for help with the code in VBA to do that. After having the code, I can use
the macro to run that procedure or module. Can you help me with the code to
change the format of the table? Thanks!

 

[Guest]

It's possible to do in VBA, but I think there's a much easier solution. In
the query which builds the table, instead of using the field as is, convert
it to date type using datevalue(<fieldname>).

 

[Guest]

Excellent!! Thanks!!!

It's possible to do in VBA, but I think there's a much easier solution. In
the query which builds the table, instead of using the field as is, convert
it to date type using datevalue(<fieldname>).