Search results

I have a modal form which has a single record which is then linked to a sub-form on the same modal form. This all works fine and shows the relevant record and sub records but I want the modal form main record to change dependant on the record selected in the subform (which is basically order...

I have a table which has 2 fields 1) Project_Priority_Number and 2) Previous_Priority_Number. If there were 100 records these would be numbered 1-100 in the order that the user originally sets the priority (this number is in addition to the record ID number). I have created a form with code...

Hi - I have a main form (let's call it MAINFORM), attached to that I have a sub-form (let's call it SUBFORM). In the SUBFORM there is a combo box which gets its list from a select query (lets call it QUERY1). I have a "ON CLICK" action to run the query. When I load MAINFORM and click on the...

I have the following code as I have user/login tables. When the user logs on it creates a record in the relevant table, when they log off I want it to remove the user information. The code works fine for the first part but when I come to use it as part of the quit button code I am getting the...

I have a main form "KZ_SEARCH" and within this I have a subform which is loaded when a button is pressed and is populated with query results (based on text entered in a text box). The subform is called "KZ NOTICES Query subform". That all works fine and the query modifies based on the text...

I have a form with a button which then shows a popup form. The popup form is just to list customers and their respective customer numbers and is not relevant to the base form that the button resides on (as in there is no common data). When the popup form loads it has a textbox where the user...

I have a drop down box on a form that, dependent on what is chosen runs a query which creates a new table ("POWER PRICES Query Table 1") via a Macro. It then displays the results in a sub-form. If you then use the drop down box again to change the selection I get the error message "The...

Hi - I am not very adept at Access but have put together some tables, queries and forms and have, so far managed to get by. I have come to something which should be really simple but I am struggling. 1. I have a table called "CONTRACT NAMES AND NUMBERS" with a field called "REDUCED_USERS"...