Search results for query: *

Thanks Jim, but now I get an error at the "exit for;" line stating a number is required. If I throw down "tonumber(x);" just to see what happens, I get an error on this line (else if {N87CM607.N_CHKG_MO_AMT_STAT} = '3' ) requiring a string.......I'm a little flumoxed. Jody

Using Crystal 8.0 in PeopleSoft 8.8 and have used Crystal since Ver. 5. Trying to get rid of leading zeroes in a field that is stored as a character in an Oracle database. Here is the code: Local Stringvar x := totext({N87CM607.N_CHKGM_AMT}); Local Numbervar i; Local Numbervar y; Local...

I need to copy a record on a form that is bound to a table. I have a button to copy the record and that works fine. Problem is finding the two records again. I decided to use a filter when I click on the copy record button. This works fine also. But, if I want to make a copy of the record...

I have a procedure to copy records on a form in datasheet view to create new records because of excessive data entry. Only problem is that after I made a few programming changes, three fields are not copied to the new record. These fields are part of drop-down menus that pull from other tables...

Access97 - Advanced user has a procedure to copy records on a form in datasheet view to create new records because of excessive data entry. Only problem is that after I made a few programming changes, three fields are not copied to the new record. These fields are part of drop-down menus that...

I've been able to answer my own problem. When I was creating a copy of the table w/ the new file name that I wanted, it was creating it linking into my application (storing my tables in another DB to avoid severe fragmentation). Therefore, when I exported the new table, the link was exported...

I am trying to automate an export of a table in Access 97 to another 97 DB. The only catch is that I want the name of the file in the external DB to have a dynamic name created at the time of the export. I have been able to create the table in the external DB using Transfer Database, but the...

Thanks Ido, is it then possible to add a character before or after this character I'm searching for. If it was a known number of character then it would be fine, but the field could have any number of entries. Here is what I'm trying to do: Current data: 245 12 4789 Desired data: 245, 12...

Is it possible to use a "for loop" or a "while loop" or something similar to search through a string field for a certain character? TIA! Jody

Using Crystal Reports 5.0 (unfortunately) in a Peoplesoft environment using Oracle 7. I need to be able to insert a comma after each alphanumeric value in a string field. I'm thinking this will be very complex since I will not know how many values will be entered or the format that they are...

Hey gang, we're running Peoplesoft 7 w/ Crystal 5. The problem we have has been occuring in numerous environments. Only one environment seems to have avoided this problem. When we run a crystal report through PS on the server side, the status monitor will go through the following sequence...

ggreg, I found this on Microsoft's msdn online help: NOTE: An update query can append and update records only if the tables contain a unique index that does not have the AutoNumber data type I was trying out your suggestion, but I was encountering a few problems so I checked it out and found...

I have modified an existing macro that first transfers the source table to a temp table and then I run an append query to append it to the new table. Not the most efficient route, so if you know of any other ways then I would be glad to hear them. I am not against using code instead of macros...

I'm using an import process to import Access 97 info into another Access 97 database. My problem is that the tables I am importing into have an autonumber field as the primary key. The source data is also an autonumber field, but some of the records have been deleted leaving the primary key...

That's the problem. I don't have a rule. All I know is that the first part of the field up to the "," is the last name. That's the only guidelines that I have. The formula that I created will not account for a person w/ four names only up to three w/ a suffix (if exists)...

Situation: I have a "Name" field from an Oracle 7.3 database in a PeopleSoft 7 environment that is used in a Crystal 5.0 report. The name is currently stored in this format i.e. (AGNES,JOSEPH LEONARD JR or AVALOS,ALFRED JR or BARONOWSKI,GARY WALTER). It is convenient that these...

Ken, I think you're right on about the formatting differences. I'll take a look at the drivers. I managed to have these fields appear finally. What I did was to change my printer on the report to the HP 5L and save it. I then deleted all of the disappearing fields and added them back to the...

DCM, The fields that come up missing are in the middle of the page and near the margins. It doesn't look as though that is the source of the problem. Thanks for the input. Jody

When printing a report using Crystal Reports 5.0 for PeopleSoft 7.3 using an HP LJ 8000, we are having no problems. Viewing the report shows all fields. When we print it on the 8000, we have no problems and can see all fields. When the printer is changed to an HP 5L, we still have no problems...

I cannot set up a printer on my PC that no longer exists. I only have the ablility to set up a network printer, no local printer. So, I obviously get an error when trying to use the old path to set it up. Any other suggestions? Jody