Welcome to SPN

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

Sign Up Now!

Re: Using a MSWord (2003) as an access form with autonumbers + ser

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

  1. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Chaim M. wrote:
    > Joseph,
    >
    > I like the idea for using the random number generator....
    > Any thoughts on hwo to link the word doc to access as a form?
    >
    > Thanks again


    No as I think it noted, I don't have any experience in doing that. I
    have used Word for printing pretty reports however. That was not difficult.

    >
    >> Chaim M. wrote:
    >> > The form is a service work order, each work order will require a
    >> > unique indentifier, thats where autonumber comes in :)
    >> >
    >> > If you have another idea on how I would go about doing this, please
    >> > let me know.
    >> >
    >> > Thanks

    >>
    >> As long as no one will be using the ID number is such as way to
    >> cause them to worry about a list of numbers like:
    >>
    >> 1
    >> 2
    >> 3
    >> 6
    >> 7
    >> 9
    >> 10
    >> 11
    >> 12
    >> 14
    >> etc,
    >>
    >> Then autonumber is fine. If they will only see the number on a
    >> form and then can use that number to find the data, that will be
    >> fine. But people tend to have problems when they see missing
    >> numbers or they like to use the highest number to obtain a count,
    >> which could be invalid with autonumber.
    >>
    >> Note: one way of avoiding this problem is to use the random
    >> number option so no one will know if a number is missing.
    >>
    >> >
    >> >
    >> >> Chaim M. wrote:
    >> >> >I have a form created in MS Word '03 that I would like to use in
    >> >> > an Access '03 database. I would like to add a automuber field
    >> >> > as well as have the option to search for the record by either
    >> >> > the autonumber (record #) or one of three other predesignated
    >> >> > fields...
    >> >> >
    >> >> > Is this possible? If so, how do I go about doing this?
    >> >> >
    >> >> > Thanks in advance...
    >> >>
    >> >> I have never tried to use Word for a form, but I can make a
    >> >> comment about using autonumbers.
    >> >>
    >> >> I suggest you may not want to use Autonumber for that use.
    >> >> Autonumbers are designed to provide unique numbers. It in not
    >> >> designed to provide numbers in order and for a number of reasons
    >> >> may not do so. As a result using them in any application where
    >> >> the user sees the numbers is likely to end up with confusion.
    >> >>
    >> >> There are other ways of providing the numbers you want
    >> >> depending on the particual application.
    >> >>
    >> >>
    >> >> --
    >> >> Joseph Meehan
    >> >>
    >> >> Dia duit

    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    --
    Joseph Meehan

    Dia duit
     
  2. Loading...


  3. Chaim M.

    Chaim M.
    Expand Collapse
    Guest

    Thanks :)
    --
    Chaim


    "Joseph Meehan" wrote:

    > Chaim M. wrote:
    > > Joseph,
    > >
    > > I like the idea for using the random number generator....
    > > Any thoughts on hwo to link the word doc to access as a form?
    > >
    > > Thanks again

    >
    > No as I think it noted, I don't have any experience in doing that. I
    > have used Word for printing pretty reports however. That was not difficult.
    >
    > >
    > >> Chaim M. wrote:
    > >> > The form is a service work order, each work order will require a
    > >> > unique indentifier, thats where autonumber comes in :)
    > >> >
    > >> > If you have another idea on how I would go about doing this, please
    > >> > let me know.
    > >> >
    > >> > Thanks
    > >>
    > >> As long as no one will be using the ID number is such as way to
    > >> cause them to worry about a list of numbers like:
    > >>
    > >> 1
    > >> 2
    > >> 3
    > >> 6
    > >> 7
    > >> 9
    > >> 10
    > >> 11
    > >> 12
    > >> 14
    > >> etc,
    > >>
    > >> Then autonumber is fine. If they will only see the number on a
    > >> form and then can use that number to find the data, that will be
    > >> fine. But people tend to have problems when they see missing
    > >> numbers or they like to use the highest number to obtain a count,
    > >> which could be invalid with autonumber.
    > >>
    > >> Note: one way of avoiding this problem is to use the random
    > >> number option so no one will know if a number is missing.
    > >>
    > >> >
    > >> >
    > >> >> Chaim M. wrote:
    > >> >> >I have a form created in MS Word '03 that I would like to use in
    > >> >> > an Access '03 database. I would like to add a automuber field
    > >> >> > as well as have the option to search for the record by either
    > >> >> > the autonumber (record #) or one of three other predesignated
    > >> >> > fields...
    > >> >> >
    > >> >> > Is this possible? If so, how do I go about doing this?
    > >> >> >
    > >> >> > Thanks in advance...
    > >> >>
    > >> >> I have never tried to use Word for a form, but I can make a
    > >> >> comment about using autonumbers.
    > >> >>
    > >> >> I suggest you may not want to use Autonumber for that use.
    > >> >> Autonumbers are designed to provide unique numbers. It in not
    > >> >> designed to provide numbers in order and for a number of reasons
    > >> >> may not do so. As a result using them in any application where
    > >> >> the user sees the numbers is likely to end up with confusion.
    > >> >>
    > >> >> There are other ways of providing the numbers you want
    > >> >> depending on the particual application.
    > >> >>
    > >> >>
    > >> >> --
    > >> >> Joseph Meehan
    > >> >>
    > >> >> Dia duit
    > >>
    > >> --
    > >> Joseph Meehan
    > >>
    > >> Dia duit

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     

Share This Page