Checking Duplicates and error messages

[Ugo DI LUCA]

Hi,

Here is the way I check duplicates in my Company/Contact file using messages "completely integrated to the interface".

Hope this could help anybody. Of course, tell me if you identified any strange behaviour, as this file really belong to the my new database.

Many thanks for the constant help I have on this Forum.

UPDATED - SEE THE POSTS BELOW

Also included an adaptation of DJ's renumbering portal to bring the Main Adress from the Adress File.

I plan to post more of these in the near future as long as I rebuild my own database.

Password is UGO.

Thanks for the feedback.

[Lee Smith]

Hi Ugo,

Nice job, I like the feedback area a lot.

Lee

[Ugo DI LUCA]

Thanks Lee,

As promised, here is an update with :

- Checking Duplicates while entering new records

- Personalized messages within the Interface

- Locking records

- Renumbering portal

PASSWORD = UGO.

With the future update will be added a list of all threads from this site used to build this file.

Lee, actually you've been very useful with the function ABC--A.B.C...

Again, please tell if you encounter some problems...

[Lee Smith]

Hi Ugo,

I download it, and I'll run it through its paces in the Morning.

Lee

[Ugo DI LUCA]

Corections + HELP NEEDED PLEASE

Hi,

Some of you may have noticed the error as this file wasn't working as it should have.

There was a bad calc I modified here :

"c.ns_T_gOperatorNameAbbrev " =

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(g_N_OperatorName & g_T_Title & g_T_LastName; "."; ""); "-";""); ",";"");" ";""). Title and LastName were text field in the previous attachment !

This modified calc is used in another calc to trim any accidental carriage return when processing a new entry.

"c_T_trimg_CompleteOperatorName" =

TRIM(SUBSTITUTE(c.ns_T_gOperatorNameAbbrev; "

[Ugo DI LUCA]

Here is the last update. Don't pay attention to the last layout with a fixed layout that isn't fixed yet

Does anybody see any files attached here ?

[Lee Smith]

I'm getting the 404 err code you write about earlier.

Lee

[Ugo DI LUCA]

I know.

Anyway, the problem is still there. So check the second attachment and make the corrections to the calc as I said earlier. Thank you.

[Ugo DI LUCA]

OK, let's stop with these awful calcs. I now have a terrible headache.

I think I can handle a "check dupes on Names", then have a list of all records shown in a portal for these Names.

There were too many paramaters to check anyway as Mr SMITH could also have been entered as Mr and Mrs SMITH, Dr SMITH or Mr Lee SMITH ....

The important part of it was the substitute "-", ".",... and even Trim any spaces and accidental carriage return.

So I'll post the latest update of it soonly, waiting for the whole Contact file.

The "invisible messages" and locking records part of the second attachment still remains a little working tip for anybody who was looking for an interface with dynamic messages.

Thanks anyway.