Search results

  1. OverSight

    Search for vendors by goods/services supplied

    Oh yes thank you for pointing that out! I didn't realize the functionality of those buttons. I've fix that issue now. I am wondering with the search function can I add multiple field names so that they can also be searchable or is this only for one field at a time?
  2. OverSight

    Search for vendors by goods/services supplied

    So my database won't communicate with the internal system. Its totally separate and it will only be used as a glorified contacts list or "Yellow Pages" with the ability to add and search for goods and services that a vendor provided us. So instead of an employee writing down in a cheat sheet...
  3. OverSight

    Search for vendors by goods/services supplied

    Hi there, thank you for taking the time to look into this for me. Basically I have a table with all the GSIN codes and descriptions that we might use to categorize a good or service. Right now this is just being used to provide a list for the end users. In my Vendor Details form...
  4. OverSight

    Search for vendors by goods/services supplied

    Hello, I have a vendor database that keeps track of basic vendor contact information as well as goods/services they provide. I want to have the function where the end user can search for an item like "Laptop" and a list of vendors that supply a "Laptop" will show. Right now I have it that the...
  5. OverSight

    Solved A Main form does not display data when subform left blank

    Hey there, Yes you are right it was showing Inner Join! Thank you very much for this! I think this is now working!
  6. OverSight

    Solved A Main form does not display data when subform left blank

    I am having an issue where one of my main forms will not display or populate data until a subform is populated. This is a Vendor database with contact information. The main form frmVendorsDetails contains all contact information of the vendor. within this form is a subform frmVendorPOCs...
  7. OverSight

    Solved Main form with sub form containing data from reference tables

    Wow! Yes, this works very well! This demo will be way more useful to the end users as there are so many that they may not know the actual number or description but this will allow them to search for most any kind of information!! Thank you very much for this! I have a separate question, but...
  8. OverSight

    Solved Main form with sub form containing data from reference tables

    Hi there, so I took a look and attempted to create a quick form to see if I could figure out the basics. I decided to go with the first method you suggested, one vendor carries specific goods/services. For me I'm not too concerned about the end user manually typing in data multiple times...
  9. OverSight

    Solved Main form with sub form containing data from reference tables

    I will take a look at this later tonight to see if I can figure it out. Thank you again for helping me with this.
  10. OverSight

    Solved Main form with sub form containing data from reference tables

    Thank you very much for taking the time to explaining this and assisting with the subform! I am learning so much! This makes sense now.
  11. OverSight

    Solved Main form with sub form containing data from reference tables

    Hi there, Thank you for your advice and input! Sorry I have been slow with a reply. Based on the information you have given me, I have decided to start from scratch and have tried to incorporate all the advice you've given me on making sure I have proper naming conventions and table...
  12. OverSight

    Solved Main form with sub form containing data from reference tables

    Thank you. I've just uploaded the whole db that I have so far.
  13. OverSight

    Hello from Canada

    Thank you! Totally new to both MS Access and Forums :LOL:
  14. OverSight

    Solved Main form with sub form containing data from reference tables

    I am brand new at using MS Access so I have pretty much zero knowledge of what I'm doing. I have been reading online best I can but just not following or haven't found something that helps me. Apologies if I'm posting in the wrong thread. I will try my best to explain what I'm looking to do...
  15. OverSight

    Hello from Canada

    Thanks! Now to find out what is the appropriate thread to post in lol
  16. OverSight

    Hello from Canada

    Thank you! I'm hoping I can find some help getting my databases actually working the way I want. But I've run in to some walls that I simply just don't know how to do them as I have pretty much zero knowledge.
  17. OverSight

    Hello from Canada

    Hello, I am new to using MS Access. I've just discovered the potential it has and am looking to start created 2 databases for some of my coworkers to use to help make their lives a bit easier as well as my own. I am fairly tech savvy but also have pretty much zero knowledge of how to create...
Top Bottom