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 strongm 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. gimenes26

    Auto Number Question

    i`ve tried but still not working.. i have the same problem i want the autonumber to start at 3000... any chance that u can explain it step by step?
  2. gimenes26

    how to unlock a database??

    i`ve got a database for work but is locked with password, is any way that i can unlock? i have to change some thing on the report.
  3. gimenes26

    HOW TO SEND A FORM BY E-MAIL??

    I`VE GOT A REPORT THAT I CAN SEND USING Snapshot Format, BUT NOW I WANT TO SEND A FORM.. IS IT POSSIBLE? BUT I DO NOT WANT AS A HTML ..
  4. gimenes26

    REPORT IS NO PICKING RECORDS UP

    yes i mean Master/Child.. No.. week sold is in my child report and weekpaying is in my main report.. Basicaly i want that field weekpaying lookin on : weekpaying and weeksold what i want is a look up.. one field looking in 2 fields... i think
  5. gimenes26

    REPORT IS NO PICKING RECORDS UP

    sorry.. That main report has basically is only to select the week(that means the week that we sell jobs) year`s week. Main report(1) has : weekpaying,repsname,branch that report comes from a query.. when i type the week number brings all the jobs sold of the week selected.. and i have another...
  6. gimenes26

    REPORT IS NO PICKING RECORDS UP

    yes.. i am really using subreports... Each report comes from a query.. so i have 5 queries.. The main one plus 4 more.. I have no idea why is picking the records for weekpaying;weekpaying and is not picking records that i`ve linked weekpaying;weeksold..
  7. gimenes26

    REPORT IS NO PICKING RECORDS UP

    I!VE GOT A REPORT WITH 4 SUBFORMS SELECTED BUT WEEKPAYING 1.SUBREPORT = WEEKPAYING;WEEKPAYING 2.SUBREPORT = WEEKPAYING;WEEKSOLD 3.SUBREPORT = WEEKPAYING;WEEKPAYING 4.SUBREPORT = WEEKPAYING;WEEKDEBITED BUT IN SUBREPORT 2 IS NOT PICKIN UP THE RECORDS... COULD ANYBODY HELP ME PLEASE???
  8. gimenes26

    subreport not showing data

    i have done a formula in the query.. weekpaying : weeksold+1 example: if we are on week 2 week paying is 3 (we pay the jobs that we sell on the next week) but when i select that week 3 for example on my main report that subreport does not come up with the records.. i work on main report to...
  9. gimenes26

    hasdata not working

    THANK U VERY MUCH!!! U ARE THE MAN!!!!!!!!! I`M VERY HAPPY WITH THIS WEB SITE!!
  10. gimenes26

    hasdata not working

    THAT IS THE FORMULA IN THE MAIN REPORT : =IIf([CASHJOBS].Report.HasData=-1,[CASHJOBS].Report!TEXT127,0) BUT WHEN I HAVE DATA SHOWS UP WITH ERROR... CAN ANYBODY HELP ME PLEASE??
  11. gimenes26

    hasdata not working

    and thanks for the advice, i`ve changed already from: cash jobs to cashjobs :) can u help me with my problem please?
  12. gimenes26

    hasdata not working

    thank u very much for your attention but is not working.. sorry but i meant IIF , is correct in the formula... the point is: i need that subreport total showin numbers, if the subreport has no data i need showing 0, if has data i need that formula : [cash jobs].[report]![totalcomm] cheers
  13. gimenes26

    hasdata not working

    i,ve got 3 subreports on main report each with total price, and i use the hasdata formula but still having problem.. formula for subreports on main report : =[cash jobs].[Report]![totalcomm] on cach jobs report i`ve got : =sum([totalcomm]) and when i have no data shows...
  14. gimenes26

    subforms in report

    thanks hitechuser!!!!!! is working now , but i have another problem if the subform has no record, the formula shows error , i need showing number 0 for the grand total works!!! if the 1 subreport shows error , the grand total shows error, i need showing 0 for the sum!! would be great if u could...
  15. gimenes26

    subreport total showing error

    I`v done a report with 3 subreports on the same page, each one showing separeted totals, but they are selected by week , for exemple if i select week number 27, the report shows me 3 records , if i select week 35 , the report shows me 7 records but sometimes we have weeks with no records , that...
  16. gimenes26

    subforms in report

    i have a report whit 3 subforms, and i need a total of these 3 subreports, but if a put these subreport in the details sections, they repeat the section, and if a put the sub reports in the header section only shows me one works fine, but the total in the footer header does not work!! could...

Part and Inventory Search

Back
Top