I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints in
outlook and could send to someone wher you can see more information.

Hi terry,

You can send them to me martin_fishlock @ yahoo . co .uk (with no spaces)


--

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"TerryD" wrote:

I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints in
outlook and could send to someone wher you can see more information.

What versions of Excel and Access? InStrRev didn't appear in VBA until the
version in Office 2000. If you're using '97, perhaps Access has a function
that computes InStrRev and Excel doesn't, or perhaps you are using Access
2000 and Excel 97.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"TerryD" wrote in message
...
I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints
in
outlook and could send to someone wher you can see more information.

2003 excel and access running with XP

"Jon Peltier" wrote:

What versions of Excel and Access? InStrRev didn't appear in VBA until the
version in Office 2000. If you're using '97, perhaps Access has a function
that computes InStrRev and Excel doesn't, or perhaps you are using Access
2000 and Excel 97.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"TerryD" wrote in message
...
I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints
in
outlook and could send to someone wher you can see more information.

Thanks! I have forwarded the email with the screen prints with sample data.
Also have the formula in the access query so you can see. I just don't know
why excel will not allow me to query as the query works fine in access. I'm
using this data to create kanban pull sheet to suppliers. The first data
stream that I will read from a barcode has the part number(space) their
control number(space) and the qty. I use this to give them feedback as to
what material I consumed for the consignment material to bill.

"Martin Fishlock" wrote:

Hi terry,

You can send them to me martin_fishlock @ yahoo . co .uk (with no spaces)


--

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"TerryD" wrote:

I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints in
outlook and could send to someone wher you can see more information.