Search results

  1. A

    Download a Web Database from Sharepoint

    Morning everyone, I have build a web database onto sharepoint. I want to download this and have it as a local file (so that I can compact it etc) How can I do this easily? I cant seem to find an answer anywhere :( Thanks
  2. A

    Count Function - display a number

    Morning, So doing this on excel is easy however struggling with the following on access. I have loads of projects in a table, they all have a status (eg Red, Green, Amber). I have a query for each so if you run qry_RagRed, it will show in a sheet all Red projects and obviously have a total in...
  3. A

    Best way to lay out the database

    Hi all, I have been playing around with Access to try and do a project tracker for my team at work. The manager will load a project and input information and then the analyst will update this (seeing different options) I want to be able to have many updates (seperate records) for each project...
  4. A

    Report showing Primary Key, not value

    Hi again I have a query that runs - off the back of this, a report. The query will show a name eg dave however the report will show Daves unique key (eg 3) and not just say dave how do I sort this? I'm not that great at access but learning fast! Thanks
  5. A

    Report produced from a drop down box and query

    Hello, Apologies, once again I have tried searching here with no luck. This is for access 2010 web data base I want to be able to select a project from a drop down combo box, and when selected a report to be run. However, what I want to display in this combo box is from a query - how can I...
  6. A

    Drop down box to find records (web database)

    Hi guys, I am using Access 2010 and the web database so having a bit of an issue. I have tried google but no luck really - seems complex and confusing. Basically I have a table which has column 1 of the unique id and column 2 is the project name. When you click the drop down on the form, I...
Back
Top Bottom