I have a form that the user will fill, then email it to a customer.
I dont want to send the whole table, just the values that the user just inserted in the form.
Any idea on how should i do that using Access?
I am aware of the SendObject method, but i never used it, and dont know how. Any help will be very apreciated.
Thank you in advance.
We are a facility maintenance company that do a variety of jobs for many commercial companies with a several different trade groups we have (electrical, hvac, plumbing, painting, masonry, etc...) Our Trade Group Managers submit estimates and budgets for the jobs they are bidding to. I created a database to store all those jobs so we can track what manager has bid to any certain job, what trades are involved, if it has been accepted-rejected-in progress-and such. As of now the managers turn a written (paper) form into me to submit an estimating inquiry request and I put it in the database and print them out a receipt of all the information they submitted to me along with an Inquiry Number (which is the primary key in the database)-then that is how we keep track of that particular bid-with that unique Inquiry Number assigned to it.
Now we are wanting to be able to have this all electronically. So the managers can submit an inquiry request electronically and get a receipt back electronically-either by email or online or whatever. On the form they fill out there are several different trades that are able to be checked off. After they are finished filling out the form I would like for there to be a button at the bottom to email that form to all the checked off trades. How do I go about doing that?
..any suggestions would be greatly appreciated.
Thank you so much!!
Well im close to putting my DB into action, but I'd like to have a form that will show a list of queries and reports where they can be selected and emailed. I would like to be able to choose one or many files. I have created the email module and its working fine, I just thought I could make it a bit easier to send multipule reports with the click of a button. I just can't find a way to list all my queries/reports in a dropdown list. Can someone send me a suggestion on how to do this if posible.. Thanks in advance.
Scott
hi
is there anyway to temporarily store the information being entered into a form before actually writing it to a table. i want information to be added to the table only once the save button is pressed. i dont want the table to be used even as the scratch pad.
Thanks
I have a form, which is used to create proposals. The form has form headers and footers, as well as a page footer.
In the Detail area of the form there are only two fields, Description and Amount, which only take up one line. I want the detail area to determine how many pages the form will be when printed. Can a new description/amount fields line be automatically inserted after I complete one? I guess the question is, can the Detail area of the form grow automatically? If so, how is it done.
Naturally, I only want the Form Header and Footer to be printed once, regardless of the amount of pages the proposal becomes. And, likewise, I want the page footer to be printed on each page. So, if the detail area only has one line completed then only one page will be printed. However, if there are 20 lines in the detail area then two pages or more will be printed.
Any help would be greatly appreciated.
MrAviator
Hi fellow Access battlers!
I've searched high and low on this forum on a step by step on how to do this and everyone's answer is either vague and assumes everyone is an access wizard, or really complex and codey and assumes every one is an access wizard!
I have a "lead sheet database" and I need to add a button on the form which emails just the contents of that current record. My company still handwrites these lead sheets and faxes them to consultants so I'm trying to bring them into the 21st century! An uphill struggle. I'm a code and VB newb by the way.
I've tried sending the form to a report as other posts suggest, but I get an error message about there being too many fields. So I'm stuck. All I need is for each form record to be emailed to a different consultant each day.
(I've had to rar then zip the database file due to size restrictions. I couldn't get the files size down enough by just zipping.)
Thankyou!
My database is stores information about students such as name, student number, programme, email, etc. I have a STUDENT form with this information visible.
I also have a another table and MARKS sub form that contains the details of courses completed by the student and results. I have placed the sub form in the STUDENT form and can see each student's details and a list of their courses.
I want to be able to send this information to the relevant student via email. The student should only receive his information and no one else's.
Can this be done? Do I need to create a report first? Should I be using WORD to produce the emails?
I have a basic design question that I am not sure how to address.
I am trying to build a simple data entry database with a form to take input from the user, store the values in a table. Once the data is gathered into the table I want to use this table to print a report of each record (entered using the form before).
To achieve this objective, I made a form (frminput) with some text fields. Most of the fields on this form are Bound fields to a query (qrymaster). One of the field is a Combo box (whose value is shown from another table). I have designed the RecordSource of this Form to be a Query (qrymaster).
This is a basic Data Entry form where the user selects the Combo box item and based on what he selects, some of the fields in this Form gets pre-filled. The rest of the fields on this form are bound to the query "qrymaster" and the user has to type these fields manually.
Now, I want a Save button here that would save all the values on this form to the table "tblmaster". How do I do this efficiently keeping in mind all the normalization laws on the database?
At this time, behind the Save Button, I have included a SQL statement to insert all the field values into the table "tblmaster".
I am sure there is a better way to do this. Can someone point me in the right direction please?
Thanks.
Dear All!
I'd like to ask you to help me in the following. The issue is basic I think, but not for me...
I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same values). This table is connected with one to one relation to the table which the form bases on.
(An automatic data-transfer would be desirable. If it is difficult a button will do as well.)
Please write if you have got any good idea or solution.
Thanks in advance.
BR
xxyy
I currently have a form that will simply display the values from a query, which was called by a form. What I want is for the header (a text box) in the report to have the value that the user selects from the form that calls the report. Also, when the form calls the report, it only prints it off. I would like to know how the form can just display the report instead.
View 1 Replies View RelatedI have a table where I use 3 date fields in, all with different views.
Field 1: Date as dd/mm/yyyy
Field 2: Quarter: q (shows the same date, but then as quarter of the year.
Field 3: Year: YYYY
Now I have a form that fills all of my fields, but is there a simple way () to populate the other two fields Quarter and Year from the value I entered in Date?
So if I change Field "Date", Fields "Quarter" and "Year" updates as well.
Maybe I don't need to do it in the form, but in the table?
I'm not that good with VB- scripts, and I'm not sure If it is possible to auto populate the table field Quarter and Year directly in the table itself.
Access 2010 frontend, SQL-Server 2008 R2 backend
During filling a form, I generate a code which should include the ID of this record.
But the ID is not available before update of the form.
If I save the record before all fields mandatory are filled, i get an error of course.
How can I manage this and get the ID "earlier"?
I have a form to record student information. On my student table i have a school I.D that links to the primary key of my school table.
My problem is that in my form, i want to be able to fill in the rest of the fields about the school info based on the I.D chosen.
i.e.
student table:
Student id
name
address
school I.D (FK)
School info table:
School I.D (PK)
school name
contact name
email
address
My form that's linked to the student table needs all the information from the school info table in separate fields
but i can only select School I.D in the Control Source Property.
I have a table [Employees] that has the field [FirstName] and [LastName]. On my form [Jobs], I have a combobox [ComboWho]. The combo box has all of the possible first names. When a first name is picked, it makes the last name fill in a textbox.
In the real version, it is a [LastName] is a lot of information, so it is kept in a memo field. I tried to use cascading combo boxes, but it cuts off my text.
I keep getting it to almost work... I've tried about 5 different methods... DLookUp, subform, etc.
Right now, I'm using this code:
Private Sub ComboWho_Change()
Dim location As String
Me.ComboWho.SetFocus
location = DLookup("LastName", "Employee", "FirstName = '" & Me.ComboWho.SelText & "'")
Me.MyTextBox.SetFocus
Me.MyTextBox.Text = location
End Sub
It has properly filled in the textbox. I thought it was working perfectly, but ran into one snag... We have been using a split form... and it won't let me filter that column (Column ComboWho). I think because it is saving everything as numbers instead of text.
ComboWhoDatabase.accdbI've attached a copy of the simplified database.
Can someone give me the code to send email via access form. Thanks
View 2 Replies View RelatedHi all,
I have e-mailed a database and when it arrives at the other end it is read only. I sent it in a zip file.
Using MS access 2003, emailing through a corporates firewall.
Any help would be much appriciated.
I've been working on a database for the last month or so. It's been a slow process since I've been learning Access and VBA in the process.
But my supervisor wanted a copy of it as a progress check to send to his boss. So I sent an email with a copy of the database as an attachment.
THe email went through, but when my supervisor tried to open said email, a dialogue came up saying that Access couldn't open the file because it was "out of the intranet or on an insecure site" or something along those lines
I was just wondering what this meant and how I would be able to send my boss a copy of the database so that it can be reviewed and such. Would this require splitting it?
Thanks in advance,
Nathan
Sorry to drag this forum back to the nursery school but.....
We have set up a database for recording manufacturing trials. The trial details (such as date, product, nature of trial, person responsible etc) are entered into a form. At present this form is then printed and distributed for authorisation and to inform people of the trial.
It would be much more convenient to be able to email the completed form to interested parties so they could review it in advance.
I have seen references to emailing tables etc from Access but do not know how it is done. Can someone explain it to me please in terms an idiot could understand!
Thanks in advance
I have a combobox named: Champion the control source is EmailChamptionID, based on SQL statement
SELECT tblChampions.EmailChamptionID, tblChampions.Champions, tblChampions.cemailaddress FROM tblChampions;
I want the user to be able to select the persons name from the box, which has an email name associated with it cemailaddress. When a command button is selected the person is supose to get emailed, but I keep getting a compile error "method or data member not found" .cemailaddress
the line is:
Private Sub cmdNotifyChampion_Click()
DoCmd.SendObject , , , Me.EmailChamptionID.cemailaddress, , , "TS16949 Non-Conformance #" & Me.Text19 & "", "hello", False, ""
I've also tried
Docmd.SendObject , , , Me.cemailaddress, etc
I guess I'm refering to the email address incorrecly, how would I write it?
I apologies for this thread, I was desperately attempting to avoid the need to post for help, especially as this is a much discussed subject. However, after three days of reading hundreds of threads and searching the web (not to mention winding the wife up) I am more confused than ever.
So, please bear with me, I have tried but everything I've attempted so far has failed.
My query centres around multiple e-mailing. I have a table from which a query runs. The query is called QryAddressBookEmail. The query will bring back anywhere from ten to thirty plus results, dependant upon the search parameters entered. From the query results I would like to e-mail each record. The email address is contained in the query field Email.
I'll be using Outlook Express for the emailing.
Rather than sending each e-mail separately I would prefer if they went as one, (IE Pete@..... , Joh@.... etc) thus avoiding the 'silent email warning - confirm to send' that appears to accompany each e-mail
For the subject and body of the e-mail, if possible, I would like two fields on the form that are populated by the user. These are named 'Subject' and 'Body'.
Again, if possible, the email is to be sent by clicking a command button.
So.. in theory, the user will select their search parameters which brings them back a list of hits. They then enter their subject line and the body of the e-mail directly onto the form and then hit the command button which will send a single e-mail to all those identified.
Also........ Whilst its not essential, anticipating future developments and other peoples wants, could an option be added for the user to attach a document by providing a path for it via a field on the form?
And..... if possible and time permits. Again, anticipating other peoples questions and problems, could an alternative be provided that e-mails each record seperately.
As you've probably already guessed, my VB is limited but I will give it my best shot.
Thanks in anticipation to anyone that can help. It is appreciated the time it takes to answer SFQ's from people like me.
I have a field within a table called E-Mail. I want to send a newsletter to everyone withing the DB. I have created some code which is as follows:
Private Sub testemailer_Click()
Dim rsEmail As DAO.Recordset
Dim strEmail As String
Set rsEmail = CurrentDb.OpenRecordset("QryStoresEmailticked")
While rsEmail.EOF = False
strEmail = rsEmail.Fields("E-mail").Value + ","
DoCmd.SendObject acSendNoObject, , , "jo.bloggs@k-n.com", , _
strEmail, _
"UK KNLogin NewsLetter", , True, ""
rsEmail.MoveNext
Wend
Set rsEmail = Nothing
End Sub
Now this works but it opens an individual email per email address into the BCC part. That a major problem if you have over 1000 contacts to send to. How do i get all my email addresses from my DB into the BCC of an email?
Any help would be much appreciated!
Hello, I am looking for some help on what appears to me to be a very large problem. Hopefully, to others, it's an easy fix. I have a very large database that has several details, of which one is email address.
My report is structure to group first on the email address, 2nd on the cost center, and third on the exeption. I am emailing the report to each individual email on the report. I can get it this far, what I can't get is for the email to only mail out each part of the report that is strictly for that particular email address.
I know this isn't very clear, but right now the entire report goes to each email address, I only want specific pages to go. The kicker to it all is that if I set specific parameters the first time, then I would have to set them every time, because the report varies in length each time it is pulled.
Please helppppppp! Thank You
I have set up a database that holds wedding list details for our shop. The product images are not held in the database itself - I have linked to them using VBA as outlined in the microsoft access help pages.
Now I can print a report absoluely fine, but I can't capture the report to send as an email to wedding guests. A snapshot isn't good enough as I don't want our customers having to download software. I thought maybe I could export the report to Word and then email that as an attachment. However, when I export the report, there are no images in the resulting Word document.
Does anyone have any ideas? I primarily need ease of use for the customers picking up the email at the other end.
Hope someone can help!
hi!
I'm a student It's just my first time to program in MS access and my project requires to automatically send email reports from MS Access...how can i do it??
Hello gang!
I've read through many of the threads relating to sending Email from Access but can't seem to find quite what I'm looking for. I work as a Tutor Coordinator at a local college and I've set up Access to handle a lot of the day-to-day chores that our administrative assistant has to deal with.
One feature that would be absolutely wonderful would be to create and send Emails to students at the click of a button. I have several types of Email I'd like to be able to set up, but the one most needed (and probably most complex) is this:
Students come in to the office and request a tutor. If we have a tutor available, we assign them to an available tutor. If there is no tutor availabe, then every Friday we send out an Email to each individual student saying something like this:
"Dear John Doe - We currently do not have a tutor for MATH 101 at this time, but when one becomes available we will let you know... blah, blah, blah..."
I'd like to set it up so that the body of the message comes from a template - such as a text file (that is easily edited by a user) and populated with fields from a query.
Probably do something like this:
Query the Student_First_Name_field, Student_Last_Name_field, Department_Name_field, Course_Number_field, and Student_Email_field. Send an Email to each Email address pulled from the Student_Email_field and tell them the following - "Dear <first name, last name> we currently do not have a tutor for <department name, course number> at this time... blah, blah, blah..."
Currently the way the administrative assistant handles this is to send each student an Email individually - manually creating each Email with the specific data needed. As you can guess, this is quite time-consuming.
I'm rather new to Access but have been a RDMS programmer (in PICK) for several years. I know what it is I want to do, but don't know how to do it in Access.
Any help?
Would the best way be to use text files for templates?
Can text files be set up with field codes (Access recognizes "<LAST NAME>" to be Student_Master_Table.Last_Name_field)?
I'm guessing this will likely have to be a Visual Basic loop that works with data from a query.
Help? *grin*
I am using Access 2000, Windows XP and Groupwise 6.5. I am trying to email an employee leave report using the SendObject method. I would like to use the SnapShot format. Must I save the report before I send it? I tried acFormatSNP with no success. Thanks for all your help.
View 1 Replies View Related