Is it possible to create a forms that uploads

[zmbaker]

I am trying to think of a consistent way to upload information from people. Can I create a form that I can send out to people and they can return it somehow and the information they uploaded will be entered into a table. Or some other idea

[rpeare]

you may be thinking about this the wrong way. What exactly is your process? You have users that are updating, for instance, excel files and you want to make sure you have the most recent information from each of those excel files in your database? The question is very broad and not really that helpful in trying to give you direction a detailed example of what you want your process does would help.

[zmbaker]

For example i would like to be able to email a form out that has specific fields like name, date, company, item, price this could be a word form. Then be able to easily transfer that data into access without manual entry.

[ranman256]

You could email a spreadsheet.
When it comes back , save it to the same name /place. c:\user\data.xls
(c:\user\data.xls is a linked xl table in the db)
run a macro that imports the data from the above file.

[zmbaker]

I found this but its in 2000 and im working with 2010 so the directions arent the same. http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[ranman256]

Yes, that would work, but involves a lot of code.
My example uses Zero code. So if something changes, all you do is alter the query and/or table.

In the Word version, the form would need to change, the code would need to change, and any access tables.

[rpeare]

Are these people on your network or external to your network?

If they are external to your net work and the only possible way for you to get this information is through email it should be possible to parse information out of an email record without using a form but you would likely need to have a consistent subject line or some other data in the email itself that would help you correctly identify emails you want to process, for instance you could dump all the incoming emails to 'PROCESS PENDING' then when you were done parsing them move them to a folder "PROCESS COMPLETE" or something similar.

If they are within your network but you can't give them access to your database (or don't want to) you can create another application that has your 'temporary' stuff (the stuff you want to get) then perform an import once a day or whatever. The description of the 'why' in your posts is kind of lacking. There are quite literally a dozen ways I can think to do this but you want the one that does the last to disrupt your current business operation.

[zmbaker]

The people are external to the network. Which is why I was thinking maybe having a consistent form would be good so the format is the same no matter what user returns data.

[rpeare]

How are you prompting that collection of data, do you send out a reminder email, or is part of your process that they send you the information every day?

If you prompt them you can supply them a template within your email that they can reply to and write in the values on the appropriate line, then, as I said, parse the outlook record to pull what you want. It would rely on them not changing the format and/or that if there was a failure to import that another email be sent out to the person to warn them that they had altered the file beyond recognition.

[zmbaker]

I will send out a reminder type email that has a template for them to enter information ideally.

[ItsMe]

A little late to the party but, 2010 has an option to create email forms and then Wizard them to a table. My understanding is that the feature is deprecated for 2013, so edits to the feature would have to be done in 2010. Not sure why they are getting rid of it. Maybe an issue with email recipients not opening their email in HTML format and goofing the entire process up.

I would probably just have a website collect the data and then periodically import the data from the website.

[rpeare]

I don't have itsme's capability with web programming but here's a thread to show you how to cycle through items in MS outlook:

http://www.fabalou.com/access/modules/reading_email.asp

[ItsMe]

I will take a wild guess that most any pay web hosting service will offer a WYSIWYG interface to create a web page to collect and store data. I am thinking the tricky part would be retrieving the data from Access and then synchronizing .