i have a2k and developed a simple two statement macro i attached to a
cmdbutton to let users export a table to their desktops. the mdb file is on a
shared network drive (called the "I" drive in its own folder).

the 'informational' message reads "Too many fields defined" and the "Help"
button opens to an empty grey screen (so no help).

the next thing you see is another window when you click 'Ok' which seems to
spell out the values of the terms in the macro command.

i'm going to list them out fwiw below:

macro name: Exporting
condition: True
action name: Transfer Spreadsheet
arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,

note that the comma (",") following the "Yes" above is displayed in the said
message window.

anyone out there know that a2k is trying to tell me.

Try changing
C:\Screening_Log

to
C:\Screening_Log.xls


--

Ken Snell
<MS ACCESS MVP>

"Ted" <(E-Mail Removed)> wrote in message
newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> i have a2k and developed a simple two statement macro i attached to a
> cmdbutton to let users export a table to their desktops. the mdb file is
on a
> shared network drive (called the "I" drive in its own folder).
>
> the 'informational' message reads "Too many fields defined" and the "Help"
> button opens to an empty grey screen (so no help).
>
> the next thing you see is another window when you click 'Ok' which seems
to
> spell out the values of the terms in the macro command.
>
> i'm going to list them out fwiw below:
>
> macro name: Exporting
> condition: True
> action name: Transfer Spreadsheet
> arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
>
> note that the comma (",") following the "Yes" above is displayed in the
said
> message window.
>
> anyone out there know that a2k is trying to tell me.
>
>

tried it but it doesn't like it. the same message as before only now the file
name reflects the added extention.

btw--what does that mysterious number "8" mean in the string. i don't seem
to see it anywhere else but the error message.

ted

"Ken Snell [MVP]" wrote:

> Try changing
> C:\Screening_Log
>
> to
> C:\Screening_Log.xls
>
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Ted" <(E-Mail Removed)> wrote in message
> newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > i have a2k and developed a simple two statement macro i attached to a
> > cmdbutton to let users export a table to their desktops. the mdb file is
> on a
> > shared network drive (called the "I" drive in its own folder).
> >
> > the 'informational' message reads "Too many fields defined" and the "Help"
> > button opens to an empty grey screen (so no help).
> >
> > the next thing you see is another window when you click 'Ok' which seems
> to
> > spell out the values of the terms in the macro command.
> >
> > i'm going to list them out fwiw below:
> >
> > macro name: Exporting
> > condition: True
> > action name: Transfer Spreadsheet
> > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> >
> > note that the comma (",") following the "Yes" above is displayed in the
> said
> > message window.
> >
> > anyone out there know that a2k is trying to tell me.
> >
> >
>
>
>

The 8 refers to the version of EXCEL being exported (Excel 97, I believe).

How many fields are in the table/query named Screening Log?

--

Ken Snell
<MS ACCESS MVP>

"Ted" <(E-Mail Removed)> wrote in message
news:115A41D8-89ED-4C52-917E-(E-Mail Removed)...
> tried it but it doesn't like it. the same message as before only now the
file
> name reflects the added extention.
>
> btw--what does that mysterious number "8" mean in the string. i don't seem
> to see it anywhere else but the error message.
>
> ted
>
> "Ken Snell [MVP]" wrote:
>
> > Try changing
> > C:\Screening_Log
> >
> > to
> > C:\Screening_Log.xls
> >
> >
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> >
> > "Ted" <(E-Mail Removed)> wrote in message
> > newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > > i have a2k and developed a simple two statement macro i attached to a
> > > cmdbutton to let users export a table to their desktops. the mdb file
is
> > on a
> > > shared network drive (called the "I" drive in its own folder).
> > >
> > > the 'informational' message reads "Too many fields defined" and the
"Help"
> > > button opens to an empty grey screen (so no help).
> > >
> > > the next thing you see is another window when you click 'Ok' which
seems
> > to
> > > spell out the values of the terms in the macro command.
> > >
> > > i'm going to list them out fwiw below:
> > >
> > > macro name: Exporting
> > > condition: True
> > > action name: Transfer Spreadsheet
> > > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> > >
> > > note that the comma (",") following the "Yes" above is displayed in
the
> > said
> > > message window.
> > >
> > > anyone out there know that a2k is trying to tell me.
> > >
> > >
> >
> >
> >

i count 30.

"Ken Snell [MVP]" wrote:

> The 8 refers to the version of EXCEL being exported (Excel 97, I believe).
>
> How many fields are in the table/query named Screening Log?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Ted" <(E-Mail Removed)> wrote in message
> news:115A41D8-89ED-4C52-917E-(E-Mail Removed)...
> > tried it but it doesn't like it. the same message as before only now the
> file
> > name reflects the added extention.
> >
> > btw--what does that mysterious number "8" mean in the string. i don't seem
> > to see it anywhere else but the error message.
> >
> > ted
> >
> > "Ken Snell [MVP]" wrote:
> >
> > > Try changing
> > > C:\Screening_Log
> > >
> > > to
> > > C:\Screening_Log.xls
> > >
> > >
> > > --
> > >
> > > Ken Snell
> > > <MS ACCESS MVP>
> > >
> > > "Ted" <(E-Mail Removed)> wrote in message
> > > newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > > > i have a2k and developed a simple two statement macro i attached to a
> > > > cmdbutton to let users export a table to their desktops. the mdb file
> is
> > > on a
> > > > shared network drive (called the "I" drive in its own folder).
> > > >
> > > > the 'informational' message reads "Too many fields defined" and the
> "Help"
> > > > button opens to an empty grey screen (so no help).
> > > >
> > > > the next thing you see is another window when you click 'Ok' which
> seems
> > > to
> > > > spell out the values of the terms in the macro command.
> > > >
> > > > i'm going to list them out fwiw below:
> > > >
> > > > macro name: Exporting
> > > > condition: True
> > > > action name: Transfer Spreadsheet
> > > > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> > > >
> > > > note that the comma (",") following the "Yes" above is displayed in
> the
> > > said
> > > > message window.
> > > >
> > > > anyone out there know that a2k is trying to tell me.
> > > >
> > > >
> > >
> > >
> > >
>
>
>

Although this KB article speaks to saving a table, its "fix" may be what you
need to do with your Screening Log table:

http://support.microsoft.com/default...b;en-us;128221


--

Ken Snell
<MS ACCESS MVP>

"Ted" <(E-Mail Removed)> wrote in message
news:1C12F6D9-7C2E-4E0C-9965-(E-Mail Removed)...
> i count 30.
>
> "Ken Snell [MVP]" wrote:
>
> > The 8 refers to the version of EXCEL being exported (Excel 97, I
believe).
> >
> > How many fields are in the table/query named Screening Log?
> >
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> >
> > "Ted" <(E-Mail Removed)> wrote in message
> > news:115A41D8-89ED-4C52-917E-(E-Mail Removed)...
> > > tried it but it doesn't like it. the same message as before only now
the
> > file
> > > name reflects the added extention.
> > >
> > > btw--what does that mysterious number "8" mean in the string. i don't
seem
> > > to see it anywhere else but the error message.
> > >
> > > ted
> > >
> > > "Ken Snell [MVP]" wrote:
> > >
> > > > Try changing
> > > > C:\Screening_Log
> > > >
> > > > to
> > > > C:\Screening_Log.xls
> > > >
> > > >
> > > > --
> > > >
> > > > Ken Snell
> > > > <MS ACCESS MVP>
> > > >
> > > > "Ted" <(E-Mail Removed)> wrote in message
> > > > newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > > > > i have a2k and developed a simple two statement macro i attached
to a
> > > > > cmdbutton to let users export a table to their desktops. the mdb
file
> > is
> > > > on a
> > > > > shared network drive (called the "I" drive in its own folder).
> > > > >
> > > > > the 'informational' message reads "Too many fields defined" and
the
> > "Help"
> > > > > button opens to an empty grey screen (so no help).
> > > > >
> > > > > the next thing you see is another window when you click 'Ok' which
> > seems
> > > > to
> > > > > spell out the values of the terms in the macro command.
> > > > >
> > > > > i'm going to list them out fwiw below:
> > > > >
> > > > > macro name: Exporting
> > > > > condition: True
> > > > > action name: Transfer Spreadsheet
> > > > > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> > > > >
> > > > > note that the comma (",") following the "Yes" above is displayed
in
> > the
> > > > said
> > > > > message window.
> > > > >
> > > > > anyone out there know that a2k is trying to tell me.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

this looks like it definitely offers the potential to do so.

much thanks, ken.

ted

"Ken Snell [MVP]" wrote:

> Although this KB article speaks to saving a table, its "fix" may be what you
> need to do with your Screening Log table:
>
> http://support.microsoft.com/default...b;en-us;128221
>
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Ted" <(E-Mail Removed)> wrote in message
> news:1C12F6D9-7C2E-4E0C-9965-(E-Mail Removed)...
> > i count 30.
> >
> > "Ken Snell [MVP]" wrote:
> >
> > > The 8 refers to the version of EXCEL being exported (Excel 97, I
> believe).
> > >
> > > How many fields are in the table/query named Screening Log?
> > >
> > > --
> > >
> > > Ken Snell
> > > <MS ACCESS MVP>
> > >
> > > "Ted" <(E-Mail Removed)> wrote in message
> > > news:115A41D8-89ED-4C52-917E-(E-Mail Removed)...
> > > > tried it but it doesn't like it. the same message as before only now
> the
> > > file
> > > > name reflects the added extention.
> > > >
> > > > btw--what does that mysterious number "8" mean in the string. i don't
> seem
> > > > to see it anywhere else but the error message.
> > > >
> > > > ted
> > > >
> > > > "Ken Snell [MVP]" wrote:
> > > >
> > > > > Try changing
> > > > > C:\Screening_Log
> > > > >
> > > > > to
> > > > > C:\Screening_Log.xls
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Ken Snell
> > > > > <MS ACCESS MVP>
> > > > >
> > > > > "Ted" <(E-Mail Removed)> wrote in message
> > > > > newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > > > > > i have a2k and developed a simple two statement macro i attached
> to a
> > > > > > cmdbutton to let users export a table to their desktops. the mdb
> file
> > > is
> > > > > on a
> > > > > > shared network drive (called the "I" drive in its own folder).
> > > > > >
> > > > > > the 'informational' message reads "Too many fields defined" and
> the
> > > "Help"
> > > > > > button opens to an empty grey screen (so no help).
> > > > > >
> > > > > > the next thing you see is another window when you click 'Ok' which
> > > seems
> > > > > to
> > > > > > spell out the values of the terms in the macro command.
> > > > > >
> > > > > > i'm going to list them out fwiw below:
> > > > > >
> > > > > > macro name: Exporting
> > > > > > condition: True
> > > > > > action name: Transfer Spreadsheet
> > > > > > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> > > > > >
> > > > > > note that the comma (",") following the "Yes" above is displayed
> in
> > > the
> > > > > said
> > > > > > message window.
> > > > > >
> > > > > > anyone out there know that a2k is trying to tell me.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

i have been away from the project for a while...

it seems to me that the article's limitations are that it did not appear
relevant to my usage of the access 2000 version of their product (just up to
'97).

thanks, though.

t

"Ken Snell [MVP]" wrote:

> Although this KB article speaks to saving a table, its "fix" may be what you
> need to do with your Screening Log table:
>
> http://support.microsoft.com/default...b;en-us;128221
>
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Ted" <(E-Mail Removed)> wrote in message
> news:1C12F6D9-7C2E-4E0C-9965-(E-Mail Removed)...
> > i count 30.
> >
> > "Ken Snell [MVP]" wrote:
> >
> > > The 8 refers to the version of EXCEL being exported (Excel 97, I
> believe).
> > >
> > > How many fields are in the table/query named Screening Log?
> > >
> > > --
> > >
> > > Ken Snell
> > > <MS ACCESS MVP>
> > >
> > > "Ted" <(E-Mail Removed)> wrote in message
> > > news:115A41D8-89ED-4C52-917E-(E-Mail Removed)...
> > > > tried it but it doesn't like it. the same message as before only now
> the
> > > file
> > > > name reflects the added extention.
> > > >
> > > > btw--what does that mysterious number "8" mean in the string. i don't
> seem
> > > > to see it anywhere else but the error message.
> > > >
> > > > ted
> > > >
> > > > "Ken Snell [MVP]" wrote:
> > > >
> > > > > Try changing
> > > > > C:\Screening_Log
> > > > >
> > > > > to
> > > > > C:\Screening_Log.xls
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Ken Snell
> > > > > <MS ACCESS MVP>
> > > > >
> > > > > "Ted" <(E-Mail Removed)> wrote in message
> > > > > newsF208F45-C0E7-42E3-A209-(E-Mail Removed)...
> > > > > > i have a2k and developed a simple two statement macro i attached
> to a
> > > > > > cmdbutton to let users export a table to their desktops. the mdb
> file
> > > is
> > > > > on a
> > > > > > shared network drive (called the "I" drive in its own folder).
> > > > > >
> > > > > > the 'informational' message reads "Too many fields defined" and
> the
> > > "Help"
> > > > > > button opens to an empty grey screen (so no help).
> > > > > >
> > > > > > the next thing you see is another window when you click 'Ok' which
> > > seems
> > > > > to
> > > > > > spell out the values of the terms in the macro command.
> > > > > >
> > > > > > i'm going to list them out fwiw below:
> > > > > >
> > > > > > macro name: Exporting
> > > > > > condition: True
> > > > > > action name: Transfer Spreadsheet
> > > > > > arguments: Export, 8, Screening Log,C:\Screening_Log,Yes,
> > > > > >
> > > > > > note that the comma (",") following the "Yes" above is displayed
> in
> > > the
> > > > > said
> > > > > > message window.
> > > > > >
> > > > > > anyone out there know that a2k is trying to tell me.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>