Search results

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

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

Yes that would work. How would I do this, make the search form invisible when the results form open up. I also want to give users the choice to close the results form & go back to the search form to do another search (a simple close form button on the results form) or close both forms & go back...

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

Hi He seems to have a different problem to mine. I am trying to get a one-to-many relationship working between 2 tables, where the entry in the 'one' table (the SOP number) may not exist yet. My tables are: tblSOP: AutoID (Autonumber) SOPNumber (Text) tblRecords: RecordID (Autonumber)...

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

Ive attached an example of the database tables Im working with. Would you mind showing me how the query would look as I dont fully follow the SQL statement & havent been able to get it work work for me. I get a 'syntax error in the JOIN operation' message. Are there any good websites that you...

The tables I am using for this account are very simple, just 4 fields for Date, Category (of income/expense), Income Amount & Expense Amount. The resulting table is very similar to your standard bank statement in that it just lists all entries one after another. I like the idea of just using a...

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

Thanks for your help Bob

That works perfectly for what I was trying to get at, which was calculating the balance of the sum of Income - the sum of Expenses. Can I ask please if you wouldnt mind walking me through the formula you used. Im wondering why you chose to rename the fields, like Inc for Income, & then if you...

Bob Ive attached an example of what I am working on. I have a few records in a table, different deposits & withdrawals over a few days, & a query summing up all the ins & outs & then a field to calculate the balance. If I could get that calculation to work Id be happy. Cheers

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

I dont think I really have another table to think in terms of. Going back to the original use for this, procedure Proc-001 (X) references Proc-039 & Proc-045 (Y), and Proc-002 references Proc-039 & others. I want it to be so that when I am updating Proc-039 I can see that both Proc-001 & 002...

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