I'm thinking about a couple of new projects for work for use on site using laptops with touch screens or a windows tablet.
There are a couple of things I was wondering if they were possible or not.
1. If an access database is on a windows tablet & a form is being filled in would it be possible to have buttons on the form with VBA code behind them so once pressed the onboard camera can be used to take a photograph then import it into the form & then into a report once the form has been completed?
2. All the databases I have made have split front & backends & backup the backend using VBA on closing, what I was thinking was is it possible to complete a form on a database while on site on a laptop/windows tablet, once the form is completed for the day use a button with VBA behind it backup just the entry on the table rather than the whole backend so it can be emailed to the office & the table entry from the site laptop/tablet be imported into a table on the database there, be corrected if required?
Any help, links to something simular or VBA code would be appreciated.
Thanks in advance for anyone taking the time to read this & for any help
There are a couple of things I was wondering if they were possible or not.
1. If an access database is on a windows tablet & a form is being filled in would it be possible to have buttons on the form with VBA code behind them so once pressed the onboard camera can be used to take a photograph then import it into the form & then into a report once the form has been completed?
2. All the databases I have made have split front & backends & backup the backend using VBA on closing, what I was thinking was is it possible to complete a form on a database while on site on a laptop/windows tablet, once the form is completed for the day use a button with VBA behind it backup just the entry on the table rather than the whole backend so it can be emailed to the office & the table entry from the site laptop/tablet be imported into a table on the database there, be corrected if required?
Any help, links to something simular or VBA code would be appreciated.
Thanks in advance for anyone taking the time to read this & for any help
Last edited: