Search results

  1. A

    Access 2010 & Sharepoint

    I have created a list of archived documents in SharePoint from a ~1900 row spreadsheet. I want to make this list searchable by all users at our site & manageable by a select few. In its current state, the easiest way for a user to search this is to export the list to a spreadsheet & use Ctrl + F...
  2. A

    Attaching Files to Access DB

    I have a database in which users regularly attach extra files to the records they are entering. At the moment they save the extra file to a designated directory on the network (G:\Central Store\Attachments\2012) & then go into the database & make the link. I have a command button which creates a...
    • Altin
    • Thread
    • Replies: 0
    • Forum: Forms
  3. A

    Close Form once Another Opens

    I am trying to build multi field search into an Access 2007 database I have with 2 forms & 1 query. I have a form for entering the details & a query, with criteria such as 'Like "*" & [Forms]![frmSearch]![txtFirstName] & "*"' and 'Like "*" & [Forms]![frmSearch]![txtLastName] & "*"'. Rather than...
    • Altin
    • Thread
    • Replies: 4
    • Forum: Forms
  4. A

    Auto Update a Table

    Hi I have an Access 2003 database for tracking requested updates to Standard Operating Procedures in work. Currently I have just 1 table with fields for SOP Number, Details of update & other specific details like requestor & date. Any 1 SOP number can have a number of updates logged against it...
  5. A

    Calculating Across Pivot Tables - Access 2003

    For a few years now Ive used an Excel spreadsheet with pivot tables to track our house finances. For each year I have 2 pivot tables, 1 for the various incomes per month & 1 for the various expenses per month. These work nicely in showing me the regularity of incomes/bills & monthly totals. I...
  6. A

    Using Access to Track House Account

    Hi I have been using an Excel spreadsheet & pivot tables for the past 2 years or so to keep track of our house finances. I did a course recently in Access 2003 & want to use this now to do the same. I am having a bit of trouble currently with summing up the Income & Expense columns &...
  7. A

    Database linking referenced procedures/actors

    I'm trying to design a database which will list our operating procedures (X) in work and all the other operating procedures referenced in the that procedure (Y). Then I want to be able to select the referenced procedures (Y) and see which procedures (X) reference to it. A good analogy would be...
Back
Top Bottom