Search results

It is then using that value to filter a sub form and this is the value that is passed to that filter. I actually found the problem, it was having a problem getting the month correctly, do not know why as it worked on 3 other forms using the same code, this one it did not want to work, so I...

Help... I am losing my mind. I have the following snipet of code, that when it tries to run get the error above, but if I use this off of my purchase date it works with no problem, any ideas would be a big help, both the purchase_date and refund_date are in the same query. Dim StrR As String...

Hello, Thank you so much for the help, that did the trick. Have a great day...

Hello, Thank you for the idea. It did not work though, as it said an invalid reference to Recordset. Thanks for your time on this any other ideas would be appreciated?

Hi, I have the following that runs after a combo box value is selected: If Not IsNull(Me.Combo3) Then strSales = "MonthName(Expr3) ='" & Me.Combo3 & "'" Me.Total_Sales.Form.Filter = strSales Me.Total_Sales.Form.FilterOn = True What I want to do is make sure...

Thanks a ton that really did the trick

Hi all, I am trying to figure out how to calculate the values of items in the sub forms and place them on the main form. The problem I am running into is if the subforms have any of the calculating boxes empty the total would be empty. How can I search or work around this so I can total up...

Hi all, I am trying to filter a subform, I can do a single item per field with no problem. I have one field that has would be as follows: venue <>"amz" And <>"ali" but I am not sure how to code it, even hard code it. Below is what I have for a single filter coding. If Not IsNull(Me.Combo3)...

Thanks a ton for the help. I got it working. You are the greatest....

Hello, Thanks for the idea. I am trying to do it via 2 unattached combo boxes and then send it via a filter command, but I do not believe I can send 2 that way. I am not sure how I would use a query to update the subforms from the main form after one or both combo boxes are selected. The...

Hi all, I have 2 combo boxes, one for month and one for userid and I want to use them to filter the subforms. I was able to filter the subforms using a single combo, but I can not figure out how to get 2 of them to work. Here is the code I got the one to work if anyone needs something...

Hi, I am a newbie and coming down to the biggest part of the database I am creating. Im trying to create a form that will allow the user to enter the month, year and userid from that it will open 4 subforms that have a datasheet view in a 4 tabbed area, 1 subform for each tab. Then have it do...

Hi all, I am looking for anything or site that might have a list of some of the form commands like Forms.forum_name.Refresh I would really like to find a list of items like that that explains them and shows an example. Thanks for any info..

How would I update the view on the form after it does the calculation for a partial refund?

Thanks a ton for all the help, you wont believe what the problem was, I had the partial_refund in the table as the last item, once I moved this up in the location in the table it worked.

Hello, I am getting confused. I am sending the code that is used of a top form that uses an unbound combo box to look up the field. I found this on another site and can not take credit for it as I do not understand what it is fully doing: Private Sub Combo22_AfterUpdate() ' Find the...

Hello, I am not sure on the subform. I do the code as you see but it will not write the new price amount to the main table over the old price amount. It might be a subform, as I am not sure of the terms. Thanks again for the info...

Hello, The refund_amount field is the one that is holding the value. The way it works is in the header area of the form I have the user enters the sku for the search this will bring up the record in a detail area. Also, in the header area I have 2 buttons, the refund and partial_refund and...

Hello, The reason is the items are never really entered, the way the database is setup is it reads in a text file and adds the items to a table. Then I want to be able to enter partial and full discounts as needed, that is what is being done on the form, as it finds the record with a search...

Hi all, I have the following code: If refund Then [refund_less_20percent] = ([refund_amount] - ([refund_amount] * 0.2)) Else refund_less_20percent = 0 End If If partial_refund Then [price] = [price] - [refund_amount] End If The refund and partial refund are...