Search results

  1. AOB

    DELETE query with OUTER JOIN on sub-query (AC365)

    Hi all, Have a suspicion what I'm trying to do is simply not possible in Access (as opposed to SQL Server) but figured I'd ask before completely scrapping it. I have a table - consisting of two fields of ID's (basically a junction table) - but no formal relationships, so no foreign keys etc...
  2. AOB

    Solved VBScript to determine bitness of local MS Access version

    Very good point! I don't think Click-To-Run is used much here but I shall file this in the "Maybe" column for the next time it falls over! 😵🤪
  3. AOB

    Solved VBScript to determine bitness of local MS Access version

    Thanks @arnelgp - this seems to work pretty well! I made one modification as I don't particularly want to launch Access (in order to determine the path to the MSACCESS.EXE), then exit and relaunch Access again - so I subbed that part out and replaced it with a registry read : Set objShell =...
  4. AOB

    Solved VBScript to determine bitness of local MS Access version

    Thanks @Ranman256 but this is VBA, not VBScript - VBA not an option as I need to determine the bitness before I launch the ACCDE
  5. AOB

    Solved VBScript to determine bitness of local MS Access version

    Hi there, I've run into some difficulties with a distributed Access DB (that is, a central ACCDB backend with distributed ACCDE frontends) The front end utilises some API's which obviously have to be declared differently in the two configurations (made pointer-safe in 64-bit) and I've...
  6. AOB

    Solved Access keeps crashing when trying to open ACCDB master file (MS Access for Microsoft 365 MSO 64-bit)

    Yeah I followed the rabbit hole to that CopyMemory API, it was already PTRSAFE'd but there must be something twitchy between it and O365 which I really can't be bothered researching (it's a nice-to-have rather than an essential) Like I say, if there's a way of pulling the system fonts into a...
  7. AOB

    Solved Access keeps crashing when trying to open ACCDB master file (MS Access for Microsoft 365 MSO 64-bit)

    Figured it out... As usual, 4 hours of debugging, then as soon as I post a question on here, I figure it out myself... Sorry!... So it looks like it's an API that was added when this was first developed in Access 2013 which is now being troublesome in A365 (or whatever it's supposed to be...
  8. AOB

    Solved Access keeps crashing when trying to open ACCDB master file (MS Access for Microsoft 365 MSO 64-bit)

    Hi there, I've been making some modifications recently to an Access DB that's been in production for several years. Standard FE/BE split design, single BE ACCDB sitting on a network drive and distributed FE ACCDE's. I have a master copy of the FE locally and I make whatever updates are...
  9. AOB

    Solved EnumFonts across multiple Office versions (O2013 vs M365 / 32-bit vs 64-bit)

    That's worked a treat, thank you so much! I'd been fiddling with the pointers but needed a steer on which ones were causing the issue! I would be 99.9% sure everybody is on at least 2010, if not in fact 2013, but I'll keep the old syntax in there just in case as it's easier to keep it and have...
  10. AOB

    Solved EnumFonts across multiple Office versions (O2013 vs M365 / 32-bit vs 64-bit)

    Hi there, I have a module which I use to pull the local system font information into a local table (literally just the available font names) which I've done via EnumFonts as follows : Declare Function EnumFonts Lib "gdi32" Alias "EnumFontsA" (ByVal hDC As Long, ByVal lpsz As String, ByVal...
  11. AOB

    Continuous subform partly scrolls to the right on load / requery (AC2013)

    Thanks guys, Looks like it was tab ordering I have a command button as the leftmost control of each record (to allow a quick delete) but had it at the bottom of the tab order as I didn't want it to take the focus on loading (lest anybody accidentally hit the Enter key - even though it prompts...
  12. AOB

    Continuous subform partly scrolls to the right on load / requery (AC2013)

    Hi there, I have a continuous subform residing inside a parent form. I recently added two columns to the subform and now for some reason every time I load the parent form, the subform is always partly scrolled, horizontally, to the right, by a couple of centimetres. I thought it may have been...
  13. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Oh, yes, 100% - assuming a) the user knows how to navigate their way around the skeleton of Access and b) they're motivated to even bother trying I have the Navigation Pane hidden and locked so F11 won't let prying eyes into the engine room, intentionally or otherwise. Yes, one could hold the...
  14. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Indeed - I would have thought opening exclusively was a very specific process rather than anything that could happen accidentally? A front end .accde couldn't open the backend exclusively "by accident" could it? Unless it was designed / coded to do so (it's not) I also hide the backend (as...
  15. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Just to confirm - backend was indeed the source of the problem Restoring the last backup has rectified it Can only guess that one of the local front ends forced a permanent record lock on one or more tables that was immutable - to be honest, I've never experienced that before, nor can I see...
  16. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Hi CJ, Correct, it's a standard split DB, everybody has their own local copy of the front end and a single production backend on the server It seems to be the backend that's corrupt Thanks AOB
  17. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Thanks again Colin The SQL is correct (as it has always worked) The issue seems to be the production backend - I switched in a backup and the recordsets are all updatable so there must be some corruption issue in the live version. If there is, it's not immediately obvious as there are no...
  18. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Thanks Colin, It's not a saved query, it's generated at run-time - but very vanilla and has ever been an issue before : Dim dbs As Database Dim rst As Recordset Dim strSQL As String Set dbs = CurrentDb With dbs strSQL = "SELECT [tblTable].* " & _ "FROM [tblTable] " & _...
  19. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

    Hi there, I have an Access DB which has been in production for several years. This morning, users reported issues loading it up and running any of the functionality. It appears that recordsets which were previously used for data manipulation, are no longer updatable (??) These recordsets abide...
  20. AOB

    Unbound multiline plain textbox 64k character limit (AC2013)

    That escalated quickly... :D So I got around the problem by replacing my single plain textbox with a handful of other controls. First I added three local tables; one which stores all the "valid" codes, one which holds any duplicates of the valid codes (and the count of the dupes) and a third...
Top Bottom