473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Edit MS access to Outlook 2010 data Collection form and resend

Jerry Maiapu
259 100+
Hello everyone,
I have searched the forum and internet on collecting data from outlook into access with custom formatting but no there is no resource to assist.

I 'have looked at the following options:
1. Create custom outlook from and connect to access 2010
2.Create outlook form using access to outlook data collection wizard and modify to suit my needs
3. Create inforpath form and convert to outlook form and connect to access.
And what I decided to use is the HTML outlook 2010 data collection form (survey form) generated by MS access 2010 data collection wizard.
However, the generated format is not quite user friendly especially with multiple choice questions where the options appear at the bottom. To answer such a question the user has to press Ctrl + click on link to access the options that are located at the bottom of the form which is not very user friendly.
So I used an HTML editor to move the options close to where the questions appear so that users do not need to scroll down or click on link every time to see their choices.
Now the problem is that the form is no longer connected to MS access since I have modified the form layout. Maybe the connection is lost somehow.
Can someone assist me to reconnect the modified outlook form to the MS access database table? I have not changed anything, just moved the options of each question close to its corresponding question. This is to make available the option right next to the question for easy response.
I don’t know if this can be achieved by placing a code in the HTML source of the form or thwacking some settings in outlook and MS access but I would appreciate if someone can assist me in reconnecting the outlook form back to the access table so that all responses received will be automatically processed/stored in access table.
I am very new to outlook and access 2010 integration and am stuck now.
PLS HELP!!
Thanks..
Feb 22 '13 #1
7 6912
zmbd
5,501 Expert Mod 4TB
JM:
{The feature is not documented very well; however,}
However, here's a start: automation code:
Application Automation
Feb 22 '13 #2
zmbd
5,501 Expert Mod 4TB
Jerry Maiapu:
{As I noted earlier,} the feature is not very well documented.
The HTML form has a very limited template format and it appears that when the email is returned, the html is parsed somehow for a very specific section and if that is altered then the HTML form breaks.
Someone will have to disect the HTML code to see what is happening.
Mar 5 '13 #3
zmbd
5,501 Expert Mod 4TB
I really had to do some digging for this information and it read as not for the faint of heart. Also there's not a lot of detail, just enough be a tad frustrating... still it may prove useful.

I've read thru it twice now and I'm still not entirely sure I have it down yet:

Automate data collection forms using VBA
Mar 6 '13 #4
Jerry Maiapu
259 100+
Honestly, I felt out of place after reading the comments but its ok I respect forum members and try to learnt from every posting and comments here so I will take it anyway.

By the way Neo thanks for stepping in with clarifications.

zmbd, thanks for the link, I was at the crossroads but that will point to the right direction.

I will come back if I achieve what am looking for.
Mar 7 '13 #5
Narender Sagar
189 100+
Jerry, You can achieve what you want by using MS Infopath.
Infopath is perfect choice for Data collection or for surveys.
Infopath forms can be send to users via outlook and data will be stored in your Access Database. (And this is what you want)..
Mar 7 '13 #6
Jerry Maiapu
259 100+
Thanks Narender Sagar.
I guess one of the requirements using infopath i.e the end user need to have infopath installed otherwise it won't work. My target group do not have infopath installed at thier end.
Mar 12 '13 #7
Dear Jerry, have you found a solution to edit your form generated by Access? Do you maybe know where the produced form is generated, what kind of file is it? Is it by any chance a form with the same format as a customisable Outlook form ? I am also trying to change that form (I dont have any programming skills)
Kind Regards
Apr 15 '13 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Iain Miller | last post by:
Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5...
1
by: Iain Miller | last post by:
Currently using & developing a new application in A97. This app has a lot of Name & Address information in it. A lot of that information will be duplicated in Outlook & I suddenly wondered if its...
4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
1
by: deko | last post by:
Does anyone know where I can find code that will grab Outlook Calendar data? I need to get a count of existing future appointments, and possibly the next existing appointment, and dump that into a...
3
by: intl04 | last post by:
Is it possible to create a Word form as the data entry form for an Access database? I didn't see any reference to this possibility in my Access books, so I'm sorry if this is a question that is...
4
by: Martin | last post by:
I want to build a data entry form for creating and updating info on something. When I'm first creating an item all the fields need to be editable. There after some fields become readonly. Most...
2
by: filbennett | last post by:
Hi Everyone, I'm generally unfamiliar with Access form design, but have programmed Cold Fusion applications for a couple of years. I'd like to build a data entry form in Access that allows the...
2
by: seltzer | last post by:
I am using Access 2000 but I also have the 2003 version. I am working on creating a data entry form in Access for a research study. Since there is a maximum of 255 fields per table in Access, I...
8
by: stuchdk | last post by:
background: I have created a series of data entry forms for use of data collection. Each has a table as a record source with the same primary key "survey_id", which is a text field. this is...
2
by: jzalar | last post by:
I recently installed office 2007 just to make my life more difficult. I started to use the Email Forms for data collection last week. Started up my computer yesterday and I could no longer use the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.