Search results

  1. C

    Linking Buttons from one form to filter another

    I thought it might be easiest to just show you what I am working with. I need the "Rate" button on the Supplier Information page so that when you click it it takes you to the Rate page and also connects you to the supplier number you were viewing on the original page.
  2. C

    Linking Buttons from one form to filter another

    Which form? The main database, or the one I am trying to connect the button to?
  3. C

    Linking Buttons from one form to filter another

    Okay, I fixed that, however, it's still not taking me anywhere when I click on the button that has that code in it. Is there something else that I am not doing right? I wanted to open the form, "Company Information for Rates: Datasheet" on click, but to that particular company supplier...
  4. C

    Linking Buttons from one form to filter another

    What I name my forms are important to what you will see on them, it makes completed sense on our end. Data type for Supplier Number? It's a number ... they are "010489" always 6 digits, but of course the digits vary.
  5. C

    Linking Buttons from one form to filter another

    So I attempted to use that code, but I must not be doing it right. Here is what I have ...
  6. C

    Linking Buttons from one form to filter another

    Thank you for that link vbaInet, but I still don't understand where I am supposed to put that code. Even when I click on the button properties and go into arguments section I don't see any options for "DoCmd.OpenForm" I only see "OpenForm"
  7. C

    Form for Multiple Company $$ Rates

    I did removed a post, I had figured it out :) In regards to the other problem you were exactly right, I had changed the header name and it had created that problem. Thanks! It is fixed now.
  8. C

    Linking Buttons from one form to filter another

    Is this something I can do in the button commands or do I need to go somewhere else for this? It looks more like coding. (I am not very advanced in Access as of yet)
  9. C

    Form for Multiple Company $$ Rates

    One last question about the form, when I exit it and try to re-open it - it asks me to put in the Supplier ID# - I don't want it to do that. How do I cancel that option?
  10. C

    Linking Buttons from one form to filter another

    I have one form that I use to keep off of our Suppliers information, they are kept in order by Supplier ID#. I have a button down at the bottom of the form that will take them to a form called "Rates". This is our $$ Rates for every supplier. Is is possible to link the Rate button on the 1st...
  11. C

    Form for Multiple Company $$ Rates

    Rookie, After tinkering with it - I found that option. Thanks so much for your help. Now I am trying to just get the format right and the size of all the forms and data sections to align right. I think this seems to be the most challenging part. haha.
  12. C

    Form for Multiple Company $$ Rates

    Thanks so much Rookie :) Maybe one of you can assist me with the next part to this? I have now created the Subform inside the Mainform and I would like to .... hmm how can I explain this ... I want to show multiple records at once in the Subform. Instead of clicking through to see the...
  13. C

    Form for Multiple Company $$ Rates

    John, What does (PK) and (FK) mean?
  14. C

    Form for Multiple Company $$ Rates

    I am creating a Form using a table. It has the following columns Company Name Date of Entry PO # Ship Rate Notes What I need to do is one company will be listed 15-20 times. I need to combine all of the information for each company. There will be multiple companies though. Example...
Back
Top Bottom