Search results

Whilst datasheet forms have the functionality to hide / freeze / move / reorder columns already built-in, the same features can all be added to continuous forms. See the various links in my summary article: https://www.isladogs.co.uk/add-features-forms/index.html

Old threads are closed in moderated areas of the forum (sample databases and the code repository). There is no block on posting new threads but remember such posts have be approved by moderators before they are visible to all.

I’ve only skim read the thread but it’s easy enough to make the tables read only as suggested in the thread title. You need to assign the dbSystemObject property. My database analyzer has similar functionality to the FMS TAA app. Suggest you look at the detailed descriptions of both tools...

Perhaps my articles will help? https://isladogs.co.uk/references-code/ https://isladogs.co.uk/reference-list-locations/index.html Its unlikely you will need to register a missing reference library before adding it, but to do so, you would use regsvr32 from a command prompt

Somewhat late i know but I've only just seen this thread as I normally have the watercooler blocked. For info, although it wasn't the main point of this article, the handle I use is indeed a play on the location Isle of Dogs in east London and is explained in an article Why Isladogs? Why Access...

You can create the same large spreadsheets in both 32-bit and 64-bit Excel. The number of allowed records was increased back in Excel 2010 IIRC, and is not bitness specific. You can SOMETIMES install both 32-bit and 64-bit Office (different versions) though officially it is not possible For...

Yes it works well. I suspect that’s why my request to integrate it into modern charts wasn’t taken up

64-bit has improved memory handling and will be better for very demanding tasks. Otherwise 32-bit will be fine

Unfortunately not. I did request that feature about a year ago but it wasn’t taken up. I use the same solution with a subform as you.

@Jason Lee Hayes Not sure what is in your file from post #11, but it is blocked on my machine with a virus detected message

@arnelgp's code leaves the taskbar accessible so users can 'escape' by switching to another app. When I created my version of this a few years ago I deliberately ensured the taskbar was also dimmed and inaccessible See https://isladogs.co.uk/highlight-entire-form/index.html Both approaches are...

So the two fields I mentioned are in the CSV file and therefore text? I can see issues with your table structure in terms of repeating fields etc but nothing that explains error 3828 Hopefully uploading a cut-down database will assist us to explain the problem.

I suspect there will be a table or query property responsible. It would be helpful if you can upload the relevant objects from the database If the fields Quantity and / or AccountCode are number fields, there should be no quotes in the query sql for those fields

AFAIAA, former MVP, Doug Steele isn't a member here but I agree its an excellent tutorial

The issue is simple - you are using popup forms. Popup forms cannot be directly identified as active using Screen.ActiveForm. This is because they are located 'on top ' of the screen rather than being part of it Similarly, the selected control in a popup form cannot be identified using...

I've spent almost 30 years learning Access and I'm still finding things to learn I expect to be obsolete before Access is.

@dalski If I’ve inadvertently reinforced any concerns you have then my post had the opposite effect to that intended. Twelve years ago when Access 2013 was released, it was notable for removing several features without providing viable alternatives. Most were little used but there was a lot of...

Yes - that was the point. The issue still exists over a year later @msch88 I reported this in June 2024 and got an acknowledgement from the Access team The fact that it hasn't been fixed yet is I think because it is a relatively trivial issue in the larger scheme of things. I will raise it...

As already observed in another thread started by @pekajo, whenever this OP posts questions he/she does not respond to any of the advice or suggestions given.

You are both suggesting that functionality is being removed from Access itself (as in the great feature cull of A2013). That is not the case. Changes to external apps will indeed impact Access together with Excel etc. That is absolutely true but its not due to any changes in Access itself...