Search results

Hi everyone! I need help regarding subtracting two values from two queries. I have search around and found some examples, but I could not make them work with mine because it involves SQL statements and I'm not that familiar with them. Basically I have two queries that sums up the value from...

Hi everyone! This is driving me nuts for hours now... I was trying to look for a solution here, but it seems to relate to a different cases or I'm using the wrong words to search... Anyway, I think this is a very simple problem, yet I'm unable to fix it. I have a subform based on a query...

Hi everyone! This currently affects all my objects, from table up to forms. My problem is that I cannot make the Totals row on the datasheet view to work, nor can I make the form footer sum to work. Usually, I just sum a field at the footer of the subform with a textbox with a value of...

Hi there, I have an existing thread Here. Unfortunately, I have not gone beyond my last post, and my problem seemed to have spilled over to some vba scripting which I'm totally at a lost. To make it short, I have a mainform and a subform. I have a DLookup function in my subform.combobox...

Hi everyone! I have a combo box in a subform that AutoFills textboxes in the subform. The subform combo box also has a Dlookup procedure on "after update" event that has a criteria on what the AutoFill procedure will populate based on the mainform textboxes that is AutoFilled by a mainform...

Hi everyone! This has stomped me. I have a mainform that has 2 subforms (Subform A and Subform B). "SubformA" lets the user add and delete records in datasheet view, while SubformB serves as a summary total of the records that have been added, and is locked. I have made an after update event...

Hi there, I have attached a sample database that I made to help me explain my problem more clearly. I have a combo box query in my "fsubOrderDetail" subform that lists all products including their discounts. However, I would like that "combo box list" filter it's result by matching the...

Hi There, I have these table: tblInvoice tblInvoiceDetail (Related to tblInvoice) tblProduct (chosen through a combo box on a subform based on a query.) I have a combo box where you can select products by its ProductID. However, I would like that item, once selected and added to...

Hi everyone, Novice access user here, I have a problem calling a value from a subform within a subfrom to the mainform. I tried the suggested solutions from the searches I did but still could not figure out what is wrong. Here is my setup: frmMain Detail of frmMain>fsubSubform1 Footer of...

I have been using access on and off for almost a year now, I started using it more frequently to help some family and friends manage their transactions. Let me just say that I have made a few very simple databases that were very helpful but have also made a lot of useless and confusing ones...