missing data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jomara - 18 Mar 2008 20:58 GMT

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

Reply to this Message

Jeff Boyce - 18 Mar 2008 21:30 GMT

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

Reply to this Message

jomara - 19 Mar 2008 12:12 GMT

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
[quoted text clipped - 12 lines]
>> the front end no luck. it only happens sporadicly and cant figure out why
>> any have a guess

Reply to this Message

Jeff Boyce - 19 Mar 2008 18:18 GMT

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

Reply to this Message

jomara - 26 Mar 2008 18:35 GMT

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

Reply to this Message

J_Goddard - 26 Mar 2008 19:14 GMT

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
[quoted text clipped - 11 lines]
>>>>> why
>>>>> any have a guess

Signature

John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Reply to this Message