missing data

[jomara via AccessMonster.com]

Not sure if this is the right place to post this but here is my problem. I
have a multi user database, all info is inputted by forms, all a sales
persons records are sorted by a query and displayed on their screen with a
form. recently i started getting random entries that do not appear in a
sales person form. when i log in as admin i see the lead assigned to the
salesperson and everything looks ok but they cannot see it on their screen
replaced the front end files for the user no luck tried an older vwersion of
the front end no luck. it only happens sporadicly and cant figure out why
any have a guess

 

[Jeff Boyce]

Do those "random entries" never show up, or will they show up if the person
shuts down the application and re-starts it? (or closes the form, then
re-opens it?)

If so, it sounds like a refresh/requery might be in order.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jomara via AccessMonster.com]

had the user log off and back on it is a sporadic problem someone could enter
15 leads in a week and 1 might not show up

Do those "random entries" never show up, or will they show up if the person
shuts down the application and re-starts it? (or closes the form, then
re-opens it?)

If so, it sounds like a refresh/requery might be in order.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Not sure if this is the right place to post this but here is my problem.
I

[quoted text clipped - 7 lines]

the front end no luck. it only happens sporadicly and cant figure out why
any have a guess

 

[Jeff Boyce]

I'm not sure I understand yet... perhaps you and I don't share the same
definition of sporadic.

If your (hypothetical) user enters 15 leads during a week, is that 1 NEVER
showing up, showing up SOMETIMES, or ???

Is there anything that the record(s) that don't show up have in common with
each other (across all users)? For instance, time of day, some code field
value, ...?

If this were mine, I'd look for what patterns there might be for those that
do show up and those that don't.

Regards

Jeff Boyce
Microsoft Office/Access MVP

had the user log off and back on it is a sporadic problem someone could
enter
15 leads in a week and 1 might not show up

Do those "random entries" never show up, or will they show up if the
person
shuts down the application and re-starts it? (or closes the form, then
re-opens it?)

If so, it sounds like a refresh/requery might be in order.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Not sure if this is the right place to post this but here is my problem.
I

[quoted text clipped - 7 lines]

the front end no luck. it only happens sporadicly and cant figure out
why
any have a guess

 

[jomara via AccessMonster.com]

sorry this took a little bit of a back burner for a few days. The problem is
when a salesman enters a new lead if he enters 15 leads in a week maybe 1 or
2 will not show up in his "book" and they never do even after multiple logg
offs and ons. If i log in as admin i can see the leads assigned to him even
though he cant see them.. data is the same across records that show and dont
show. all data is entered through forms. If i run a report it shows the data
he cant see. I have checked and rechecked all the queries behind the forms
and nothing looks out of place. I have even tried to duplicate the problem
myself and havent been able too

I'm not sure I understand yet... perhaps you and I don't share the same
definition of sporadic.

If your (hypothetical) user enters 15 leads during a week, is that 1 NEVER
showing up, showing up SOMETIMES, or ???

Is there anything that the record(s) that don't show up have in common with
each other (across all users)? For instance, time of day, some code field
value, ...?

If this were mine, I'd look for what patterns there might be for those that
do show up and those that don't.

Regards

Jeff Boyce
Microsoft Office/Access MVP

had the user log off and back on it is a sporadic problem someone could
enter

[quoted text clipped - 18 lines]

 

[J_Goddard via AccessMonster.com]

Hi -

Might this be happening for data entered using one particular PC? If so, try
having that user enter his data using another machine (no one else should use
either, for that application). We had a problem where an application simply
would not run properly on one particular PC - the same user had no problems
on other machines. We never did determine the cause, and had to give him
another PC.

John

sorry this took a little bit of a back burner for a few days. The problem is
when a salesman enters a new lead if he enters 15 leads in a week maybe 1 or
2 will not show up in his "book" and they never do even after multiple logg
offs and ons. If i log in as admin i can see the leads assigned to him even
though he cant see them.. data is the same across records that show and dont
show. all data is entered through forms. If i run a report it shows the data
he cant see. I have checked and rechecked all the queries behind the forms
and nothing looks out of place. I have even tried to duplicate the problem
myself and havent been able too

I'm not sure I understand yet... perhaps you and I don't share the same
definition of sporadic.

[quoted text clipped - 19 lines]