I have had the same problem and found that certain strings of text that contained special charactors or CTRL in records caused the problem. By deleting those records and then re-entering them making (ctrl #124) in a memo field to (control No. 124) the database could then be compacted.
On the...
Hi,
It sounds like there is some code somewhere (maybe in the oncurrent event of the form) that sets the focus or default value of the particular field on the form that the cursor goes to. Check this code so that it does not do this and your problem is solved. Rob Freeman
rfreema1@ameritech.net
I have not see the "me.recordset used so I don't know if this is valid. However, is rs defined elsewere as a recordset?
Rob Freeman
rfreema1@ameritech.net
Multi-user database (5 users max)
5 tables
tblProject (main table, projectID is primary key field)
tblCustomer (CustomerID is Primary, projectID is foregn)tblPrincipal (PrincipalID is Primary, projectID is foregn)
tblPart (PartID is Primary, projectID is foregn)
tblNote (NoteID is Primary...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.