Search results

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

Good evening, I have a form called frmMainTable with two sub forms (frmFirstTable & frmSecondTable), in the subform frmFirstTable I have placed in the on-current event the following code: Forms![frmMainTable]![frmSecondTable].Form.Requery However, when I open the frmMainTable I get the...

If you create the database yourself and read this, I realise I am being pulled down the rabbit hole 🐇😜

Thanks for replying :)! I am using sql server by the way as back-end. I don't think the relational integritry is working, since the table (with product key*) related to frmA can have records while they don't have to be exist in frmB (TableB). Below a small example in excel what i want to...

Morning :)! I have made a continues subform (frmA) on my main form (frmMainA) with an button on it. In the clickevent I have made some statements to run eventually a delete query. There is also another subform (frmB > which is linked to frmA by frmMainA). Now I want to make a If statement that...

Thanks for all explanation and different suggestions :)! Learning a lot these days. I have used the method suggested by arnelgp & sonic8, which was suggested in the begin of the thread.