Search results

  1. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    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.
  2. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    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?
  3. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    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...
  4. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    It is indeed a useful reading and documents aspects not found elsewhere.
  5. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    Mainly removal of options/columns from the list. For example in the screenshot I would like to remove the AttachmentPath and AttachmentAddress options.
  6. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    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.
  7. H

    Is it possible to edit the contents of the Unhide Columns box in the datasheet part of a split form?

    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...
  8. H

    Solved Insert Into Select not working in VBA

    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...
  9. H

    Solved Insert Into Select not working in VBA

    This sounds like a workable idea. Thank you, I'l ltry it!
  10. H

    Solved Insert Into Select not working in VBA

    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...
  11. H

    Solved Insert Into Select not working in VBA

    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...
  12. H

    Solved Insert Into Select not working in VBA

    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...
  13. H

    Solved Insert Into Select not working in VBA

    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...
  14. H

    Solved Insert Into Select not working in VBA

    Useful for reference. Thank you theDBguy! I will need to take a closer look at it to understand what it does fully. :)
  15. H

    Solved Insert Into Select not working in VBA

    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?
  16. H

    Solved Insert Into Select not working in VBA

    Hello to everyone, Before asking, let me just say that I do have a solution to the question cited below, but I would like to understand why VBA won't work. I have been trying to automate a repetitive task in a quite complex database, but VBA keeps throwing a "too few parameters. expected 2"...
  17. H

    Solved How to reference a non-bound column of combobox in the rowsource query for another combobox?

    Thank you for the constructive criticism. A bit of details to address some of the concerns... Three items was requested by the client and is not the same data, they just draw the data from the same table, but each one due to criteria in the underlying queries have unique items inside them. They...
  18. H

    Solved How to reference a non-bound column of combobox in the rowsource query for another combobox?

    Thank you! I've improved a bit further the optics by using an expression, as below: SELECT Tbl_Dataunits_Social_Uses.ID, Voc_Social_Uses.Social_Use_Name AS [Main Type], Voc_Social_Uses_1.Social_Use_Name AS [Subtype I], Voc_Social_Uses_2.Social_Use_Name AS [Subtype II]...
  19. H

    Solved How to reference a non-bound column of combobox in the rowsource query for another combobox?

    Just looked at it right now! Amazing and elegant solution that I had no idea you could actually do without causing system stress. Thank you for sharing. I was able to connect all three values and also changed the relationship to a Right join to avoid having values not showing up due to Nulls...
  20. H

    Solved How to reference a non-bound column of combobox in the rowsource query for another combobox?

    Left-over from experimentation. Sorry. The original just says Text Box at the top. I was toying with the idea that maybe if I set the field in the table with the lookup, it will carry the values over to the query.
Top Bottom