Validating a uniuque name before saving Product in DB

[sorensjp]

Hello all,

I'm wanting to validate a unique name for a New Product in a Point of Sale application.

I have been attempting to use either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Either line of code has an issue and don't understand how to correct them. I'm not of the best course of action to accomplish this of if there is better way. The MACRO they are part of is below:

Please Login or Register  to view this content.

Thank you for looking,
V/r,
Jim

[MarvinP]

Hi Jim,

You need and "IF" in front of those two bold lines. The "Then" needs a starting If to work correctly.

[sorensjp]

MarvinP,

I realized when I enter a name that is already in my list a Macro that is already running basically does the what trick. I have a Worksheet Change on that cell to Load the Product if it exists which fires if the name used is entered in that cell. So it does the same thing without me having to create another check.

V/r,
Jim

[MarvinP]

Hi sorensjp,

I'm not sure if I helped to answer your question or not. You have rem'ed out two lines in your code that I un rem'ed ant stepped into that code. It didn't know how to handle a "Then" without an "If" in the front of both those lines. Did that help to answer your question?

[sorensjp]

MarvinP,

I didn't ask the question correctly to start with. I forgot to un-rem the other lines of code to produce the same issues I had seen.

I was thinking that either of the BOLD lines below in the code would check the helper cell (since I have it checking for a name already). But I realized by having that helper cell already fires a different load MACRO that effectively accomplished my results.

Please Login or Register  to view this content.

This project is a virtual "Ship's Store" for my ship so Crew Members can pre-order products. I'm adding many more features will be certainly asking plenty more questions.

V/r,
Jim