Positive Test Flagging & Reminders

[June7]

I did a search in VBA for specific text in the procedure and nothing came up. Code is shown within the Open event procedure.



The CreateDocumentStorageTable() procedure in Module 3 is not the posted code. This procedure is not called from any other procedure.

The image shows "Macros in: Sapo2011 (SAPO DB W40)" - neither of the files provided have that name nor title.

[Micron]

Binary data (OLE [bitmap], type 11)
27 fields with 30701 records.

I'm assuming that a field takes up the same space in a file size whether or not the field has anything in it (with the possible exception of text and memo fields) but I don't know.

[Micron]

I did a search in VBA for specific text in the procedure and nothing came up

Where did you check, in the fe? Fairly certain I found it in the be.
As for the rest, I suspect we got sanitized versions with different names given that most of the data was converted to x's. Might just as well removed everything that wasn't necessary to replicate the issue. I think I am done without further input from OP. Maybe done regardless because I don't intend to keep going to AWF to see what's new on this.

[Welshgasman]

[Welshgasman]

Maybe done regardless because I don't intend to keep going to AWF to see what's new on this.

[yrstruly]

Please re-run the code to count them, it would be great to hear your findings, as it will help me to optimize the database size.

[yrstruly]

I sensored the data to fill in x's as place holders.

[yrstruly]

I removed Macro CreateDocumentStorageTable(), ran the code and it gives me no output as stated earlier. I appreciate each and everybody's assistance.

[June7]

Yes, I checked only in frontend for code.

CreateDocumentStorageTable() is NOT a macro - it is a VBA Sub procedure. Macros are very different things in Access.

So your issue is resolved?