Search results for query: *

GuptaSteve: Thanks You sent me in the right direction.

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

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

Have any of you ever had problems with not being able to link to a specific table. I am using MS Access as a front end, trying to draw data from PT. I can see the data on the Pervasive Control Console; tables etc, but when I try to link to the tables via Access ODBC, I get an error message -...

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

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

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

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

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

Depending on the amount of data that you expect the db to hold, I would go with a master-order and a suborder-table that would hold both the accountable and unaccountable items. I simple check box (yes/no) field could identify the different types of orders. Multiple table queries across any...

Create a parameter query based on the table with start date as one parameter and the end date as the other. The SQL statement would look something like this - Select * from tblNAME WHERE tblNAME.EventDate BETWEEN [Input Start Date] AND [Input End Date]; Hope that helps. BusMgr

Thanks sostek. I work with it a little and have settled on RGB(j, 64, 255-j) The spectrum over my data goes from red to violet to blue, as you point out. The code returns a long value for the color (ie 16716811), not the hex equivalent from 255 to 0. I think that it might work best to...

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

Thanks PH I went back and read the Ubound and GetRows help section. My print loop was wrong, you were correct. Thanks Karl aka BusMgr

Not there yet. I should end up with an array the is 'vardata' records by 12 columns. If I try to print out that array, I get an error message at the intCtr = UBound(vardata, 11) + 1 line that states "Subscript out of range". It shows intCtr = 0. I tried to put a line in with...

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

Are you trying to create a plot with location as the Y axis, the date as the X axis and the value (MPY)? If that is what you are trying to do, you need to create a crosstab query with your current query and then use VBA to do your plotting. I've just completed a series of plots similar to...

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

Why don't you set the border style on the form to none, removing the ability of the user to use the X to close the form; create your own buttons to close the form and then write the error checking code to see that the user has input the desired info before he or she can close the form.

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