Search results

In sub form module: Me.DestFieldName = Me.AnotherFieldName

You have two erroneous lines in your code. Replace them with the ones below: CurrentDb.Execute "UPDATE 201Assets SET AssetFlag = True " & _ "WHERE stdid=" & Me.subformAssets.Form.Recordset.Fields("stdid")

https://docs.microsoft.com/ru-ru/office/vba/api/access.formatconditions.add https://www.access-programmers.co.uk/forums/threads/conditional-formatting-the-field-based-on-the-value-of-another-field.301500/

Oops! Please forgive me generously. I can't see well this morning ....

Try use Me.Undo ...

Dim sVal As String, vVal sVal = "[Customer ID] = " & Me![Customer ID] & " AND [Customer First Name] = '" & Me![Customer First Name] & "'" vVal = DLookup("[Customer ID]", "[Your Table Name]", sVal) If vVal > 0 Then 'Found ... ' ... Else ' ... End If

Yes - it Is possible - For example by DlookUp() function. DLookup Function in Microsoft Access

You don't need that already! My computer doesn't match either (i have no TPM2 module). I installed myself from the original image - everything works

There could be many causes for this Can you post a sample form with the necessary tables

Private Sub YourTextFieldName_AfterUpdate() Dim s As String Dim t As String Dim i As Integer 'Clearing the field value of all characters except digits s = Me.YourTextFieldName & "" Me.YourTextFieldName = Null For i = 1 To Len(s) t = Mid(s, i, 1) If IsNumeric(t) Then...

Before adding new records to table "INTAKELOG" you should have "Relation key ID" record in table "CLIENTS" for each new record. ... And read: Introduction to data types and field properties - that's about second screenshot from post #28 ...

There are some functions for data transform ... TimeValue() for example ... ... My local time is late, I'm tired. I leave you in the good hands of the experts of this forum. Good luck!

That's why !

Some fields are perplexing ...

Two fields were missing in the file: "MASTER DATA EXPORT TEST.xlsm"

Ye-e-e-e-e-s-s-s-s! That's right. But I worked with the file that was posted and there were really two fields missing. I didn't make it up any more ...

@JED25 - query works: INSERT INTO [INTAKE LOG] ( ADMISSION, [CLT ID], INSURANCE, [REF BY], LOC, DISCHARGE ) SELECT [INTAKE LINK].ADMISSION, [INTAKE LINK].[CLT ID], [INTAKE LINK].INS, [INTAKE LINK].[REF BY], [INTAKE LINK].Loc, [INTAKE LINK].DISCHARGE FROM [INTAKE LINK] LEFT JOIN [INTAKE...

That's better! Looking at the material ...

И где Excel файл - А! ??? Вы думаете - или нет? ... :( ... EN: And where is the Excel file - Ah! ??? Do you think - or not? ...

You are not the only one who has this kind of thing Just replace sensitive data with meaningless text by using update queries.