Search results

  1. A

    Allen Brown browns Inventory Function

    Id say your right about not quite understanding which is why im trying to get this to work. Im trying to get a handle on how functions work in VBA, I have jumped right in the deep end with a fairly complex bit of code. I did test the waters with a simple age calculation which works perfect...
  2. A

    Allen Brown browns Inventory Function

    For my own knowledge im trying to create a database to test and sample the function created by Allen Brown. Using access 2013 to this point I have created exactly as per the instruction by the tutorial. With the exception of my own name conventions eg. tblacq = AcqT...
  3. A

    Problem with Date Range search Nav Form

    Ive got it, took me a bit with this StrCriteria = "([DateCreated] between #" & Format(Me.txtDateFromPC, "mm\/dd\/yyyy") & "# And #" & Format(Me.txtDateToPC, "mm\/dd\/yyyy") & "#)" Task = "Select * ProgressClaimList2Q where (" & StrCriteria & ") order by #" & Format(Me.DateCreated...
  4. A

    Problem with Date Range search Nav Form

    The date Ranges i select has always been earliest date first. Please excuse my lack of VBA and SQL knowledge but i am still learning especialy when it comes to dates its a little confusing. The code you have provided I dont know exactly where this is meant to be added. Or for that matter where...
  5. A

    Problem with Date Range search Nav Form

    ([DateCreated] between #3/08/2016# And #4/07/2016#) This also appears on the forms filter proberties after selecting the date range with single day digits Does this have something to do with thr formating? if so im not sure where to implement this.
  6. A

    Problem with Date Range search Nav Form

    Seems to working except for one problem, in the search variables if a single day digit is used for between dates for eg 3/8/16 to 5/8/16 the search returnes nothing just an empty list but will work with double digit days for eg. 16/9/16 to 20/9/16. and will also work with date range for eg...
  7. A

    Problem with Date Range search Nav Form

    I updated the datatype to "Dim StrCriteria As Variant" I do understand now as you explained dates in SQL must be formated right and will attempt to amend the code with between operators just to be sure im using the correct metthods in VBA for this particular operation. But im still not sure what...
  8. A

    Problem with Date Range search Nav Form

    How good is that spot on Thankyou
  9. A

    Problem with Date Range search Nav Form

    Im attemting to create a search between 2 dates on a navigation form, the particular form is a continuous form using a query. The VBA code sample I aquired from a Utube Tutorial The VBA code in the form when not attached to the navigation form works fine , when running the code under the nav...
  10. A

    Hi From Western Sydney

    Hi All Ive used access for some time now and consider my self at intermediate level, as with probabaly a lot of access builders, VBA is now the one to crack. But still plenty to learn in all areas. But I feel Im in the right place for advise and possibly help others if I can. Thank you...
Back
Top Bottom