Recent content by xavier.batlle

This is another approach of the example I upload a few days ago: https://www.access-programmers.co.uk/forums/threads/convert-all-the-old-check-box-controls-on-a-form-to-a-modern-style.335129/ This example uses image controls to display the checkbox status and a transparent button to toggle its...

Today I came across this one working with an image control: Debug.Print Me.ImageCtl.Properties("ControlSource").Value Me.ImageCtl.Properties("ControlSource").Value ="SourceString" EDIT: To late, I noticed that's in the first post:censored:

After reading this article by Colin @isladogs : https://www.isladogs.co.uk/settings-form-toggle/index.html, I thought it would be a good idea to find a simple way to convert existing forms with many checkboxes to a new modern style easily. So, I came up with the idea of creating a form wrapper...

Splitting databases is the main reason to avoid weird errors. I think that most of gurus here can't help you on an unsplitted database.

I think AHeyne's post is number #48, not #38.😉

I think you have the code in the page section instead of in the detail section.

Try this code in the Detail_Print Section. It draws 3 different vertical lines. In this example you have to set the LeftPosition value in TWIPS. Dim LeftPosition As Single Const MAX_HEIGHT_SIZE As Single = 32767 ' This limit correspond to the section’s actual rendered height, not...

This is an example how to replace the behaviour of tooltips in MS Access using classes. Some of the options are: - Tooltips are displayed with no delay. - Tooltips with or without Icons and titles. - Customize font and background tooltip text colors. Diferent customizations can be applied to...

This error: ACCDE - "Requested type library or wizard is not a VBA project" raised to me when using an ACCDE library on an ACCDE main database . Is that your case? Do you use any MS Access library?

If I'm not mistaken, the code you have found opens another MS Access instance. If you want to open a BE password protected from the Front End you'll need something like this: Dim MyBE_DB as DAO.Database Set MyBE_DB = DBEngine(0).OpenDatabase(BACKEND_PATH_AND_FILE, False, False, "MS...

Easy, I created a new database and imported all the objects.😉

mloucel Don't ask me why, but if you add Docmd.Restore when opening the report, it works! Private Sub Report_Open(Cancel As Integer) DoCmd.Restore ' Line to add Me.Filter = Forms!ReportFormForAuthorizationsF.Filter Me.FilterOn = Forms!ReportFormForAuthorizationsF.FilterOn...

Another way to strip away time from any field [ArbitraryDateTime] is: DateValue([ArbitraryDateTime])

After some tests I find out that the controlsource property max length is : 2048, and the maximum number of fields in a sum is 100. Screen 1 Screen 2

I've tested the arnelgp code indexing on the Region field and it's surprising how some Dcount() improve their performance and others don't. === Withoud indexing============== DCount("*", "SalesRecord", "Region='Europe'") Result: 271901 in 0,14453125s DCount("Country", "SalesRecord"...