bordentech
asked on
Access 2003 - Error 16389 "Reserved Error"
We've recently upgraded some from Win2k w/ Office 2000 to WinXP w/ Office 2003 and this error popped up. I can't seem to figure out how to fix it. I'll try to explain the best I can.
There's a main form that is used to assign a room to people (B_RationActivityMainForm)
Within this form is a subform (SingleQuartersSubForm) that uses another form as it's source object (B_SingleQuartersAssignmen
B_SingleQuartersAssignment
SELECT RankGrade, SurName, SQ_TransAutoNum, TrgActivityAutoNum, SvcNum, CF_Rank, RoomAssignment, RoomStartDate, RoomResEndDate, RoomMethodOfPayment, RoomResCounter, RoomResNotes, BldgNum + ' ' + RoomNum AS RoomAssignText, RecCreateByUserName, RecCreatePC_Name FROM A_BuildingsTbl
Although only SvcNum, CF_Rank, SurName, RoomStartDate, RoomResEndDate, RoomAssignText and RoomResNotes are displayed on the form.
So the user will choose the SvcNum (which auto populates the rank and last name), the start and end dates. Then they press a little button to assign a room. This button opens a new form where the user can choose the room to assign. Once they choose the room they press the enter button which is supposed to update B_SingleQuartersAssignment
Forms
ps:
see this link as an example of what appears on the public forums:
http://www.access-programmers.co.uk/forums/showthread.php?t=61865
see this link as an example of what appears on the public forums:
http://www.access-programmers.co.uk/forums/showthread.php?t=61865
ASKER
The DoCmd.RunCommand acCmdSaveRecord command is nowhere in the code. I tried adding the Me.Dirty code in a few different places anyways with no luck. I also tried the following just for the hell of it:
Forms![B_RationActivityMai
If Forms![B_RationActivityMai
Forms![B_RationActivityMai
End If
Forms!B_RationActivityMain
The funny thing is that the line:
Forms![B_RationActivityMai
kicked the same 16389 error.
Forms![B_RationActivityMai
If Forms![B_RationActivityMai
Forms![B_RationActivityMai
End If
Forms!B_RationActivityMain
The funny thing is that the line:
Forms![B_RationActivityMai
kicked the same 16389 error.
That is odd!
Did you try the following:
1. comment out the requery line then test if you still get the error (knowing that the query output won't be correct....just a test to definitely pinpoint the requery line as the error line)
2. if the requery line is definitely the problem, then verify that [SingleQuartersSubForm] is the name of your subform control (i.e. the subform container). Often the subform control and the source object (the form inside the container) have the same name, but sometimes they don't.
Did you try the following:
1. comment out the requery line then test if you still get the error (knowing that the query output won't be correct....just a test to definitely pinpoint the requery line as the error line)
2. if the requery line is definitely the problem, then verify that [SingleQuartersSubForm] is the name of your subform control (i.e. the subform container). Often the subform control and the source object (the form inside the container) have the same name, but sometimes they don't.
ASKER
ok I commented out the requery line and didn't get an error. It's definetly the problem. Also [SingleQuartersSubForm] is definetly the subform container. You can see in this screen shot.
http://i12.photobucket.com/albums/a217/rshackleford/StupidError.jpg
http://i12.photobucket.com/albums/a217/rshackleford/StupidError.jpg
The Access 2003 compiler is more strict about using the correct operator, so this might be it:
Change the the dot {.} operator before >>> .[SingleQuartersSubForm] in the assignment statemement on the first line below to the bang operator >>> ![SingleQuartersSubForm] . The requery line has the right operator..... maybe the assignment did not take place and the requery blew up. To verify, place a code break immediately after the assignment statement but before the requery, and check if the assignment actually took place.
Forms![B_RationActivityMai
Forms!B_RationActivityMain
Change the the dot {.} operator before >>> .[SingleQuartersSubForm] in the assignment statemement on the first line below to the bang operator >>> ![SingleQuartersSubForm] . The requery line has the right operator..... maybe the assignment did not take place and the requery blew up. To verify, place a code break immediately after the assignment statement but before the requery, and check if the assignment actually took place.
Forms
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DoCmd.RunCommand acCmdSaveRecord
If you are using the above code line before a requery, try substituting the following code in its place and see if it helps. As always, make sure you have your system backed up before making any changes.
If Me.Dirty Then
Me.Dirty = False
End If
Hope this helps.