Database Error

[Guest]

Hi there- I am experiencing a very strange problem with my database. I have
the following forms that I was working in when the error occured:

Form1: Edits the PM table, has subform for Labor Hours with button for Form2
Form2: Shows info for piece of equipment whose PM is being edited in Form 1,
includes a subform that views info from the table that Form1 is based on.

While in Form2, I noticed that the record I had just modified in Form1 was
not showing the changes I had made. So I changed it, (presumably wrongly) in
Form2. Now the database is not showing the 2 following records (as if they
were deleted), and will freeze and error at the record that was changed
wrongly- either in form view or table view. Below is the information from the
error report- is there any way to correct this issue? Thank you in advance!

AppName: msaccess.exe AppVer: 11.0.6566.0 AppStamp:42cdb33e
ModName: msjet40.dll ModVer: 4.0.8618.0 ModStamp:403430ac
fDebug: 0 Offset: 0004e16f

 

[Tony Toews]

Hi there- I am experiencing a very strange problem with my database. I have
the following forms that I was working in when the error occured:

Form1: Edits the PM table, has subform for Labor Hours with button for Form2
Form2: Shows info for piece of equipment whose PM is being edited in Form 1,
includes a subform that views info from the table that Form1 is based on.

While in Form2, I noticed that the record I had just modified in Form1 was
not showing the changes I had made.

Behind the code in Form1 which opens Form2 you will see code similar
to the following:

Dim stDocName As String
Dim stLinkCriteria As String

If Me.Dirty = True Then _
DoCmd.RunCommand acCmdSaveRecord

stDocName = "FAQ Details"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Add the me.dirty lines of code.

So I changed it, (presumably wrongly) in
Form2. Now the database is not showing the 2 following records (as if they
were deleted), and will freeze and error at the record that was changed
wrongly- either in form view or table view. Below is the information from the
error report- is there any way to correct this issue? Thank you in advance!

Weird That makes no sense. What changes did you make? Can you
undo the changes?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Hi thank you for your reply, and I apologize for the delay in answering! I
will try the me.dirty.
As far as the changes go, I cannot undo them, because the database will
freeze and error any time I approach that specific record- either in table
view or form view! It's bizarre- the DB functions normally otherwise- as long
as I do not attempt to view that single record. I assumed that it was some
kind of "violation" that occured by changing the record while 2 forms ( A
main form and a subform in the other form) for the same table were open. Does
this help?? Thanks!

 

[Tony Toews]

Hi thank you for your reply, and I apologize for the delay in answering! I
will try the me.dirty.
As far as the changes go, I cannot undo them, because the database will
freeze and error any time I approach that specific record- either in table
view or form view! It's bizarre- the DB functions normally otherwise- as long
as I do not attempt to view that single record.

Ah, that's different. That record is corrupted.

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Tony thank you so much for your help- I again apologize for the delay in
answering- I only work PT. I will try this and appreciate your expertise!

 

[Tony Toews]

Tony thank you so much for your help- I again apologize for the delay in
answering- I only work PT. I will try this and appreciate your expertise!

You're quite welcome. Delay is no problem. I'm slow sometimes in
getting back to folks.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm