Recent content by madhouse

  1. M

    Northwind Database with Graph Example

    Thanks for the reply. I downloaded the database example but unfortunately the graphs were embedded into a Report as opposed to a Data Access Page.
  2. M

    Northwind Database with Graph Example

    A while back a colleague at work (who has since left my company) showed me an example of a graph within a Data Access Page in the Microsoft Northwind database. The Northwind database that I've downloaded doesn't contain such an example. Does anyone know of a Northwind DB with an exmaple of a...
  3. M

    Combining GROUP BY and SUM

    The image above shows results from a query I've created. However, I need to group the results by Product Id and display a sum of the individual Product Id's. So I should have something like: Commercial Loan Mr Steve F Cobblestone LNCLCLRE £299,491.33 Demand Deposit Mr Steve F Cobblestone...
  4. M

    Data Access Pages - Newbie Needs Help!!

    First of all can I say that I'm quite competent when it comes to designing applications in Access - creating forms, queries and using VBA. However, I've been given the task of creating a Data Access Page to display some sample data. Now I have to admit that I've never uses or even looked at how...
  5. M

    To Do List

    rak - thanks for that. It's a good basis from which to start from...was hoping that someone might have a to do list application with all the bells and whistles i.e. ability to categorise tasks, prioritise tasks etc, etc.
  6. M

    To Do List

    We use Lotus Notes which does have a To Do List feature, but I was looking for something standalone which I could adapt to my own needs.
  7. M

    To Do List

    Has anyone got, or know of somewhere that has, a good example of a To Do list application for MS Access (2000 version)? I've been looking for something to use to keep track of all the daily tasks I need to perform and haven't got time to create something for myself.
  8. M

    Problem with combo box on datasheet subform

    Ok, basically the problem is that I have a subform where the default view is set to Datasheet. On this subform I have 5 fields, 2 of which are combo boxes. The values in the first combo box (cboCategory) are populated from table Category. The values in the second combo box (cboType) are...
  9. M

    Using + or- key to increment number or date in a text box

    Thanks for the Access 2000 version but when I try to open the database I get the following message: Microsoft Access was unable to create the Database window. Please upgrade to a new version of Microsoft Internet Explorer. Any idea as to why I'm getting this error message??
  10. M

    Using + or- key to increment number or date in a text box

    Any chance of posting an Access 2000 version??
  11. M

    Open Database via .BAT file

    ok, the thing is that I already have a form specified in the startup options - this form is used by the staff to login to the database. The idea is that I want a means of bypassing the login form that opens on the database startup....don't ask why, long story....but it involves the use of an IBM...
  12. M

    Open Database via .BAT file

    I've created a .bat file to open an MS Access database..... C: CD\Program Files\Microsoft Office\Office Msaccess.exe C:\MMG\ORLCBS11\libinfo_viewer.mdb But I was wondering if it was possible to open the database and specify a macro to run on startup so to speak i.e. can I pass some...
  13. M

    Change file to read-only

    ghudson - thanks for the reply....in both forums ;) Works perfectly. I don't suppose, moving on a step, whether it's possible to go as far as actually giving a user authority to a file. For example, if a set of files in a directory were tied down so that no-one could use them except for...
  14. M

    Change file to read-only

    Is it possible within MS Access to change the attribute of a file (a Word document for example) to read-only? If so, any ideas how this can be done?
  15. M

    Reports print out in black & white

    Pat - that's what I thought could be the problem, but I double checked and the printer settings were definitely set to print in color.
Back
Top Bottom