Search results

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.

If you want to compare to cost, need to modify each conditional rule to reference appropriate field or control or expression in place of of "0". Possibly: [Stop_Current] > [TotalCost_$] AND [Text523] > [TotalCost_$] [Stop_Current] < [TotalCost_$] AND [Text523] < [TotalCost_$] Expression for...

This rule also worked in my test of combobox: In (-1,0) Or Is Null

I tested with Colin's app. I cannot use CDO with Outlook any more. Been a while since I tried but as I recall this requires some kind of account I can't have as an individual. However, I can get CDO to work with Gmail. I did have to set up a special Google account. Although, my phone email app...

And the zombie phenomenon should not apply with SQLServer backend? Perhaps we can track down issue with db. Make copy of frontend and import relevant tables.

Review http://allenbrowne.com/AppInventory.htm

An UNBOUND form using VBA to lookup LoyaltyAmount and execute SQL actions is one option. Another is form bound to Clockings table and focus on new record row (form set for DataEntry yes will only allow new records) Scan barcode into a combobox control. Combobox RowSource is like: SELECT...

Yes, subforms could work. I have actually done this (once). Build each subform with static criteria in Filter property for particular attribute type. A combobox will have attribute values relevant for that type only. Might also be able to apply this concept to report with subreports and avoid...

With Plog's suggested data structure, all attributes are stored vertically. Each selected attribute is a record. This eliminates MVFs. Then if you want to display the attribute values under attribute type columns horizontally in query or report, would likely need VBA to concatenate into CSV...