Search results

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.

A VBA expression where 2=True would return False. Null=True returns Null and in an IIf() that would evaluate to the False condition. ?-1=True True ?2=True False ?Null=True Null ?IIf(Null=True,"A","B") B CBool() forces number input to be treated as True or False, not that the input is True...

AFAIK, a Yes/No field cannot be Null. It is either True or False (-1 or 0). However, since Null is not -1 it would be treated as False.

Again, I tested that criteria and it worked for me. Could provide you db for analysis.

Sort of agree, Doc. Adding parens shouldn't hurt but not having in complex JOINs can. And for even less typing, don't need = True or = False if these are truly Yes/No fields. Semi-colon is also not required. sQry = "UPDATE Discrepancies " & _ "SET Notes = 'Spelling' " & _...

This is not valid UPDATE syntax. FROM belongs with a SELECT. John, I tested your syntax (without the bad "or") and it works for me. Appropriate records are updated.

Please define "render" in this context. If you are trying to input a string that exceeds 255 characters into a Short Text field, that will fail.

As already suggested - make subforms really small (0 height), virtually a barely visible line, then position them almost touching each other, set CanGrow to Yes. Can't really completely eliminate space but maybe hardly noticeable.

Because the SQL engine will process the SQL statement and "find" the function and evaluate. Just as if you had referenced the function in a query object. Semi-colon is actually not necessary but doesn't hurt. Also, DoCmd.RunSQL will allow form control reference to be embedded and evaluated...

Would these remote laptops even have reliable internet connection? Have you tested connecting remotely using command line commands? From what I've read, it's quite an involved process to set up MySQL to accept remote connections. MS Access as frontend might not be best path. Review...

"In the field" means they are not on the same network as MySQL server. They would have to connect over internet, maybe via VPN. MS Access is not designed to work over internet. Have you done any research on remote connection to MySQL?

Instead of hijacking a 4-year-old thread, should start your own. New threads get more attention. Reference the old one if you think it has relevant info. Graph should still work on report. I have an older accdb doing this with classic graphs and still works under Access2021. You moved code as...

No, this cannot be accomplished by a simple calc in table. Generating custom unique identifier is a fairly common topic. I had to do this for tracking laboratory samples. Samples are numbered sequentially for each year. The numbers had to be accounted for so no gaps and code deals with that...