Search results for query: *

Here is a link ot the application that I use... works great and is free: http://www.snapfiles.com/get/clickyes.html

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

2007

I get the same message that it will not allow it for 2k or 2002-2003 versions.

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

...= rs("VendorNo") DoCmd.OpenReport "Current_Back_Orders", acViewPreview DoCmd.SendObject acSendReport, "Current_Back_Orders", "SnapshotFormat(*.snp)", rs("EmailAddress"), "", "", "Current Back Order - Immediate Attention is needed ", "The attached is a listing of items that need your...

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

tyvm - just what i needed, could you recommend some links or sites to help me further study up on using the event procedures / vb

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

Is it possible to change the USER ID of who created the PO to another user?

Anyone???

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

...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: Sum(Round(([LDHoursWorked])/24,15)*24) RoundedTime2: Sum(Round(([LDHoursWorked])*96,0)/96) LDHoursWorked Sum = 15.97 after above expressions = 15.97

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.