That is a line I was trying to see if it would work. The line that should work starts here and it is called out below towards the middle to populate the email sa Notes
Notes = usrNotes '-- ACEMAN this is the line that should work
'NoteDate = [frmQuote_Notes].Form![Date_reviewed] '---...
TheAceMan1,
I tried to save it to 2k ( I am in 2007) but it will not allow me to save a copy.
I used the code above and I no longer receive the error but no notes are pulling into the email. Maybe a problem with how I am trying to pull the notes in - it is towards the middle of the code
Here...
Ok,
Here is the code I hace so far but I am missing something as a copy of the entire report is being sent the all suppliers instead of each supplier only getting their piece:
Private Sub Command50_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs =...
I know - I checked several times and was still stumped, I am attaching a screen shot showing their names:http://img218.imageshack.us/img218/8397/frmview.png
First of all - Thank you for assisting...
I have edited the code to pull the actual names / fields but I am getting a message: "Microsoft Accesscan't find the field 'frmQuote_Notes' referred to in your expression
CODE:
Public Function usrNotes() As String
Dim sfrm As Form, rst As...
Hello,
I have a report that is generated based on supplier back orders. For example there is 10 different suppliers that have current back orders in our system. I am needing to send each supplier a report of their current back orders.
So for every supplier there would be a seperate email sent...
Hello,
I am sending an email based on the field data displayed in the current form window. A problem I am running into is that there is a subform within the current form and I am wanting to pull the information from that form into the email as well. The subform data = 2 fields (DateCreated)...
I have a form where the form field "Date Due to Customer" is populated - and I would like it to feed the next field "Date Due to Contracts" minus 1 day).
Both fields are in the same table and are of the short date property.
any help is greatly appreciated
Hello,
We have been running some tests on teh performance of MAS90 on both the server and local machine after noticing a lack of performance after upgrading to version 4.10.1.16. The server seems to be fine, but the local machine is hitting at 25% and not increasing - even if there is no other...
Hello,
I have read some of the threads already with this similar topic but it does not seem to fit my needs. I am wanting to do somewhat of a mass email(s).
Here is what I basically want to do:
Send an email to a contact from a table that contains their information, with the list of back...
Well first let me say thank you for assisting but I am not having any luck...
Kruken were you able to get this to work for you?
I tried to do what you were saying but check the attached screen shot showing that it is printing in the body of the order...
problem is that I am reading time from a linked table that is read only.. other issue never done functions so I was hoping to do it right in the query...
I have seen the following expressions used on the net but for some reason it does not work for me:
RoundedTime...
Hello all,
I am trying to round for the first time in a query...
and would like to have the query round to the nearest quarter hour...
Example date:
Hours
1.16
2.73
6.40
Desired results:
1.25
2.75
6.50
to have the hours worked rounded to the nearest quarter hour. Up or Down...
Thanks in...
Dawn... I tried doing the same with mine but for some reason that would not work ... any ideas? It kept pasting it in the body of the report
For some reason the page footer is before the report footer - does not seem right and cannot move it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.