Re: [MS_AccessPros] Offsite Data Entry: MS Access

 

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

 

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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___