Thank you so much Neo, that was the nail on the head,
Cheers Eddie
ebasshead
Last Activity: Jan 31 '13, 01:17 AM
Joined: May 28 '07
Location:
-
How can I get all recordset results into email body
Hi Everybody,
I'm having trouble getting all recordset records into the body of an email. I just get one when there should be more. Could you please checkout my code to see where I'm going wrong. Thank you. Eddie...
...Code:Private Sub Command0_Click() Dim rs As dao.Recordset Dim strSql As String strSql = "SELECT tblRRCustomers.ArriveDate, tblRRCustomers.Property, [CustFirstName] & "" ""
-
OK Cool, thank you Neo
EdLeave a comment:
-
How to reply to an open Outlook email from Access
Hi Everyone,
I'm trying to figure out how to reply to an open outlook email via an access button, I've been using VBs docmd.sendobjec t method in the past to start new emails and attach PDFs, but I'm not sure if there's a method to reply to an already open email. If someone could point me in the right direction... santa may visit your house :-)
Thank you for the knowledge
Cheers Eddie -
Getting query results onto form thru Combobox and VBA
Hi Everybody,
Behind a combo box on an open form, I have the below code to run a query, which it does, and pops up the query results.. MaxofID, NPPricePerWeek and IDProperty2, in data sheet view.
I would like to have the query run in the background and not pop up as a datasheet, and then.
I would like to get the results back onto the form for calculations.
Can someone please point me in the right... -
Thank you so much Jerry,
Your recommendation was a great help, noew I can get on with my life... at least until next time.
Cheers EddieLeave a comment:
-
How to use total query result in a form
Hi Everyone,
I'm having problems with putting a result from a totals query in a form which is based on aother query. If I add the totals query to the form query, I'm not able to add or delete records on the form.
I tried to add
Val([NPPricePerWeek]) to bypass the problem but no luck,
I tried to create a txtbox on the form to access the totals query directly =tblRRNewProper tyPrice3!NPPric ePerWeek... -
Thanks so much Neo,
I think setting the date costed as max date is the piece of logic Im missing
Cheers EddieLeave a comment:
-
Hi Neo,
I'm wanting to use the value returned for calculations in another query, ultimately to populate a form and report
Cheers EddieLeave a comment:
-
Finding values based on dates in a query
Hi Everybody,
I'm having problems getting my head around finding a value (price) based on a date range. I have created a table which lists product items, price, and date (that the price will come into effect). Some products have more than one price and date.
What I would like to do is, select the product, select, for example a random date, and the query will find price that the product is valued at, at that time.... -
Thanks everybody,
I'll have to think a little harder about this one
Cheers EddieLeave a comment:
-
Opposite of Chr$(10)
Hi Everybody,
I'm trying to figure out what the opposite of Chr$(10)... "line feed" is, does one exist?
Cheers Eddie -
Hi ChipR,
I tried your suggestion out but so far... no luck
Cheers EdLeave a comment:
-
Trying to get a 0 value from an empty report
Hi Everybody,
I've been building a main invoice report which has a seperate itemised and then summed expenses report inserted on the page.
I am then using the summed expenses for a calculation in the main Invoice report.
Everything works fine unless there are no expenses, at which point the expenses report disappears and so does the summed expenses total (which would be 0).
As a result... -
Hi Everybody,
Please disregard my question, Iv'e just found a workaround, sorry.
Cheers EddieLeave a comment:
-
Formatting a color within an expression
Hi Everybody,
This is probably a simple question but... is it possible to format colors within an expression. I have quite a long expression in a text box, and I would like a line of it to always be in red. Is there something similar to format date or currency that will make a result a different color please. I had a look at conditional formatting but I don't think its the way.
Cheers Eddie -
Thank you Don and Puppy,
Although I've never written VB before I think the vbCrLF is going to be the way to go. Thank you so much for pointing me in the right direction.
Cheers EddieLeave a comment:
-
Thank you,
I tried the <>0 in the criteria section of my query, but it will not include invoices that have 0 extra days or 0 kids etc. These invoices will still need to be reported even though there are 0 extra days, 0 kids...
So much for the easy fix, and now for the hard?
Cheers EddieLeave a comment:
-
Making "0" lines disappear from an invoice report
Hi Everybody,
Firstly thank you for all the help this site has given me over the past year in getting my database to hum, its been awesome.
I'm currently building an itemised invoice report to send to clients, and having a hitch with presentation. At the moment its a collection of individual text boxes showing the number of adults, children, weeks and extra days a family has stayed in a house.
Sometimes... -
Time Syntax problem in IIF statement
Hi everybody,
On my form, I have a time field where the user enters a time, if the user enters a time between 4am and 12pm, I would like my "early checkin" check box to check itself. I thought the below would do it (and Ive tried variations of it) but to no avail.
=IIf([txtArrivalTime]>#04:00:00#,IIf ([txtArrivalTime]<#12:00:00#,-1,0))
Do I need to convert time to a number to use the IIF...
No activity results to display
Leave a comment: