Search results

Yes works from another network...

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?

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

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

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

I don't use relationShips.

Yes i know this is wrong but thought it might be some kind if sql technik or something to avoid that. See i have made this sollution in another way using VBA but it takes a lot of time to calculate the results using vba. The point if this is to count the number of intervals the stockcode was not...

Hi, There it is: SELECT Trim(Query2!StockCode) AS StockCode, Query2.Wh, Nz([FreeBal],0) AS FreeBal1, Date.Date FROM [Date] LEFT JOIN Query2 ON Date.Date=Query2.Date WHERE (((Date.Date) Between "2010.05.01" And "2010.05.31"));

Yes StockCodes and Wh is stored in another query but the problem is that i need it date by date and in a query that I store stockCodes and wh it is joined with a table that has everyday data, That Table is joined with the data in the query i store stockcodes and if in that date there was no...

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

Finally i got it to work!!!

Hi again, Thanks a lot for help but as a result i get 1 if i use it in function. The counter i think somehow doesn't count.

OK i see. But how i can return those results to a query. Because i will be analyzing stock code for period. for example how i could show in query like this: stockcode: missing 220022510 3 the debug print doesn't help me at this time. I need to show the number.

Yes i want no stock for 06/10, then no stock for period 06/18-06/21 and no stock for 06/25 - 06/30. 3 "no stock" totals". I have some coding with recordset can you help me with loop and counting those intervals Function GetINT() As String Dim db As Database Dim Lrs As DAO.Recordset...

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