Recent content by peterlee516

we have over 100 extemely busy bankers who are receiving these emails so installing snp reader is not possible. i've tried to write to pdf but haven't been successul. there's tons of code out there for a pdf file but can't seem to make them work. some are very complicated.

For some reason the subform in my report is not showing up in the HTML and Rich Text Format. It works perfectly with the Snapshot format but not everyone receiving the email has MS Access and wont be able to open up the snp file. Thank you in advance for your help.

Hi, I have this code that sends out an email from Lotus Notes (works great!). I just need to figure out how to attach a form or a report. Does anyone know where to add the report/forn name? Thank you in advance. Public Sub SendLotusNotesMail(strMailTitle As String, strLotusNotesUserID As...

Hi Jennifer, After reading that you were able to do alternate row colors, i thought maybe you can assist with me problem. I have a report that has several subreports. For one of the subreports I would like to grey out a row if the "category" for that row is a specific value. Here's my code...

Does that mean there is a way to gray out a line based on an if statment? I tried the following. On Repor Open If me.category.value = "category name" then me.detailfield1.backcolor = number end if The error message is "Can't find the field "category"...."

That worked perfectly! Thank you Bob!

Me too! I'm also looking for the solution to that problem. Any luck?

I've been trying to think about how to go about doing this but I'm stuck. I basically will be receiving 3 data dumps every month. 1) Last Year's Total 2) Current Year's Month to date Total 3) Last Year's Month to date Total For example if the current month is March of 2008. I would get 1)...

If all the reports that include calculated fields need to have their respective forms open, I have to find another solution because I won't be able to do that. Can you please elaborate on how I can do it by storing the results of the calculations?

ah.. so there is a catch. Why is it bad practice to record the result of an equation into the table? For example I have a field named "Total Invoiced" in the Project Table. The control source of the field is...

Really? I've never done that before. How do you do that? Thanks!

Great! I basically have a main form with event information ProjectName Budgeted Invoiced etc.. The invoiced and many other fields have these calculated fields because they are summaries of other tables/queries. When a field has this equation it's more for view only purposes and the result...

Is there any way to update the actual record with the result from an equation like these? 1)=DLookUp("[SumOfAllocationAmount]","qryInvoicedPB","[ProjectID]=[Forms]![tblProjects]!ProjectID") 2)=[BudgetPB]-[InvoicedPB] 3)=[qryInvitations subform]!TotalAllocations Thanks for reading!

Thank you for the reference. I'm still getting a "can't find" message I've tried: 1)Forms!MAINFORM!tblGLCCtransactions_subform.AllocationAmount = Me.InvoiceAmount 2)Me!tblGLCCtransactions_subform.AllocationAmount = Me.InvoiceAmount Do I need to add this (DoCmd.GoToControl...

Hi guys, I'm sure there is an easy solution to this but I don't know it. haha I have a form and a subform. I have a command button that I want to automatically populate 2 values into my subform. I've tried. 1)Forms![tblGLCCtransactions subform]![AllocationAmount] = Me.InvoiceAmount...