Replies

Why should you have duplicated info in you database ? It’s against normalization. It seems that you database structure is not correct.

The same thing for Access 2007. No animation.

You can also use the menu View, Current View , Unread messages in this folder.

I added that to the top of both forms

You have to declare Public variables only once. Take it away in one of the two forms.

Can you repost the code in the button ‘on click’. Without seeing it, it’s impossible to say what’s wrong.

Public variables have to be declared at the top of the VBE editor, outside of the sub. And only once.
Something like this :

Have you insert the line :

Public frmLink As Form

Like Hans says ?
I don’t see it in the code behind the error message.

Hi Mark, can you please explain the procedure(s) you use to store the path to the backend in the registry?

Giorgio,
To write in the registry you use the SaveSetting statement
To read in the registry you use the GetSetting statement.
See the help file.

Don’t forget that there is a Split function you can use to split your field with the , :
MyArray = Split([MyField],”,”)

Then you have indeed some structure in this field so you can split it. But as the delimiters are , and ‘and’ (two different) you certainly have to do it in code.

Second thing : Why create a new table with 20 fields where all of them, excepted one, will be duplicated ? Wouldn’t it be better to create a table with three fields, the splitted field , the new alphanumeric ID and the primary field of your first table, and work with relations and queries ?

As your multiple reason is a sentence and not a delimited list how would you determine what the different substrings are in a query (I don’t see how) or in code ?
In your sample why should it not be :

2a(i) THIS
2a(ii) THAT
2a(iii) and
2a(iv) THE
2a(v) OTHER

I suppose you have Access 2007
Go to Access Options, Trust Center, Trust Center Settings… , Macro Settings.
What is the Macro Setting ? Mine is set to Enable all macros. If you have to change it, you have to restart Acces for activate the new setting.

Use the following formula :
=IIf(IsError([SubForm1].[Form]![SumCost]),0, [SubForm1].[Form]![SumCost])

A google search for “hide user account windows 7” bring several links. Most of them are speaking about modifying the registry. Be careful

If you forward the mails to someone with another e-mail program (ex outlook), are the pictures still in that Incredimail format or can you save it in another format ?

Glad I could help you to find a workable solution