Recent content by rsingh4377

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...

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...

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...

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

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...

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!

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!

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...

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...

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.

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...

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?

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...

You rock! Thanks so much :)

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?