Search results

  1. DBApprentice

    N00b in MS Access from Rio de Janeiro

    Merry Xmas, Arnel!!!!!:)
  2. DBApprentice

    N00b in MS Access from Rio de Janeiro

    Indeed I have been reading a lot about Database design and normalization is something that is still being procesed by my brain slowly. That is one of the things that sometimes I believe I understand and then I find myself staring at the screen wondering what is going with this topic. Any...
  3. DBApprentice

    How to prevent Duplicates when Null is involved

    This might sound silly, but what you mean by adjusting the delimiters?
  4. DBApprentice

    How to prevent Duplicates when Null is involved

    Hi, Isladogs. Thanks for the tip! I read the Golden Rules and will abide them! Just a heads-up: the link you posted took me to a webpage that did not had the post, from there I had to clink another link to land on the correct message. Since I don´t have authority to post link I can´t re-post...
  5. DBApprentice

    How to prevent Duplicates when Null is involved

    I agree with you moke123! Just when i was testing I realized that event trigger is not working good. I believe I can move it to the btnSave_Click() to be be more suitable. Thanks for the input!:)
  6. DBApprentice

    How to prevent Duplicates when Null is involved

    It would be impossible to use DOB on this case because the Observer are supposed to provide his name only, sometimes he can decides to be annonymous, where I have to use UNKNOWN. Considering these observers are confined to a ship, chances of having a lot of people with the same name would be...
  7. DBApprentice

    How to prevent Duplicates when Null is involved

    The code you provided work good! The OBSERVERS table is oversimplified because we don´t get that much information from users, they have to submit their names on a safety card and in many cases they do not even supply a name and we have to use UNKNOWN. The real important information is the...
  8. DBApprentice

    How to prevent Duplicates when Null is involved

    Arnelgp it worked!
  9. DBApprentice

    How to prevent Duplicates when Null is involved

    Hello, I have a form to add people to a table called "Observers", it cosists of ObserverID, FirstName, MiddleName and LastName only. I built query to underly a form to add new persons to the table. My problem is: how can I prevent the operator to add duplicated names to it by deploying a...
  10. DBApprentice

    N00b in MS Access from Rio de Janeiro

    Hello, Guys! My name is Diogo and I am savvy Excel user looking forward to move projects from that application to Access as I recently realized this is the way to go. I have been reading a lot about Access, Database design and Relationships, VBA and building applications. Always working...
Back
Top Bottom