Search results

  1. C

    E-cigarettes

    For those of you who vaping has not helped I suggest the following: 1. You were probably not introduced to vaping in the best way, and therefore Ill-advised. 2. You more than likely did not have the correct amount of nicotine for your smoking habits. 3. You did not have a handfull of flavors...
  2. C

    Filtered TextBox Value

    I started work on May 11th. they started me on a different database, but about 2 weeks in decided against it and started me on this one. My boss knows that I am new to access, and that there would be a learning curve. I told him that I thought I could do all of it, and that I would do my best...
  3. C

    Filtered TextBox Value

    The database is about replacing the current method of making quotations which is 4 different excel sheets. The employees will enter all of the necessary data, the quotation will then run the necessary calculations. All of this will be used to create reports to either send by mail or email to...
  4. C

    Filtered TextBox Value

    The relationships that I had went away. do you want me to go in and recreate them, or post a screenshot of them, or just don't worry about it?
  5. C

    Filtered TextBox Value

    Here is all of my tables. I can post another with just queries, and just forms. All together it was too big.
  6. C

    Filtered TextBox Value

    My database is too large to post on this site. what should I do?
  7. C

    Filtered TextBox Value

    I can do that. I will upload the entire thing as soon as I get the sample data entered.
  8. C

    Filtered TextBox Value

    I would love to go through it with you. I think the only tables that I will need to take out is the customers and suppliers tables. After that I can post my current database if that will help, or I can just start from scratch. which ever you think will be most beneficial.
  9. C

    Filtered TextBox Value

    Yes. I am just so far into all of this that I guess I am scared to go through the entire process because of my situation. I am doing a summer internship and my boss wants me to be done with this database by the end of June. I will just have to go back and do the process and hope I can move...
  10. C

    Filtered TextBox Value

    In my tables do I need an ID field for each of my combo box values and a text field? I am really trying to understand how to fix the problem.
  11. C

    Filtered TextBox Value

    When I make the bound column to be the ID field the value in the table is the ID field, not the name like I want. when I created the combo boxes I made them from queries using the wizard. I want to store the text field in my tables not the ID number. I understand that the ID field is necessary...
  12. C

    Filtered TextBox Value

    Here is a screenshot of the VBA Code. I am much more familiar with If statements than the DLookUp function. I don't know why I didn't try this first. Thanks again for all of your help. I will probably be asking more questions.
  13. C

    Filtered TextBox Value

    I got it to work with an If Statement within the AfterUpdate event of the cboMetalMarket.
  14. C

    Filtered TextBox Value

    Thank you so much for all of your help. You have no idea how much I appreciate it.
  15. C

    Filtered TextBox Value

    I believe I have all of the necessary elements here in this database.
  16. C

    Filtered TextBox Value

    The criteria is the cboMetalMarket combo box selection. There is a price for each metal for each market. Right now my text box is returning all of the prices for the selected metal. I want only the price for the market selected.
  17. C

    Filtered TextBox Value

    This is my statement so far with the first criteria. =DLookUp("[MetalPrices]","OptionMetalsListQ","[MetalsID] = " & [cboMetals].[Column](0)) The next criteria is that the column head of the concatenated value is equal to the string value within a combo box cboMetalMarket. These values...
  18. C

    Filtered TextBox Value

    I have the text box set now to get the field that I created with the concatenated values. The text box looks at the metal chosen in the cboMetals and returns the concatenated field for that record. How do I now tell it which of the 4 values I want? I am trying to do this by using the columnHeads...
  19. C

    Form working properly alone, but gives error when combined with other forms

    So I only need to duplicate the queries and just give them different names and I can only have one form used as a subform in many different forms?
  20. C

    Form working properly alone, but gives error when combined with other forms

    Yes it does. I think I am going to make it just another form that opens up as a pop up with the click of that button.
Back
Top Bottom