Search results

As Duane said, it is possible to have a "non-normalized" form for data entry and save the data into "normalized" table by use of VBA. But why? Are you certain that 10 items is the forever upper limit?

Filter on range of what? What field are you applying criteria to - DateOfReceiving? Your dates are formatted for non-U.S. structure. Review http://allenbrowne.com/ser-36.html Post your attempted query SQL statement.

Fairly common topic. Review https://www.access-programmers.co.uk/forums/threads/max-of-multiple-columns.184618/ https://www.access-programmers.co.uk/forums/threads/finding-the-lowest-value-in-multiple-fields-issue-with-null.235721/

MajP, when you say "get rid of all lookup tables" did you really mean "get rid of all lookup fields"? Because surely the tables should remain?

Did my explanation clarify that it is not "safer" option and not appropriate for the requirement?

Labels have Tag property but not Value. So far, don't see any regular Access controls without Tag. If control's property does not have "clear", code should work, unless form includes ActiveX controls. I have a form with two Web Browser controls, each with different properties - one has Tag and...

Did you try it? Aggregate ignores records with Null in specified field. If no records, function returns Null (except for Count which will return 0) so calc Nz(fieldname,0) accomplishes nothing because there are no records for Nz() to work on and Sum(Nz(fieldname,0)) still returns Null when no...

Now use Nz() function. =Nz(Sum(fieldname),0)

I edited my previous answer and no longer has that suggestion because it did not work in my test. I should have tested before posting.

There is no Null() function. There are Nz() and IsNull() and Is Null. Testing for Null in main form textbox won't work because there is no Null, there is an error and the error will just propagate and textbox shows #Size! error. I did a test and when there are no records in subform, main form...

Reported in other thread that changing to 1 fixed problem. I finally examined the db and can see the issue. And I was able to replicate in my db.

RunSQL will trigger warning popup. Avoid that by turning Warnings off then back on after. Or use CurrentDb.Execute instead of DoCmd.RunSQL.

FAYT is basically what I suggested, just didn't put a name to it.

Selecting part from BOUND combobox should be able to save to record without resorting to a "search form" and code to INSERT a record. My suggestion is code to reduce the combobox list to a smaller set of choices for user to review and select from.

Did you see post #3? The filter criteria could apply to multiple fields with OR operator.

Could have code filter combobox list based on text entered. Similar to http://allenbrowne.com/ser-32.html. Modify to use wildcard on each side of input.

I see that now. I used cmd window to output IPConfig info. I have 5 configurations and 4 are disconnected so I only get IP for my WiFi as only enabled objects are retrieved by the query into IPConfgSet. If I remove the filter criteria, I get 18 items. I also looked at DeviceManager and it lists...

Does this help https://www.access-programmers.co.uk/forums/threads/how-to-get-my-computer-ip-address-with-vba.331661/

Yes, I already had Access Tips page open on my browser but could not open links from there. Back to all good now. Could be nice if accessmvp.com adopted Allen's site like they did with Ken Snell's. Oh, wait, that's just a link to Ken Snell's site? So Allen would still have to maintain?

?CBool("A") triggers error So CBool() understands text "True" should be converted to Boolean True.