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.

..._ Name:="Q:\90 REG\90 EMS\MMS\Databases\AST UST.mdb", _ LinktoSource:=True, _ Connection:="QUERY qryUSTReportPage1", _ SQLStatement:="Select * from [qryUSTReportPage1]" objWord.MailMerge.Execute Thanks, Jeff

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

...myPath = myLoc!PictureLocation & txtLocName & "\" myFile = Dir(myPath & Me.PWCTankID.Value & "*.jpg") ' Retrieve the first entry If myFile = "" Then Me.imgTank.Visible = False Else...

...On Error Resume Next Set cnn = CurrentProject.Connection Set rst = New ADODB.Recordset strSQL = "Select * from [" & Me.RecordSource & "] " rst.Open Source:=strSQL, ActiveConnection:=cnn, LockType:=adLockReadOnly intColCount...

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.

...myPath = myLoc!PictureLocation & Me.LocationDesc.Value & "\" myFile = Dir(myPath & Me.PWCTankID.Value & "*.jpg") ' Retrieve the first entry. If myFile = "" Then Me.imgTank.Visible = False Else...