Search results

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

Wow... Access 2007 huh? Look forward to using it in about 5 years. haha Thanks for your help!!

hi, i used allan57's code and got lotus notes to send the email. http://www.access-programmers.co.uk/forums/showthread.php?t=131103&highlight=email+lotus+notes

hi jackie, would you be able to tell me how you attached the report to the email? I used Allan57's code for just the emailing portion. http://www.access-programmers.co.uk/forums/showthread.php?t=131103&highlight=email+lotus+notes Thanks in advance for your assistance.

I figured it out. I created a sum query. =DLookUp("[SumOfAllocationAmount]","qryInvoicedPB","[ProjectID]=[Forms]![tblProjects]!ProjectID") Thanks for your help!!

Would that equation work if the tables are setup like this? Project Table: ProjectID ProjectName Invoice Table: (Project can have many invoices) InvoiceID ProjectID Cost Allocation Table (One invoice can be broken out to many different cost centers) TransactionID InvoiceID Cost Center Amount

It works but now all the fields in the project form are locked. Did I do something wrong? Thanks.

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

Thank you !!!

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

It worked! And thanks for the extra tip! I'll make the change!

Hi Bob, I've been reading through this thread and others but can't seem to find the answer. I know it's simple but I just don't know the syntax. I'm just trying to count the records based on the value in a field. Specifically count how many records in the subform where "Type" = Client and...

Sorry.. I tried that too. It actually errors out and brings me back to the VBA screen highlighting that line.

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 liddlem, I understand what you are saying. Now I would like this new "Invoice Balance" field in a subform with mulltple invoices being displayed. How will this field tie back to that specific invoice record on the subform? Thanks,

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