Search results

I think he means the "compare to other records" option in conditional formatting. Personally I've never used this feature, but other conditional formatting (background color) works fine for me with sorting & filtering. I am unsure how this would react when values are filtered, with the...

Hmm, I am eager to learn! I already read Minty's (new) Normalization explanation.

[YourField] = Environ("UserName")

For normalization, you merely do the same things with all the different tables, in different audit tables.

Your date picker probably results on a DateSerial, meaning that you need to take out the "#"'s.

Or turn on vertical scroll bars on the subform.

It really depends on how the form is used, but I have found the best way to set-up a reliable audit trail is to create a logging table, with more than twice the fields of the audited table: a field for each previous field, and a field for each for changed values. Then a field for the username as...

I did something similar to this (only one letter though), and I used another field for the letter, where a third field had the concatenated string (whole thing). Specifically, I wanted to be able to differentiate between serial numbers if two or more documents were accidentally given the same...

Don't do that. Use a query to query all 3 tables, then use the results in your report. You can then debug your query rather than debugging your report blindly.

The query must get it's information from somewhere, or to somewhere, did you change the type in the table too?

I see a possible issue here: this code appears to be wrote for the main form. And the code relies on a value in the subform, which is dependant on the current record. I would think the code should be modified to be moved to the "current" event on the subform. Also, IDK if it would also...

In my opinion, if all is within a LAN (single-location network), and not on Wi-Fi, you will not have any problems with the network. And as far as system specs go, a small database is no excersize for a desktop computer that is not extremely obsolete. However, weak computers like a "chromebook"...

That's why I never use "IsNull(...)," instead I use a simple custom function: Public Function ZeroLength(InputVar As Variant) As Boolean '.................................................................... ' This simple function checks the variant, of any type, ' for either Null or...

Like this: Private Sub TextBox_BeforeUpdate(Cancel As Integer) If Dcount("*","Tables![yourTableName]","[Field]=TextBox") <> 0 Then Cancel = True MsgBox "Value exists, try another..." End If Exit Sub End Sub Assuming your textbox is formatted to the same type variant as [Field] (otherwise...

Try making a new column in your query: Expr1: DateAdd("m", 3, Date()) Then in the conditional of your [FieldName]: Between Date() AND Expr1

I see. I had to open an old database backup save to read this, as I had replaced all these with vba assignment instead. It turns out I was mistaken, it was: =DLookUp("[FieldName]","[TableQuery]") So (with mud on my face) 🥵 I was wrong, you can't save to the table/query this way through...

If the table/query only has one record, then it isn't a problem. For instance, I use a database table to assign names of units to an entity, it only has one record - the current one. So there is no need to specify which record, it uses the only one. Hypothetically speaking, if one changes the...

Edit, IDK about add.

The same way you would refer to a table (or query) cell in vba, for instance: =Tables![yourTableName]![field] works for a single record table, or a singe record result in a query; =Tables![yourTableName] may work for a multi-record table/query (not sure about syntax here).

Unbound form does not mean unbound textboxes. You can bind individual textboxes to different sources. Otherwise, what data could you you talking about to save on that form?