Putting A New Line Into An Email Messsage

Feb 1, 2006

Hi.
I am just setting up a command button so when it is pushed, outlook opens and I can send a message.
The code for this I got from another thread.

I am sure this is a simple one (?) but in the message of the email, I want numerous amounts of lines, not just the one.

This is the code for the message subject (taking from the thread)

strMessage = "Hello" & " " & Me.cboChampion.Column(1)


I want about 10 lines, not just the one. I tried copying the same line again, but that didn't work

I am sure this is basic coding....just can't find the answer.

Hope this makes sense.

Thanks.

Frank.

View Replies


ADVERTISEMENT

Putting The Line Under A Letter On Button As Shortcut Key

Sep 5, 2006

Hi All

How do you assign a shortcut key to a command button.

I want to close a form with the command button - the button would have the words "Close Form" on it with an underline under the C.

If the user does the action eg: Ctrl E - the form will close.

Tee

View 2 Replies View Related

Email In Snapshot Format And Subject Line

Oct 28, 2004

Hi,

I have been reading all of your post for days now and can't find the answer to my question.

I have however found the answer to one of my programming problems. Thanks to all of you.

I have used Access as a data supplier but this is my first attempt to program in access.

I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.

My question(s) are:

1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.

2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.

Thanks so much for all that you have done already.

Tasha

View 14 Replies View Related

Modules & VBA :: Edit Subject Line Of Outlook Email

Aug 27, 2014

I'm trying to write a line of VBA code (in an existing Access 2010 DB) that changes the Subject Line of all selected emails in my Outlook Inbox to today's date.

View 1 Replies View Related

Modules & VBA :: Can't Make New Line When Pushing Outlook Email

Mar 20, 2014

i'm trying to send an Outlook e-mail from Access. Everything works fine except for one thing:

When generating the HTMLBody I use vbNewLine for starting a new line in the string that works fine as long as being in Access. However after displaying it in Outlook there are no any new lines in the mail text; the complete text is one mass.

I tried to use Chr(13) but had the same result.

View 2 Replies View Related

Queries :: Remove GROUP BY Line And Stick Semicolon At End Of Previous Line

Jun 25, 2013

Here's the statement

Code:

sqlfinal = "SELECT Employees.ID, Employees.Name "
sqlfinal = sqlfinal & "FROM ((qryDeptVBA INNER JOIN qrySkillVBA ON qryDeptVBA.ID = qrySkillVBA.ID) "
sqlfinal = sqlfinal & "INNER JOIN Employees ON qryDeptVBA.ID = Employees.ID) "
sqlfinal = sqlfinal & "INNER JOIN qryAreaVBA ON Employees.ID = qryAreaVBA.EmpID "
sqlfinal = sqlfinal & "GROUP BY Employees.ID, Employees.Name;"

If i simply remove the GROUP BY line and stick the semicolon at the end of the previous line (.EmpID; ) it works just fine. How is adding a group by line causing an error?I tried adding another parenthes at the beginning ((( and ending the joins as EmpID); and that failed with the exact same error.

View 12 Replies View Related

Forms :: How To Get Values From Line Items Form Inserted Into QUOTE LINE

Jun 5, 2014

I have a main form with 3 sub forms. The main form is tied to a table called QUOTES_MASTER. The first sub form is tied to a table called QUOTE_ LINE_ ITEMS_DIRTGLUE. It calculates the subtotal when selecting items. The relationship is one-to-many linked on QUOTE_ID.

The second sub form adds up total of all line items and is not tied to a table.The third sub form adds ESTIMATED FREIGHT to the PRODUCT TOTAL and is not tied to a table. how to get the values from the line items form inserted into the QUOTE_LINE_ITEMS_DIRTGLUE table as they are added.

I also want to insert the total value from ESTIMATED DELIVERED into the LINE_TOTALS field in the table QUOTES_MASTER.I tried this code on the product total sub form but it doesn't do anything and there are no errors:

Private Sub PROD_SUB_AfterUpdate()
DoCmd.RunSQL "UPDATE QUOTE_LINE_ITEMS_DIRTGLUE SET QUOTE_LINE_ITEMS_DIRTGLUE.SUBTOTAL = Me.PROD_SUB WHERE QUOTES_MASTER.QUOTE_ID = " & Me.QUOTE_ID

View 6 Replies View Related

Modules & VBA :: Read CSV Transaction File Line By Line And Add Correct Transactions To Access Table

Nov 29, 2014

I have a module which reads a CSV transaction file line by line and adds the correct transactions to an access table and places the wrong ones in a logfile.Now some transactions are rejected twice there is even one rejected six times. Whereas one wrong transaction is processed only once. I am certainly overlooking something obvious in the logic but what. Here is the relevant code.

Code:

Function ImportCSVForConfederation(inputCSV, ORG)
Dim TNO As Integer, TACT As Integer, TABLE As String, TLINE As String, I As Integer, J As Integer, K As Integer
Dim FLD1 As String, FLD2 As String, FLD3 As String, FLD4 As String, LogFile As String, LogPath As String
Dim Lim As String, ITNO As Integer

[code]....

View 8 Replies View Related

Modules & VBA :: How To Import Text File Line By Line

Nov 18, 2014

I am having a little difficulty with my importing in Access. Every time I import my text file, the lines will be jumbled. I have been reading up and I found this recordset code that seems to be what I need:

Code:
Dim strLine As String
Dim intLineNum As Integer
Dim MyDB As DAO.Database
Dim rst As DAO.Recordset
Open "C:TestTest.txt" For Input As #1
Set MyDB = CurrentDb
Set rst = MyDB.OpenRecordset("tblResults", dbOpenDynaset)
CurrentDb.Execute "DELETE * FROM tblResults", dbFailOnError 'Clear tblResults

[code]....

Basically, this code will extract data from the text file as long as it fulfills the Mid$ criteria. Here's where my problem comes. Each line in my text file is of different lengths and I have to capture the entire line.

I think using the Left$ function would work, but I don't know how to determine the character count such that the entire line of text would be inserted into the table.

Another difference between what I need and the code above is that, I am required to store each line into each row of my table, meaning

Line 1 is placed in Row 1 Column 1
Line 2 is placed in Row 2 Column 1
Line 3 is placed in Row 3 Column 1
.
.
.
Line X is placed in Row X Column 1.

View 14 Replies View Related

Forms :: No Line Only Marker In Line Graph

Oct 18, 2014

I can change multiple things on a line graph with VBA.

Me.Graph47.chartType = GraphType ' take 65 for line
with me.graph47
.SeriesCollection(1).border.Color = vbblue ' change the line color
.SeriesCollection(1).border.Weight = LineWeight ' change the line weight to for example 3
.SeriesCollection(2).MarkerSize = MarkerWeight ' Change the marker weight, for example 4
.SeriesCollection(2).MarkerBackgroundColor = vbblue ' Change the marker color,
.SeriesCollection(2).axisgroup = 2 ' put this series on the secondary axis
end with

SeriesColection(1) is line with markers. This is correct.But now I want the seriescollection(2) without line, so only the markers. I cheched the MSDN site from Microsoft. The Excel trick with the macro does not work for me.how to hide the line with VBA for only SeriesCollection(2) in Access?

View 1 Replies View Related

Putting It All Together

Mar 25, 2007

I dont know hot to say this but lets try :rolleyes:


I have about 8 forms each form with a table behind it or a query, so the user starts at the first form selecting this and that, after the selection a button is pressed another form opens the user fills out the information and presses a button and another form opens and so on until all the information have been filled.

My problom is that I want this to be only one window (form), and when the button is pressed this form changes to next window and so on.

Now it works like when the button is pressed a new windows opens and this window (form). The user can see this as a another form I want the first form to change into the second and the second to third and so on.

Hopefully someone understands what I am trying to say.

Best regards
Frodo

View 4 Replies View Related

Help Putting Password On Please Help

May 4, 2006

hi im doing my A level course work and im wanting to put a password on my database, so if i want to look at the tables ect i need to put a password in, i think its something i have to do in quries but im not sure please can someone help me i have to have it finished for tomoz thanxs

View 1 Replies View Related

Putting An .mdb On A Server

Nov 7, 2004

soooo now my client wants the program i just wrote on his brand new server that he doesn't know how to use. i've semi-split my db (i kept my lookup tables with the program to save room for data). i'm not very familiar w/networking. my assumption is that i just put the BE on the server and put the FE on their machines, but i was wondering if i could put both the FE and the BE on the server with a shortcut to the FE so that i could update it and not have to worry about making sure everyone has the most recent copy.

anyone have any suggestions on how to make this run smoothly and make it appear as though i have some semblance of what i'm supposed to be doing?

-Jason

View 14 Replies View Related

Putting Queries In A Folder

Jul 31, 2005

Hello,

I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible?

Having 40 queries all inside the database window is not so convinient...


Thanks in advance for any replies.

View 1 Replies View Related

Help With Putting A List In Access

Mar 20, 2006

i have started to try putting the concrete records i keep on excel into microsoft acces. for each record, i need to make note of the vehicle registration numbers. what is the best way of doing this? if it is possible

Thanks

View 3 Replies View Related

Putting Row Values Into Columns

Nov 17, 2006

Hi,

I have been trying to figure this out for a long time. Any tips/helps is much appreciated it.

I have a table with 3 columns(SSN,DeductionType,DeductionAmount). Let say I have 100 employees. There are 3 records per employee, because each have 3 different deductionType(TypeA,TypeB,TypeC).

I want to create a queryTable that will result with 1 record per individual, with TypeA,TypeB,and TypeC as column names and the DeductionAmount as their values. Make sense? Below is an example of what the new table should look like:

SSN--------------TypeA-------TypeB-------TypeC
022-58-5898------ $10.35-----$25------------$14
036-89-5487-------$5----------$45.69---------$47.33
...
..
.

Thank you VERY much!

By the way, if QueryTable is not the method to do this, please let me know how.
Joe

View 4 Replies View Related

Putting In A Date Range

Jul 20, 2005

I'm a beginner to Microsoft Access, and I just started working on a project for a marketing company I work for. I have to build them a pretty straightforward database which has tables including Clients, Contacts, Vendors, Employees, Timesheets, etc. The point is to have any employee be able to work with the database and enter any piece of information they have into it. Again, it's a pretty straightforward database. Right now, I am working on a search form for specific jobs. For example, if they need to design a website for a particular company, that specific website job will be entered into the jobs table. I am working on the search form right now so that they can search for specific jobs and they will come up.

One of the sections of the form is a date range, for date received. For example, this would apply if they wanted to search for all jobs that they received between 1/1/05 and 7/10/05. In the query that I am designing for this form, I have the table entry "Date Received" apply to both of the two boxes in the form (I titled them "What Date Received 1" and "What Date Received 2"... my boss advised me to title the boxes in the search forms "What ___" to not get them confused with the forms displaying the information). In the query, the code I am using right now for Date Received is this:

Between [Forms]![Search Jobs]![What Date Received 1] And [Forms]![Search Jobs]![What Date Received 2]

I've also tried this code:

(Between [Forms]![Search Jobs]![What Date Received 1] And [Forms]![Search Jobs]![What Date Received 2]) Or IsNull([Forms]![Search Jobs]![What Date Received 1]) Or IsNull([Forms]![Search Jobs]![What Date Received 2])


The first code works if I have things entered into these boxes. However, if I try to search and leave these blank, I never get any results. I tried playing around with some "IfEmpty" statements, but none of those worked. The second code doesn't work either. Does anybody know how I should modify this statement so that if the "Date Received" boxes are empty, it just ignores it? Thanks a lot.

View 2 Replies View Related

Putting 0 Where Field Is Empty

Jan 12, 2006

I have a query which has a field where it shows reservations. if there is no reservation the field is empty.

how can I achieve getting a 0 in this field when it is empty?

View 14 Replies View Related

Putting A Graph In Form

Apr 14, 2005

Hi,

I would like to display a graph in a form along with the fields from a table. The user will be allow to update the table and the graph will be updated. So far I am able to display the graph on the report but I cannot find a way to display the graph on the form. Can somebody help? Thanks in advance.

View 2 Replies View Related

Putting A Query Into A Form

Aug 9, 2006

I would like to put a query or some look up device into my form so that a certain part number can be found and its form opened for changes. How should I do this?

View 1 Replies View Related

Putting A Counter On A Form

Sep 16, 2007

Hello everyone, new member here. I am in charge of a student sign in sign out database at the college where I work. This database has two forms and one table. What I would like to do is include a text box on the first form, which is the sign in form that will display a running total of the students that are signed in. This text box should count 1, 2, 3 etc. each time a student clicks the sign in button. Thanks for the help

View 4 Replies View Related

Putting My Database Online.... My Options??

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

Putting Query Result In One Field

Nov 7, 2005

Hi,

I have a two column table and I want to display all records in the second column but I want it to be displayed in another single field.

Anyone has a trick on this?

Example:

Column1 Column2

001 Basket
002 Jar
003 Pillow
004 Hat


Result should be something like this:

Basket, Jar, Pillow, Hat

View 1 Replies View Related

Putting Command Buttons On Forms

Aug 4, 2005

I ma going to sound a complete idiot with this question, but I have been working on a database for some time now, successfully putting buttons on forms with the wizard, jumping from form to form, form to report, basically the button wizard used to work now it doesn't and I don't think I have done anything stupid. (I hope). The wizard was brilliant, I'm lost without it. How do you restore it?

Thanks in advance guys. :confused:

View 2 Replies View Related

Putting In The Date After Field Is Input

Jan 26, 2006

Sorry guys, I thought this would be simpler than it was!

Basically I just want to update my "Resolution date" field with the date or time now (which I know how to do) but AFTER I input data in my "Resolution" field ie I want a field to automatically record what time I am entering the text in my "Resolution" field?

How do I do this, and can I do it without writing a macro? I thought it was along the lines of After Update, but now I am confused!

Thanks again - I am learning just slowly!

View 5 Replies View Related

Getting Value From Form And Putting It As The Field Criteria?

Jul 11, 2006

Somewhat simplistic question, but I can't seem to get it to work correctly.

SELECT Field1, Field2
FROM Table1
WHERE Field1 = [Forms]![Form1]![Text1];

Form has two quieries, named Text0 and Text1. Text0 contains the Field info for the query to search under.
How do I change it so that this will work.

SELECT Field1, Field2
FROM Table1
WHERE [Forms]![Form1]![Text0] = [Forms]![Form1]![Text1];

Presently I am getting nothing but blank queries. I'm sure its some simplistic thing but I can't figure it out atm.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved