Online Form -> Email -> Access Database
Jul 13, 2005
I’ve recently added form functionality on my website, which runs with the aid of a perl script and sends the results via an email message.
I’m currently able to import, or link, data from a specific mail folder (Outlook 2002) to an MS Access database (Access 2002). However, my problem is the message body, which contains the data I’m interested in, is all placed in the one field.
I would like the data contained in the message body to be imported into separate fields but I have not been able to figure out how this is done.
I can arrange the data within the email message body to conform to a particular format if needed, even HTML, but I can't work out how to import the data into separate fields.
Tried searching this forum but couldn’t find the answers. Perhaps there is a better way of processing online forms, one which I’m not aware of.
My web service does support mySQL and also has ODBC dirvers for Access but this to me seems like an over kill approach particularly since I don't need access to data from the website (active pages)
Can anyone help?
Thanks.
View Replies
ADVERTISEMENT
Apr 8, 2013
Where does one start to look for information on what is needed to set up an online web form that can write to an Access database? I'd like to learn how I could possibly set up an online registration form for clients to use via a web page. I don't really know where to start, but I have seen some information on asp.net stuff. What's the easiest path?
View 6 Replies
View Related
Mar 30, 2007
I want to locate an address online from my access database program upon clicking a button. What will be the best way to do this. Does access database have the tool to link address from your program.
Any help p
View 3 Replies
View Related
Aug 28, 2004
Hello,
I was wondering if anybody could please advise on how to make the existing database(Ms Access) online.
Does IIS server come with Ms office? How to install and what are the steps to make it a client server application.
Would appreciate your help a lot. Thanks
Regards,
GreetInfo
View 2 Replies
View Related
Jul 28, 2007
I am developing a very simple little app online that is giving me 2 main areas of trouble. Basically, all this app does is take information from a form and put it into an access db which is located on a web server (it also sends out an email to the admin when the form is submitted, but that is working fine). So there is one page that is the form and it is pointed at a second page that does the insert to the db, sends the email and then displays a Thank You message. I set up a ODBC connection on the web server to the database that seems to be working fine ( I can run a SELECT query against it and get info out of it - I put one dummy record in the db just for testing).
I'm having 2 main problems as follows:
Permissions - the sys admin is hesitant to open up the folder that contains the DB (and nothing else) to allow for write/read control to the anonymous internet user account. Just to test it, he did and I was able to run the query on the page (although I had problems with inserting - see problem 2 below). The sys admin suggested that I "use different credentials" to access this db in this folder and set up a separate user account/password for this purpose on this folder. 2 questions:
1.) how dangerous is it to allow read/write access for the anonymous internet user account?
2. what kind of code (.asp) could I use to access the DB using the separate user account the sys admin set up?
Insert to the DB not working - When I do run this page, it seems to run fine, with seemingly no errors, but when I do a SELECT query against it, none of the data is there. here is the code I am using:
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=RVU_contact_db"
objConn.Mode = 3
objConn.Open
strSQL = "insert into `contacts`(first_name,last_name,email,phone,addres s,city,state,zip,subject,message,department) " _
& "values ('" & request.form("first_name") & "','" & request.form("last_name") & "','" & request.Form("email") & "','" & request.form("phone") & "','" & request.form("address") & "','" & request.Form("city") & "','" & request.form("state") & "','" & request.form("zip") & "','" & request.Form("subject") & "','" & request.form("message") & "','" & request.form("department") & "')"
objConn.execute strSQL
objConn.Close
%>
I notice that there is a .ldb that seems to stay open in that folder, even when I do a objConn.Close, and I don't seem to be able to delete this off the server.
Any ideas on how to solve these problems? Any help on any of the above greatly appreciated.
Sincerely
johnmr
*
View 1 Replies
View Related
Mar 17, 2015
I have developed on ms access project (MS OFFICE 2010) i am trying to make it online so anyone can open Forms through browser.
Does it possible to make ms access Form online and view in browser? if yes then how?
View 4 Replies
View Related
Jun 12, 2006
I read a lot of threads and some KB articles before this, but am still confused.
Can a copy of the BE database be made on the Server while users are logged on ? Max No. of users is 7.
Does copying a BE while work is going on lead to corruption in the database.
Right now i make a copy of the database thru code and then compress the copy for a backup.
View 2 Replies
View Related
May 25, 2005
I currently have a database on my hd and four other ppl have a copy on theirs. (We are in different physical locations which makes it very slow to put the database on our server).
Currently eveyrone is sending me files that i upload to my copy of the database so i have all of their data.
the obvious setbacks to this is that the data is not live and some of the changes might be missed etc.
i would like to move this and house the tables on my company's intranet
what would i need to do to accomplish this?
View 1 Replies
View Related
Feb 13, 2007
I would like to put my database that I have created online so I can update it from anywhere, and was wondering what are my options - does access have a feature to do this? Or will it involve using dynamic coding to update the tables? I would like to use the forms that I have already created etc ... but is this possible?
I have my own server if this helps?!
thanks
d
View 3 Replies
View Related
Sep 24, 2004
Greetings,
I have created a database to track applicants’ eligibility process. Mainly, a Head of Household will call or apply in person for a medical assistance for self or for child #1, child #2 etc. I created two tables tblHeadHouseHold and tblApplicants with a (one-to-many relationships) and, a main form (frmHeadHouseHold) and a subfrom (sfrmApplicants). So far, the database works fine and just recently, I was approached first, to make this database available online, so that applicants can go to a given center (clinic) to fill in the application, and we then pull the application from the office. Second, to add a new field (source of Application) where applicants learn about our program (Friend, School, Doctor, Advertisement, other) to create a ‘Source Report’, how many from friend, how many from school, from Advertisement etc.
I’m using access 2003 and would like to know:
1. What I need to make the existing db available online
2. Given the type of report I need to generate for ‘Source of Application’ shall I use check box, drop downs,
or a lookup table?
Thank you in advance,
OCM
View 1 Replies
View Related
Jun 27, 2005
Can anyone suggest a good program that will handle scheduled emails to people in our Access database? I need to send an email automatically to each of our employees on their birthday. I need the program for much more than that but that is what I am working on at this time.
Thank you!
Ben
View 4 Replies
View Related
Feb 3, 2006
I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.
Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?
View 2 Replies
View Related
Sep 14, 2012
I would like to know if there is a way to update information in my Access database via e-mail.
I tried to do this, but when I collect from the e-mail, it creates a new entry in the database.
View 1 Replies
View Related
Sep 20, 2006
Hi All,
What's the best way to go about protecting an MS Access database online? Hoping to launch tomorrow, but no can do without protecting the DB first
Basically, I have a database containing some personal information and I need to block people from downloading it, while still allowing my ASP pages to read/write/modify its data.
Can anyone point me in the right direction here? Any relative links, methods, tutorials, etc, would be a fantastic.
I've looked into User-Level Security Passwords, but am not sure if there's a better way to achieve what i'm trying to do (i.e. setting up specific access rights to the folder in which the MDB file is contained).
Thanks in advance...
View 4 Replies
View Related
Oct 24, 2012
I need to let all our suppliers know we have moved and wanted to do this by email. how I use Access database of suppliers email addresses and use them on Outlook.
View 1 Replies
View Related
Sep 17, 2014
I have a requirement to send a email to individual clients via my access database 2003 . I am using the email address of the client in the current open form . I then created a query using the id to filter that particular client, this query then becomes my record set.The content for the email is held in a .txt file , On my c drive . Every things appears fine however the fonts that I select in the .txt file are not being use in the actual email body. I created a word document with my preferred fonts and copied and pasted them into the .txt file but on sending the email the selected fonts do not appear.
I have attached a demo of what I am trying to do . To test enter your own email in the email address field of the form . Note the .txt file is on the C:/ drive.
View 4 Replies
View Related
Nov 24, 2014
I have an Access 2013 database which will generate a pdf report and attach it to an email using the code:
Code:
DoCmd.SendObject acSendReport, "Report Name", acFormatPDF, Nz(To email address, a), , , "Email Subject", "Email body", True
I would also like to automatically attach on the server to this email. Such a file stored such as servernamesharefilename.pdf. Is it possible to do this?
View 14 Replies
View Related
Jun 4, 2005
I am new to Access and not a sophisticated user of computers. I've been given the task of redesigning some forms on an existing data base. I understand how to put the new fields I'm adding into the table associated with the forms I'm working on, but I've having a hard time actually moving stuff around the screen and getting it lined up.
Is there an online tutorial or reference I can go to that will teach me the layout basics?
View 1 Replies
View Related
Aug 1, 2006
Hello to all the Users!
I am new at Access and new to programming.
I have created an Access form that has four labeled control buttons each one with an individuals name. I have the corresponding code:
Private Sub Email_PersonOne_Click()
DoCmd.SendObject acSendNoObject, , , "personone@yahoo.com", , , "Work Request", "A new work request has been submitted."
End Sub
When I have one button and one code the email function works. I want the users to be able to select one out of four people who they want to notify upon completion of the form. So I have four buttons and changed the email address and the names on the buttons but now none of the buttons work.
The code is on the same page separated with just a line between each section.
Does this make sense?
Any input would be greatly appreciated.
Thanks in advance for your time and help.
Sincerely,
DebraF
View 14 Replies
View Related
Sep 30, 2014
I have a form which on selecting a command button sends out an email to a manager to say a specification is ready to be reviewed (this contains a link to a sharepoint site where the spec resides). The "approval" details are stored in by DB also so I would like to have included in that email a link back to the access db and the particular record so the person receiving the email can easily approve, if that makes sense.
Here is my code for generating the email (at the point "To approve please click here" is where I would like my link to go):
[i][i] Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = "<font size=""3"" face=""Calibri"">" & _
[Code].....
View 5 Replies
View Related
Feb 14, 2012
Send an email form Access code with attachment..
I am able to export data to excel file, I would like to send the excel file created to the customer, is there a sample code I can use to do this in a module.
View 1 Replies
View Related
Sep 4, 2013
I am close to getting code to send an email from access with the body of the email populated with a Rich Text textbox from my access form. The problem I am having is that the body of the email is converted to plain text in Outlook which is creating problems for me. How to identify what I can do to convert to rich text or HTML in Outlook? I also want to attach a table that is populated by a query in my application, but i haven't got that far yet.
View 5 Replies
View Related
Jun 15, 2014
The code works perfectly except that a random "0" appears in the body of the email. How to correct the code to remove this annoying little "0"?
Private Sub Command62_Click()
Dim strSubject As String
strSubject = Me.LoadNo
DoCmd.SendObject _
[Code] .....
View 1 Replies
View Related
Dec 9, 2013
I am opening a new mail message in outlook using a button in a form.I want to change the "from" email address to a specific inbox (NOT personal email). Even though the email address is switched, after I hit sent and check my sent items - the email is actually sent from my personal email address and not from the inbox email address i wanted it to be sent from. I have access/permission to sent emails from the other inbox.
Is there a way to make sure emails are sent from specific email addresses and not ONLY personal inbox.What I read online is probably because of some "network" connection issues. Is there a way refresh connection between access and outlook? I am not even sure what the problem is.
View 1 Replies
View Related
Jan 15, 2014
I have a form which has a button to email the data out in a standard email message.
Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String
[code]...
This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.
View 6 Replies
View Related
Apr 10, 2013
I have a macro set to email a form to a person once a condition is met. This works fine but I've discovered that Outlook (2010) has to be open BEFORE this macro is invoked.
I wanted to add a step to the macro before the one that makes it email that basically says to open Outlook.
I have tried the RunApplication macro, but I apparently am not getting the path right. I don't understand what the problem is.
I accidentally dragged Outlook to my desktop and therefore created a shortcut from my Start Menu, but now when I go to Microsoft Office in my Start Menu, Microsoft Outlook isn't one of the options. I can't find the path to where it may reside now.
I am using the path to the shortcut on my desktop.
C:UsersJust MeDesktopMicrosoft Outlook 2010
What else am I supposed to do?
View 8 Replies
View Related
