Search results

Hello, I need help figuring out this issue. Any assistance will be greatly appreciated. I have a main form and a subform. I am doing a simple sum of a field in the subform and do that with a unbound field in the footer called [INVSUM]. All works well with this and I could show this value in...

Hello, I have form that uses the datasheet view as the default view. I have a subform within the datasheet where I am summing up a field call Quantity by putting an unbound field in the footer of the subform and referring to it in the main datasheet view. The calculations seem to work but in...

Hello, I have what I thought was a simple problem but seem to be stuck and could really use some help. I have simple form, looking at inventory that I am trying to calculate the sum of the quantity of a particular part that has been purchased over time. This seems to work OK. I have a...

Hello, Im trying to develop certain criteria in a query and having some issue adding operators to the IFF statement. In the criteria section of the query builder I have the following: IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "#2 Or #0","*") I have also tried less complex as I thought...

Hello, I have an Access 2013 database with linked tables to Sharepoint. On several forms I have a button that when clicked, it shows the record in the report as preview. The code I use is as follows for the button on the form. Me.Refresh DoCmd.OpenReport "rptquoteExtreme", acViewPreview, ...

Hello, I have button the when pressed will insert a record (via an insert into query) to the frmMain and several records to the frmSub. The problem is when a new record is created in the main form the auto number primary key advances. This is fine however the linked Child field which is a...

Hello, For the life of me I cant seem to figure out the correct syntax and was hoping someone could provide some help and the specific syntax needed. I had a form "Quotes" that worked perfectly and upon clicking a button opens a report using the following code and set the Quote_ID to the...