Recent content by Elyso

Thank you to both of you. The problem has now been solved. The public variable solved the issue.

I have a form which has an OnClose event handler connected... Private Sub Report_Close() DoCmd.OpenForm "MyFormName" End Sub What it does is simply to open the form called MyFormName but of course the first record will be displayed and that is not optimal. I have an ID number which is the...

I use Access 2007... maybe that makes a difference... I don't know. John, if you can post a sample it would be awesome... :)

Thx for your swift reply... I tried to go into my form, clicked properties and chose the tab called Event... first row "On Current", chose the code builder and put in the following... Private Sub Form_Current() DoCmd.Maximize End Sub Saved and tried again but still it won't work....

Thank you both of you... I liked your solution MStef but when I close the report I want the form to be maximised in sized but it is not.. for some reason... John Big Booty, your solution appears to be the most professional one but I am not a wiz in VBA so don't know how to use your...

I have two issues and hopefully you can help me out here. Basically I have a form (called MyForm1) connected to a table with some hundred records.... In MyForm1 there is a button (CmdButton1) with an onclick event attached. When CmdButton1 is clicked a macro is run (stored in Access' own macro...

Sorry to say Ajetrumpet but you just lost your last nickle... I composed this question yesterday and posted it on this and only this forum, nowhere else. It wouldn't make sense to post a question from somewhere else (at least not if the answers were to be found in the other place too).... but...

I have a form with a couple of text boxes and and some check boxes. The data that is entered in some of these textboxes should be validated with some preset rules and if the criteria are met other text boxes should be enabled. I was hoping that someone can help me in the right direction here...