Search results

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...

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

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...

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...

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

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,

Indeed, Colin!

[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...

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...

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"...

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...

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 & ""'"))

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...

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!

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...

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...

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...

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...

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

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...