Search results
-
Syntax to populate a field in a subform based on another field in the same subform
Your question is older than the universe! :) The point is that by applying selection conditions to the secondary combo box - you do it for all records of sub form. -
Syntax to populate a field in a subform based on another field in the same subform
In sub form module: Me.DestFieldName = Me.AnotherFieldName -
Solved VBA - Form update boolean field
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")- Eugene-LS
- Post #3
- Forum: Modules & VBA
-
Solved Programatically change color on continous form conditional formatting
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/ -
Solved Now allowing Sub-form to update table based on condition in subfrom
Oops! Please forgive me generously. I can't see well this morning .... -
Solved Now allowing Sub-form to update table based on condition in subfrom
Try use Me.Undo ... -
Solved How to find out the ID of the record to which I am trying to add a duplicate
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- Eugene-LS
- Post #6
- Forum: Modules & VBA
-
Solved How to find out the ID of the record to which I am trying to add a duplicate
Yes - it Is possible - For example by DlookUp() function. DLookup Function in Microsoft Access- Eugene-LS
- Post #2
- Forum: Modules & VBA
-
Tried 11 yet
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 -
Solved how to listbox for specific record
There could be many causes for this Can you post a sample form with the necessary tables -
Solved Filter characters or remove spaces or allow particular characters
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...- Eugene-LS
- Post #2
- Forum: Modules & VBA
-
Solved Append Query Key Violation
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 ... -
Solved Append Query Key Violation
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! -
-
-
Solved Append Query Key Violation
Two fields were missing in the file: "MASTER DATA EXPORT TEST.xlsm" -
Solved Append Query Key Violation
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 ... -
Solved Append Query Key Violation
@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... -
Solved Append Query Key Violation
That's better! Looking at the material ... -
Solved Append Query Key Violation
И где Excel файл - А! ??? Вы думаете - или нет? ... :( ... EN: And where is the Excel file - Ah! ??? Do you think - or not? ...