Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting and Grouping problem. Please help

Status
Not open for further replies.
mickeync

mickeync

Programmer
Jan 26, 2003
28
US
Hi all,
After I converted my database from Access97 to Access2000. When I am trying to run the report, I got an error message saying "Undefined function"LEFT" in expression". I found out there was a grouping error on the report when grouping by the customer name with "PREFIX CHARACTER". I have to group by this way to sort the report as the way the user wanted. Is the database run against Access 2000 missing any component during the convert or any idea ??? Any help would greatly appreciated.

M.
 
Sort by date Sort by votes
In VB Editor, Go to Tools-Links (1st entry) and check if there is any dll marked "not available".
It might be, that some... let's say "Office 8.0" library link is set, but you have not Office 8 installed, but Office 9.

Remove the unavailable link and link the correct dll.

Hope that was the problem.. :)

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:
 
Upvote 0 Downvote
Hi,
Thanks for the quick response. Where is the "VB editor" located ???

M.
 
Upvote 0 Downvote
Hi there,
I got it !!! Thanks so much ... You're good !!!

M.
 
Upvote 0 Downvote
Hi Andy,
Yeah I found where is all the references under the VB editor and look through all the references. However I have no idea which .DLL I need to make the "PREFIX CHARACTER" grouping available on my Access 2000 database !!! Any idea ??

Thanks again,
M.

 
Upvote 0 Downvote
Hmmh.

Can you paste your SQL statement here, please?
[worm]


Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
2K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay
swicor
  • Locked
  • Question
Exact match using access upper and lower case
Replies
0
Views
1K
swicor
swicor
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
521
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top