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!

  • Congratulations Mike Lewis 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: 016
  • Order by date
  1. 016

    Copy Of an MS Access and repopulate it

    Thank you TrojanRabbit I have a database with tables, queries, forms and report. these tables are populated and the reports give info form this database. I want to have the same table structure, the same queries, the same forms and the same reports. the info in the database will be different...
  2. 016

    Copy Of an MS Access and repopulate it

    Thank you for your help. But can I process the same for the queries and the forms and the reports from the old database to the new one? I appreciate. kyal
  3. 016

    Copy Of an MS Access and repopulate it

    Could you please tell me how to copy an MS Access database. Actually, I need to have the same queries, the same reports the same forms. The data will be totally different. I make a copy of my old database and rename it. I opened the new table to check the rows, it is obvilously the same. I...
  4. 016

    DATE IN A CURSOR

    thank you, sem.it was helpful. kyal
  5. 016

    DATE IN A CURSOR

    sem Thank you very much, I will try and keep you informed.
  6. 016

    DATE IN A CURSOR

    HI, SEM. tHANK YOU FOR YOUR SUGGESTION, BUT COULD YOU HELP ME WITH SELECT CODE, PLEASE. THANKS
  7. 016

    DATE IN A CURSOR

    i am writing a cursor and I want to give certain information because, for example the budget year 2000 is from november 1 2000 to october 31 2001. If i am considering the budget year 2000, I want to say if order_1 is done between november 1 and december 31, the budget year is 2000 and if it...
  8. 016

    POPULATING TABLE

    Loren256. Thank you very much Here are the tables the bill_table is the table I want to populate . the space table contain the data. thank you again SQL> desc bill_table; Name Null? Type ------------------------------- -------- ---- inst_CODE...
  9. 016

    POPULATING TABLE

    I have to populate a new table from an old one: the problem is the new columns table do not have the same name than the old one. for example the new table is iNSERT INTO BILL_TABLE (budget_no, VERSION, FISCAL_YEAR BILL_SEQ_NO...
  10. 016

    Key DELREC Trigger raised unhandled exception ORA-01918."

    I had one user try to log in to the Production Database with her username and password, however, we got this message:"ORA-01017: Invalid username/password; logon denied." We were pretty sure that we had the correct account information, but I figured that I would just delete her old...
  11. 016

    sending a report by email

    I have to send a report by email. When I click save as I have 2 choices as n ezxport or by html, I chose the html choice and somehow I cant finalise the process.
  12. 016

    make a dump data? urgent

    I have to dump data form an oracle database and send it to a client.Could you Please help?<br>Thanks
  13. 016

    columns and data...

    giving complementary info:<br>I am using oracle 7 and I have 15 other fields in the same table. can i proceed with your answer. what about the data contained in the fields North-east, north-west, south_west and south_east.&nbsp;&nbsp;i will lose them, right if I wont select the fields? I want to...
  14. 016

    columns and data...

    I have a field USA, and 4 other North-east, south-east, north east and south east. I have to delete these 4 fields . they have data.&nbsp;&nbsp;I want to have the same info when I query the USA. so i WILL HaVE IN MY TBLE ONLY THE USA and not the regions. How can I do? Thanks
  15. 016

    emailing an access report

    once I finished a report, how do I email it/ and If I save it in MS EXCELL, HOW CAN i find a copy of this report in Ms access.Thanks!
  16. 016

    having an access report generated by a user once a week?

    It is urgent.<br>How can I have a user generating&nbsp;&nbsp;independently a report once a week. Thank you
  17. 016

    query for a report . Pl Help

    select customer.name, case.caseid, case.customerid, case.status, case.datecreated from case, customer where CASE.CUSTOMERID = CUSTOMERR= customerid, and case.status = 'open' and ((dateDiff(&quot;d&quot;, [case.datecreted], now())&gt;15<br>(i have 2 tables : case and customer&nbsp;&nbsp;the...

Part and Inventory Search

Back
Top