everything was working fine until a few minutes ago. I have not change any code but my forms show up with no data as if it was a new record. I have list form where a user can select a record to get a detail information about the record. Its working fine on my backup but i havent change any code regarding the open or close form. this have happend before to me, at that time i didnt have time to look at the issue so i use the backup to restore it but this is really bothering me who no records show up. in the design mode the filter is set to the record that i click so it passing the parameter but for some reason it not showing up any records, the form is tied to right record source so there is no problem there
Corrupt or ghost form
- Thread starter Thinh
- Start date
GohDiamond
"Access- Imagineer that!"
- Local time
- Today, 13:59
- Joined
- Nov 1, 2006
- Messages
- 550
Try Compact and Repair: Tools\Database Utilities\Compact and Repair Database...
Let us know what happens,
Goh
Let us know what happens,
Goh
I'm glad you have made a backup, as you'll need it. The database has become corrupted. Sometimes, a compact/repair will fix it. Almost all the time, a decompile will fix it, although that takes a bit more effort. (Search for "decompile" in these forums for instructions.)
I've found that the easiest solution is to open a new copy of Access, create a new blank database and then drag all of your old tables, queries, forms, modules, etc. from the old corrupted DB into the new DB. This seems to correct it 99% of the time.
I don't know what caused your corruption -- it can be any number of things -- but that's at least one solution. And you've apparently been doing it, but keeping making those backups at regular intervals.
I've found that the easiest solution is to open a new copy of Access, create a new blank database and then drag all of your old tables, queries, forms, modules, etc. from the old corrupted DB into the new DB. This seems to correct it 99% of the time.
I don't know what caused your corruption -- it can be any number of things -- but that's at least one solution. And you've apparently been doing it, but keeping making those backups at regular intervals.
The first thing i tried was compact and repaired but nothing
i never got any error about corrupt data or anything and second for some reason the same code works on a different form that why i am clueless.
I use the same code and pointed to a different form and it worked when i changed it back to the right form it shows up the first time but any time after that it just shows no data and i added a record navigation to see if it pulls all the record when i go into datasheet mode it it display only 1 records. it display one filter records when i use the list to enter the form. This have happended to me before so i just find it so weird. its like a ghosting effect. I would really get to the button of this since it really bothering me. I had to use a backup again to restore it.
i never got any error about corrupt data or anything and second for some reason the same code works on a different form that why i am clueless.
I use the same code and pointed to a different form and it worked when i changed it back to the right form it shows up the first time but any time after that it just shows no data and i added a record navigation to see if it pulls all the record when i go into datasheet mode it it display only 1 records. it display one filter records when i use the list to enter the form. This have happended to me before so i just find it so weird. its like a ghosting effect. I would really get to the button of this since it really bothering me. I had to use a backup again to restore it.
CraigDolphin
GrumpyOldMan in Training
- Local time
- Today, 10:59
- Joined
- Dec 21, 2005
- Messages
- 1,578
You haven't by any chance set the DataEntry property of the form to 'Yes' have you?
It's a corruption in the DB. It will keep happening until you move all the objects to a "fresh" DB, as I suggested before. Again, there are a lot of things that can cause it and yes, it's a big pain in the butt. But once you move it to the new DB, the problem should automagically disappear. I believe the decompile may fix it as well.
