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

Thanks that works good. Will that also work with cascading combo's where it is in the secord or third in the cascade. Iain

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

Got it fixed. I had an open form argument in the code in the wrong place. DUH

The first part is in the on click of the calling form and the second part is in the unload event of the called form. Which is the way I read it to go.

Yes it appears to be running

Thanks for the try guys but it did not work, and did not come up with any errors either.:confused:

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

That got it thanks. Will be using the qry later hopefully, put it in there as i was thinking about it at the time.

So what changes would you suggest to make this work. Still trying to learn this code thing. Iain.

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

Thanks for looking at the problem but I have now got it to work.

What I have is a number of different tables all with the same structure but different data in each. e.g. A different table for each state. What I am trying to do is when the state is selected in the combobox, run the query on the table that matches the state selected. Then populate a form with...

Thanks but before it runs the query it has to set the table it will run the query on, as the current table(recordset), based upon the selection in the combobox.

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

Put all this code in a standard module: Public Function LastOfMonth(Optional dteDate As Date) As Date 'Purpose: Get last date in month of date provided ' This function calculates the last day of a month, given a date. ' If no date is passed in, the function uses the current date. If...

Got the problem solved with code from another forum. Thanks anyway.

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