Search results

Under what circumstances does the original code not work?

Why is qryFedTax1 including join to FedTaxTable? qryStateTax2 does not repeat join to StateTaxTable. Should be consistent with naming. Why not names qryFedTax1 and qryFedTax2? I would advise not to use spaces in object naming.

Cartesian Product: the number of rows in the result-set is the product of the number of rows of the two tables. Joining on ContactID reduces the multiplication but doesn't eliminate. Joining restricts which records will associate and thereafter a Cartesian product is employed. In a table where...

CJ, a self-join on only ContactID will involve Cartesian product. If a contact has both a car and bike record, joining will return 4 records, not 2. If there are other categories, the multiplication gets worse. If there are 3 types, then 9 records result. Use of WHERE clause with AND operator...

CJ, Since CategoryType should not be a field in tblContact_Category, use CategoryTypeID in WHERE clause for the first SQL. This approach involves a Cartesian relationship which may be slower than nested query.

That's why one would make copy and remove sensitive data.

Again, please post code between CODE tags. Should be able to query source table(s) and not need local "temp" table.

Please post code between CODE tags to retain indentation and readability, especially longer snippets. I tested code with my query, except for funcDisplayEMail_nosend because its code is not provided. No file is saved. I had to specify full destination path. All data is presented as ASCII codes...

Even if not defined as PK, an ID autonumber can still sometimes be useful as a unique record identifier (see my SQL example in post 10). tblCategory_Contact really doesn't need any PK. The two FK fields can be set as a compound index without being defined as PK.

ContactID is primary key in tblContacts and therefore is NOT superfluous. An entry: SELECT tblContact_Category.ContactID, tblContact_Category.CategoryTypeID, Q1.CategoryTypeID FROM tblContact_Category INNER JOIN (SELECT CategoryTypeID, ContactID FROM tblContact_Category WHERE CategoryTypeID=y)...

Which only adds to the confusion. I consider a "single quote" as " and a "double quote" as "".🙃

Note, these are not "single inverted commas", they are apostrophes.

Please post code between CODE tags to retain formatting and readability. Probably shouldn't even maintain a "Stocks" table. Review http://allenbrowne.com/AppInventory.html Why are you using Str() function? Are those ID fields text type? If they are not, don't use apostrophes. The posted code...

Are you sure you can't use your 2003 custom menus in an accdb? Review https://support.microsoft.com/en-us/office/use-the-custom-toolbars-and-startup-settings-from-earlier-versions-of-access-eeea8c31-c2fb-4f36-81a7-7886e168a2c8 It's not clear to me what you are asking for. If you need images of...

John, I think Colin is wondering why the title bar is a dark green. My popup form shows a very light green.

If by "brackets" you actually mean "parentheses", use Format property. Review https://support.microsoft.com/en-us/office/format-a-number-or-currency-field-e48f2312-67f0-4921-aca0-15d36b7f9c3b #,###.##%;(#,###.##%);0,000.00 or if you really want brackets #,###.##%;[#,###.##%];0,000.00 BTW...

1. I don't think so 2. Look at the form BorderStyle property

Actually, on second thought, I must have been hitting the button control itself, not the form background.

Be aware clicking between controls onto the form will cause button (or whatever is used) to show up over other controls.

Did you see post 5? The "code" is the Conditional Formatting rules. Use of Access 2003 is not issue.