Search results for query: *

I have a form which I am using DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 which does a good job of refreshing/updating everything on the form. Once that is done, my intent was to either open a form, or have a pop-up that informed the user that they needed more money before...

thanks!

I have a form that opens as a pop-up modal when a credit card is used. If it is the first time for a given record that the card is used, it will open to a new record. How do I get the ID number from the main form stored in the appropriate field of the pop-up form? (Yes, I should know this...

I am still struggling...no answers in the newsgroups, perhaps because I am just so obviously clueless as to how to even figure out what part of the code I need or where to find it (and then where to put it in my database.) Surely I am not the only one who has wanted to output graphics to word?

Well, it looks like the lebans stuff does what I am trying to do, but how do I implement it in my database? Now I feel really stupid! I downloaded the zip file, and it gives me a database that has a report with a chart. I would think if I could figure out what he did that I need in my...

I have created an absolutely lovely Access report, which is perfect except for one little thing. (Isn't that always the case?!) I need to be able to export the complete report to MS Word so the end user can add comments beyond the scope of the database and delete information they don't want in...

I have created an absolutely lovely report, which is perfect except for one little thing. (Isn't that always the case?!) I need to be able to export the complete report to MS Word so the end user can add comments beyond the scope of the database and delete information they don't want in the...

Have you tried doing it as a DLookup? It will look up the info in therapisttable based on the EMPLOYEEID variable you entered. Dim strFilter As String strFilter = "EMPLOYEEID = "& Me!EMPLOYEEID Me!PAYRAT = DLookup("PAYRAT","therapisttable",strFilter) Me!EMPLOYEEID =...

A little more fussing around with it and I kind of figured out where my error was. You were absolutely right! Thank you so much! In case you still want to see what I did, it was =Sum(IIf([TXTYPE]='Labor',[PRICE]*[QUANTITY],0)) I am not exactly sure where I was off when I tried it before...

Thanks. I still end up with totals for items within that category that are in the entire table. I need to block out the items that are not on that invoice. I would have thought this would happen simply becuase it is a subform and is linked only to that invoice, but apparently the functions...

I have a subform, which lists data based on the invoice number of the main form. So far, it works great. I then try to get the totals for PRICE of the items on the subform. Again, it works! Now it gets tricky...there are several categories which the various items fall into, like LABOR...