Search results

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

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

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 in advance for your assistance. I've read through the other threads but can't seem to find anything that is simple (not an experienced SQLer so can't really tweak too much) and that would work for my problem. I have a Project table linked to an Invoice Table (1 to many respectively)...

Thanks in advance for your assistance. I have an invoice table and a project table. A 1 to Many relationship from Project to Invoice respectively. Invoice Table: InvoiceID ProjectID InvoiceAmount Status (Paid, Not Paid) I am trying to create a report that lists Total Invoiced and Total Paid...

Thanks in advance for your assistance. I have a project table, invoice table, a cost center allocation table and many inbetween. The first 3 mentioned all have 1 to M relationships respectively. On the project form I have a Total Paid field that I want to populate as users pay invoices. I...

Thanks in advance for your assistance. I would like to hide specific tabs based on the value in a field. I'm using a Case Select function when that field is updated when the user is entering a new record. But also need to make sure the specific tabs show up when the user flips through records...

Hi, I have a vendor form with a list box displaying all the vendors along with more vendor description fields. Selecting the record on the list updates the form record. When I open this vendor form from the main "projects" form it filters based on the vendor selected and opens the vendor form...

Hi, This is my first post. Thank you for reading it. And thank you in advance for your assistance. I have an invoice table and a payments table. One invoice can have many payments (a deposit, final payment etc). The relationship is created. I have a form with tabs that hold subforms. One of...