Search results

Hi Mike, Not sure what you are suggesting here by Select object before before other actions? The only action I was looking for was to preview a report, What actions would you suggest to follow? cheers Tanya

Hi RainLover It worked wonderfully. I can live with the form opening maximized! Thank you very much. Regards Tanya

The form is modal and is dependant on ClassID

Hi, I ended up simply getting the report to print. But interested in how to toggle the forms to view True and False. Could you please give me some direction on this. Thanks Tanya

Hi Ned I have already tried that, I think the problem is however on reflection that the report is looking at a query with a where clause directed at the form. i.e. it is looking for the ExcursionID to base the report on. Tanya

Hi my report opens fine except that I can't access it without closing the form which has the following code to open the report: My question is, is there a way to open the report and maintain a focus on the report until you close it? Private Sub CmdPreviewAllStudents_Click() On Error GoTo...

Just because you have a 1 to many relationship doesn't mean you have to have a corresponding record in another table. Have a look at my example, I think it will achieve what you are looking for. Cheers Tanya

Sorry, too late to spend any more time on this and going away for a couple of days. I am sure some on this forum will be able to help you.

See how you go with this copy Ian, I can't do any more tonight its too late. Don't know what was wrong with your version, couldn't get it to cooperate. I've given you two versions of form setup. You can choose which suits. You will have to import your data across and tidy up the forms...

You are welcome, glad I could help.

oops... you are using 2007, I only have 2003. You will need to save it in an earlier version You could also try uploading to this site for free http://www.savefile.com/

You could try creating a new db and importing all the tables, forms etc.

Here, its not pretty, but you should get the idea.

Try 'Tools>Database Utilities>Compress and Repair'

Yep, no prob

Another version. After re-reading your first message

The sample I have loaded takes advantage of navigation buttons to achieve what you want, it is the easiest way to navigate. the form also allows you to add new films. It can be made more user friendly with combo box's for ease of searching a particular title if you wish.

Here is a sample of what I think you want, you can work with how it looks. Let me know how you go with it. cheers Tanya

Hi dk I like your solution, nice work!

you need another table to relate the two tables you have already. Like this tblFilmCopyRecord FilmCopyRecordID - PK FilmID - FK FilmCopyID - FK You then need to relate the tables. Once you have done this, creating a form to enter your data is relatively simple. Hope this helps.