Recent content by michaellysons

Thanks again for the suggestion. It worked really well for my needs.

That's a good suggestion, thanks. I'll give it a go and see how it works.

I have a form that I want to open with acDialog (to prevent people interacting with the calling form). The form I open has a button to display the results of a query in datasheet view. The problem is that if I open the form with acDialog, the query results are displayed behind the form and I...

Fixed. Now I can see the wood, the trees, and even some birds!

I have a sub form that displays a list of students. There is a combo box on the sub form that limits the student list to either 'all students' or 'active students'. If I run the sub form on its own it works correctly: I can change the value in the combo box and the list reflects that change...

I've added an extra line to your code that should help you out. It's after the first 'WHERE' clause. Private Sub ProductSearchtxt_Change() Dim txtSearchString As Variant Dim strSQL As String txtSearchString = Me![ProductSearchtxt].Text strSQL = "SELECT DISTINCTROW...

That's a great tip, thanks. I wasn't aware you could call subs/functions in that way. I've tried it out and it works a treat. In fact, it works so well, it's solved another problem I was working on. Thanks again.

The subforms were being added to the tab control correctly; I checked that in the form view. I'm still no wiser as to why Access saw fit to reset the subforms though. But it works now, so I'll stop losing sleep over it.

Hi I'd like to make a sub form raise an event that can be trapped by the master form. Is this possible in Access? I have tried doing it and while I can create and raise the event, the master form seems unable to trap that the event has fired. For example, in the sub form I have some code...

I've solved it now. In my Access databases I have a form called frmTemplate, which not surprisingly I use as the template for all forms. I decided to delete it from my database along with the offending main and sub forms. I then recreated the main and sub forms. And lo and behold it all...

Hi I have a form that contains a tab control. There are a number of pages on this control, with each page containing a sub form. Here's an example: Form1 has a tab control called Tab1. Tab1 has three pages: Page1, Page2, Page3. Page1 contains SubForm1 - this subform was added first. Page2...