Search results

This has escalated... :ROFLMAO: I'm actually going to solve the problem by replacing the listbox with a subform that looks like a listbox (for a variety of reasons, but one of the upshots is that you can customise the select / deselect behaviour far more easily - that's not the primary reason...

Thanks everybody. All coming back to me now... Why would that be normal behaviour by design I wonder? Surely there should be a native / intuitive method of undoing the selection rather than having to implement one via code? For what it's worth, I've decided to go with this as it replicates the...

I'm embarrassed to even ask this question but for some reason I can't figure it out... Very, very simple problem - I have a ListBox that has Multi-Select set to None (i.e. only allow one item to be selected at any time) When I select an item, I can't seem to deselect it again? I can only...

Nice - I didn't realise you could use a formula in the ControlSource property of a control in a continuous subform. Might use that somewhere else... Ultimately, though, this will result in the same behaviour as formatting the control for positive;negative;zero;empty values (replacing the zero or...

Thanks Uncle Gizmo, unfortunately firewalls prevent me from downloading "third party" software but I do appreciate the offer! I have used a command-button-in-place-of-a-checkbox myself elsewhere and it works really nicely, it just doesn't work very well as a field in a continuous subform, hence...

Aaargh - sorry - just a case of changing the Format string :

Came across this thread in the Code Repository as a neat little workaround for displaying checkboxes a little larger and with a touch of colour but struggling with one tiny detail (and the thread is no longer open for replies) if anyone can point me in a direction? How does one "translate" the...

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...

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! 😵🤪

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 =...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...