Search results

Hello, I have the following code that lets the user read in a text file and backs up the table and then addes the data to the main table and then removes the imported temp table, works great on my xp computer using access 2003, tried it on my laptop running win7 and access 2003 and it comes up...

Hi all, I am wondering which would be quicker. I have a combo box where a value would be selected. Then I would either have it requery a query to fill in the subform or to create a value and filter the subform and display it. Which would be faster as the record size grows?? I have created...

Hi all, I have gotten a lot further on this thanks to a lot of suggestions and help from the people on this board. You can ignore my guidance question now as I have made a decision. I have the following code which will take 2 values from list boxes and open up a report. I now want to be able...

Hi, I am trying to do a sql select from a query using 2 values from a "view sellers sales" form combo box. I am getting month and user from the combo boxes and I want to select the record from my "report sales query" using those 2 values. I have been trying this for a while but I am so...

Hello, I need some ideas and assistance. I am looking to setup a way to output my sales results. As you can tell I am a newbie on this and trying to help someone out. I have created the forms and they let me search for information and place it on a subform, that works great. It is now...

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...

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...

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)...

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..

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...