RE: [AccessDevelopers] Best approach for data collection...

I typically create procedures to export to and import from Excel. You would need to make sure the export contains the primary key from the table/list.

Duane Hookom MVP
MS Access

________________________________
> To: AccessDevelopers@yahoogroups.com
> From: afguasp@yahoo.com
> Date: Mon, 29 Apr 2013 15:03:40 +0000
> Subject: [AccessDevelopers] Best approach for data collection...
>
>
>
> Hi,
>
> I have Access 2010. I'm trying to do the following but I'm trying to
> figure out the best way to approach the solution:
>
> I'm sending 20 individuals customized lists that contain 100+ line items.
>
> The end user has to send me a list back with additions, modifications
> or deletions flagged. Many of the users do not have Access.
>
> What is the best approach?
>
> 1) Most of the end users have Excel and my original plan is to
> implement a solution with Access and Excel.
>
> 2)Is there a way to create an executable access database (runtime
> version of access) where the end user would be able to run the the db
> application I created even though they didn't have MS Access?
>
> 3) I haven't used InfoPath but would a better approach be creating an
> Infopath form
>
> Thanks
>
>
>

------------------------------------


Please zip all files prior to uploading to Files section.Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessDevelopers/join
(Yahoo! ID required)

<*> To change settings via email:
AccessDevelopers-digest@yahoogroups.com
AccessDevelopers-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/