Hi All,
I am hoping that you can help me. I've been using access for years but after a long break I'm having trouble breaking back into it.
What I'm trying to achieve is create a database whereby an 'Invoice' document will be produced but also the information is saved in an invoice table.
Currently we use the attached Excel file for the invoicing template which uses macros to hide/show if certain options are selected and auto populate default prices by using VLOOKUPs.
Can someone point me in the right direction on where to begin to
1. Get access to produce the excel document
2. Create the form so that the document can be produced and hold the data in an invoice table
All help is greatly appreciated.
Thanks in advance!
I am hoping that you can help me. I've been using access for years but after a long break I'm having trouble breaking back into it.
What I'm trying to achieve is create a database whereby an 'Invoice' document will be produced but also the information is saved in an invoice table.
Currently we use the attached Excel file for the invoicing template which uses macros to hide/show if certain options are selected and auto populate default prices by using VLOOKUPs.
Can someone point me in the right direction on where to begin to
1. Get access to produce the excel document
2. Create the form so that the document can be produced and hold the data in an invoice table
All help is greatly appreciated.
Thanks in advance!