Prevent Duplicate Through VBA Userform (1 Viewer)

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
Hello everyone,
I made a userform named (frmEntry) and through this form I add my data into excel sheet. one of the colume is CODE.

Want:
When I click on the frmEntry SAVE button, I want to check for duplicate on column CODE

Thanks all
 

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
More Info

for further information plz see the attached file...
 

Attachments

  • DuplicateProb.zip
    11 KB · Views: 536

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
Hello everybody,
plz anyone write the solution....
 

tanha

Registered User.
Local time
Today, 13:25
Joined
Apr 9, 2007
Messages
80
Hi,
Nice work...I am really interested to know the solution for this thread too, Please some one from this forum find the solution for me and for the one who need it....................

Thanks in Advanced....
 

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
Hello Everyone,
Sorry for writing again, I really need it, and Do search on the internet and I tried with my best ablility, but unfortunately could not find the solution for that.
There must be some one who faced to this problem or have the knowledge of this...
plz some one help me
 

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
Hi everyone,
What is going on on the Excel forum, from yesterday upto now, no one reply for the above thread...
plz some one reply for the above thread................................
 

shades

Registered User.
Local time
Today, 03:55
Joined
Mar 25, 2002
Messages
516
Don't know about anyone else, but aside from 12-14 hour days, not much is happening in my world. Frankly I don't have the energy after those kinds of days to tackle something like this. And funny thing, my wife thinks I should actually talk to her too. :) So, that is what I am doing.
________
SUBARU EA ENGINE SPECIFICATIONS
 
Last edited:

boblarson

Smeghead
Local time
Today, 01:55
Joined
Jan 12, 2001
Messages
32,059
Patience is required when posting on this site. We are all volunteers here so you get it when we feel like it or when we have the time to respond. If no one responds in the time you need, then look into hiring someone (not via an ad on this forum) to do it for you so they can concentrate on your issues.
 

tanha

Registered User.
Local time
Today, 13:25
Joined
Apr 9, 2007
Messages
80
Hi all,
first I am thanking all ones in this forum, but just requestiong all not post such words and sentences here, please
Hope some one find the soluution for your thread (20120), and others take the benefit too
 

a_20120

tan
Local time
Today, 13:25
Joined
Nov 21, 2006
Messages
175
Hello everybody,
Yeah you all are right, Patience is needed...
 

ssteinke

for what it's worth
Local time
Today, 04:55
Joined
Aug 2, 2003
Messages
195
Last edited:

unmarkedhelicopter

Registered User.
Local time
Today, 09:55
Joined
Apr 23, 2007
Messages
177
Surely not !!! ;)

That would be cheating :eek:

a_20120/tanha is still gonna have to wait for the code though :D
 

kenjreto

New member
Local time
Today, 01:55
Joined
Feb 11, 2010
Messages
1
It's funny how tanha always seems to request that someone reply to a posting by a_20120, just a few examples:

  1. http://www.access-programmers.co.uk/forums/showthread.php?p=583678
  2. http://www.access-programmers.co.uk/forums/showthread.php?p=581356
  3. http://www.access-programmers.co.uk/forums/showthread.php?p=581364
almost like they were the same person, huh... imagine that...


They couldn't be the same person because tanha speaks with broken english, while a_20120 has strong grammar!...
 

vbaInet

AWF VIP
Local time
Today, 09:55
Joined
Jan 22, 2010
Messages
26,374

Users who are viewing this thread

Top Bottom