Strange thing: I am able to set a recordsource of a subform sfrm_myStandardSubform as usual, like

I am trying to suppress certain subforms based on conditions in the parent.

I am trying to suppress certain subforms based on conditions in the parent.

I’m trying to create an automated manufacturing history system to create a report, and copy attachments from a job card & email them. The file names have to be specific format..so need to be assigned from a variable.

i have a complex reporting module which creates reports on the fly. that’s why i’m adding table programmatically, this is a way to allow to add and edit reports without having to redesign the app, everything is dynamic, there’s a set of tables that store configuration parameters and adding or changing a report just requires changing some data in those tables

the code below creates tables based on settings in a table.
I’m trying to set the FORMAT property to “Standard” or “Percent” (meaning, i have tried both for different fields) and neither work, it errors on

I have a continuous form, in the table I have a field with the path of an image, so in the form I set that field to an image control and it shows the image, that works great.

I’m trying to write a function which converts a csv file into an excel file. I’m using Access 2021 and my problem is concerning the **Opentextfile **line below..

I have a [Before Delete] data macro that works fine when I delete one row manually. But, as soon as I try to delete rows with a query – it fails.

Full context, because this is such an odd problem that I’m not even sure where the issue lies: the database I’m working on requires the storage of consent forms for easy access. I’ve set this up by using code to copy a selected file into a central storage folder (referenced in the global constants), and adding the filename (ConsentProof) to a Short Text field on the Customer table. The Customer form then uses a query to create the full file path (ConsentLink) from the filename and the aforementioned global constants, and displays that.