Search results

  1. G

    Query help!

    I've attached my database so that you can see what I'm working with. Basically, I want qos to be exactly like qalloy, just for the different table. It won't let me run it. It says "qos" is not a valid name. Let me know if I'm being unclear. Thanks!
  2. G

    What is the syntax error?

    As you can see in the attached database, I'm trying to make a search form. The query qalloy seems to work fine, but qoxsamples is giving me troubles. looking in SQL view, I tried modeling qoxsamples after qalloy. It won't let me save it, but the block of code at the bottom is what I was trying...
  3. G

    Queries based on text box values

    I have attached my database so you guys can see what I'm looking at. I would like the query to search my database based on what is entered in the text boxes in the form. Right now, it has pop-ups that prompt you to enter information, and even that isn't working right. Any help is appreciated...
  4. G

    1 form for multiple tables

    Hello all, I've very new to Access and need some serious help, or at least a nudge in the right direction. Attatched is my database. I would like to have one form that can enter all the information in the database. Not sure if it matters or not, but eventually I would like to have buttons to...
  5. G

    Database design

    I thought I had it figured out, but soon realized I had no idea. I'm new to Access and having a lot of trouble figuring out the right layout for my database. My company tests metal samples. The attatched excel book shows the main categories as well as what information is in each category. The...
  6. G

    Access search form

    I work for a company that does metal research. Attached is a database I have started working on. It shows basic metal and sample information, as well as data from three tests that are ran. I'm new to access as I'm sure you can tell from my work. I would like to be able to search for a record(s)...
Back
Top Bottom