Search results

  1. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    It is based on the "Evils of Lookup fields" article, I should have a query underlying my form for a couple of reasons but I should not make lookup fields on my table. For instance, consider tbl1Departments and tblSupervisor, if I need to build a form to enter new supervisor I will have to say...
  2. DBApprentice

    Relationships Question

    Plog I was told to have Queries underlying Forms but since you are saying it should have Tables I got confused... :confused:
  3. DBApprentice

    Question about Relationships 1-to-Many or 1-to-1

    Hi, Colin! Does MVF stand for Multi Value Fields? The Team Supervisor field is not MVF, at least not intended to. The user should pick just one supervisor for each feedback... These fields are intended to be editable by user later, so they can add more. Is it OK to have a table with so little...
  4. DBApprentice

    Question about Relationships 1-to-Many or 1-to-1

    Hello again! Everytime I am staring at my DB´s relationships I get a feeling that I am creating them wrongly. The screenshot is attached. For instance, the relationship between tbl1Ratings and tbl1Cards, I related the RatingID from tbl1Ratings to the RatingFK on tbl1Cards. But I sense that I...
  5. DBApprentice

    Subform Tutorial

    Thnks, Uncle Gizmo! I just have a problem at the moment: I am on a drillship and network here does not allow me to access YouTube due to low bandwith. I will be able to see videos just next week when I will be at home. Can you refer me to a good written tutorial? :D
  6. DBApprentice

    Subform Tutorial

    Hi, guys! Anyone can recommend a good tutorial to harness the MainForm/Subform iterations? :confused: I am having a hard time to set this duo on my form... :banghead: Thanks,
  7. DBApprentice

    How to prevent Duplicates when Null is involved

    [SOLVED] How to prevent Duplicates when Null is involved Hello everyone, I finished my "Add New User" form and I would like to thank you all for your inputs and insights. Indeed my theory was true, concatennating values of fullname on the underlying query and use it as a string on DCount...
  8. DBApprentice

    How to prevent Duplicates when Null is involved

    Isladogs it seems I need to have a AutoThanks in Replication ID to be enough to give you! :) I am verry happy to join this forum! Thanks for the explanation! I got the second option and it is working fine! I did not noticed that. I have updated my code and removed the Nz function. Thanks...
  9. DBApprentice

    How to prevent Duplicates when Null is involved

    I managed to tweak my code and accomodate the DCount and it is working: Case Nz(DCount("FullName", "qryCreateUsers", "FullName= """ & strFormFullName & """"), "") > 0 Msgbox "This person already registered!" & vbCrLf & vbCrLf & "You cannot register the same person twice"...
  10. DBApprentice

    How to prevent Duplicates when Null is involved

    Thanks for the help! Please note that when I tested this first code I got error: 3075 - Syntax error (missing operator) in query expression 'FullName='JohnPeterO'Toole". The second one works great! If DCount is faster would it be able to spot the same thing as Dlookup on the string...
  11. DBApprentice

    How to prevent Duplicates when Null is involved

    June7, how can add this to my code? I tried a couple of time but it didn´t work... :banghead: strQryFullName = Nz(DLookup("[FullName]", "qryCreateUsers", "FullName= '"" & strFormFullName & ""'"))
  12. DBApprentice

    How to prevent Duplicates when Null is involved

    Hi Guys! A couple of days ago I had developed a theory about catching the dupe and asked GregoryParkGeorge if that was doable. He told to test it and I did. The theory was: I spent a couple of hours working on my theory about the concatenated field on a query and use that concatenation to...
  13. DBApprentice

    Calculating Space for Records in a Database

    A-ha! I didn´t know I could use negative Autonumbers to broad the number, but I guess 2 billion is large enought for my database. Thanks a lot for your help!
  14. DBApprentice

    Calculating Space for Records in a Database

    The reason I have opt for Replication ID is because I have taken the code and technique from Steve Bishop´s "Programming Access" series and he uses that. I know Long Integer could leade me to more than 2 million records without running out of IDs. What you recommend: Replication ID or Long...
  15. DBApprentice

    Calculating Space for Records in a Database

    Hellos Masters! I am here again evoking your wisdom! How can I calculate the capacity Access has to handle records in a database? I have seem some people saying it has up to 2gb per table, but it looses Relational Integrity in some cases. Specifically in my case, I am learning DB Design...
  16. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    You know what? That´s the part of DB Design that messes me around, because I used to be more of an Excel guy and building small applications didn´t make me think too hard about the DB design... You simply throw all information in sheets and write VBA and Forms to return what is needed. When it...
  17. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    In this case, if I have lookup fields at form level, does that sorting will display the results from the query can be controlled, right? For instance: PeopleID | FirstName | LastName 1 Zoolander Smith 2 Xander Cage 3 Alvin...
  18. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    jdraw, thanks for the response! I have saved the link on my references.
  19. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    Hello again Access Experts! I have a theory question that has been boggling my mind for a while and I would like you wisdom to answer it: Why one should use a query to underly a form instead of the table originating the query? :confused: I have seen a lot of people stating that but I do not...
Back
Top Bottom