Search results

I'm not being able to find the correct sintax do use Yes/No field as a criteria in my Dlookup function: AttachPrep = DLookup("[Flux]", "251 Preparation", "[Selected]= Yes") Many other sintaxes like -1, true, etc...... all return data type mismatch . Any help? Any clue?

I believe it could be a good strategy. And I thought to create a sql query with all * fields of the table. Doesn't matter how many fields it has. Then create a Recordset and populate it. However, it's like The_Doc_Man stressed: The Access isn't able to format it inside the subreport. A mess again.

Ok, The_Doc_Man. I will study a little how to work with OLE techniques. Thanks.

Yes, theDBguy. That's exactly what I haven't been able to code. How to name/define the subreport record source with the name of the new table? At the end, I thought, it's only a syntax problem.

Thanks theDBguy and The_Doc_Man. Yes, each new table has a different number of fields. The table is created as a DAO.Database and each field as variant using TableDefs. 🤔 Thinking on what The_Doc_Man said, maybe I will need to find another way to join the table to be printed together with my...

I create a long routine process where the user creates a table and, at the final phase, he fills a form and press a button to print it as a report. It's working fine but know I want to print in the report the table created as a subreport. Each time the routine is carried on a new table with a...