D
Dj
History - I have db which twice a week a macro is run that imports records to
a table defined in the Frontend and then those imported records are appended
to the main table which is defined in a Backend. We have been doing this for
close to a year with no problem.
This week, I needed to work on changing the database so I started in the
backend table (which is not imported but is the one appended to).
This is the weird thing that started happening. The last field in my
imported FE table is a Date type. Whenever I run my macro that runs does the
'transfer spreadsheet' and 'append query', that last date field is
automatically changes it from "date" to "text". The date an field that's
inputted when the append query runs and that becomes the criteria. So, it's
comparing a text field to a date field and nothing get appended because
there's no match. I can change my field to "date", save the change, exit the
design of the table, run the macro, go back into design of the table and it
says "text" again.
The really really weird thing is that only it only happens when I run the
macro on my Citrix logon and it doesn't happen when I run it from my XP
logon. Can any shed light on this for me. Both my Citrix logon and my XP
logon are 2003. Thx, Dj
a table defined in the Frontend and then those imported records are appended
to the main table which is defined in a Backend. We have been doing this for
close to a year with no problem.
This week, I needed to work on changing the database so I started in the
backend table (which is not imported but is the one appended to).
This is the weird thing that started happening. The last field in my
imported FE table is a Date type. Whenever I run my macro that runs does the
'transfer spreadsheet' and 'append query', that last date field is
automatically changes it from "date" to "text". The date an field that's
inputted when the append query runs and that becomes the criteria. So, it's
comparing a text field to a date field and nothing get appended because
there's no match. I can change my field to "date", save the change, exit the
design of the table, run the macro, go back into design of the table and it
says "text" again.
The really really weird thing is that only it only happens when I run the
macro on my Citrix logon and it doesn't happen when I run it from my XP
logon. Can any shed light on this for me. Both my Citrix logon and my XP
logon are 2003. Thx, Dj