Using a MSWord (2003) as an access form with autonumbers + serchab

[Guest]

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...

 

[Joseph Meehan]

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.

 

[Guest]

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

 

[Joseph Meehan]

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.

 

[Guest]

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

 

[Joseph Meehan]

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.

 

[Guest]

Thanks
--
Chaim

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.