M
Matthew Schwarz
Hello,
I have very little Access and Coding experience.
I'm trying to create a simple database to let me track documents my office
creates about certain events. For each event, we create an Excel file from a
template, and a Word document from a template, then we send it for review to
certain other offices.
For my form coding question:
On the form, once I get to the field "Word Document" I'd like Access to
determine if a Word document is already attached to this record's specific
primary key number. If not, open up a new one from the template (let's say
c:\Wordtemplate.dot) and automatically save the file as
"c:\saves\primarykeynumber.doc". If said document already exists then when I
click on the field "Word Document" the file should open.
On the form, once I get to the field "Excel Document" I'd like Access to
determine if a Excel document is already attached to this record's specific
primary key number. If not, open up a new one from the template (let's say
c:\Exceltemplate.xlt) and automatically save the file as
"c:\saves\primarykeynumber.xls". If said document already exists then when I
click on the field "Word Document" the file should open.
So, for example, my form would be in column format.
The fields could be:
DateCreated, Name, Purpose, Word Document, Excel Document
For a new record, I would fill in the first three fields and on the fourth a
new Word document based on the template would open, and when saved would
automatically save as something like 001.doc.
If I'm on a previously created record, then when I get to the fourth field
the file already created would open.
Any suggestions? I really appreciate it.
I have very little Access and Coding experience.
I'm trying to create a simple database to let me track documents my office
creates about certain events. For each event, we create an Excel file from a
template, and a Word document from a template, then we send it for review to
certain other offices.
For my form coding question:
On the form, once I get to the field "Word Document" I'd like Access to
determine if a Word document is already attached to this record's specific
primary key number. If not, open up a new one from the template (let's say
c:\Wordtemplate.dot) and automatically save the file as
"c:\saves\primarykeynumber.doc". If said document already exists then when I
click on the field "Word Document" the file should open.
On the form, once I get to the field "Excel Document" I'd like Access to
determine if a Excel document is already attached to this record's specific
primary key number. If not, open up a new one from the template (let's say
c:\Exceltemplate.xlt) and automatically save the file as
"c:\saves\primarykeynumber.xls". If said document already exists then when I
click on the field "Word Document" the file should open.
So, for example, my form would be in column format.
The fields could be:
DateCreated, Name, Purpose, Word Document, Excel Document
For a new record, I would fill in the first three fields and on the fourth a
new Word document based on the template would open, and when saved would
automatically save as something like 001.doc.
If I'm on a previously created record, then when I get to the fourth field
the file already created would open.
Any suggestions? I really appreciate it.