Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

One more mistery

Discussion in 'Information Technology' started by Ben, Jul 28, 2006.

Tags:
  1. Ben

    Ben
    Expand Collapse
    Guest

    In my access database I have an overview page where I have some totals.

    The overview takes the information on some subforms and shows just the
    result.
    This works great except that on some computers, one of them doesn't count.

    Computer 1:
    Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)

    Computer 2:
    Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)

    As you see, nothing changed except for the result...
    How can that be ?
     
  2. Loading...

    Similar Threads Forum Date
    Is There An Increasing Trend Of More And More Sikh Girls Dating Bihari Hindu Guys? General Sep 24, 2016
    Sikhism More Than Just Another Religion New to Sikhism Jul 25, 2016
    Interfaith I Have More Sikhs In My Cabinet Than Modi Does - Trudeau Interfaith Dialogues Mar 12, 2016
    I want to learn more about Sikhism New to Sikhism Jan 11, 2016
    Health More personal stuff about anxiety Blogs Dec 11, 2015

  3. Larry G.

    Larry G.
    Expand Collapse
    Guest

    Are you using a FE and a BE database, the obvious solution is that the data
    is changed on one computer but not the other.
    --
    Never give up, the answer IS out there, it just takes a while to find it
    sometimes!


    "Ben" wrote:

    > In my access database I have an overview page where I have some totals.
    >
    > The overview takes the information on some subforms and shows just the
    > result.
    > This works great except that on some computers, one of them doesn't count.
    >
    > Computer 1:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > Computer 2:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > As you see, nothing changed except for the result...
    > How can that be ?
    >
     
  4. Ben

    Ben
    Expand Collapse
    Guest

    Yes, I am using FE and BE.

    The weird thing is that this is just a record counter and that users cannot
    change anything on that.
    I think I checked all details and there is absolutely no difference.
    One of the users has an older windows version could it be something like
    that... or an installation that was incomplete, or ...???




    --
    Novice


    "Larry G." wrote:

    > Are you using a FE and a BE database, the obvious solution is that the data
    > is changed on one computer but not the other.
    > --
    > Never give up, the answer IS out there, it just takes a while to find it
    > sometimes!
    >
    >
    > "Ben" wrote:
    >
    > > In my access database I have an overview page where I have some totals.
    > >
    > > The overview takes the information on some subforms and shows just the
    > > result.
    > > This works great except that on some computers, one of them doesn't count.
    > >
    > > Computer 1:
    > > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    > >
    > > Computer 2:
    > > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    > >
    > > As you see, nothing changed except for the result...
    > > How can that be ?
    > >
     
  5. Ben

    Ben
    Expand Collapse
    Guest

    Ok, seems like some more stuff are not working either.
    The conditional formatting doesn't seem to work on those computers either.

    There must be something wrong in the Access installation or Windows
    things... anyone knows how to check this?


    --
    Novice


    "Ben" wrote:

    > In my access database I have an overview page where I have some totals.
    >
    > The overview takes the information on some subforms and shows just the
    > result.
    > This works great except that on some computers, one of them doesn't count.
    >
    > Computer 1:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > Computer 2:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > As you see, nothing changed except for the result...
    > How can that be ?
    >
     

Share This Page