By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Uggg Help with Reserved error -1038 - not Access 97

P: 4
I have been using a bit of great code and SQL I found on this site and it has worked fantastic but all of a sudden i am getting this error message. " Reserved error (-1038): there is no message for this error." All i can find about the error is that it has to do with access 97 but i have 2002 and never had this db on a computer with access 97. I think i might go crazy if i can get this to work. I am new to this whole site but here is the URL to the original post i was working from.
Dec 2 '08 #1
Share this Question
Share on Google+
6 Replies

Expert 100+
P: 2,364
Glad to hear we have helped you solve some issues, mallegirl... please continue paying us a visit now and then.

I am not sure what may be happening. I will however send you over to our gurus in VBA to see what could be salvaged for ya.

Sorry for your troubles:-)
Dec 3 '08 #3

P: 4
I appreciate you taking the time to respond. I actually figured out how to make it work.

The solution uses Max(concat(group, item) but for some reason that wont work for me. I changed it to last(concat(group, item)) and now it is working again.
Dec 3 '08 #4

Expert Mod 15k+
P: 31,494
Check out the linked thread again (You should be subscribed already).

I have highlighted two posts which indicated that the OP had a similar problem to yours, as well as finding the same "solution".
Dec 3 '08 #5

P: 1

I cut and paste the code and works perfectely fine (ofcourse I have to use last and not max).

Really appereciate the solution.

Feb 15 '10 #6

Expert Mod 15k+
P: 31,494
Thanks for letting us know :)

Another related link - direct to the solution - is Combining Rows-Opposite of Union.
Feb 15 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.