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...
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.