Prevent for duplicate data (VBA MS Access) (1 Viewer)

A

ASK

Registered User.

Local time

Tomorrow, 04:08

Joined

Jul 23, 2014

Messages

21

• Jul 31, 2014

• #21

Yes, Mr.
Can I send the db file to your private email and could you please check me for that ?
or
Should I attach here ?

I am sorry for disturbing you.

Thank you & Best regards,
ASK

 

GinaWhipp

AWF VIP

Local time

Today, 17:38

Joined

Jun 21, 2011

Messages

5,899

• Jul 31, 2014

• #22

Yes, you can upload it here. Please remove any personal information.

 

A

ASK

Registered User.

Local time

Tomorrow, 04:08

Joined

Jul 23, 2014

Messages

21

• Aug 2, 2014

• #23

Dear Mr,
Could you please kindly check the attached & advice me how can I fix for it ?
And also in frmGui form, Duplicate Msgbox was shown as wrongly.

user name: opt (or) admin
pass: opt123 (or) admin123

Thank you & Best regards,
ASK

 

Attachments

• OPT DB_Test.accdb

  2 MB · Views: 64

V

vbaInet

AWF VIP

Local time

Today, 22:38

Joined

Jan 22, 2010

Messages

26,374

• Aug 2, 2014

• #24

ASK said:

Dear Mr,

Click to expand...

Ms (or Mrs) would be more appropriate "Gina" is a good giveaway.

 

A

ASK

Registered User.

Local time

Tomorrow, 04:08

Joined

Jul 23, 2014

Messages

21

• Aug 2, 2014

• #25

Well noted! vbaInet

 

GinaWhipp

AWF VIP

Local time

Today, 17:38

Joined

Jun 21, 2011

Messages

5,899

• Aug 2, 2014

• #26

Pardon delay, grandkids visiting...

I am a little confused. I replaced it in qryTest but that did not seem to replace it where the Form is calling it from. What/where is the Record Source.

 

GinaWhipp

AWF VIP

Local time

Today, 17:38

Joined

Jun 21, 2011

Messages

5,899

• Aug 2, 2014

• #27

No. Ms. Mrs..... just say Gina that will do. (And, my feelings are not hurt, I don't even read that part.)

 

Last edited: Aug 13, 2014

A

ASK

Registered User.

Local time

Tomorrow, 04:08

Joined

Jul 23, 2014

Messages

21

• Aug 2, 2014

• #28

Thanks for checking my DB, Gina. I have a another inserting criteria, named as dupResults. It's added in frmGui form.
If my answer does not meet with your question, please let me know.

Thank you & best regards,
ASK

 

Last edited: Aug 3, 2014

GinaWhipp

AWF VIP

Local time

Today, 17:38

Joined

Jun 21, 2011

Messages

5,899

• Aug 13, 2014

• #29

Finally playing catch and I have adjusted your database. I also cleaned up as many of the Form modules as I could as I could not compile unless I did. See attached... (Thanks for your patience )

 

Attachments

• OPT DB_Test.zip

  185.7 KB · Views: 69

A

ASK

Registered User.

Local time

Tomorrow, 04:08

Joined

Jul 23, 2014

Messages

21

• Aug 14, 2014

• #30

Thanks Gina!! I thought that you have forgotten me . You are the best.
Have a great Thursday !

Thank you & Best regards,
ASK

 

GinaWhipp

AWF VIP

Local time

Today, 17:38

Joined

Jun 21, 2011

Messages

5,899

• Aug 14, 2014

• #31

Not forgotten just got busy... You're welcome!