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 Chriss Miller 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: jwa6
  • Content: Threads
  • Order by date
  1. jwa6

    SSIS FORMULA ERROR?

    using visual studio 2008 V3.5 sp1 i HAVE A TARGET FLD DEFINED: xfld (DT_STR,30,1252) I HAVE A FORMULA HERE for xfld: Im comparing 2 year fields IE: 2008 = 2008 (CAST([YEAR] AS VARCHAR(4)) == CAST([CUR_YR] AS VARCHAR(4)) ? [STATUS] : "CLOSED" if they are = then xfld = STATUS if <> then...
  2. jwa6

    web site for oracles roles ans schemas -- just the basics

    thread1177-795377 http://dev.fyicenter.com/faq/oracle/oracle_managing_user.php jim
  3. jwa6

    views missing table fields

    oracle 10g I have views on tables in oracle that I need to check to see if the views are current. Sometimes we add a new field to a table and recompile the view. But, the view wasnt changed to reflect the added field in the table. this is on our dev DB... We have many contractors thru here and...
  4. jwa6

    I have a problem w/ the 'DoCmd.OpenReport cmd.

    this is pretty straight forward. I want to open a report based on the same qry as the form. I am using the form filter values ( which work) to open a report / the same record set - which isnt working. this is the command. DoCmd.OpenReport "rptqCBoxes_w_Years_exp2", acViewPreview, ""...
  5. jwa6

    sort order by SUM on a report

    hi all I have a rpt based on a qry fields are county exp type cost period - there are 3 periods I am dealing with that means 3 cost amounts per grouping ( county) this is the sum at each group level ( county) =Sum([Cost]) I need to order by highest to lowest group sum amount.=Sum([Cost])...
  6. jwa6

    focus on reports writing?

    Im am pondering this. I have a chance to move to a new employer. The $ is about the same. They are going to EPIC ( health care) and the demand for reports writing is dire it seems. I have some CR experience. I have done alot of pl\sql as well. I love writing sql( weird I know) -- its the...
  7. jwa6

    reports XI and native sql?

    hello I have been working in CR8.5. I use crystal sql designer for native oracle sql. Write your oracle sql and paste it right in. I think the CR sql point and click stinks. We may be going to CRXI. My understanding is that you can no longer use oracle sql in a report. Now, you must use a ref...
  8. jwa6

    Reports writing?

    Im am pondering this. I have a chance to move to a new employer. The $ is about the same. They are going to EPIC ( health care) and the demand for reports writing is dire it seems. I have some CR experience. I have done alot of pl\sql as well. I love writing sql( weird I know) -- its the...
  9. jwa6

    reports writer and marketability?

    hello, Im am pondering this. I have a chance to move to a new employer. The $ is about the same. They are going to EPIC ( health care) and the demand for reports writing is dire it seems. I have some CR experience. I have done alot of pl\sql as well. I love writing sql( weird I know) -- its...
  10. jwa6

    reports to html a suggestion

    thread703-1083136 this may be for you http://msdn2.microsoft.com/en-us/library/aa200523%28office.10%29.aspx HTML template file example <HTML> <!--The following token places the object name in the title bar of the Web browser.--> <TITLE><!--AccessTemplate_Title--></TITLE> <!--The...
  11. jwa6

    cobol?

    Hi everyone. Im 51 and doing nothing in this job to further my career. I have 10 years experience in oracle and crystal reports. Due to the diverse nature of what I do I am now ( the master of none). Im at a dead end here. I have taken a java class to see whats up w/ that technonlgy. Frankly...
  12. jwa6

    ScriptTimeOut Error

    I have seen this issue in a few threads out here. On XP; the default is 90. To set this to a higher limit... check this KB : http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q268/3/64.asp&NoWebContent=1 There are three ways to resolve this...
  13. jwa6

    MEMO fields in CR8.5

    RE: thread766-1143318 I had the same issues as mentioned in thread thread766-1143318 . I could not put a formula on a sql field from cr query builder as the report showed the query fields as 'memo'. I ended up adding an outer select and doing a substring to bring the fields to 10 and 12 char...
  14. jwa6

    query parm default?

    Im running a query w/ a state parm from the design view. Msaccess2000v If the user doesnt enter a state value IE: IL,IN MI but leaves the parm null Ill want to show all of the states in the state field ( no filter) Im working w/ this in the design view but cant get the right combo in the state...
  15. jwa6

    desktop icons and start menu dont load.

    Hi I have a pc ( xp home edition w/ SP2). Every so often when I start up the pc the desktop icons and start menu do not appear. Ill then bring up task manager ( where I can see the icons when I do "file" "browse") and run the MS Restore from the system32 folder to bring the pc back 1 day. The...
  16. jwa6

    I want a job to run at 330 am on the 15th of every month.

    hello I have a job I wouuld like to submit to delete historical data. I need the job to run the 15th of every month at 330 am. I am not sure how to get the date right ( IE the 15th)for the Interval the DBMS_JOB.SUBMIT function. DBMS_JOB.SUBMIT( v_JobNum, -- Return of job...
  17. jwa6

    good books for vb.net?

    any suggestions for a neophyte w/ only cobol experience? jim
  18. jwa6

    getting knocked off the 2003 active directory

    we are on a active directory(2003). I am on a XP pro pc here. I am getting locked out of the network while using this pc. I see some of this in the event viewer: Event Type: Failure Audit Event Source: Security Event Category: Detailed Tracking Event ID: 861...
  19. jwa6

    media player convert mp3 to .cda or wav.

    Hello windows xp w/ SP2 media player v 10 I have an mp3 cd I would like to cut into a .wav cd for my auto. Can one do this using media player? I see nothing in the help files on this thanks jim
  20. jwa6

    migrate access qry data to word

    hi all ms access 2003 ( originally built in v97) ms word 2003 on windows xp interesting problem.\ I am tryin to bring fields into a word doc from a query in ms access. The mdb uses odbc to a oracle 9 db. In this query i can drop out one specific field selection criteria-- then I can import the...

Part and Inventory Search

Back
Top