Duane -
This is what I am leaning towards... create an excel form with call notes, and forward to the job site tech. Tech updates form, and then when at the office, use the Western Digital MyCloud to sinc the files, from which the office staff can load the data...
On of the issues is that Tech's should not have access to all the data... for security reasons,
And sending an excel file is relativity small. Worst case scenario is to stop by McDonalds or Starbucks on the way to a job site to download emails.
Take care,
Mike
On Tuesday, February 5, 2019, 7:27:24 AM PST, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I would consider using Excel and data queries, DAO, or ADO recordsets to pull data into sheets and then pushing data back into the database. I currently do this regularly allowing users to
1) open an Excel file,
2) make some type of filter selection,
3) download data,
4) update the data,
5) click a button to upload
The file could be emailed to someone between steps 3 and 4. The completed file could then be emailed back for step 5.
Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, February 5, 2019 8:49 AM
To: saccity101@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Offsite Data Entry: MS Access
Sent: Tuesday, February 5, 2019 8:49 AM
To: saccity101@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Offsite Data Entry: MS Access
I would like to see the responses to your question. I have a similar issue at our Housing Authority and creating and tracking work orders.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
On Monday, February 4, 2019 07:35:53 PM CST, saccity101@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
At the office I have my database with all my business info...
What I would like to be able to do is Create a form in Access and Email it to the service tech. The Service Tech could update the form as per job requirements. And then later email the completed form back to the office. So that the updated fields can be loaded into the Office Database...
How can I approach this? Any thoughts?
Thanks Mike the Plumber
__._,_.___
Posted by: Sac City Plumbing <saccity101@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar