Search results

Hi cboTrustee is a String It is indeed a checkbox with true/false datatype - I was under the impression that these were recorded as 0 for false and 1 for true ? I have the 1st filter working off of the cbo again which is great - however the 2nd filter is not doing anything. I would assume...

Hi, I have tried the below but it blocks any data from being shown? I am guessing I have messed it up along the way :o Dim strFilter As String If IsNull(Me.cboTrustee) Then Me.FilterOn = False Else strFilter = "Trustee = """ & Me.cboTrustee & """"...

Hi, So I have a form where the user selects a customer from a combo box - this then applys a filter to only show the results for that customer chosen in the combo box. This works fine but I would like it to only show outstanding orders for the customer also, this is indicated by a check box...

Hi, So I have an input form that users key into, however whenever they edit or enter a new record after they hit the next button it always reverts back to record 1. I would like the form to stay on the current record after the user has finished editing / creating the record. The reason for...

Hi, Apologies for the late response - that was what I was missing, I have been scratching my head for days on that one :o Thank you Demo

Hi, So I have a database that users enter order details into - but I do not wish to have duplicate records. I have prevented that by the following code in the before update portion of the database. Dim Answer As Variant Answer = DLookup("[Order_Number]", "tblOrder_Details"...

You are a star - thank you for all your help !!

Ok I think I managed to work out the parameter part =DCount("Difference","query1","Difference=" & 1) This seems to be returning the correct values - how does it look? Demo

Hi, yes!! it returns the total returned by the query - 6 records Demo

Hi, Yes, its in a form - when I reproduce your code it creates an #error =DCOUNT("[Difference]", "Query1", "[Difference]='1'") Have I not changed the code correctly? & was I suppsed to enter this into a text box as the control source? Thanks Demo

Cheers Paul :)

Hi, I will try. The sample data for A is in the attachment tblOrder_Details - the result I want is in the attachment orders. Thank you Demo

Hi, I want to thank everyone for their help so far I am very grateful - I am just not getting it I am afraid... I have attached a snip of my query so far as requested Demo

Hi, I am having a particulary :banghead:day I cannot work this out from your code, I am very new to Access - when I input it into my query & change the fields I get a syntax error In lieu of permenant names I am using "Difference" as my datediff field & "query1" as my query name. Thank you...

Hi, Thanks for the response - I have been trying to work out how to acomplish this in a query but thus far I am drawing a blank, I have it calculating the differences but as I say I just cannot work out how to make it total the individual numbers. Thanks again Demo

Hi, So I have made a simple database & have it linking to forms & a few reports, again basic. I have however a requirement where I have two dates, a start & finish date for each record in my table. What I need to be able to do is calculate the difference between the two dates & then total the...

Hi, Newbie to Access & VBA coding in general - I am slowly getting my head round what does what though :) I am here to offer any help I can along my journey & also pick up some tips & tricks along the way. Demo