Search results

  1. M

    Decimal Point Problems

    I am working on a database that tracks things for a welding shop. Because of this I am using heights in millimeters and decimal points are necessary. The page I am using is an input form with a subform tied to a specific record. I can under no circumstance get my decimals to stay put in the...
  2. M

    matching names

    Hello all, first off, this forum was a huge help for me this summer during my internship, and now it seems the access skills I have gained are boiling over to my jobs at my university! Any help would be appreciated, also feel free to ask questions if something is not understood. I am currently...
  3. M

    Form question

    sample Ken, I get the idea, but my logic is still out of place as to how to link. Below is the DB I am started. Take a look. I want to be able to select a dot and then if the dot is selected then on query it will show Riley Football Riley Soccer Jeff ultimate frisbee i realize this...
  4. M

    Form question

    Ken that makes sense, I was wondering, when I build the relationships...what does it mean for referential integrity and how would it be used or would it be needed, the help section doesn't do much for me on this. thanks. Riley
  5. M

    Form question

    I am trying to create a form that updates numerous tables. I would like to be able to input a name and list sports that the person plays (this is purely an exercise for me to learn access) so it would update two tables one like this ID Name 1 Riley 2 Jeff the other that it is...
  6. M

    Append query question - simple

    works great 67 helpful to use the correct tool for the job! Worked swiftly and effectively. Thanks Riley Don't use a hammer to kill a fly
  7. M

    Append query question - simple

    Just fooling around, I need to make a shell of my Database because I will be ending my internship soon and I can't control the information in my database for legal reasons, but I still want to have the database shell to show my skills of using access (recently required and not extensive :) ) so...
  8. M

    just wondering

    Is it possible to use a combo box to select a value and change where a form updates a table based on which value is chosen? My thought is to have 1 form to input data, but there are 4 different tables I would want to update and which table is updated is based on what value the combo box is...
  9. M

    Table relationship theory

    Thanks mhartman, do you have any information on joins and what they can help to accomplish in databases? Riley
  10. M

    relating a table back to PK

    I am fiddling with a DB right now just to try to work out some table relationships. I have a PK, Name, it is accompanied by a year in school. I then want to relate the year in school in a different table with the requirements for that year. such as Year Requirement1 requirement2...
  11. M

    Table relationship theory

    I was hoping to get pointed in the direction of some relationship theory. I am new at this and was wondering when, where and how to implement relationships into a DB. I am sure this has a lot of good uses, but I am failing to understand it completely. Any and all help is appreciated. thanks Riley
  12. M

    Table relationship theory

    As I continue my pursuit of MS access knowledge, I am moving to table relationships and would love if someone could point me to a good source to explain in detail when, where and why to use table relationships as well as how to implement this. Thank you much! Riley
  13. M

    SQL to search multiple fields

    Please help?! I am still in dire straits. Now my search engine will not requery if I select one criteria get a group and then select another specification within the selected group. also, i can not reset the query to start a new one how can I get this to happen? please help, I need to get...
  14. M

    SQL to search multiple fields

    Hoping to get some feedback?
  15. M

    SQL to search multiple fields

    KeithG I have this working now, thanks a lot for your help. I am still struggling with a couple things. -Right now I want it to be able to not error when nothing is entered in any of the text boxes or combo boxes. Right now it returns a where error. -A reset button for those boxes that resets...
  16. M

    SQL to search multiple fields

    that's something like it, but It will not narrow down the search based on the combo box input, or the steel type. Looking at the code I do not understand the If Len(Me.cmbGroup11) >= 1 Then If Len(strWhere) >= 9 Then statements. What are the numbers there for? A little explanation of the...
  17. M

    SQL to search multiple fields

    Ok, I hope this is as easy as you say, but the text box is a wildcard search and I am trying to do this in SQL. I will post what I can of the database as it is a lot of internal info. I have cut it down, but I think there is more than enough to work with, frmSearchCriteriaMain is the one you...
  18. M

    SQL to search multiple fields

    Kieth, I have seen this thread before, and I think I am mis-stating my question. I am using text boxes and combo boxes. I have the combo boxes working fine, and I can search one field with my text box, but I want to search 10 different fields with the text box and continue only searching 1...
  19. M

    SQL to search multiple fields

    What do you mean by dynamically? I found nothing under Database From Query, if you had the thread I would appreciate. My apologies for being a rook when it comes to this stuff. thanks RILEY
  20. M

    SQL to search multiple fields

    anybody?? Thanks RILEY
Back
Top Bottom