Information placed in form not displaying in table

pathomps

Registered User.
Local time
Today, 09:50
Joined
Oct 4, 2012
Messages
14
:banghead:Good morning,

I have a problem with my database where the information placed in approximately 6 forms has not loaded into the table. I have no idea where to begin looking to fix this problem. There are approximately 430 records in the database.
Any suggestions I would be happy to try.

thanks PA
 
Has it worked in the Past?
 
Last edited:
Yes, this is the first time I have come across this problem. If you view the records through the form - they are there. When you look on the table they are not.
 
I have gone into design view for my form, selected property view, clicked on record source and have run the form from there. When I view it from here the record is displayed in the table, so I save it. However, when I click out of this view and go back to my table it has gone again. So the records are certainly there, I just can't get them to remain displayed in the table. This is really frustrating because I run a query from this view which is not complete because those darned records aren't in there.
 
Please post your record source here:
 
Uncle gizmo, not sure what you are asking?

Earlier you said:
I have gone into design view for my form, selected property view, clicked on record source

I am asking to see this record source...
 
I have taken a snap shot, how do i attach to the forum here. I can't paste the copy in.
 
Sounds like there is a Filter applied to the Form.
 
Ok, how do I check that? Also, why would it only be happening to a selected few records?
 
See the Navigation buttons at the bottom of the form or check the filter property of the form.

It could happen to any number of records if they don't match the filter.
 
The filter button is greyed out on all the forms. Is there any other way to check if they have a filter attached to them?
 
It won't be the filter then.

Have a look at the RecordSource of the form. Maybe it is query that excludes those records.
 
There is nothing obvious in the record source either. i have deleted the table from this view and reinstalled it, but they still will not come across. It is only affecting one particular user and only since the weekend entries. Should I be looking in that table?
 
One user only?

I assume you did you check for filters on that form in their front end? They may have applied a filter.

If it wasn't just one user I would have suggested a Compact and Repair on the backend because this rebuilds the indexes. If the index had a problem it could leave out some records. But this should affect everyone. I would still try a C&R anyway.
 
I have not split the database, so I'm not 100% sure if I am checking the front end of the form. the database is stored on a local network drive that we all have access to. Each person can log in and update the database as required (we run 24/7, and this is there shift log).
I will open the database through the local server and not citrix and see if I can use the compact & repair that way. It did nothing when logged on through citrix, but you never know, it may work this way.
thank you so much for your help so far. I know it is frustrating giving remote it support. So I really appreciate your help :)
 
If it is not split then anything can happen when multiple users open it. That is the problem here. It can be much worse thanhas happened for you with serious corruption of the data.

All databases should be split, even for single users. It separates the data and program making it much easier to upgrade the FE.
 
I have tried to split it, but after being used a couple of times it becomes corrupt. I have been told that often happens within citrix servers, but I have no choice but to go through citrix.
Any suggestions would help. At the moment I am getting a different problem everyday. The maintenance of the database is a huge burden at the moment :(
 
Everyone should be running a separate copy of the front end in the split setup too or you can get front end corruption.

You will definitely continue to have trouble sharing an unsplit database.
 

Users who are viewing this thread

Back
Top Bottom