This confirms my suspicion that editing the contents of the show/hide column selection box is indeed impossible. Thank you for your time and information.
I understood that from the article and it is indeed useful, but even if I do a Detail+Datasheet combination to imitate the traditional split form division, I would still not be able to control the contents of the Column Chooser box for the Datasheet form, right?
I thought about disabling right-clicking altogether and creating a custom pop-up modal form that would allow the user select columns and then use VBA to hide/unhide them in the datasheet section, but it is too much hassle and not much to be gained. We need a split form cause I'm using a tab...
Mainly removal of options/columns from the list. For example in the screenshot I would like to remove the AttachmentPath and AttachmentAddress options.
Useful reading, but I did not find anything related to the question. As far as I gather, the split form and datasheet Column Chooser control is not documented, therefore my hopes for being able to edit its contents are rather limited.
Hello to all,
I've been trying to figure whether something is possible and trawling the web has not helped. The question is quite simple: When you right click on the column header in the datasheet part of a split form and select Unhide Fields, a box pops up with the available columns to...
All the above are very informative and unfortunately a great deal of this knowledge is not in manuals or even knowledgebases for Access, so thank you for sharing these.
To address a few worries, the user never sees queries, as the interface hides everything and locks users out of all the Access...
Thank you Pat for the in-depth response and explanation.
A couple of explanatory notes: a. The prompt I was getting is the one mentioned in the original post that it was getting "too few parameters. expected 2". I did gather that it wasn't parsing something correctly, I was just wondering why...
Thank you very much for the full and extensive explanation as to how Access works. Admittedly, I thought everything was being pre-computed in VBA and then sent to SQL-ACE for execution, but apparently, I need to re-think and read a bit more on what processes are handled by the application and...
Thank you for the explanation. I now see what the issue is. I have used Insert Into without Select in the past with success in VBA, but this one was particularly tricky. Since calling the Append query from VBA already works, I don't think I will spend more time trying to make it work fully in...
The database is complex (158 tables, 208 queries, 209 forms) because it is used for attribute analysis for material culture in archaeology (many one-to-many relationships for having a normalised schema). The user interface is also complex and forms nesting goes up to sixth level on occasion.
In...
Thank you for the explanation. I understand about Warnings and the dbFailOnError argument, which is useful for rolling back changes in the event of an error.
The first part I did not understand. Which values do I need to concatenate and how do I do that?