Search results

Thanks for the quick reply but I'm getting the following error when I compile: Also, I'm using Access 2007.

Hi guys I have the following query that displays the selected data as a Pivotchart. DoCmd.OpenQuery "qPaymentsQueryJustMonth", acViewPivotChart I action the about via an VBA Event. This all works fine The graph displays the "Sum of Payments Amount" on a monthly graph just for all the...

Hi Gasman, The penny has finally dropped! I was focusing on the data in the table and not the data in the query result....all fix and now working as it should. Thanks again for you patience and help. Cheers Greg

Thanks Gasman, Sorry about the issue with one of the fields being defined as a memo...this was done accidentally. I have implemented your code but I still cannot get the sku-00004 to work...it just doesn't find it. I have attached the database that I am using for testing. Cheers Greg

Thanks again for help me with this but I am just not understanding why the following code works perfectly when using and searching the Location table but doesn't work consistently when using and searching the Parts table: If Len(txtSearchMain.Text) > 0 Then filterText =...

Thanks but when I type in sku-000 I still get the error message.

I just tried it and it still does not work...it's actually worse.

Thanks for the quick reply. How will this fix the issue of finding only some is the SKU numbers?

Hi Everyone, I have been trying to resolve this issue for hours and have finally decided to ask for some help as I am sure it is something very simple I'm missing. I have provided a "cut down" sample database (XXLateral.zip) containing just the form and 2 tables and a query. It is in Access...

Hi Can you please explain this for me? Cheers Greg

Hi Micron I was hoping to not have to change the data format of the field from Currency to Number. This entire process is doing my head in a bit. I have tried multiple times changing the field type to Number, Double fixed and I get differing results. Sometimes I will still get the...

Hi Guys I have spent many hours today trying to sort this issue out but I'm throwing my hands up for some help. I have a table called "Parts" and a query called "qExportPartsToCSV". I have attached a sample database with these in it. The Parts table contains records relating to various cars...

It’s basically the code you helped me with in an earlier post https://www.access-programmers.co.uk/forums/threads/i-cant-seem-to-get-this-simple-formula-working-when-using-a-percentage-field-in-the-calculation.311088/

Hi Dbguy. I think I tried that and it almost worked but it was not capturing the “before” value of the field.

Hi guys I have a continuous form displaying a number of text boxes. I have a text box called “txtNewPrice”. I have some VBA code that I use to keep track of when the user manually changes the data in txtNewPrice via a module that is triggered by the “Before Update” event. this all works...

Hi Gasman I want to maintain and always have the same Markup when the cost price (wholesale) price changes ( usually increases) so this formula uses the existing Markup and new wholesale price to work out the new purchase price.

Thanks for all of the help guys. I learn a lot from this forum.

You're a legend DBGuy! It works like a treat. Cheers Greg

Hi guys I have a table that contains a list of Parts in a stock and inventory type of database. It has field called "[Markup]" that contains the percentage markup and is calculated and updated each time the database is start via a query. The [Markup] field is defined as a Percentage field...

Hi guys, I discovered that I had many forms that had tabs that contained other sub forms that were all being opened when the main form was being opened. These sub forms all had queries some of which were complex and this is what was eating up my handles. I changed the logic so that the...