Search results for query: *

I have data in the following format: Item Total test 1 test 2 test1 5 test1 4 test1 6 test2 7 test3 8 test4 6 test5 3 I want to be able to find the item with the highest total. I know that this would be very easy with a pivot table, but I want to use a function. So I need a formula that...

Thanks. I will work on modifying that code for my chart.

I am pretty good at VBA. Would I have to completely code the chart? Do you know how I would go about setting it up? Jeff

Thanks Skip. The pivot table is almost what I want. I made a stacked graph with it. For the actual data, there is many more projects, project managers, and fund types than 3. Is there a way that I can stack the data with one color for each project and one hatch for each fund type; instead of...

I have created a stacked chart in Excel for the following type of data: Project ProjectManager1 ProjectManager2 Project Manager 3 Project 1 Funds Funds Funds Project 2 Funds Funds Funds Project 3 Funds Funds Funds x-axis has the project managers...

I am using Office 2000. I have set up a word template with bookmarks. I can insert text into these bookmarks. However, I also want to insert an access graph into the word document. Is there an easy way (through vba) to insert this graph into word? Thanks, Jeff

We have an Access 97 database on our network. We want to replicate the database so that we can take a laptop out of the office to make updates. We also want to be able to use our pocket PCs to make updates. However, when you create the replica, it adds an autonumber field to the table that...

I have a .tab file that I need to get into Access. I will be getting these on a regular basis, so I wanted to write a command that will automatically do this. I cannot import it directly into Access because this file type is not supported for Import. I know that I can import it into excel...

I am using Access 2000. I wanted to add a logo to my main screen. I added an image box, but the db size increased by about 10 megs. I decided to delete the picture; however, I can not get the db size to return to the previous amount before I added a picture. I tried compacting, but it did...

The reference is still set to the Word 8.0 object library.

I have a computer with Windows 2000, Office 2000, and Office 97. We have an access 97 database that performs a mail merge to MS Word. Prior to getting Windows 2000, the mail merge would open whatever version of Word that was last opened. However, since installing windows 2000, MS Word 2000...

Before we added the option to search the subissues, this was just a basic select query. The user would just mark a check box for reviewed and type comments into a text box. These would write directly into the tables. I would like to keep a similar structure if possible. The users of this...

I am using Access 2000. The following is my table structure. tblRegulation: RegulationID (PK) Issue SubIssue1 SubIssue2 SubIssue3 SubIssue4 Comments Other Fields tblRegReviewed: RegulationID (PK) User (PK) Reviewed DateReviewed...

I am using access 97 and I am trying to sync a query with my pocket PC. I cannot do this using Microsoft Activesync. I tried syncing it through Visual CE, but when I try to update the query on my desktop. I get an error that says that "the field cannot be updated". Is there a...

I am using Access 97. I have a report that has a picture associated with each record. The pictures are stored in a separate directory and the path is found with the OnFormat event. The picture load fine if I cycle throught the records. However, if I try to print out the report for more than...

I am using Access 2000. I am trying to set up a report with dynamic column headings and text boxes. I have four crosstab queries. I have combined the results of these queries into one query that is the recordsource for the report. I have the following code for making dynamic columns: Private...

I have set up four crosstab queries. I then made a query that puts all of the crosstab queries together in one query. I use this query as a recordsource for a report. All of the queries run fine. However, when I try to open the report. I get the following error: Microsoft does not...

The main query does not use any other queries.

I just tried this, but I still got the run-time error.

I am using Access 97. I have a report that has an image control in it. I have the pictures stored in a directory on a network drive. All the pics are jpegs. I am trying to get the report to load more efficiently. I have the following code in the On Format event: Private Sub...