Search results

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...

I doubt the base set can be modified. Why is this needed? Do you want to limit user's color choices to a defined set? How many colors? After a certain point, can't avoid getting colors that look close in hue. If users want unlimited choices then they should be willing to learn the tool. If...

By "access runtime" you mean clients do not have full Access program, just Runtime? Are they running an accdb frontend? You say it "works perfectly in access" - so you mean on your PC with full Access program? Are you actually changing password in this case?

Cross-post https://stackoverflow.com/questions/79634165/how-do-i-use-vba-to-save-the-layout-of-a-subform-query-on-an-access-form

Not quite sure what you are asking for here. A combobox would be bound to field so a selection would automatically populate field of record. If a user needs to enter an item that does not yet exist in tblPropertyTypeAttributes, would require code to allow them to input "on the fly" during data...

Need a form/subform arrangement. Main form bound to tblProperty Subform bound to tblPropertyAttributes with a combobox using tblPropertyTypeAttributes as its RowSource This is essentially a many-to-many relationship where tblPropertyAttributes is a "junction" table that associates properties...

As I said, I did change the extension and it won't open, says file is corrupted. Attach the file in a Zip folder. Use Windows Compression. Could have included all those files in one Zip folder.

Build an aggregate query. This is basic Access functionality. Have you studied an introductory tutorial? File in post2 won't open, not even if I change extension.

Consider using a Toggle button instead. In either case, consider code to change button Caption property as well.