Recent content by Shrout1

  1. S

    Relinking queries and reports after upsizing

    I have several MS Access databases that I would like to migrate the back ends into SQL Server. I have tested the upsizing process on some sample MS Access databases and it makes sense to me. I am able to link the upsized table as an external data source and use the MS Access database as a front...
  2. S

    Access Web Database Resources / How to's

    I have built several client side Access databases in the past, however I am now undertaking the creation of an Access 2010 Web database. Are there any decent resources out there i.e. books, forums, blogs etc. that talk exclusively about the creation / limitations of Access web databases and...
  3. S

    Many to Many v. Multi-Select

    A bit green, so bear with me. I am designing a database to track different aspects of contracts. Primarily, I am tracking that contracts have a single prime contractor and many subcontractors. One sub contractor could be involved in many contracts, and many contracts could involve multiple...
  4. S

    Form field not being passed to query as criteria

    Looks like this thread has the answer! (Can't add links until 10 posts! Just add the www in front of that) techonthenet.com/access/comboboxes/bind_index.php Let me know if that looks right... I'll test it this evening (What better way to spend a Friday night, eh?)
  5. S

    Form field not being passed to query as criteria

    Hard to believe I didn't see that! It's funny how typical this kind of post is and how I was *certain* that I wasn't making that kind of mistake... One more question - on the form itself I have combo boxes with 2 columns being referenced. Is there an easy, non code way to have the combo box...
  6. S

    Form field not being passed to query as criteria

    Instead of the combo box value being passed into the target query as it should I *always* receive a popup that states "Enter Parameter Value" I set my filter criteria as such in the target query: "[Forms]![Invoice_Form]![comboFamily]" but for some reason, despite there being a value in that...
  7. S

    How to publish a table to SharePoint using VBA

    I need to programatically publish a table to a SharePoint list using VBA. Can this be accomplished? My goal is to have the table published each time a user closes access. I will have a hidden form load when the user starts the database and the close subroutine for that form will publish the...
Back
Top Bottom