G
Gégé
Hi,
I'm using MS access 2003, I use the transferspreadsheet in a VBA function
to import excel worksheets into the database. I use the first line of the
excel worksheet as field names. Sometimes creative guys add or change a few
field names in the excel file. I want to catch the missing field name in the
target table and display an error message containing this name.
If I run with the VB debugger window open, I catch the full message (error
2391, field soanso not found in table whatever..). If i call the import
procedure via a macro that is open for modification, this also works. But in
normal mode, I can olny error 3270, "property not found".
Is there a way to get the full detailed message in 'normal' mode when the
procedure is called via a macro ?
Thank you in advance,
- gg
-- When there is no solution there is no problem
I'm using MS access 2003, I use the transferspreadsheet in a VBA function
to import excel worksheets into the database. I use the first line of the
excel worksheet as field names. Sometimes creative guys add or change a few
field names in the excel file. I want to catch the missing field name in the
target table and display an error message containing this name.
If I run with the VB debugger window open, I catch the full message (error
2391, field soanso not found in table whatever..). If i call the import
procedure via a macro that is open for modification, this also works. But in
normal mode, I can olny error 3270, "property not found".
Is there a way to get the full detailed message in 'normal' mode when the
procedure is called via a macro ?
Thank you in advance,
- gg
-- When there is no solution there is no problem