Search results

  1. DBApprentice

    Syntax problem on building SQL using wildcard * on a numeric field

    Hi Colin! From any side? Cheers!
  2. DBApprentice

    Syntax problem on building SQL using wildcard * on a numeric field

    Thanks, arnelgp!!! :)
  3. DBApprentice

    Syntax problem on building SQL using wildcard * on a numeric field

    Hi! I am having a hard time with this string: Dim strSQL As String strSQL = "SELECT tbl1Cards.CardID, tbl1Cards.CardNumber, StatusCard AS Status, tbl1Categories.Category, tbl1Observers.[FirstName] & "" "" & [MiddleName] & "" "" & [Lastname] AS FullName " _ & "FROM tbl1Categories...
  4. DBApprentice

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

    I sense I am starting to grasp the Normalization Theory vs Real World problems... Thanks for the ponderation about the multi-column lookups tablem I will have that in mind. In fact, I am very happy with this forum because I have learnt a lot with you guys!
  5. DBApprentice

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

    June7, those 2 cents plus that final sentence worth a lot to me thanks!
  6. DBApprentice

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

    Thanks! I did feel that was the least I could do after reading the etiquette post. :o :D Here is something else for you to laugh: one of my bosses is from Alabama and he has a very strong accent, every single time he says "You all" it sounds "YOL" but in my mind, for some mysterious reason, I...
  7. DBApprentice

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

    That post about the evils of lookup fields was haunting me for a while, but I decided to search here about alternatives. I found simple explanation from jzwp22 that opened my eyes! If any n00b fellow is interested please check here: https://access-programmers.co.uk/forums/showthread.php?t=207989...
  8. DBApprentice

    Alternative to Lookup fields?

    Thanks a lot for the explanation, jzwp22! I was doing the query at table level and also at form level! :banghead: But I guessed it was wrong and I was looking for an explanation on how to solve the "Evils of Lookup Tables" and your explanation was super simple and direct!:) Now I know and...
  9. DBApprentice

    N00b in MS Access from Rio de Janeiro

    Merry Xmas and Happy new year, Shadow! That´s would be a very nice nickname: Carioca_Grasshopper! I wish I had that idea before... :):)
  10. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    Uncle Gizmo, that link is not working anymore.:(
  11. DBApprentice

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

    Thanks, I am here to absorb knowledge and wisdom from you, if I take offense I would not be a good pupil and also would not learn anything.
  12. DBApprentice

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

    I appreciate your comments, The_Doc_Man! I have considered this approach but I am not really sure if that would be the correct one in this specific case. I agree this approach would apply for the UsersStatus, Categories, SatatusCards and AccessLevels because they have the same number of...
  13. DBApprentice

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

    What would you recommend me to do with them?:o I followed Plog´s advice on how to treat them. However when you responded that the other approach is better I decided I would change it later. He is the writer of "Database Design for Mere Mortals" and he describes a process to design tables for...
  14. DBApprentice

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

    Colin, now I know how to call those mini tables, they are lookup or static tables! :D The reason I am using it is because they will seldom change, but they can. On the forms the user will pick-up them when adding the card information. All of them are to be lookup tables on this DB only...
  15. DBApprentice

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

    No. I have made the table using the table design and I am using the Relationships window to link the fields from one table to the other. The reason I made it on a separte table is because I have found an example on RogerAccessLibrary with a similar situation and I thought to be usefull in my...
  16. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    Thanks for the explanation, Uncle Gizmo, I will consider that and the article about "Excel in Access" really teaches a lesson - I am a Excel coming to Access. Indeed I am having problems with the design of my very first DB in Access project and you are more than welcome to jump in if you...
  17. DBApprentice

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

    I am very excited with this project because it will be my very first Access DB but at the same time I get frustraded because I cannot harness Access yet. Colin, I understand it would be hard for you to understand my project. During the begining of the project I have created a briefing about it...
  18. DBApprentice

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

    Thanks for the explanation, The_Doc_Man. I am trying to relate tbl1Cardsto tbl1Feedbacks but Access keeps pushing for the 1-to-1. I don´t know what to do to make it to be 1-to-many.
  19. DBApprentice

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

    I did not noticed that... But then how can I keep a copy of the card in my database? It will not be every single card just the ones awarded as best cards. I am sorry if I being too dumb or maybe my English skills are failing me here: I am lost on this answer... You mean I should have them as...
  20. DBApprentice

    Theory Question About Forms and Underlying Queries instead Tables

    I found interesting this part: Considering your PoV, I should finish my DB and then start checking how the data relates to each other?
Back
Top Bottom