Recent content by syztemlord

Is there anyone who can help with this? I'm sure it's something very simple but as a noobie to Access I'm starting to loose the will to live! Please help!

I tried the "DoCmd.ShowAllRecords" but when I have done a search then click on the clear filter button, I get the query search window up again.

I have serveral filters I use on my form, example: Private Sub customer_Click() Forms!customers.RecordSource = "Enter_Customer" FilterOn = True End Sub I would like to add another button that clears all the filters and allows me to view all the data again. I have tried using "Me.FilterOn =...

That is so simple, thank you very much.

I'm looking to create a query which I can use to produce a report. In one of my tables I have an "In Progress" check box. I'd like to create a query which will show all records with the "In Progress" box checked. I'm just not sure what to enter in the criteria field in the query.

Thats great, worked a treat, thanks.

I've just created a parts database which holds data on customers and parts informaion they have ordered etc. I have an email field which I would like to place a button next to which when clicked, opens a new message window in my email client and takes the email address from the field in the...