Search results

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.

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

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

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

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.

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.

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.

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

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

Any chance of posting an Access 2000 version??

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

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

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

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?

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.

Ok, I fixed the problem by making a copy of my report that does print out in colour, and then transferring all of the text boxes, labels etc from one that doesn't print out in colour onto it. But I would still like to know for future reference why one of my reports only prints out in black & white??

I have 2 reports for my database, but one of them prints out in black & white even though when previewing the report the colour boxes are displayed in colour. My other report prints out in colour fine but I can't see what I need to change for other report to print out in colour as well. Any ideas??

Rich, I've got separate tables for Personal Transactions, 3rd Party Transactions and Loan Transactions - although each transaction has some common fields e.g. Customers Name, Address etc, the rest of the details for each type of transaction are different.

Mile-O-Phile, Thanks for the reply but I don't have a query that populates the subform. I've only got the code that I posted which populates the subform.

I've got a form with a combo box that lists company names. When a user selects a company name, a subform (on the same form as the combo) is populated with a list of transactions for the selected company. However, I only want to display the last 5 records - how do I limit the subform to only...