LeizladNeb
Technical User
In the creation of a POS system, I am using both Excel and Access in it's development. I need to be able to open a particular Excel template file for data entry on clicking a button in Access. Is this at all possible?
I am using Execel as a Data Capture form using the Template Wizard to export data to Access. I want the two to appear as seamless as possible, but crossing over between the two, I have drawn a blank.
Also, I would like to dynamically add a record to a table and add the current date to the 'Date' entity in the new record.
Any help would be greatfully recieved as Im really struggling with this.
I am using Execel as a Data Capture form using the Template Wizard to export data to Access. I want the two to appear as seamless as possible, but crossing over between the two, I have drawn a blank.
Also, I would like to dynamically add a record to a table and add the current date to the 'Date' entity in the new record.
Any help would be greatfully recieved as Im really struggling with this.