Ms Access Error 1038
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Uggg Help with Reserved error -1038 - not Access 97 P: 4 mallegirl 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 Post Reply Share this Question 6 Replies P: 4 mallegirl Combining Multiple Rows of one Field into One Result Dec 2 '08 #2 reply Expert 100+ P: 2,364 Dököll @mallegirl 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 reply P: 4 mallegirl 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 reply Expert Mod 15k+ P: 29,923 NeoPa 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 reply P: 1 vissas Hi, I cut and paste the code and works perfectely fine (ofcourse I have to use last and not max). Really appereciate the solution. Thanks!!!! Feb 15 '10 #6 reply Expert Mod 15k+ P: 29,923 NeoPa Thanks for letting us know :) Another related link - direct to the solution - is Combining Rows-Opposite of
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a https://bytes.com/topic/access/answers/857216-uggg-help-reserved-error-1038-not-access-97-a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Run-time error '3000': Reserved error (-1038); There is no message for this error. Microsoft ISV Community Center > Visual Basic for Applications (VBA) Question 0 https://social.msdn.microsoft.com/Forums/en-US/2da409ca-8ed0-4f3d-b71d-0561229297e1/runtime-error-3000-reserved-error-1038-there-is-no-message-for-this-error?forum=isvvba Sign in to vote Hi all,  New problem to me, the above error occurs on the seek method below. My PrimaryKey is correct. Cannot see the problem any ideas?  Private Sub btnBuildLastMoved_Click()Dim rsPart, rsLastM, rsSQL As DAO.RecordsetDim lngSI As LongDim strSQL As String Set rsPart = CurrentDb().OpenRecordset("Part Table")Set rsLastM = CurrentDb().OpenRecordset("tbl Last Moved", dbOpenTable)rsLastM.Index = "PrimaryKey"    While Not rsPart.EOF       strSQL = "SELECT DM9ADTA_F4111.ILITM, DM9ADTA_F4111.ILMCU, DM9ADTA_F4111.ILDCT, Max(DM9ADTA_F4111.ILDGL) AS [Julian Last] " & _                "FROM DM9ADTA_F4111 " & _                "GROUP BY DM9ADTA_F4111.ILITM, DM9ADTA_F4111.ILMCU, DM9ADTA_F4111.ILDCT " & _                "HAVING (((DM9ADTA_F4111.ILITM)=" & Trim$(Str$(rsPart![PS Item])) & ") AND ((DM9ADTA_F4111.ILDCT)<>'IB' And (DM9ADTA_F4111.ILDCT)<>'IZ' And (DM9ADTA_F4111.ILDCT)<>'IT'));"       Set rsSQL = CurrentDb().OpenRecordset(strSQL)       If rsSQL.RecordCount > 0 Then           Me.Status = rsSQL!ILITM           Me.Repaint           Me.Refresh           While Not rsSQL.EOF               rsLastM.Seek "=", rsSQL!ILITM, Trim$(rsSQL!ILMCU), rsSQL!ILDCT               If rsLastM.NoMatch Then                   rsLastM.AddNe
SQL Server. I am able to successfully connect to the SQL Server but I get "Reserved Error -1038: No error message text available" soon thereafter. How can I diagnosis this problem. -- Arlen Guest, Mar 15, http://www.pcreview.co.uk/threads/upsizing-reserved-error-1038.1107461/ 2005 #1 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and http://www.office-forums.com/threads/upsizing-reserved-error-1038.303278/ then you can ask your own questions on the forum. Sign Up Now! Similar Threads Reserved error (-7778) There is no message for this error Ketaki, Oct 20, 2003, in forum: Microsoft Access Replies: 1 Views: 6,926 Joan Wild ms access Oct 21, 2003 Reserved error (-3004); there is no message for this error Guest, Jan 7, 2004, in forum: Microsoft Access Replies: 0 Views: 957 Guest Jan 7, 2004 Reserved error (-3002); there is no message for this error FT, Mar 9, 2004, in forum: Microsoft Access Replies: 0 Views: 1,641 FT Mar 9, 2004 Reserved error -1587, There is no message for this error Guest, May 12, 2005, in forum: Microsoft Access Replies: 4 Views: 376 Guest Aug ms access error 17, 2006 Reserved Error (-7776); there is no message for this error Guest, Sep 20, 2005, in forum: Microsoft Access Replies: 0 Views: 768 Guest Sep 20, 2005 Reserved Error (-7748); there is no message for this error James D Smooth, Jan 4, 2006, in forum: Microsoft Access Replies: 2 Views: 815 Tony Toews Jan 8, 2006 SSW Upsizing Pro and Upsizing in general Guest, Feb 9, 2006, in forum: Microsoft Access Replies: 0 Views: 374 Guest Feb 9, 2006 Reserved Error (-7776) there us no error message for this error Simon, Feb 2, 2007, in forum: Microsoft Access Replies: 1 Views: 809 Douglas J. Steele Feb 3, 2007 Loading... Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Welcome to PC Review! Hello and welcome to PC Review. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask any tech support questions, or chat with the community and help others. Sign up now! Member Login Remember Me Forgot your password? Advertisements Latest Threads Nintendo Switch announced today Becky posted Oct 20, 2016 at 5:33 PM GTA5 Mod uses Galaxy Note 7 phone as bom
upsize my Access 2000 database to SQL Server. I am able to successfully connect to the SQL Server but I get "Reserved Error -1038: No error message text available" soon thereafter. How can I diagnosis this problem. -- Arlen Arlen, Mar 15, 2005 #1 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Similar Threads Reserved error (-7778) There is no message for this error Ketaki, Oct 20, 2003, in forum: Access General Replies: 1 Views: 573 Joan Wild Oct 21, 2003 Reserved error (-3004); there is no message for this error MJ, Jan 7, 2004, in forum: Access General Replies: 0 Views: 309 MJ Jan 7, 2004 Reserved error -1587, There is no message for this error BAC, May 12, 2005, in forum: Access General Replies: 4 Views: 139 Klumzy Aug 17, 2006 Reserved Error (-7776); there is no message for this error deshg, Sep 20, 2005, in forum: Access General Replies: 0 Views: 298 deshg Sep 20, 2005 Reserved Error (-7748); there is no message for this error James D Smooth, Jan 4, 2006, in forum: Access General Replies: 2 Views: 276 Tony Toews Jan 8, 2006 reserved error (-5001) ; there is no message for error mult1f1l, Feb 7, 2006, in forum: Access General Replies: 0 Views: 384 mult1f1l Feb 7, 2006 SSW Upsizing Pro and Upsizing in general DBG, Feb 9, 2006, in forum: Access General Replies: 0 Views: 169 DBG Feb 9, 2006 Reserved Error (-7776) there us no error message for this error Simon, Feb 2, 2007, in forum: Access General Replies: 1 Views: 1,052 Douglas J. Steele Feb 3, 2007 Loading... Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Welcome to Office Forums! Welcome to the Microsoft Office Forums where you can ask questions or find answers on anything related to Word, Excel, Outlook, Access or any of the other Office applications. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask questions about MS Office or chat with the community and help others. Sign up now! Member Login Remember Me Forgot your password? Advertisements Latest Threads Use a master workbook to carry over changes to multiple workbooks Maxwell posted Oct 20, 2016 at 3:00 PM 3 variable data in MS project file Yan Bousquet posted Oct 19, 2016 at 10:00 PM Which MS Program