Search results

  1. R

    Making a Default Value Appear as "no"

    Hi guys, thank you for all the suggestions. I have tried typing in "no" in the default value for each combo box already and that did not work. I also just tried the coding method but that had no effect on the outcome either. If you have any more suggestions I'd be happy to try them. I appreciate...
  2. R

    Making a Default Value Appear as "no"

    Hi All, I am attempting to make a default value of "no" appear on my form's combo boxes. There are about 20 different combo boxes in which an individual must select "yes" or "no" and from there press a button to find which criteria applies to their desired search. I am just having trouble...
  3. R

    Access and Excel

    Hi theDBguy, so basically I want to be able to create a criteria in either access or excel where I would be able to find a BIN in all records and based on that BIN I want to put particular elements into a new table and so on going across. For example, if I am looking for BIN 1234, there are...
  4. R

    Form and Query Help Please!

    And just to clear which data are included, I am looking for a simple math equation once I am able to find my desired data. I am looking for the percentage makeup of cs3 and cs4 out of the entire sum quantity. So it would be ((cs3+cs4)/sum quantity)*100
  5. R

    Form and Query Help Please!

    Hi JHB, so basically I want to be able to create a criteria in either access or excel where I would be able to find a BIN in all records and based on that BIN I want to put particular elements into a new table and so on going across. For example, if I am looking for BIN 1234, there are duplicate...
  6. R

    Access and Excel

    Thank you so much! I am also attaching what I want the finished product to look like in hopes of helping piece my thought together. Let me know if you have any questions!
  7. R

    Form and Query Help Please!

    Hi JHB, I was able to resolve that particular issue however I have another bump in the road...I will post the attachments here regarding what I messaged you. Thank you!
  8. R

    Access and Excel

    Hi, I am attempting to pull specific data from access with calculations to store in excel. I am new to coding so I am not sure how I should go about this. In the attachment, In table 3 I am aiming to find the percentage of sum quantities 3 and 4 over the total sum quantity. However, I am only...
  9. R

    Access to Excel?

    Just wanted to clarify what I am looking to do. I want to take information from both tables in the sample and use certain operations to filter the results into excel. As you can see in the sample one table has duplicate BIN entries as records with different elements. Each element affects...
  10. R

    Access to Excel?

    Thanks so much for the link, I will take a look...and sorry I'll post the sample with this post. And that would be perfectly fine, just wanted to know if that is possible and how I can achieve this.
  11. R

    Access to Excel?

    Hi, sorry for the late reply. Hope you enjoyed your weekend. I am posting a sample database with fields from my current database but only in fields that I need for the access to excel transfer. Basically I am trying to take certain fields and create a calculation and transfer this data to an...
  12. R

    Access to Excel?

    My query is not functional, I may be doing something wrong I'm assuming. Does my code look like it would work? I guess out of context it can be a bit puzzling? And that's great I just took a look at that! Thanks so much for the tip! Should I upload a sample in case I am unclear about my situation?
  13. R

    Access to Excel?

    Hi, So I am trying to help add values to one database from another database. The origin of the data will come from a couple of tables on access and I am trying to input this information into an excel spreadsheet. However, the access data needs to be filtered before I transfer it to the...
  14. R

    Help with opening for multiple users

    You rock! Thanks so much :)
  15. R

    Help with opening for multiple users

    Ok thank you so much! So each user has to save the file as well and then that prompt will stop popping up I am assuming?
  16. R

    Help with opening for multiple users

    Hi DBguy, thanks so much. So a trusted folder on a shared network? What if I am not on the same network as them? I appreciate the help
  17. R

    Help with opening for multiple users

    Hi, so I have a database which I split because it will be used by multiple users. I just had a question regarding how to make it easier for other users to use my access file. When I email the file, 2 prompts come up directing the user to save the document and enable content. This database will...
  18. R

    Form and Query Help Please!

    Hi JHB, I did look at the code. I am still new and learning to code so I wanted to know if you had sort of a formula for me to mimic this same function? Also I wanted to know if it was possible to make this function show a report instead of a query but with the exact same results? So basically...
  19. R

    Hi JHB! You really helped me out with my form and query that I wanted to reach out to you for...

    Hi JHB! You really helped me out with my form and query that I wanted to reach out to you for further help! I wanted to know how you designed the query to give me those specific results. You posted it yesterday on my thread titled SAMPLE15. What I wanted to do further was to have those results...
  20. R

    Form and Query Help Please!

    Hi, sorry for the late reply, was away from my computer. Thank you so much for all your continued help! JHB that is exactly what I am looking for! How did you get the query to do that? Please let me know! It is spot on! You're a life saver!
Top Bottom