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

  1. djpingpong

    PL/SQL - selecting the MAX() of a date field with criteria from another table

    ...working now CREATE OR REPLACE FUNCTION GET_CURRENT_EARN(inMbr in person.person_id%type) RETURN NUMBER IS v_Event number(5); begin select * into v_Event from (select a.EARNINGS into v_Event from EARN_HIST a where a.EARN_DATE = (select max(d.earn_date)...
  2. djpingpong

    PL/SQL - selecting the MAX() of a date field with criteria from another table

    Well... i was successful in creating a function that would return the most current Earning record when passing in a PERSON_ID CREATE OR REPLACE FUNCTION GET_CURRENT_EARN(inMbr in person.person_id%type) RETURN NUMBER IS v_Event number(5); begin select a.EARNINGS into v_Event from...
  3. djpingpong

    PL/SQL - selecting the MAX() of a date field with criteria from another table

    So I have 2 tables: PERSON -> is a table of basic info regarding members in the company (unique key here is PERSON_ID) sample records: PERSON_ID DEPT 123 abc 111 abc 100 bdc 200 cda 140 abc EARN_HIST -> is a table of historical earnings...
  4. djpingpong

    DOS batch script for renaming files

    thanks SMAH, it helped me out a lot... saved me tonnes of time thanks everyone who replied so quickly
  5. djpingpong

    DOS batch script for renaming files

    Hi, I have a folder from work that contains about 4000 PDF files, each named something different However, in each file name, somebody decided to put the number '4' before the ".pdf" So, my filenames are "myfile4.pdf", "yourfile4.pdf", "testfile4,pdf", etc.... Is there a way that I can write a...
  6. djpingpong

    Batch script help for renaming a bunch of files

    OMG... thank you guys... i appreciate all your help ... this will TOTALLY save me a bunch of time for the future really thank you.. much appreciated here's my final script @echo off cd "H:\work\Projects\SAM\test" FOR /F "tokens=1,2" %%i in (users.txt) do copy BES_Front.mdb "BES_Front_%%i...
  7. djpingpong

    Batch script help for renaming a bunch of files

    Hey guys... the script sample you gave worked... but only have 1 little problem so i didn't make any changes to the script: @echo off cd "c:\temp" FOR /F %%i in (users.txt) do copy 1.doc 1_%%i.doc echo done pause cls However, in my users.txt each line contains the first and last name of a...
  8. djpingpong

    Batch script help for renaming a bunch of files

    oh geniuses... i knew the art of DOS haven't been lost to the world.. i'll have time to try it tomorrow at work.. so thanks for the quick responses... i'll post my result afterwards cheerios
  9. djpingpong

    Batch script help for renaming a bunch of files

    Hello all, I've been doing a certain task at work manually for a long time and it has reach the point where I would like to create a batch script so that I could run it in DOS (yes, i know it doesn't exist anymore.. but i still like to call it by that name). My work runs a WinXP Pro...
  10. djpingpong

    Access button to open Lotus Notes document link

    I'm sorry.. but i'll need more guidance for FollowHyperLink... because Lotus links isn't just a string like URLs, is it?
  11. djpingpong

    Access button to open Lotus Notes document link

    Hello, I've searched online left and right... and I can't seem to find the answer that i'm looking for... Its possible that this cannot be done, but I need to ask the people in this community If I'm designing an Access form, can I create a button that opens a Lotus Notes document link? The...
  12. djpingpong

    DoCmd.TransferSpreadsheet and keeping the same format

    Hi, sorry, I did mean to say table formatting... I'm not having any problems with the queries, its the table formatting that I would like to have transferred as well when its a table
  13. djpingpong

    DoCmd.TransferSpreadsheet and keeping the same format

    Oh.. and I forgot to add this important point... I have multiple tables/queries that I need to transfer to the same excel file... this is why I'm using TransferSpreadsheet but I need to keep the formatting at the same time is this even possible in Access?
  14. djpingpong

    DoCmd.TransferSpreadsheet and keeping the same format

    I have briefed both DoCmd.TransferSpreadsheet and DoCmd.OutputTo. Both have their strengths and their purpose. DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel file...
  15. djpingpong

    Need help to design a monthly summary of payments in my spreadsheet

    thanks for the formula ck1999 =IF(DAY(F7)=16,(IF(DAY(F6)=1,((MONTH(F7)-MONTH(F6))*2)+1,(MONTH(F7)-MONTH(F6))*2)),((MONTH(F7)-MONTH(F6))*2-1)) this code does work to calculate current year... Now as i mention initially, not only do I need a column to keep track to current year total, but I also...
  16. djpingpong

    Need help to design a monthly summary of payments in my spreadsheet

    what's if it's a mid-month change... For example: 2007/4/1 $50 2007/6/16 $30 2007/8/16 $40 2007/10/1 $50 How do I determine that it's $50 for 5 periods, $30 for 4 period, $40 for 3 periods, etc?
  17. djpingpong

    Need help to design a monthly summary of payments in my spreadsheet

    because the SUM of the PAYMENT column doesn't take into account how many payments are paid for each value.... In the example I gave, the SUM(payment) equals only $390, but the Total I'm looking for is $1260 (as indicated in bold) As a note to whoever else is going to read this... the most...
  18. djpingpong

    Need help to design a monthly summary of payments in my spreadsheet

    ...in Excel. I'm usually pretty good, so for me to ask for help means this should be a challenging question Let's begin.... Current Situation: /*SAMPLE SPREADSHEET*/ DATE: PAYMENT: MonthElapsed 2007/1/1 $100 2 2007/3/1 $150 1 2007/4/1 $100...
  19. djpingpong

    Need form to display a dynamically generated table

    thank you LonnieJohnson ... that worked... thanks all for helping
  20. djpingpong

    Need form to display a dynamically generated table

    Good question.. that is one of my problems... but I figured that if I set the form's recordsource = "SELECT * FROM tlbTmp".. shouldn't it display the entire table content no matter what.... am I wrong? cheers

Part and Inventory Search

Back
Top