Search results

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

Thanks for your reply. I've done as you have suggested and created list boxes and a buton called "Preview" which I think will bring up the report if... I knew how to get rid of the parameter box asking for "Forms.Disc Enquiry.Disc ID" once I press the Preview button. Any ideas?

Anybody got any ideas?

Generating a Report from A Form As you may have worked out by now (from my previous posts) I am still relatively new to Access, and would like some more help in simple terms (with directions as to where to find things) on the following: I have built a database which contains a table of...

Silly me! It was there all along, wasn't it? I just kept looking past it. :D Thanks to everybody for their help and suggestions as to what it could have been!

The report is based on a query - I've run the query on it own, and it does not ask for the Prog No. there - but does ask for it when the report is generated. Does this mean that the fault lies somewhere in the Report design, and if there is a hidden expression/field/text box etc. somewhere on...