Search results

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.

This would maybe a good solution, but i have to think about the limitations. Eventually, I want to do some tests before loading the data and i wanted to use the sql server queries for this purpose.

Thanks for replying, this one does not work, I think it is because the tables in access are named with "dbo_" and sql does not recognize this. 😅

Hi :)! I want to load some data from an Access form into a sql server table, but i am facing some challenges. The data I want to load is from/displayeb by a "saved qry in Access", lets call it "qryAccessDemo". This query I use in a form form with some related criteria's. So when I have a form...

Thanks guys for thinking with this problem. I now choosed to go for this method.

Hi again, I have this problem with my comment form, where I want to autoresize the comment field to save some space when it is not used. What I found in a couple of threads is that this is probably not possible, since it is only possible within a report. Some sources I found: Not possible...

Thank you :D I had a look to your greate example files, i think i can implement this!

Hi, I have two problems which i try to fix: First problem: I have created a simple project form where i try to make an option to asign a person to a project by a combobox. In addition, I want to filter the combobox with the corresponding category from the project. My current method is that i...

Thanks! I have deleted the PK on table 2, I thought that CompanyID in table2 also needed the status primary key. Since it is the unique identifier of Table2. When I make it a foreign key, access recognizes the relationship.

Good morning :)! When I create a relationship in SQL server and add them in my Access database, Access sometimes does not auto recognize the relationship. I try to understand why this is happening. I have tried to restart sql server and relink/fresh the linked tables in access after creating...

Good evening, I have a form which contains a combox to select certain products. I use the combobox to fill in the form. This combobox is based on a qry with approx 50 records. Now, I wanted to make a search box in the form which can be used to filter the combobox so I don't have to scroll all...