Search results for query: *

I am trying to sum based on multiple criteria. I want to be able to have a calculated sum in one field that can automatically calculate the dollar amount of all records in a transaction that the ysnSP field = "YES". So I created a field in my report and added this below. However it did not...

I have used this code before to populate a new record with a previous records value. This time it is not working. The only difference is the previous time it was on a continuous form and this on is a single form. Can someone point me in the right direction. Thanks again -Pat Private Sub...

I am trying to provided an error check compent to my form where it checks to see if a value in the intWantQty is greater than 1 if so it would prompt the user of a possible error. However when I test the code below it prompts for and value enter even if the intWantQty is 0. Any ideas? Thanks...

I am using the code below to update fields values based on the after update entry in a field. However when I try to run it it wants to update all records in the table and not just the specific CardID. Any ideas on what I am doing wrong? DoCmd.RunSQL "Update tblCards set...

On my order page I would like to have a button to remove and item which is record on the a continous form. I am trying to to use the following code but am getting this error: Code: DoCmd.RunSQL "Update tblTICards set intTICardQQH=intTICardQQH+" & Nz(hold_TIqty, 0) & " where pkTICardID="""...

I have a piece of vba code (from Blueclaw) that I use for inventory control. I have used successfully it in the past on a prototype database that I created and all worked fine. Now I am getting an error listed below. The only difference is the that pkTICardID was a number and in the new...

I am attempting to output a report to HTML. The problem I am having is that Access wants to force the output to multiple HTML files and I need it to be outputted to a single page HTML. I have searched and have not found many solutions to the issue, but I did find a piece of code that may help...

Hi: This is my first post to this forum! I am a fairly novice user of MS Access. I am creating a trade database for sports cards. I want to be able to have a listbox of past due trades that a user can click on a particular trade and it will open the Trading Partner form (frmTradingPartner...