Search results

How does one trap the clicking of the close box (x)? I would like to present the user with a "Save Changes?" msgbox before the window closes. thx, Jeff

Thx

As I understand your structure you're analyzing the data in InputFile2 for each record in InputFile1. To "go to the beginning" of InputFile2 try this: Open InputFile1 For Input Access Read As #1 Open OutputFile For Output As #3 Do Until EOF(1) ....(code) Open InputFile2 For Input Access...

This may be a stupid question but... I have a form that opens a second form. I'd like to have the first form call a particular subroutine of the second form. Here's what I have: Form1 Module ----------------- DoCmd.Open "Form2" Call SetupForm(Param1, Param2) 'This subroutine is in Form2...

Is there a way to get the results of a query into a recordset using ADO? I've searched the archives here and have come up empty. Thx, Jeff

I've ported the MSFlexGrid control onto my MSAccess form. I'd like to populate the grid with the results of a query. What is the best way to do this? Should I load the query results into a recordset and then into the flexgrid? Any suggestions would be welcomed, Jeff

Thanks for the reply. Turns out the problem was with the type of control that I was passing (MSFlexGrid). I changed the parameter list to "Generic as Control" and it is working fine now. Jeff

Are you using a module? Private Sub chkBox_Click() If chkBox.value then Datefield = Date() Statusfield = "New" end if End Sub HTH

What is the correct syntax to pass a control as a parameter? For Example: Private Sub ChangeEnabled(Generic as Textbox) Generic.Enabled = not(myTextbox.Enabled) End Sub Private Sub Main Call ChangeEnabled(Me!myTextbox) 'This doesn't work End Sub

Try this mlujan: Call choosebox (Me!Box0, true) This way you are passing the control object directly. Since each box will have its own Box?_MouseMove routine, the choosebox routine can still be generic. Hope this helps, Jeff