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 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. tektipdjango

    Access and sql server, performance question

    Here is my problem Thre is an app (ERP) running with sql server, connected with several sites. I want to give the users the ability to look at tables in the database without updating rights, and I think Access ùay be a good solution for this, with runtime and menus giving read-only forms. For...
  2. tektipdjango

    How to calculate first or last given day of the week in a month

    eg find first Tuesday in a month, or find last friday in a month... I wrote a FAQ about this http://www.tek-tips.com/faqs.cfm?spid=183&sfid=5074 -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  3. tektipdjango

    Report using Oracle and SQL Server database. Is it possible?

    I usually use CR 9 on an SQL Server Database. But I have to do a report to compare to tables, one in the SQL Server Database, and one in an Oracle Database. Is it possible and How? Thank's in advance ! -------------------------------------------------- Django [thumbsup] bug exterminator...
  4. tektipdjango

    is convert function bidirectional

    it's unclear for me if convert function is used from datetime to string only or also the opposite way. Can anyone help me Thank's inadvance -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  5. tektipdjango

    variables don't update in mysql 4.1

    I've just installed mysql 4.1 on WinXP + easyPHP and I tried a few queries. When I use variables, it looks like mysql don't update them eg set @carr='test'; select codeArt,artDesc,@carr myVar from articles where 1; the myVar column is empty...
  6. tektipdjango

    does SAP check this issue (cosmetic inductry)

    one problem in cosmetic industry (and I think in chemicals also) is to be sure, if there is a change in the formula of Bulk (BOM), that production is knowing if the manufacturing order to make the bulk is different from the BOM the R&D has modified. Maybe there is an OK to do this but maybe not...
  7. tektipdjango

    Join speed performance question

    suppose you have 2 tables A and B with a join on A.Id and B.A_Id. A.Id is indexed and not B.A_Id what is is most efficient? 1 - select A.Id from A left join B on A.Id=B.A_Id 2 - select A.Id from B right join A on B.A_Id=A.Id I Think solution 2 is best, is it right? django bug exterminator...
  8. tektipdjango

    difference between fast and slow queries >> tip

    In another post I put this information that may be usefull for all f us : -------------- it's a good pratice for queries to put the fields alone and the operations on the other side (left). so I modifed {youth_goal.dt_set} + 365 < CurrentDate to {youth_goal.dt_set} < CurrentDate - 365 Here...
  9. tektipdjango

    How to : select the whole text of a combo on click

    when you click in a comboBox the text is not selected even if in the event onClick you write the following code which works with a textBox: (cBox is the name of the comboBox) cBox.SelStart = 0 cBox.SelLength = Len(cBox.Text) It looks like Access is sending an event after the onclick...
  10. tektipdjango

    a kind of &quot;stylesheet&quot; in the report

    CR9: You have a lot of formatting ways in CR via the format formulas, but if you want to change afterwards your &quot;Bold&quot; to &quot;Italic&quot; (for instance) you have to go through all the places in the report. One way is to make a formula and put it (hidden) in the report header to...
  11. tektipdjango

    is it possible to use sql with cr9?

    Is it possible to have with sql a query that select a list of records and use it as a part of a report. I tried with the &quot;command&quot; in database expert but it's very slow on a simple query and when i try to add tables the sql view seems to show only the table and not the complete sql...
  12. tektipdjango

    why my subreport insert a blank page if large

    CR 9 The problem : the subreport list a certain number of lines depending of the item of the group in main report. If the number of lines is small no problem the items and detailed subreports follow each other items after items, changing of pages when full , but when the size of the subreport is...
  13. tektipdjango

    Report and subreport printing

    I'm a newbie in CR! Main Report : for each item which has customer orders detail qty of customer orders ItemXXX order o1 qty q order o2 qty q2 ... Subreport detail of inventory (qty location) ItemXXX loc1 qty qInv1 loc2 qty qInv2 ... How can I print only the Items where total inventory <...
  14. tektipdjango

    how suppress blank page at end of report

    I checked for the group footer in my report to have a new page after, but the problem is that I get a blank page after the last group of the report. How can I suppress it? Thanks in advance TektipDjango

Part and Inventory Search

Back
Top