Search results

  1. J

    Lebans methog

    Hi, I'm currently facing problems with the automation of exporting reports from ms access to pdf via tasksheduler on windows server 2008 R2. I have found in a lot of threads about http://www.lebans.com/reporttopdf.htm but the page seems no longer available. Can anybody share what was the sollution?
  2. J

    Export report to pdf via vba through task sheduler

    Hi, I have a nasty problem that i can't resolve. I can't get tasksheduler to complete the export task. I want nightly to export some reports to pdf but the task sheduler for some reason starts the task and is not anle to finish it. If i run the Bat file manualy from the same server where i...
  3. J

    Send individual pdf attachment to individual recipients

    Hi, I have created a database that generates a report with customer debts. I have a lot of customers and in a report each page is a different customer with individual debts info. What i would like to do is to create a button and distribute individual report page as pdf to individual customer by...
  4. J

    Calculation according date criteria

    Hi all, I need to make a function that calculates if the needed qty can be transfered. My problem is that the function has to decide wather the warehouse is in prior to recieve the qty of goods according to reservation date description: i have a table1 with the following data StockCode qtyrez...
  5. J

    Filling empty query fields with data

    Hi, I have a query which gives me a results of balance info by warehouse by dates. if the balance is 0 then it is not shown in the table but in a query i use NZ function to show a zero value, but for the rest fields(StockCode and Wh) i do not know how to determin a right value because the...
  6. J

    Counting missing date intervals

    Hello guys, I need some help. I'm doing a project that calculates what was missing in the warehouse but I'm stuck a bit. I will describe what i want to achieve. I have a table with the fields. 1. Date 2. Freebalance The Date field contains of every day for a period that i specify so for...
Back
Top Bottom