Search results

All mostly good points. Except phone number is not a number (as in a quantity), it is an identifier, same with SSN and ZIP. Have to decide whether or not to save symbols with digits. Phone numbers probably never have leading zeros so saving its digits in a number type field probably ok but can't...

Lucky you, price went down. But maybe could have saved that $9.99 I am not sure you will notice any change from 2010. This lists what's new but says nothing about what was removed https://support.microsoft.com/en-us/office/what-s-new-in-access-2021-2c5c0766-b22b-4b81-a222-a791a8b5b54b Field...

As I said, which field is designated as primary key depends on what value you want to save into tblFilaments. These lookup tables each relate to tblFilaments, not directly to each other. In that image ColorID and BrandName are designated as primary keys. Those are the values that should be...

The 3 additional tables are "lookup" tables. They provide a means to dynamically build lists for comboboxes or listboxes. These input controls assist with maintaining data integrity. Either save record autonumber key into tblFilaments instead of text because numbers take less storage or save...

So far, I see potential for 4 tables. tblFilaments ID, FilName, ColorID_FK, BrandID_FK, TypeID_FK, Qty, Note (ColorID_FK, BrandID_FK, TypeID_FK should be maybe be a compound unique index) tblColors ColorID, ColorName (values like White1, White2, etc), TD, HEX tblBrands BrandID, BrandName, etc...

I did more edits on my previous post while you were reading. Might review again. I don't know why search with your table would be less accurate. Access 2021 can still open 2003 MDB files, for older files Access 2010 should be helpful. I found a source that offered 2021 for only $20.

You would have one table for records of each filament specifications (color, brand, etc). You could have "lookup" tables to help with creation of new filament records. For example, if you want to limit/standardize color choices, a table would have those values and a combobox (or listbox) on form...

Your date value shows seconds but your criteria format does not. Really want to include time components in filter criteria? Review http://allenbrowne.com/ser-36.html

DLookup without criteria is pulling random value. Usually, DLookup is not needed. A combobox could be possibly be setup to include associated values then textbox expression refers to combobox column or include lookup table in form RecordSource. Negative numbers in table or multiply by -1 or...

I have forms with lots of comboboxes and never thought it looked terrible. You have a search form that opens another form to display data (not edit) and using comboboxes on this form to display related data? I agree, just use a query that includes lookup tables and bind to textboxes, eliminate...

Yes, it's good I have the password in my code and it did occur to me I can just delete and generate another if really came to that.

Colin, I am trying your CDOMailTester app. It is basically same code I already tried from other sources and facing same issues for Gmail SMTP. The first link you provide for the Gmail fix has changed content. Says it is no longer possible to set for less secure apps even with 2-factor...

See my edited earlier post.

acNormal = 0 If you want "Normal", use 1, otherwise 0 for "Transparent". .Controls(Ctrl).BackStyle = 1 acNormal serves purpose as argument parameter for various commands, such as OpenForm. Docmd.OpenForm "FormName", acNormal

If you want "Normal", the value is 1, "Transparent" is 0. https://learn.microsoft.com/en-us/office/vba/api/Access.TextBox.BackStyle acNormal returns 0.

This sounds odd.

Yes, I see that now too. Have to delete all the bad text below table and manually enter info into cells. Annoying.

Nz() is an intrinsic Access function. https://support.microsoft.com/en-us/office/nz-function-7ae941b1-fc69-47a0-a279-a6a860cfb4c5

I have never used Record Selector to save so I just tested this. New record stays as last row since form is not requeried or refreshed.

Fairly common topic. Review https://www.devhut.net/ms-access-vba-requery-a-form-while-remaining-on-the-same-record/