Search results

  1. V

    converting to an exe

    so there is no way to have it as an exe??? what about from an MDE to EXE??? If not, then I guess I can do the whole MDE thing and maybe encrypt it
  2. V

    converting to an exe

    I have created a database but I would like it to be an exe. is this possible? if so, how??? I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem? thanks
  3. V

    Self Formating Report

    there is always a right way and then there is a sure way: right way: ????? sure way: take screen shots, edit them a little and then open those in powerpoint :)
  4. V

    Filtering Question

    Sorry about that. I meant FILTER. Can i filter out the records that I do not require even if their fields are not in my report?
  5. V

    Filtering Question

    this might be a bit of a shocker...I don't have any queries. I tried them but I found it easier to work without them. So far, I have not run into any troubles.
  6. V

    Filtering Question

    Hi. I was just wondering if it is possible to filter out records in a report using a filter...but here is the trick. Is it possible to filter them EVEN if the coulmn is not included in the report. EX: NAME----ID-----Job type-----Cost----Rebate can I sort them by "JOB APPROVAL" even if that...
  7. V

    Simple SQL statement

    thanks you very much...YOU ROCK! :D
  8. V

    Simple SQL statement

    Just wondering if this is doable. I have the following statement in a text box and would like to duplicate something like it. THIS IS WHAT I HAVE: =Count(IIf([Measure Approved]="YES",0)) I NEED the other statement in another text box to do the following. Sum up the measure cost If MEASURE...
  9. V

    small code in need of review

    that is what I am trying to do. I just can't get it to add the totals of the implemented measures. Any ideas
  10. V

    small code in need of review

    hi. I am trying to write a code to sum the total cost of all jobs that are selected as 'yes' in a combo box. Once the user selects 'yes' in a combo box, they enter in a cost for that specific job. Each client may have 10s of jobs. I need to write a code that will sum up all the 'yes' selected...
  11. V

    simple coding help required

    hi. I am trying to write a code to sum the total cost of all jobs that are selected as 'yes' in a combo box. Once the user selects 'yes' in a combo box, they enter in a cost for that specific job. Each client may have 10s of jobs. I need to write a code that will sum up all the 'yes'...
  12. V

    Adding a count into a report

    is there any way I could do it without the query. I have two of the same report. One is with a query and the other isn't. I could still use the other report. I only need this one field. TOTAL COST OF IMPLEMENTED MEASURES :(
  13. V

    Adding a count into a report

    why am i getting this message whenever I try to run the report or the query. "you are trying to execute a query that does not include the specified expression 'client prefix' as part of an aggregrate function." what is wrong?
  14. V

    Adding a count into a report

    not really, Each measure has its own cost. I need to add up all the total values of the "number of measures implemented from selected". This cost of each meausre is inputed on a form "ECM Details". If there are 5 measures, 3 are selected as 'yes' for approval, and only 2 of those 3 are...
  15. V

    Adding a count into a report

    The Last Question Thank you very very very much for your help with this issue. you have been AMAZING and fast. I just have one more thing to ask you. I already have a report and I want to add another 2 fields in it. here is the situation: I have a field "# of measure identified","total...
  16. V

    Adding a count into a report

    once again... NEVERMIND. I GOT IT. I think I might have one more small problem..i'll keep you posted
  17. V

    Adding a count into a report

    At least I thought I got it Well, The fields actually work but there is a problem. My database does not use any queries. I am now creating a report from my 'Audit Info' table but I need a couple of fields from my 'ECM Details" table. I can't see to be able to link them in the report. Is...
  18. V

    Adding a count into a report

    nevermind, I think I got it. Thanks a lot for your help though.
  19. V

    Adding a count into a report

    THANK YOU, that worked perfectly, Now I need to trouble you for one more question. I also need to count how many entries (jobs) are specified for each client. How would I go about doing that? It should be simpler than the above problem. THANKS :)
  20. V

    DCount Problem

    the thread that you linked me to does not help. I am trying to count how many 'yes' and 'no' answer are in a report, not change them to 0 or 1. I just cannot seem to figure out the DCount statement; I don't know why
Back
Top Bottom