Solved Sometimes the contents of the form disappear (1 Viewer)

[AHMEDRASHED]

Hi evreyone ,
why Sometimes the contents of the form disappear and needs to restart the database to fix evrey time !

 

[CJ_London]

not enough information to make any real recommendations

best guess is you have a corruption or there is code doing something in the background preventing or circumnavigating the form refresh. Code may be perfectly legitimate but associated with the wrong event

 

[AHMEDRASHED]

not enough information to make any real recommendations

best guess is you have a corruption or there is code doing something in the background preventing or circumnavigating the form refresh. Code may be perfectly legitimate but associated with the wrong event

Thanks for your reply

the below form photo is in normal , but somtime the contents of the form disappear and needs to restart the database to fix same photo above

 

[CJ_London]

and what about code?

I presume your db is split and if multi user, each user has their own copy of the front end. If not this could be a reason why

Only other thing I can suggest is decompile then recompile your code and/or create a new db and import your objects

 

[AHMEDRASHED]

Only other thing I can suggest is decompile then recompile your code and/or create a new db and import your objects

i will try to do it , thank you so much

 

[CJ_London]

here is a link about how to decompile

The /decompile switch for Microsoft Access

Background information on VBA code compilation and the /decompile switch.

codekabinett.com

 

[mike60smart]

i will try to do it , thank you so much

I am a little concerned that your screenshot shows an ID = T

It is not recommended that you use Text as a Primary Key

 

[Pat Hartman]

You have cropped the images too tightly. We have no context. If you minimize the ribbon and you have a tall form, if you unminimize the ribbon, it cuts off the top of the form. If you are showing us a subform, you have a similar problem. The subform if it is too tall to fit, will scroll up in the main form. If you don't have scroll bars, you can't scroll it down again.

 

[gemma-the-husky]

The contents of a form will disappear, if there are no records to display, and the form's record source is non updateable

 

[GPGeorge]

Thanks for your reply

the below form photo is in normal , but somtime the contents of the form disappear and needs to restart the database to fix same photo above


View attachment 101907

Access is event driven. That means forms respond to events. Moreover, the data available to a form depends on a number of conditions, such as filtering and properties set for the form. In other words, it's a dynamic situation and static screenshots are marginally useful in identifying problems. They show the RESULT of the problem, but not how it got there. We need more context, including the processes that lead to this state. What did you do leading up to it?

 

[Pat Hartman]

OK, we have three different guesses. Perhaps @AHMEDRASHED can post some context info.

 

[AHMEDRASHED]

Thank you so much for replies .
above problem happening 3 or 5 times aday and close the database and open again to fix
Actually I don't have a big information on this database ,
, I'm working to create other database because this one not good

 

[mike60smart]

Can you upload the database so we can see the structure of the tables?

 

[AHMEDRASHED]

Can you upload the database so we can see the structure of the tables?

I will send after vacation after tomorrow