Recent content by Jasperuk

Your table/query has a field in it that contains either OPEN or CLOSED or Nothing (Null)? Yes? Not quite the query has no blanks at all if that makes a difference... I presume this is a single 'l' Me.Fillter = "[ProdID]='OPEN'" ???

ok now we have a toggle box that changes if clicked on or not....cool Where do i put the other code ? Told you i was a complete novice didn't I :)

I am sure its a toggle button (see attached hopefully) Dont forget you dealing with a real novice here so not quite sure what i need to do, do i need to use code and forget the criteria box in the query ?

Hi Using a toggle box to ask the following question, i have data that contains either OPEN or CLOSED against each record. I tried using the following in the criteria for the specific data to either select all the OPEN records when the box is clicked and i would like to select all records OPEN...

Cheers Much Appreciated

What do i have to do to the following code to get it to attach a file to the email ? Sub SendMail() ' This routine will work will all incarnations of VBA Dim myOutlook As Object Dim myMailItem As Object Set myOutlook = CreateObject("Outlook.Application") Set myMailItem =...

The runcommand as part of a macro used to have the command RefreshPage in the 2003 version but i cant seem to find it in the 2007 version. Can anyone tell me if there is an alternative I need to refresh a form by pressing a command button eg. running a macro or vb that refreshed the current...