Linking word file to Access field and Changing Start value of AutoNumber

  • Thread starter Thread starter Abdullah
  • Start date Start date
A

Abdullah

HI there,,

Question 1.

How do I create a field that will attach a file ( MS Word,
Excel or etc) path as a fild to a table in access 2000 and
also be a able to click on that field on a report to have
the appropriate application open that file...????


Question 2.

Can we change the start value of an autonumber filed so it
could be anything we want and increment by any value we
want... Does not need to change once the values are
set...???

Please let me know
 
Q1. Make the field a hyperlink in the tables data type definition for that
field.
How? open the table in design view, change the data type to hyperlink
Q2. use the newvalue property to set the increment value (see help to find
out more) and use an update query to set the autonumber fields start value.
 
Back
Top