Search results

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

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

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?

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

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

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

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

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.

I think a copy of the db would be the best way to move forward. I've trimmed all unrelated to the issue data, code, tables, forms, etc. for online use. On the form that will open, you will see the issue in the Analysis tab. The "Social Use" combobox of the "Social Uses to Actors Relationships"...

This is what is under the rowsource for the Combobox in Subform B: SELECT Tbl_Dataunits_Social_Uses.ID, SocialUseID_Main AS [Main Type], SocialUseID_SubI AS [Subtype I], SocialUseID_SubII AS [Subtype II], Tbl_Dataunits_Social_Uses.DataunitID FROM Tbl_Dataunits_Social_Uses WHERE...

Thank you for trying to help theDBguy. I'm not using lookup fields at the table level, I avoid them in general. The underlying structure for the tables is provided in the screenshot. Subform A (Social Uses) is Tbl_Dataunits_Social_Uses, and Subform B (Social Uses to Actors) is...

But the Column() property seems to work only when referencing a combobox in VBA/macros, it does not work in the underlying query for the rowsource for the second combobox. I've tried injecting the SQL code with VBA using the Column() property, but it doesn't work either.

I've got a peculiar situation that for the life of me cannot figure out how to do properly. The situation is as follows: - I have two subforms that are bound to the same parent form. - Subform A has three comboboxes that draw values from a types vocabulary. All three are bound to hidden column...

I confirm that this works too! Thank you for sharing this, I'm sure it will help several people.

So I had to think a bit outside the box for this one, but I think I got a pretty decent workaround and since some people seem to be looking for similar solutions out there, here goes: - Used a default textbox (Transcription) in Access that is meant for editing the text. - Used a second textbox...

My issue may sound a bit silly and there may be an obvious solution I'm just not seeing, but here goes nothing: - I have a text box (Long Text, non-RTF) occupying the left half of a form. This text box stores large amounts of text, usually running several pages long. - The right half of the form...

Turns out it was parsing the Where clause of the SQL string erroneously or I mistyped quotations and ampersand characters. In any case, I've added another string variable and was able to fix everything, so consider this resolved! Thank you all for the ideas! I'm attaching a screenshot of the...