Search results

  1. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    As there have been no responses to the latest challenge in post #452 after 36 hours, I'll add two hints: Very well known American band whose albums sold massively particularly in the 1990s. The first image is a clue to the band. The other two will give you the title
  2. isladogs

    Form Design size

    I also use overlapping windows in all my applications and agree there are no downsides. That is unless you find having multiple tabs open at once beneficial. Personally I think they are a distraction to end users. I also find that overlapping windows display works perfectly with Automatic form...
  3. isladogs

    Solved Increase font size for visually impaired

    Ron Whilst you can increase the size of a listbox, surely the user will still have trouble with reading the rest of the form. Another approach is to allow users with visual impairments to zoom the entire form. I have code to do exactly that as part of my automatic form resizing routines. For...
  4. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    Apparently used in the US but not in the UK.
  5. isladogs

    Database Backup Issue

    Not sure what point you are making Pat, You can make a backup of a SQL Server BE at a 'point in time'. In fact I have code to do that built into all my commercial Access FEs that have a SQL BE
  6. isladogs

    Solved Hiding a Form

    Yes of course that's the case. I thought that was implicit in my comment,
  7. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    Just for info, I've never heard the phrase 'night crawlers' used for earthworms. Anyway here's another, possibly linked, hopefully not too hard. Song title and band please.
  8. isladogs

    Solved Hiding a Form

    I was also surprised to see that the startup form loaded first. I modified your code to use an event procedure instead of an embedded macro. Same result. Normally you would either use start up code in an autoexec macro OR in a startup form, not both! Autoexec is useful where you need to ensure...
  9. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    Cloudbusting - Kate Bush
  10. isladogs

    Importing excel whilst adding a field to table

    I see June, Gasman and I are all saying similar things. I suggested append queries as I thought you wanted to add data from each Excel file as separate record(s) However, use update queries if you just want to update existing records
  11. isladogs

    Importing excel whilst adding a field to table

    Link your Excel spreadsheets. Create your Access table with the relevant fields plus the date field. Next, if you need to do any intermediate data processing, first append the data for each of a temporary imported data table and populate the date field based on the Excel spreadsheet name...
  12. isladogs

    Crosstab - Current week dates in column headings

    You can do this with a crosstab query in Access with dynamic column headers. These are updated automatically to fit the available data. An example report using this idea and based on a crosstab query can be found here...
  13. isladogs

    Access VBA Encryption - AES256 Cipher for Text strings?

    As I said before I've been using this code in many production databases and several thousand users for over 15 years without problems I tried removing the Resume Next line and got no errors on testing I haven't yet had time to study your code yet but see no reason to modify the original I...
  14. isladogs

    Solved Hiding a Form

    @theDBguy has made many of the points I was going to make There is little point worrying about security if you don't use an ACCDE file for your FE. As you have users running both 32-bit & 64-bit Access, you will need to create two versions of the ACCDE for each bitness. The next most important...
  15. isladogs

    Solved Hiding a Form

    I've just read the link @arnelgp provided in post #2. I disagree with two points made by the OP in that thread 1. Deep hidden tables are not deleted when a compact and repair is done. If that was ever the case, it hasn't been true for at least a decade. 2. Queries cannot be deep hidden
  16. isladogs

    Solved Hiding a Form

    Hi I've just seen this thread after reading your PM. I must admit I don't really understand the point of this thread. You can right click any database object including forms in the navigation pane and hide it. However it can still be viewed if Show Hidden Objects is ticked and , of course, the...
  17. isladogs

    Using Record Selectors

    Have a look at a different approach which works well and involves no arrays. https://www.access-programmers.co.uk/forums/threads/folder-image-viewer.307449/
  18. isladogs

    Access VBA Encryption - AES256 Cipher for Text strings?

    WCS??? Perhaps you could share your SHA512/SHA256 code EDIT: Your new post appeared as I was typing this. Will read it properly later
  19. isladogs

    Blurry Headers

    As stated in my original thread as quoted in post #2, it is indeed blurred headings to the similar threads section when using Edge and the default colour scheme
  20. isladogs

    Access VBA Encryption - AES256 Cipher for Text strings?

    I have used RC4 encryption in numerous databases for over 15 years. It uses 128 bit encryption and is secure enough for any purpose where I would employ an Access database. I would never use XOR - its too easy to crack Unless the RC4 cipher is known, the encrypted data is effectively...
Top Bottom