missing data

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

--
Message posted via http://www.accessmonster.com

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" u27274@uwe wrote in message
news:815acb7532962@uwe...
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

--
Message posted via http://www.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

Jeff Boyce wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

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


"jomara via AccessMonster.com" u27274@uwe wrote in message
news:8162c48f5e94a@uwe...
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

Jeff Boyce wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

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

Jeff Boyce wrote:
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]
why
any have a guess

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

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


jomara wrote:
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]
why
any have a guess

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via http://www.accessmonster.com