How To Collect Data From Outlook In Access 2013
Feb 21, 2013
In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.
View Replies
ADVERTISEMENT
Mar 27, 2014
I am setting up a database using Access 2013, and am trying to test downloading files from Excel. For some reason it is not allowing me to have more then 4 columns in the excel file, it gives the error "Subscript out of range". I thought it was the type of variable at first, but when I tried deleting different columns on both files, the transfer always worked with 4 columns. How do I allow more columns to be transferred?Also, is there a way to not include the row numbers of the excel file as an ID column and only include the ID given in the first column?
View 4 Replies
View Related
Jan 2, 2014
I want to create a Web App in Access 2013 that contains a table of client names, addresses etc, and a second table that contains order details, including client name. It would be nice to ensure that as someone adds a new order they are give a drop down menu containing existing client names, and I can see how you can do this for a brand new table using the lookup data type. But I already have an Excel spread sheet containing client names. If I import this into my Access web app to create the client table, and import the existing orders to create the order table, I then try and change the data type of the client name (in the order table) from short text to lookup, it won't let me!! (If I create an empty client table from scratch, it lets me define the company name as a lookup data type - but I can't then import from Excel into this empty table)
View 14 Replies
View Related
Feb 12, 2014
I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....
My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!!!!!!
Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!!!!
View 14 Replies
View Related
Feb 13, 2014
I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....
My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!
I run Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!
View 3 Replies
View Related
May 5, 2015
I have a simple line chart plotting price against date.
I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this.
The closest I've found is from this:-
[URL]
I can create my array of data but I can't seem to get it to work and think it may be for pivot charts....which access 2013 can't do anymore.
how to plot multiple data sets on the same graph in Access 2013.
View 9 Replies
View Related
Aug 13, 2015
I have a people table; Ethnicity Table; Program Type Table; Attendance Table.
I enter the people into the people table then enter people into the attendance table with lookup for name from the people table and a lookup for program type from program type table and enter date attended. I then run a query on the attendance table to remove duplicates. I created a form from the attendance query there are 3 headers Program, Ethnicity, Name. but the program type comes up as the ID number and not the text name.
The Ethnicity did the same thing but when I added the Ethnicity from the people table to the ethnicity header it show up as the name and I hide the box with the number but when I add the program type from the program type table to the program header is changes the source of the report to the program type table and then nothing shows up. It did not do that when I added the ethnicity type from the ethnicity table to the ethnicity header.
View 1 Replies
View Related
May 20, 2013
I am pretty new to access and trying to create a form to enter data into a table. I keep getting a syntax error. Below is the part of code where I keep getting the syntax.
CurrentDb.Execute "INSERT INFO [Tb1 - Information]([Zone], [Controller], [Controller Type], [Panel], [CB #], [Controller Unit], [IP Address], [Modbus Address], [Sub Address/ HTC#], [PP Location], [Opp Priority],[ Startup Priority]) " & _
" VALUES('" & Me.Txtehtzone & "', '" & _
Me.Txtctrler & "','" & _
Me.TxtCB & "','" & _
[Code] ....
View 1 Replies
View Related
Jan 15, 2015
I have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example:
Table 1:
Name
Age
DOB
Table 2:
Name
Age
DOB
Table 3:
Name
Age
DOB
Table 4:
Name
Age
DOB
Table 5:
Name
Age
DOB
Is it possible to input data into all of these fields in each table using one textbox for each field?
Preferably without having to use code but if it cannot be done without it then that would be fine.
View 7 Replies
View Related
Jun 22, 2011
This is a template under 'sample templates' : "Tasks". it has a button called " Collect data via e-mail". I couldn't test is because when i hit the button it says "microsoft out look could not be started, make sure outlook is installed and properly set up.( the send and receive dialog box in outlook shows is marked and read as complete, but the green bar showing progress is still lit up + calendar contacts,etc. wont sync in mobile device center).
View 2 Replies
View Related
Nov 18, 2007
I have a golf society database. I would like to be able to send, via e-mail, a 'Form' to each of the members of the society so that that they could fill in the data in the form then e-mail it back to me and then import it into the database.
Has anyone got any good suggestions on how I should do this please ?
Cheers
Frank
View 3 Replies
View Related
Feb 13, 2015
I have a database which is populated, but users have to review and amend the data. I was going to ask users to sign in to do this, however my boss wants the data collected via email.
I have looked at using the email wizard, but it produces a rather messy looking email form regardless of if I choose HTML or InfoPath. Is there any way to adapt the email to make it better, or maybe another way of emailing users (through VBA)?
View 1 Replies
View Related
Jun 1, 2011
I am using and modifying (very little) the template "Issues and Tasks" to have my team of 35 people submit any feedback that they may have on a particular campaign.
No one has Access except for me....I would like to use the "Data Collect | Create Email" Feature so that whenever they have any issues they can just fill that out (Save the email in a special folder to be used multiple times). The problem I am encountering is that the "Create Email" button is greyed out and I am not sure why....also, I would like to know if this is the most efficient way of doing this.
View 3 Replies
View Related
Aug 8, 2007
Hi all
I've searched everywhere for a solution to this problem....and every site I come to has numerous examples of how to save Outlook Contact data into a database, but nothing on how to automatically store info from forms into Access table.
So, I assume the code will be in Access. When you run the macro it will look in a certain email folder, return all of the data within the forms in that folder and store it into an Access table.
Does ANYBODY know how to do this? I thought it'd be a much more common problem than it appears to be??
Or am I just being stupid :confused:
Thanks for your help! :)
View 3 Replies
View Related
Feb 6, 2015
It's been some time since I wrote the following, which takes a string made up of "Lastname Firstname Telephone" and writes it at a specific time in Outlook. It uses Late binding so it works across all Oulook versions.
Code:
Public Function funOutputAppointmentToOutlook(dtmDate As Date, strSubject As String)
Dim olApp As Object
Dim mNameSpace As Object
Const olFolderCalendar = 9
Const olAppointmentItem = 1
[Code] ....
I would like to first check the specific Outlook time slot whether the string exists already and only if it does not exist to write it.
View 1 Replies
View Related
Jun 24, 2015
I have a parameter query using a form to collect the data. I put LIKE and wildcard enclosing the parameter to bypass the criteria if the data box is empty. It works well. I have another parameter of date type that uses between two dates. How can I bypass the criteria if I leave the data boxes blank?
View 8 Replies
View Related
Sep 10, 2014
I created a form for adding new data to an existing database and it worked just fine.
Today the form has decided to add time to the date field and this clashes with the table it import to.
Why/how it's changed the date format and how to change it back?
View 2 Replies
View Related
Jun 27, 2013
I am the first to admit I struggle with looping through records.
I am trying to loop through a table and collect external income data and write it to a new table.
My issue may be the way the table is laid out. ???
The attached pictures show the tables. The tblExtInc is where the data are. I am trying to create a table that looks like tblExtIncYr that shows each year and separate entries by item.
How would I loop through tblExtInc and grab ex:$2000 every year for upto 100 years but only get the $1000 for year 6,7,8 only?
View 2 Replies
View Related
May 7, 2013
My department handles all two-way email communication with our customers. We have 8 different email addresses that we use depending on the customer service issue. I'm looking for a way to continuously collect 3 pieces of data from every email that is received: 1) Date Received, 2) Time Received, and 3) To Field (which of the 8 email addresses it was sent to).
As you can imagine the collection of this data to look for trends to assist with staffing needs, as well as analyze build reports for the company to review. I've been working with my IT department on this but they are not sure where to start. My guess is that I need to have them collect the data as it is coming into the email server, right? I'm good with VB and I've built some VBA scripts recently that collect Outlook information, but these only work if the computer I'm using stays on all the time which is not always practical. We'd like to have this database stored on one of our shared drives which collects this data indefinitely from our email server.
View 1 Replies
View Related
Apr 20, 2015
I have a table called Contacts in Access:
ID Email
001 email1
002 email2
003 email3
004 email4
008 email5
010 email6
And I have a table called Data in Access:
ID Date Person Title Yes/No Action
001 20/4 Mr A Consultant
001 20/4 Mr B Supervisor
001 20/4 Mr C Consultant
004 20/4 Mr D Consultant
010 20/4 Mr E Consultant
010 20/4 Mr F Supervisor
What I'm looking for is coding that would start with the first ID number in CONTACTS and see if there is the corresponding ID in DATA. If there is, then I want it to create an Outlook email and have:
1.To field populated with the email address in the CONTACTS table
2.From and CC fields to be my email address
3.The subject line needs to read [ID] "Request" and then today's date backward (e.g. 20150420).
4.The body I need to put some generic wording and then a table with the records from the DATA table (first 5 fields plus the headings).
5. The format of the table etc isn't important as long as it is a table format
If it's created the email I want it to go back to the DATA table and put "Email Created" in the Action column for those IDs.
I don't want the email to automatically send; I only want it to create a draft (as this data needs to be manually confirmed before sending).
If for example it gets to checking in DATA table for ID 002 (and as seen there's none there), I want it to skip creating the email and move on to the next ID.
In the end I would expect to see 3 draft emails open in Outlook ready to be sent, looking something like the below (just 001 below)?
From... my email
To... Email1
CC... my email
Subject: 001 Request 20150420
action the below:
ID Date Person Title Yes/No
001 20/4 Mr A Consultant
001 20/4 Mr B Supervisor
001 20/4 Mr C Consultant
And the DATA table look like this (if only 001 email was created):
ID Date Person Title Yes/No Action
001 20/4 Mr A Consultant Email created
001 20/4 Mr B Supervisor Email created
001 20/4 Mr C Consultant Email created
004 20/4 Mr D Consultant
010 20/4 Mr E Consultant
010 20/4 Mr F Supervisor
I will need to add more data to the CONTACTS table over time, also the DATA table will be different each day so I need the coding to accomodate for both of these possibilities.
View 9 Replies
View Related
Apr 6, 2015
I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.
I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-
Option Compare Database
'Hide Access desktop screen and float Forms on pc desktop
Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long
Dim dwReturn As Long
Const SW_HIDE = 0
[Code] ....
I then have two buttons on a form coded as below:-
Option Compare Database
Private Sub cmd_Hide_dbw_Click()
Call fSetAccessWindow("Minimize", False, False)
DoCmd.OpenForm "frm_Test", acNormal
End Sub
[Code] .....
I have attached a Test Database which demonstrates the problem I am experiencing.
Do the following sequence...............
Open the Test Database. DO NOT ENABLE CONTENT
The Access 'Ribbon'Test_Database.accdb is active and usable
Open frm_Test in Design View in order to inspect, all should be as shown above.
Now click the Enable Content warning
Switch frm_Test to Form View
Click button Hide dbw. Closes the Access Window
Click button Show dbw. Opens the Access Window...HOWEVER....
Attachment 20252The Access Ribbon is locked and usable !!!
I cannot find a way to re-activate the Ribbon
View 2 Replies
View Related
May 5, 2015
I have created a database that is hosted on our company sharepoint. The database contains subcontracts with resource information by geographic location and status. I have built queries and added them as reports to the web app but I need to figure out a way to sum totals on the queries. For example, one report lists all resources of a particular type by 4 different zones and 3 different status. I need to have the bottom row show the total resources.
View 6 Replies
View Related
Jul 4, 2014
I have problem sharing an Access 2013 file from one cumputer and then change the data in the file on another computer, or i can change it but the change wont be made one both computers.
I'm working so i need my secretary to be able to change information or add, but i also need to get the change.
View 2 Replies
View Related
Apr 7, 2015
Using MS Access 2013, part of Office 365, I am trying to construct a report that has a different first page footer than the rest of the document. Googling for answers has produced a few options, but none that seem to work. I have virtually no VBA knowledge. I was hoping that there might be some code that I could place in a label in the footer and have it work.
View 1 Replies
View Related
Oct 26, 2013
I have an Access 2013 database file with many fields. One of them, I'll call it Field 3, is a box which I would like to either leave blank or put a check mark in it. I would like to be able to create an Iif field for Field 3 where a check mark is automatically inserted in Field 3 IF Field 1 - Field 2 <or= 0, otherwise I'd like Field 3 to remain empty.
View 9 Replies
View Related
