Search results

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

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

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

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

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

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

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

Hi, I am having some trouble with Referential Integrity, hopefully somebody can help me in the right direction. I have two tables, 1.) tblA with products and 2.) tblB with the corresponding demand of the product. The two tables are linked together with ProductId column. My goal is to have a...

Hi, I have frmTableA (persons) and want to open frmTableB when I double click on the "Name" column from frmTableA. frmTableB opens the TableB (friends) table, where friends can be entered which need to correspond to the NameId from frmTableA. Opening frmTableB I have managed by a small vba...

Hi again, I try to understand what would be the best way to update a status field in a table by my created form. Situation is the following: tblRequest has a StatusId, which is linked to tblStatus. I have created a form with and have placed the StatusId with standard value "1" (corresponding...

Goodmorning, I am struggling with one of my queries. Basically their are two tables, which are used to build a query to populate data. Table A: ProductID = PK CodeId Description Table B: Id = PK ProductID > multiple ProductID of the same can be exist in this table CodeId Color Active > Their...

Hi, I am trying to open a form (Form B) from Form A by making a VBA code with "DoCmd.OpenForm" and apply the where clause on the current ID field. This is working great when in the form that opens, the ID field is in the main form. However, i want to go one step further and open a form with a...