Search results

  1. DickyP

    Exporting Attachments from Access tables

    To put this in perspective I created a new database with just the books table and the attachments table from my Books database. This was 778,640 bytes, After adding the external attachment files pointed to by my attachments table into a new Attachments field in the book table the new database...
  2. DickyP

    My cars been stolen

    Actually in makes a lot of sense in UK - although they are getting more popular automatics have only been the majority since 2019. In the days of Humber Sceptres (last built in 1976) they were very unusual and hence very attractive/valuable because of rarity.
  3. DickyP

    Exporting Attachments from Access tables

    Although not germane to the detail of this thread this Attachments problems link to a previous thread does show that the problems addressed by it are not worth the huge overhead if you have lots of attachments. It also goes against the niceties of Relational Database Design as its usage...
  4. DickyP

    Printing Badges

    No - it was just a possible idea. (And I don't like Access reports - purely personal opinion.)
  5. DickyP

    Printing Badges

    My personal approach to this sort of problem, which you might consider, is not to use an Access report but to build a Word document in VBA so you have control item by item as you fill a label. You need a Word template for labels of the correct size but that's easily done in Word using the...
  6. DickyP

    so the guy in the Computer Shop says "why do you want to use Access? MS will be discontinuing it soon"

    The whole point I was making is that Quicken and Sage etc just don't do the things I want the way I want them to. My Address book is just that- no contact management etc and actually took only 2 days to build. If I was in business I wouldn't be using them -for instance I would be using Sage for...
  7. DickyP

    so the guy in the Computer Shop says "why do you want to use Access? MS will be discontinuing it soon"

    By extension you'd never use Access for anything that's available commercially. In general this is good advice, but...! I wrote my Accounts package because none of those available did exactly what I wanted. Same for my Address Book DB. Luckily I have time available to me to do this as a pastime.
  8. DickyP

    DLookup returning Null instead of empty string

    If I am at fault (I don't think I am but ...)then mea culpa - sorry.
  9. DickyP

    DLookup returning Null instead of empty string

    This whole thread has intrigued me since, as most posters have said, the problem remain 'NOT UNDERSTOOD'. Thinking back to My C++ days I have a feeling that I might be that the API call used by the comparison wll use the empty string which is treated a null in C++, which theAPI is written in...
  10. DickyP

    DLookup returning Null instead of empty string

    Hold on - I'll disembowel a sacrifice or read the runes to try and see what was in the minds of the designers - can see any other way to find out. I certainly can't see a logical reason. As a check / confirmation I tried the equivalent with one of my database and got the following which was...
  11. DickyP

    Solved Closing a form from the Form_Load event

    Order of events for forms and sub-form when opening: Open => Load => Resize => Activate => Current. On closure: Unload => Deactivate => Close See attachment for the rest of the document from which I sourced the above.
  12. DickyP

    DLookup returning Null instead of empty string

    The problem with vbNullChar is that although it is a char it returns Null in DLookup. As I said its use is problematic. If you ever get to see a copy 'Dan Watermans guide to the Win 32 API' it is replete with waring to only use it when you need to generate a zero terminated string, because of...
  13. DickyP

    Solved Closing a form from the Form_Load event

    I do this differently - just open the form but add a value(s) to the openargs that will indicate that you want to create a new record, or if not the record you want to select to edit. I have standard Library code which uses semi-colon separated value pairs in my Open Args so I don't have...
  14. DickyP

    DLookup returning Null instead of empty string

    Just had a look at example the database that was attached to the post. The field is, as reported, Required and Allow Zero length Strings. I would, however, having seen your usage, expected it to have a default value of "". The next question is how are you creating the records and are you...
  15. DickyP

    Two nations divided by a common language.

    Nothing like the same - city of Cambridge is full of leftie intellectuals and well paid electronics industry: it does have rough end as well. The shire is/was hardworking farming communities, especially in the 60s. My primary school had a grand total of 90 pupils from 5 different villages.
  16. DickyP

    Two nations divided by a common language.

    Cambridgeshire not Cambridge - subtle difference. Village school for primary and grammar for secondary (mind you Peterborough wasn't in Cambridgeshire when I started secondary school Northamptonshire and then County of Huntingdon and Peterborough).
  17. DickyP

    Two nations divided by a common language.

    Essex was obviously different to Cambridgeshire in the same period. Bullying was seldom seen and when it was it was only against a very few misfits by a very few bullies. And it didn't involve beatings up and nor were there any gangs. Perhaps I was just lucky, or maybe it was just that I...
  18. DickyP

    Two nations divided by a common language.

    Why would you - its what we (differently) understand. Not right or wrong - just different.
  19. DickyP

    Two nations divided by a common language.

    Ever since the movie/film 'Dumb and Dumber' we Brits, especially youngsters have started to use the word 'dumb' to mean stupid. The Concise Oxford English Dictionary and Oxford Dictionary of American English show the primary meanings of the words to be: American English English English...
  20. DickyP

    Two nations divided by a common language.

    I love what's in a bit of slang - back when Dick as slang meant detective, Peter meant burglar in UK.
Top Bottom