Excel error: Undefined Function 'InStrRev' in Expression

T

TerryD

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.
 
M

Martin Fishlock

Hi terry,

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

Jon Peltier

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
 
T

TerryD

2003 excel and access running with XP

Jon Peltier said:
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
_______
Click to expand...
 
T

TerryD

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.
 
Top