Search results

Hi guys I know that this is a very old post but I have exactly the same issue and can't figure out how to implement the solution... Would you mind posting exactly what the revised code looks like? Thanks very much. Cheers Greg

hi Steve The PartID is a numeric value..... Also, do I need to change the actual query in some way to let it know to expect the filter?

Thanks Sneuberg, I looked a the link and I have it sort of working. Here is my code: Dim sWHERE As String Dim strWhere As String Dim qdf As DAO.QueryDef 'sWHERE = "[PartID] = " & Me.PartID strWhere = Me.PartID MsgBox Me.PartID SetQueryProperty "qDisplayPartSoldHistory", "Filter"...

Hi guys, I have a query that I wish to call via VBA and display the results as a PivotChart. I also want to pass it a parameter to enable me to restrict the amount of data being displayed. I use a command button on a form to trigger the VBA Event> Here is my code: Dim sWHERE As String...

Thanks Anakardian I managed to get things working by using a solution using Excel to merge the files first. Thanks for your help. Cheers Greg

Hi guys, I'm trying to help a friend who has very old legacy system written in some ancient language that hasn't been supported for decades. He has purchased some new software to replace the old system but the old historical data could not be imported into the new system so he keeps the old...

I just figured it out!!!! I didn't notice that the I have the report group/sort option set at the bottom of the screen and it was not sorting on PartName.....thanks for making me look again and finding it!!! Cheers

Hi Stopher I have tried the "Order By On Load" option without success...is this what you mean when you say "Have you tried using the sort functionality in the report editor"?

Hi guys, I have a report that uses the following query: SELECT Parts.*, [PartsSupplierWSP]*[SOH] AS WSPUSD, [Wholesale]*[SOH] AS WSPAUD, Parts.Inactive, [UnitPrice]*[SOH] AS SaleAUD, Parts.Reorder_Level, Parts.PartName FROM Parts WHERE (((Parts.Inactive)=No) AND ((Parts.Reorder_Level)<>0))...

Hi guys I figure this out. All I needed to do was to create a seperate query on the WorkorderParts table and use the Group function....

Here it is!

Hi guys I have an Access 2007 application that I am looking after. It is basically a custom invoicing/Work order system and was originally based on one of the Access templates. It has a table called "Workorder Parts" that contains a list of the parts that are attached to a Workorder/invoice...

Thanks Paul, I went the Query route...

Thanks guys! Solved!

Hi guys I am putting together a pretty simple report based upon a Table called "Parts". This contains a list of parts in the Stock and Inventory and includes the following field: SOH - Stock on Hand Wholesale - Wholesale (Cost) price in AUD PartsSupplierWSP - Wholesale (Cost) price in USD and...

Hi guys, I currently have a subform displaying upt o 40 columns of data and have a number of Button that the user can click to restrict the columns that are viewed. I am using the following block of code to do this and it works fine. I am trying to simplify it if possible. Private Sub...

Thanks mate,

Thanks for the quick reply....I thought the Round function wasn't what I wanted? I have since changed the code and it seems to be working as I want. Do you see any issues using this method?: Private Sub SupplierWSP_DblClick(Cancel As Integer) Dim strvalue As Currency If...

Hi Guys, I have an issue that I just can't resolve and I am sure there is a simple way to fix this. I have a number of records display in a subform in Datasheet view. I have a field called "Me.SupplierWSP" that is defined as Currency in the table. The following VBA code is attached to the...

Hi Galaxiom I figured out what the issue was. The name setting under the Other Property was not "fAll Valid Workorders Owing Money" so therefore the query couldn't find it. Once I changed it to "fAll Valid Workorders Owing Money"....problem solved! Thanks for your help....it's a trap to...