I am brand new to access, so please be gentle
I have a lot of documents which i would like to register and save.
The documents are paper, so i need to scan them and save them.
I think i need at least 3 lists.
-Category 1 list
-Category 2 list
-List with all the final data
The list with all the final data should end up with this information::
-ID
-Date
-Category 1
-Category 2
-Batchnumber
-Link to File
-Filename
-Filetype
Is there a template that can halp me with this ?
How to build an input form to register the files with the above information ?
How to build a search form where i could search for a specific document from the final list ?
Search criteria should be:
-Category 1
-Batchnumber
Is it possible to scan directly from a form in Access, or should i save the files in a folder and link to them ?
Hope anyone could help me with this little project.
I have a lot of documents which i would like to register and save.
The documents are paper, so i need to scan them and save them.
I think i need at least 3 lists.
-Category 1 list
-Category 2 list
-List with all the final data
The list with all the final data should end up with this information::
-ID
-Date
-Category 1
-Category 2
-Batchnumber
-Link to File
-Filename
-Filetype
Is there a template that can halp me with this ?
How to build an input form to register the files with the above information ?
How to build a search form where i could search for a specific document from the final list ?
Search criteria should be:
-Category 1
-Batchnumber
Is it possible to scan directly from a form in Access, or should i save the files in a folder and link to them ?
Hope anyone could help me with this little project.