Data Collection Through Email

re: Data Collection Through Email

Alan Cossey — Sat, 01 Jul 2006 10:52:30 GMT

This looks really, really good. Using HTML for basic data gathering is good, but the Infopath forms look excellent. Is Microsoft going to release an Infopath "runtime" for people who want to use Infopath forms for such Access-based data collection? I see that various people and companies are trying to do such things and it seems strange that Microsoft have not filled this hole themselves (if I have understood this correctly of course).

re: Data Collection Through Email

AL — Mon, 03 Jul 2006 07:48:07 GMT

Sounds really great!

Please tell us a bit about adding code behind the controls of HTML vs InforPath forms. Does either type of form support any kind of event model (for validatation, etc) ?

re: Data Collection Through Email

Mike Alexander — Mon, 03 Jul 2006 11:44:27 GMT

This feature is no doubt one of the best new features of Access. However, Microsoft Outlook security prevents HTML mail in many organizations. Is there an option to return text responses?

re: Data Collection Through Email

AL — Mon, 03 Jul 2006 18:49:32 GMT

Is there any way to convert Access forms to HTML or InfoPath for data collection? If so, what about code or macros in the form?

re: Data Collection Through Email

Clint — Wed, 05 Jul 2006 19:12:45 GMT

>> Is Microsoft going to release an Infopath "runtime" for people
>> who want to use Infopath forms for such Access-based data collection?

There has been discussion about an InfoPath runtime but we don't have anything to announce on that topic.

>> Please tell us a bit about adding code behind the controls of
>> HTML vs InfoPath forms. Does either type of form support
>> any kind of event model (for validatation, etc) ?

Field and table level validations are enforced when the data is actually added to the records.

You likely won't ever get clientside validation for HTML forms as all popular email clients block script.

InfoPath forms will require users to enter required fields but not field and table validations in the browser message. We will be writing a white paper about how you can create custom InfoPath forms that could have client-side validation rules.

>> Is there an option to return text responses?

Not at this time--something we want to consider for the vnext.

>> Is there any way to convert Access forms to HTML or InfoPath for data collection?

Not at this time--something we want to consider for the vnext.

re: Data Collection Through Email

Micah Rousey — Wed, 05 Jul 2006 20:47:17 GMT

I am already contemplating application of this new feature. I can't count the number of systems I've built already that could have used this feature. (Systems that email invitations to take a survey with a link to a webpage are ok, but this solution is great.) If I stay in the consulting world, this will definately be an added plus.

These questions may be answered in the next post, but if not, I'll ask them now:

Is the email adress of the responder going to be a capturable field?

re: Data Collection Through Email

rmcgaffic — Sun, 09 Jul 2006 16:59:47 GMT

This may be offpoint, but will Access 2007 still work with DAO?

I am trying to install MS Note 209891 "How to fill a treeview control recursively in Access 2000." If you remember, this is a hierarchy of Northwind employees reporting relationships based on the field "ReportsTo".

I have no problem placing the Microsoft Treeview control 6.0 (SP6) control on my form.

The note says that Microsoft DAO 3.6 Object Library must be available, and when I go to my form's code for References and check the DAO 3.6 Object library line and then [OK], the following error message results:

Name conflict with existing module, project, or object library.

Does anyone know if this is by design, a bug, or whether a workaround exists. Note that this note is an update of Access 97 note 167309. If MS has changed the rules, it sure would be nice for them to publish a note update for Access 2007.

Bob

re: Data Collection Through Email

rmcgaffic — Mon, 10 Jul 2006 17:38:32 GMT

I have just determined by experimentation that the following objects have a conflict and may not be used together:

Microsoft Office 2007 Access DB engine objects
Microsoft DAO 3.6 Object library.

Does anyone have some sample code of how to fill a treeview control without using DAO?

Thanks,
Bob

Data Collection Responces

A discussion of what's new in Access 2007 (formerly "Access 12") — Wed, 12 Jul 2006 00:21:45 GMT

In the last post, we talked about sending out data collection emails.&nbsp; In this post, we'll talk...

re: Data Collection Through Email

BCinNYC — Wed, 12 Jul 2006 19:25:06 GMT

YIKES!

quote:
<I have just determined by experimentation that the following objects have a conflict and may not be used together:

Microsoft Office 2007 Access DB engine objects
Microsoft DAO 3.6 Object library.

I say again - YIKES! Is it true that DAO cannot be used in 2007???

This would mean serious retooling of many, many deployed apps...

BC

re: Data Collection Through Email

Neil — Wed, 12 Jul 2006 19:39:53 GMT

Bob, there is no need to use the "Microsoft Office 2007 Access DB engine objects" and the "Microsoft DAO 3.6 Object" library together because they are mutually exclusive. The "Microsoft Office 2007 Access DB engine objects" are a complete superset of DAO 3.6.

None of your existing code needs to change in order to use the new Access database engine objects. All of your existing code will run unmodified.

The code to fill a TreeView Control with data is the same regardless of whether you are using DAO or the new Access database engine objects.

re: Data Collection Through Email

kui — Wed, 19 Jul 2006 06:54:07 GMT

opo[[

re: Data Collection Through Email

Angelo — Sat, 05 Aug 2006 11:11:54 GMT

When receiving replies to my form, messages are not processed by outlook, i.e. they are not sent in the folder defined by the wizard and I don't see "Export data in Microsoft office access" when I right clik on the reply. Addin for data collection in outlook is enabled.
Help?

re: Data Collection Through Email

Tim Gould — Thu, 14 Sep 2006 18:27:37 GMT

I was keen to see if Pocket Outlook (WM 5.0) would be able to handle these email forms - unfortunately it appears not. Is there an add-in that could allow/enable this as filling out these forms on a pda would be extremely useful.