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 Rhinorhino 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: *

  • Users: BusMgr
  • Content: Threads
  • Order by date
  1. BusMgr

    Centura Reports newby - Sizing the page

    I am a complete newby to centura reports. We have a PO report that consistently prints everything on the second and succeeding pages. The first page has the header, which is repeated on all the pages, but the data all appears on page two and onward. I've tried going in and removing blank...
  2. BusMgr

    Formatting cross tab report

    I regularly program Access and VBA, I understand how to do this in that. I have a cross tab report of company versus monthly sales. Company is the row, month is the column. My underlying data is in a table that I am using bTrieve SQL to pull out of Peachtree. Peachtree's date format is...
  3. BusMgr

    Unrecognized data format when importing tables

    I am trying to link Peachtree 2005 accounting tables to an Access DB. I have installed Pervasive 8.15 WS engine and can get most of the tables to link with ODBC. My question arises on certain tables where I get an "unrecognized data format" error for the likes of JournalGUID in the JrnlHdr...
  4. BusMgr

    Linking table question with ODBC

    I am trying to link Peachtree 2005 accounting tables to an Access DB. I have installed Pervasive 8.15 WS engine and can get most of the tables to link with ODBC. My question arises on certain tables where I get an "unrecognized data format" error for the likes of JournalGUID in the JrnlHdr...
  5. BusMgr

    PT & Access ODBC

    I've got PT 2005 and Access 2000 set up with ODBC and Pervasive SQL V8 SP2 (I think that it is 8.15) I upgraded to V8 from 6.15 which I only installed as we had it available before I got the V8. I got the tables to link initially, but after shutting down Access and restarting it, all it will do...
  6. BusMgr

    Trying to populate table with date limits

    I am trying to populate a temporary table with sales data. I want to be able to populate with three months of data at a time. The code below does not error out, but it does not appear to see the dates in the strSQL statement. If I leave that line out of the strSQL statement, it populates...
  7. BusMgr

    Excel newbie - series titles and axis format

    I am creating a chart in excel to plot data from an access database. The chart opens and plots fines, then closes excel. Currently all my code is being run from the Access database. My first problem is that I need to format the series title for the chart. I do it, but it is not saved with...
  8. BusMgr

    Generating RGB color codes

    I have a dynamic plotting module within my database. I use it to plot sales versus state for each month. The trouble is the limited color choices. Currently my code is dim lngColor as long dim j as integer I start j at zero and increment by 10 for each loop (state). I am limited to values...
  9. BusMgr

    Trouble reading all the values from recordset into array

    I am trying to set up an array so that I can find the max value in a table. The table is set up with field state, then months. I can read the first two months, (Jan, Feb), but when I try to read the rest I get an error in reading the rest. I want to dynamically plot the monthly sales by...
  10. BusMgr

    Setting recordsource for report

    I have a report that is based on a crosstab query. The report is the same, but depending upon whether the client wants to see domestic or international figures, it is based on two different queries. I am trying to set the recordsource dynamically through an if statement, base on selections...
  11. BusMgr

    Lost sort on Crosstab Query

    I have a constructed a crosstab query based on another query which has four fields: PlotLocal Mdate SumofInvoiceAmt SortDate MDate is a concatenation of Month & Year, sort date is an integer from 1 to 12 corresponding to the month (1 = Jan, 2 = Feb, etc). The query is sorted, but when I create...
  12. BusMgr

    Retrieve & insert previous value in recordset

    I have created a recordset based on a table with a WHERE clause. I have four fields in the table: WellID1 Days1 (rst(2)) MeasDepth1 (rst(3)) Cost1 There are some records in the recordset where the MeasDepth value is null. If it is null for the record corresponding to Days1 = 1, I want to set...
  13. BusMgr

    Syntax problem with loop

    I have a form that I select multiple files to plot data from. The form can have as many as five files selected to plot data from; each corresponds to a control txtFile1, txtFile2, etc. The cmdPLOT button on the form calls a report that contains the graph and is using a subroutine called...
  14. BusMgr

    Data format for Access Chart

    I am trying to create a chart in Access off of a table. The table has four fields PostID JobID DaysOnJob CumDailyCost The table has multiple JobID's, with DaysOnJob from 1 to X for each JobID, with a corresponding CumDailyCost for each DaysOnJob. I want to plot the DaysOnJob versus the...
  15. BusMgr

    Problem inserting a menu item to command bar

    I am following some code out an Excel manual to add a menu item to the command bar when I open my Excel application. The code gives me an error (Run time error '91' - Object Variable or With block variable not set) at the following line - Set ViewMenu = CommandBars(1).FindControl(ID:=30010)...
  16. BusMgr

    Menu bar changes

    I am an Excel newbie, I normally work in Access and Word. I assume that Excel cannot be that different, but..... I've inherited an Excel app with modifications to the Worksheet Menu Bar. They have added a new control, with a name that no longer fits. ( File TXX Edit View etc.) I need to...
  17. BusMgr

    Number conversion to pounds - ounces

    In me report, I need to output pounds & ounces from a decimal number, ie 5 pounds 8 ounces from 5.5 pounds. I input pounds and ounces separatly on my form, convert them to decimal, do all my calculations and summing, but can't figure out the way to display it back to pounds and ounces. Thanks...
  18. BusMgr

    Add values to combo box - Value List

    I have a combo box on my form that the row source type is "Value List". I have set the limit to list to "Yes", but I want the user to be able to add values to the list. Currently there are only two to four items in the list, I do not expect the list to grow to over five. I...
  19. BusMgr

    MoveNext Key EOF recognition

    I have a command button on a form to move through the records on the form. The problem that I am having is recognizing the EOF and raising a message, other then the MS generated error after the recordset moves through the first non-existent record. ie the first time at EOF, a blank recordset...
  20. BusMgr

    Creating a new table in a linked database

    In upgrading my database, I have created three new tables that are linked between the front end and the back end. I currently run code that checks the link each time that the database is opened, but it only gives an error message if any of the linked tables are not found. I want to be able to...

Part and Inventory Search

Back
Top