Search results for query: *

I have a simple database, 2 tables. One is the contact table one is the service calls table. Linked by ContactID Being that each contact can have multiple calls I wanted to create a query to display on the contacts form showing the latest call date from the service calls table for the contact...

I hope that I am placing this on the correct board. I am trying to figure this php,SSI,html,shtml thing out and to be frank I'm so confused, I am not even sure what I am asking for help on (LOL). I have a php page that I am using as a template, I am trying to get all page requests to open in the...

I know this has been covered but I need to have it translated to me in "Stupid". I am trying to sort a Formula field that contains a summary The Forumla is for getting mileage from an odometer reading field. Basicly max(odometer) - the min(odometer) Maximum ({WBVEH.MILEAGE}...

I am trying to match up account numbers based on a map number where the map number could have more than one account number. Vlookup works great where there is one account number for each map number, but when it gets to a map number with more than one account it assigns the same value ( normally...

I am trying to set up a loop to check a column of numbers in Excel, to ensure that a number being added to this column does not already exsist. I am having trouble getting the loop to break off when it evaluates, there is no chance for more than one duplication of a number in this column. and...

I have a list of 1253 Vehicle numbers in Excel. I need to end up with Vehicle Number week # Week Start Date Week end Date 0057 1 12/30/2001 01/05/2002 0057 2 01/06/2202 01/12/2002 I have created seperate columns of data for vehicle Number...

I know that this has been discussed before but is THERE a way to place a Running Total Result in the Group Header of A Version 7.0 Report?

Hi folks , I am normally over on the Crystal Reports forum, But need help with a problem I am having with my site. I have a back ground image set in one of my pages. And while it looks fine to me at a my resolution, someone with lets say 600x480 is not seeing the whole picture. Is there some way...

I am still using version 7 Crystal. I have an Oracle table that's holding data from our Hansen System. The tables I am linking go in a one to many to many relationship. As long as I stop at the first group of tables (the one to many relationship), all is well, however as soon as I add another...

I am trying to Move ( Archive) a row of data in Excel, based on a Value ( Date) being in a cell. I want the entire row removed from the sheet where it resides ( "Master") and placed in another sheet ("Archived") within the same workbook, if the cell in Column "EA&quot...

Hi Everyone, I have this problem. I was given a 17000 record report that needs to be disected. I have the data in Excel and have using mid and Find functions gotten most of what I need. One last problem I am having is getting a street address from this jumbled mess. Here is a snap shot of the...

I made it almost an entire month without asking for help! Here is what I have Crystal Ver 7. My data is a text file that is pulling in as one field. I need to break Account Number, Name, Address, and then Usage from this " field". This is for water consumption ( gallons used) Here is...

Hi Everyone, I have a report that is getting too envolved for my skill level. I have 12 tables linked to get Vehicle maintance costs, part costs, labor costs etc, and now they also want mileage added to this report. The table where the Mileage is Kept has 2 fields that I need to deal with ( if I...

Hi, everyone. Being at the bottom of the food chain here,and being that nobody has a clue how to. I was given the task of figuring a way to automate the following. Open an Access Database. Delete an existing table. Run an existing macro that recreates the table, and then delete any ( normaly 2...

We have a very simple test Form to try and figure out why we can not call Crystal Reports from VB6. At First it was a missing .ocx that problem appears to have been corrected. Now we are lost. There is only 1 Crystal Control, 1-Txt box, 1-Command Button on the Form. The code is simple...

I have backed what I am trying to do down to it's simplest form to try and get a Crystal Report to show. We are running WIN NT4.0, VB6, I have only a single Crystal Control , a Single Text Box, and 1 Command Button on my form. The code is simply this: Private Sub Command1_Click() Dim Start As...

I have created an Application in Excel To run Crystal Reports. I have Used The calendar, option Buttons, Check Boxes, Labels,Crystal Report Control,and Command Buttons On the Form. It Runs Fine Off my machine but placing it on the network, everyone else is getting the Error.. " Compile...

I have Been Trying to Get Cyrstal 7.o to except a date from VB . I am creating A front end to Operate some 50 Crystal reports. THe data is In Oracle 8i database. I used Crystal Report Control in VB. Here is a portion of what I have: Private Date1 as Date If ChkDayFlow.Value = True Then...

I am sorry I know this subject has been brought up many times. But I can not get the Parameter to pass from VB ( in Excel) to Crystal 7.0 Report. Not looking for anything Fancy. Have one Command Button that I would like to have pass the Date Parameter( single Date) on to multiple ( 5) reports...

I am trying to create a loop that will scan a column and then move the entire row to another sheet. If cell A1 =1 then select entire row and move it to sheet B,If A1<>1 check A2 and so on down the sheet. Thanks Curt