Does anyone know how to set up a form so that I can use a command button to browse to a specific file (a la explorer) then append that filename to a customers records ?
I'm playing with a concept of saving Excel generated invoices to a specific folder C:\DB\Invoices for example. This is for single user standalone PC and will never be used over a network.
It would be nice if I could attach the file-path name to the customer records. This would keep the database very small (or such is my theory) but I would also need yet another command button to call up the file that belongs to whichever customer is being browsed in the database.
So the database will have the ability, via a form, to browse to and append a file-path name to a customers records and the last command button would look at whichever file-path name is being currently displayed on the customer details form and open that file when clicked.
Any thoughts, or am I completely nuts and severely over-complicating things ?
I'm playing with a concept of saving Excel generated invoices to a specific folder C:\DB\Invoices for example. This is for single user standalone PC and will never be used over a network.
It would be nice if I could attach the file-path name to the customer records. This would keep the database very small (or such is my theory) but I would also need yet another command button to call up the file that belongs to whichever customer is being browsed in the database.
So the database will have the ability, via a form, to browse to and append a file-path name to a customers records and the last command button would look at whichever file-path name is being currently displayed on the customer details form and open that file when clicked.
Any thoughts, or am I completely nuts and severely over-complicating things ?