Recent content by dataheadache

At last, an answer to a simple question - Thank you!

re-open it - as it has previously been closed, not hidden.

Pehaps I didn't make it clear enough. Let's try again... Is there anyway to automatically open a form when a report is closed?

Thanks for that code, Rich - but is there an easier option, I mean, is there a Report_Close or Report_unload option where you could put: DoCmd.Close DoCmd.OpenForm "Switchboard"

... but how do I get the second form to not reload the Switchboard until after the resulting report is closed (i.e get the report to re-open the switchboard when it is closed)? I don't particularly need the above code to check whether the report is still open, just one to re-open the Switchboard...

Not Quite - Anyway, I have a second problem now - I've used this code 'In the main form: Private Sub cmdOpen3_Click() Me.Visible = False DoCmd.OpenForm "Form3", OpenArgs:=Me.Name End Sub 'In the second form: Private Sub Form_Unload(Cancel As Integer) Forms(Me.OpenArgs).Visible = True End...

Thanks for the help everyone - but this website had exactly what I needed.

So, using the above code, How do I make the switchboard automatically reappear after I close the hypothetical "item" (preferably without using the Window - Unhide Menu item)?

I have created a switchboard in Access, however, when I click on an item the "item" opens up behind the switchboard - meaning that I have to move the Switchboard out of the way to see the "item" - how do you get the Switchboard to either move behind the "item" until the "item" has been closed or...

Thanks a.sinatra - that worked a treat - the problem with DoCmd.Close, rich is that after the report was opened, the report became the active window and if I just put DoCmd.close it would have closed the newly created report, and not the form - which is not what I wanted!!

I've built a form which asks for data to search my database, once I select the data - I click the Preview button which sends the requested data to the query to bring up the report - on my form I have two button "Preview" and "Cancel" - I want to enhance the Preview button to close the form which...

I did follow you guide, and yes, it did work.

I've created a form in my database that has two combo boxes - one called cboID (which gets data from my table field called DiscID) and the other cboSide (which gets data from the table field DiscSide) - I want to update the cboSide combobox so it shows only DiscSides that were used on a...

After looking at your example - I have managed to get it to bring back the data on a particular disc. However, in the combo box that has been built, I have a list which looks like: (formatted DiscID | Disc Side) 02 | A 02 | B 03 | A 03 | B 04 | A 04 | B HDD|HDD (I used the DISTINCT option...

Thanks again for your reply. I have renamed a few things after I posted my last message and before you answered - which got the form/query/report working - but no matter what I select from the form now, whether it be Disc 2 Side A, Disc 4 Side B, Disc 1 Side A or the HDD it always brings up the...