Search results

I have form with 4 cascading combos on it. Both 3 & 4 are related back to No2. If I try and move the position or hide the bound field in either of them so that it cannot be seen by the user, I get a parameter box pop-up when the form is closed from a button, but not if it is closed by Xing...

I have a combo box that is set as limit to list so that when a new entry is added it brings up a form to add the new entry to the list. It currently does this by requerying and putting the new entry in order in the list, I would like it to automatically enter the new entry as the active entry...

I have a form which can be opened from 2 different paths. One from the person who will use it and access it one way, and one from the supervisor who has access to a number of these forms used by different departments. What I want to do if possible is have the form remember where it was opened...

I have a main form with an option group with 6 choices, I want the user to choose one of the options which will then open a new form. The code I have on the OnClick for the group does not give me any error messages when a button is chosen but it also does not do anything. Any suggestions would...

Is it possible to use an append query to take data from a linked table and append different fields into 3 different tables. Or do I have to use 3 different queries to do this and then run them consecutively either through code or a macro.

I have a combobox that I need not to show the first line as blank but as the first record in the table the box is based upon. I know this is simple but have brain freeze at the moment. Thanks Iain

I am trying to create a subform based upon a recordset, that is created from a query based upon the selection in a combobox. So that when a selection is made in the combo it runs the query based upon the selection and then populates a subform. Never having written very much VBA I would...

I have a problem with a table that I occasionally have to import from Excel. In the Excel table there are 4 fields, and when it is imported into Access I need there to be 5 fields. The field that is the problem is called POR and shows dates in the form (Jan 1947 - Dec 1953). I need this to...

I have a Form and a Report both based upon the same parameter query. When I submit the parameters the query is run and the results are viewed in the form. If the user wants to print the results. they can from a cmd button on the form. But my problem is that as soon as they do that the query...