• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by namliam

  1. N

    Ordered query

    All hail rule #1 from all mighty @Pat Hartman It is good to follow this rule :)
  2. N

    Date string to Date

    Concure... Expr4: Mid([Installation Date1],3,2) & "/" & Left([Installation Date1],2) & "/" & Right([Installation Date1],2) In order for you to get 1119/11/19 you must have not used the above formula.... instead... Expr4: Mid([Installation Date1],3) & "/" & Left([Installation Date1],2) & "/" &...
  3. N

    Date string to Date

    250918 = 25/0918/19 Doesnt make sence! and quite honestly is impossible to boot. 11012 is possible to fix, however how does your number date work in may? 1512 or 10512? The best way to handle this situation is to make a "tblDate" that holds your numeric date in one column and the "real date"...
  4. N

    Query to find opposite records in VBA

    Fairly simple solution, to add to @MajP Have a PK in your qryTrue... then in your qryFalse you dont need all kinds of difficulties to find nulls etc.... it can simply be: Select * From sourceTable(s) where PK not in ( select PK from qryTrue ) Only troubles you may then run into may be due...
  5. N

    Access World Forums - Stats Update

    I find people want to use "high tech" and "new stuff" just because it is "better" or "newer", mostly the latter. However nothing beats a good old excel sheet or a quick access db for a nice steady fast and cheap working solution.
  6. N

    Access World Forums - Stats Update

    It makes it easy to find "real" threads that I am involved in already that have reactions that I have not seen before... Potential questions or answers from the OP .... or other ideas from fellow posters on the forum who may have other ideas or solutions than the solution I offered....
  7. N

    Access World Forums - Stats Update

    My favorite page: https://www.access-programmers.co.uk/forums/find-threads/contributed I dont post (much) in the cooler
  8. N

    Solved Combine Records

    No no no. we do not design tables with itterating columns... mon tue wed etc is an itteration of days/dates.... thus this is bad design. Instead you should desing a table that simply holds the date and time worked, preferably in a TIME and/or datetime format. Concantinating information...
  9. N

    Ordered query

    "not ideal" you mean NOT POSIBLE. Any query by its nature is a random fetch from the table(s), it will 99% of all times return the order data was entered in the table, assuming only one table is used, with joined tables all bets are off.... however even with 1 table, it is no guarantee to any...
  10. N


    This is why your primary keys in tables are always hidden from the user and always are auto-increment numbers and always are in their nature meaningless to anything but your database. At anytime you find yourself using a PK or FK for anything but this.... adding meaning to these numbers, step...
  11. N

    Add Working Days, excluding We & hols. Function is mixing dd/mm

    @Pat Hartman Pretty much what I said, or meant to say.... When using #10/15/2020# in anything that is access (that means anything sql like, including domain functions) you need to format it MM/DD/YYYY. I.e. ... where SomeDate = #" & Format(date, "MM/DD/YYYY") & "#" Alternatively for "advanced...
  12. N

    Solved Write Conflict on record when closing

    Why create a tick box to "calculate" something that can very easily be done either on the fly or can just simply be selected on the table ?? Solution: Not do it this way.
  13. N

    Add Working Days, excluding We & hols. Function is mixing dd/mm

    despite the fact that your tables "show" DD-MM-YYYY, the dates are stored as MM/DD/YYYY Or as per Pat's post actually as a double, but access by default recognizes dates as MM/DD/YYYY unless that is not possible like 15/01/2020 or 2020/01/05 This makes things confusing because sometimes the...
  14. N

    Solved Totals Yearly Query

    Major drawdown here is the fact that things are hardcoded, hardcoding things is an accident waiting to happen... much like many things in this example. Sooner or later the same logic will appear in different places, and sooner or later the logic will change ... and come more complex times come...
  15. N

    Add Working Days, excluding We & hols. Function is mixing dd/mm

    Simply replace all TempDate By format(TempDate, "MM/DD/YYYY") or if you prefer SQLDate(TempDate)
Top Bottom