Search results

you can try something like: If Me.ComboName = "No" Then Me.TextboxName.Visible = True Else Me.TextboxName.Visible = False End If

the filename is stdocname so you can use the following stdocname = "Me.Fieldname" where fieldname is the name of your field.

an iif statement has the following syntax: IIF(Condition to test, "What happens if true", "What happens if false")

Hi, try creating a new database and import all of your objects to this new database and then try the compact/repair again.

you shouldn't be storing a calculated field i.e. concatenating the tel and remarks fields as a single field in a table. As suggested you should create the third field in your query and then use that field elsewhere i.e. forms etc.

you can untick the check box in the Show row and you won't see when you run the query

Isn't it frustrating to see a spammer posting about 5 posts in different sections in a matter of seconds and then ironically you read at the bottom of the forum; Welcome to our newest member, SpammerName :mad:

you can put that as a new field in your query and you should use the iif iif(a>b, a, b)

Go to the default value property of function1 and put the following: [Forms]![FormName]![FunctionControlName] Replace the the above with the actual names of your form and control.

Therefore you can try something like the following: Application.FollowHyperlink "C:\" & [UserNameFieldName] & ".pdf" Substitute UserNameFieldName with an actual control name on your form which has the user name

Happy Birthday Haley and i hope we will see you around again some time.

Hi No, not in the criteria row. In your query next to the two fields on the top pane i.e. the Tel and Remark, use the third column to create the calculated field and put above suggestion.

Do you mean that there will be a 2006 pdf file different for each record ? If you simply want to open a file when a particular year is selected, try searching for Application.FollowHyperlink

to concatenate you can use the & ="Your old tel" & [TelFieldName] & ": " & [RemarksFieldName]

What datatype your EquipID has ? Also make sure that you are using the correct names for your controls. Otherwise your code seems ok

Hi, Right Click on your image in your form and click on Properties and you should set the properties there.

Hi, have you tried setting the back style of your image (when in .bmp) format to Transparent. Also you can try setting the "size mode" property.

have you considered using conditional formatting?

The tags shouls be <?php (opening tag and ?> (closing tag) Also you need to save the file in .php extension

I had just the daunting task of renaming all the controls when creating a form on my mind, but yes i perfectly agree with you that an overall naming convention would be a good suggestion.