Recent content by Gaztry80

I think I got it to work, by adding first a check if the subform is already on Dirt in frmAddCar. We want the timestamp the moment the record enters dirty mode and don't change it when a field is changed. Please see my update based on your last modification.

I don't think that will work, because if the user edits another field like ProductType, it will take the "record finish datetime", instead of "records start edit/insert datetime"

The functionality for issues 1 and 2 has been resolved. However, the incorrect time is now being inserted/updated in the StartDateTime field. Currently, it records the time at which the record is saved, but I would like it to capture the time when the user begins the insertion or update process...

After testing, I can confirm that issue one is resolved. However, after inserting the record (using the method from issue one), issue 2 still exist for that record, StartDateTime is null/empty. Also when changing an existing car by using frmAddCar form (with text68) is not updating anymore the...

Hi, control "Text68" within form frmAssignmentDetails

Hi all, I have created a sub-form called "frmAssignmentDetails," which I use in the main form "frmAssignment," where I can add new cars based on the table "dbo_tblCar." I use some FAYT VBA code from MajP to find the car in a combo box. In case the car is not found, the user can double-click on...

Hello everyone, I have been working with MS Access linked to SQL Server for a while now, but only as a single user until recently. I am now experimenting with a setup for multiple users, which brings new challenges in terms of access and management. Currently, I have set up a user database...

Thanks! I managed to get it working with this code: Option Explicit Private mHandleArrows As Boolean Private mAutoCompleteEnabled As Boolean Private Sub Form_Load() mHandleArrows = True mAutoCompleteEnabled = True End Sub Private Sub cmbIngredient_KeyDown(KeyCode As Integer, Shift...

Thank you for sharing some ideas. I am doing some trial and error to see if I can get something to work. I forgot to mention in my original post that this combobox is within a continuous subform. While experimenting, I keep getting an error that the recordsource cannot be changed while the...

Hi everyone, I am trying to implement MajP's FAYT solution for a combobox, as discussed in the following post and MajP's provided solution "(MajP FAYT V12, class module: FindAsYouTypeCombo) (topic: "Search as you type with in Combobox / instant filter combobox itself" < cannot post the link) I...

Thanks @MajP , your test files have really helped me today. Will play tomorrow again with it, enjoy the evening :D!

I like this :cool: 🚀 . Both versions give me some new learnings. Is it correct that the method used in TEST3 is a tiny bit faster regarding loading / processing?

Thank you for your reactions. I am familiar with Parent & Child linking of subforms. The reason I am walking this path is that I want to determine the recordsource of "frmCarColors" based on a variable from "frmCars" and the recordsource of "frmIngredient" based on a variable of "frmCarColors".

Goodmorning, Last year i posted the following question about error 2455. https://www.access-programmers.co.uk/forums/threads/error-2455-requering-another-subform.325272/ I now get stuck with the same problem and still don't understand what I should do differently (feels stupid 😅) . Scenario: I...

In my real database, i use this oncurrent event to run an if statement after selecting a row which checks some conditions in frmFirstTable and change the recordsource to a different source in frmSecondTable, afterwards it requeries. Do you have any suggestion or example how I should do it...