Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jweisman

    Need function for Max/Count

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

    Stacked Chart

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

    Stacked 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
  4. jweisman

    Stacked Chart

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

    Stacked Chart

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

    Insert access graph into word template

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

    Syncing Pocket PC to replicated database

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

    Import to Excel then Access

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

    Decrease db size after deleting image

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

    Default Mail Merge to Word 97

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

    Default Mail Merge to Word 97

    ..._ 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
  12. jweisman

    Update Union Query

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

    Update Union Query

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

    Sync Access Query with PDA

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

    Report with pictures crashes on print

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

    dynamic columns in report from crosstab

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

    Crosstab queries to report

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

    Loading Pics in a report --run-time error

    The main query does not use any other queries.
  19. jweisman

    Loading Pics in a report --run-time error

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

    Loading Pics in a report --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...

Part and Inventory Search

Back
Top