Search results

I have several folders in ms outlook which i would like to turn their reading pane option to "off", however according to the outlook help files this has to be done on each folder individually. Does anyone knows of a "trick" which can change this setting to all folders at once rather than going...

try Like "*" & [enter name] & "*"

I'm glad that you sorted your problem. Since you have solved your issue there is no need to upload the sample because i was simply going to take a look where the problem was :)

could you upload a small sample of your database i.e. the form in question?

probably the problem is that either your FirstName or Surname fields are null. In that case you can use an if statement to check whether any of the fields are none i.e. If Not IsNull(Me.FirstName) And Not IsNull(Me.Surname) Then Label7.Caption = 'reference the controls here Else Label7.Caption...

you're welcome :)

put your code on the OnCurrent event

you're welcome :)

you can try: If Not IsNull(Me.FieldName) Then Me.CheckboxName = True Else Me.ChecboxName = False End If

and undercover task

one of the

try Private Sub cmdPrint_Click() Dim str_Filter As String str_Filter = "[Casenumber] =" & Me.txtCase DoCmd.OpenReport "rptSCT", acViewNormal, ,str_Filter End Sub Note that a comma has been added near the str_Filter

and some strange

try using a different name rather than Case because case is also a vba Keyword. Try naming your field something like txtCase

Hi, As I have already explained above that should read "[Case Number] = " & Me.Case

so it should be str_Filter = "[Case Number] =" & Me.Case note that in your original code you did not have the "Me."

I'm glad that you solved it out :)

what is the datatype of your field? Because if it is "Text" and not "Number" you will need to add the quotes i.e. str_Filter = "[Case Number] = '" & Me.Case & "'"

so that it

you're welcome :)