Search results

Hi there, can i use nested function in access form to get a value for list box. Here is the following code i am using. sql = "select invoiceNumber as InvNo, iif(sum(value_os)=0,'**Paid**',iif( (type<2) and...

Hi thanks, I have changed all to Sum .. now it is working fine. Many thanks for your help.

Hi Chris, I have attached both the design and result of reports as well. i have attached the second and third page of report ...the circul shows where the error come. this Top service is onley having wrong value...i tried to get value byr query and found that it calculate one delivery of that...

Hi, I have having a proble with Reports in Access 97. We have a report which gives the total value about all the deliveries by delivery type. everything is fine...but when report generates new page(2nd,3rd....) the top delivery type has got the wrong total. and i have found that on each new...

Hi there i have tried to write whole report but it is still niot working...from my analysis it looks like that it report has more than one pages thetn this problem occure...for one page report it is working fine..please anyone can hellp me...i am stuck here...

ok. will try this one as well. lets see..

it was working fine before 2 days...but here is the code... Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer) Select Case DateDiff("d", Report!invd, Date) Case 0 To 30 Report!curr = IIf(Report!groupdeb = "", Format(Report!groupcred, "-0.00")...

Hi .. I tried to repair local file..and it was repaired successfully... but the problem is still there... the details part of report is fine but the footer whcih dispalys the total of detaisl is not correct..it looks like it is calculation all the details value twice...i have made sum by my...

hay...what would i report the local file or my database on server...

hi.. i will try this out and if no luck will give a buzz... thanks for quick reply.

Reports has been changed suddnanly ...gives the wrong Total. Hi There, I have a big Problem. We have a system in access 97. Everything was working nice 2 days ago. Now suddnely the report are wrong mean at the end()footer sum is wrong etc. I tried to use my old back up file but it is happing...

it is like here DoCmd.OpenReport "tempServiceReport", A_PREVIEW, , G_REP_var1 DoCmd.OutputTo OutputReport, "tempservicereport"acFormatXLS, "ServiceReport.xls",_ True where G_REP_var1 = "InvoiceNumber >= " & invfrom & " AND InvoiceNumber <= " & invto & "" and the report has Record Source like...

yes it is based on prebuild query.

I tried it. it also saves in Excel but no data..only with some text box names. no data at all. Could you please tel me how i can get all data in to this Excel file. lost again.. Nitesha

thank you. I will try that. Thansk for quick reply. Nitesha

Hello, I want to save Access Reports in Excel foramt. Can anyone guide me how i can do this. I use the Access 97 to generates reports. I can save them in ritch text format and in snapshot foramt. but i want to save them in Excel format or any other format which will be imported in the Sage 50...

Hi.. I have one .mde application in which there are some linked tabels.. Now problem is the i can see two such a linked tabel which i can not find into a database(from where the table is exsit.).. this linked table is form same databse where other tables are exist. I tried..to show hidden...

hi i found the reason for error.. I created a one Textbox in Report whish had 5 lines text. as i removed that text box from report...it works fine..Textbox had a too big value.. by the way thanks for your time.. Thanks Nitesha

that line is in a comment. not used that line

i am just using the button to generate invoice. here is the code where the erroer occured...this same code was working good yesterday. also works fine in other application. Private Sub Command0_Click() If Form!invnum = "" Or IsNull(Form!invnum) Then Exit Sub Select Case Form!Frame10.value...