Recent content by Ashfaque

Thanks Steve, Below is working... =IIf([Pages]=1 And [Page]=1,"",IIf([Page]=1,"Continued Next Page... " & [Page]+1,IIf([Page]<[Pages],"Continued Next Page... " & [Page]+1,"Last Page.. " & [Pages]))) Thanks all

I know I made it complex. I need it to be short and clear. If only 1 page report then nothing to print at bottom. If pages more than 1 then start printing on first page "Continued Next Page...2" and then "Continued Next Page...3" and at last page "Last page..". Max 3 page report will be there. I...

Hi, I have an report called Invoice in which I have place a textbox in page footer which contains following IIF statement. =IIf([Page]=1,"Continued Next Page..." & [Page]+1,IIf([Page]+1<[Pages],"Continued Next Page..." & [Page]+1,IIf([Page]=[Pages]-1,"Continued Next Page..." & [Page]+1," Last...

FE was on local table. I had reinstalled Access and it worked but did not understand the real error. Thanks for all the help. Regards,

I think SQL server is stopping to run Macro and connections.....I dont know yet....

FE is on pc and the back end is on SQL Server. Upon opening log in menu, it connects tbl as required. FE in D:|Ashfaque and BE on SQL SErver

Hi, I have copied my db to new pc and and the above msg is appearing and db cant run. I opened trust center and selected "Enable all macros (not recommended.......) in Macro Setting also I selected "Enable all controls without restrictions and without promting...(last option selected) Still...

How about if we need both British and USA date format to work....I mean "dd/mm/yyyy" or "mm/dd/yyyy" Could it be ?

Thanks Gasman, that was the exact point I missed. My date format was different than the normally I used. Thanks for pointing ....very much appreciated.....

Did some one run this form ? When we receive payment 130, it should clear first circled invoice and then of 290 and 50. The query is doubling amount at first record which I want to stop and accumulate from next same customer only then query result would be ok Any other thoughts ...

Better I will attach here my FE and BE with min records and tbls etc so that it would be easy for you. Please enter in db with Shift +Enter to see the tbls, queries, forms etc. You may directly run form "F_CrSalesInvStatus_Master". This was created to clear OLDEST invoices as and when paid by...

But at me it is strange....

Hello, This query created to produce Running Sum of the invoices of same customer. But even it producing double amount when there only one invoice for that particular customer. Previous I used this query and it was working. May be there has been changed somewhere which I didnt clear about...

Hi, Since SQL Server commands are not that much familier I am with, I like to know about below to menu when I right click on my sql server tbl. Select Top 1000 Rows Edit Top 200 rows In second menu (Edit Top 200 rows) I can make changes in records as requires but records are more that 200 so...

Yes, I did split formula as advised and as shown in sample db of Arnel. And it worked.... Thanks all of you guys.....