Recent content by bigmax98

It only display "Grand Tot". I lost the rest. How do display everything without choping off my statement. Thanks

It didn't work for me because Groupfield always = txtGroup_Text (TxtGroup_Text = Max(Orgn), I put it in Group Header section). I put a textbox with ctrl source = 1 and running sum = overall in detail section. Then I put a textbox, GroupField, in group footer section below group sum box with...

Right now my program displayed group total for each group then I force a new page - CHR(12)after section because the output of this program will be displayed on the web server. How do I print grand total (1 time only) immediately after the last group total. Thanks, Trang tngoe@gmu.edu

Thank you for all the help. Trang

Thanks for all the answer. I think I get the idea. I will try to implement it. Trang

EastWind, I don't want to create a report beforehand. I would like to handle everything in the form. How do you proceed to the next step. I only know how to generate the query. Would you share some codes if you already wrote them before. I never have any formal training. I am still waiting...

Duane, I just print out the CreateReport() and CreateReportControl I will look at and try. Thankyou for pointing to the direction. I can't open any module from your application or anything in your application at all. I just kept having error. I will try to down load again and see whether it...

Duane, I download your codes, but I had error when I try to open. The error is like this: AppName: msaccess.exe AppVer: 9.0.0.6620 ModName: msaccess.exe ModVer: 9.0.0.6620 Offset: 0008885f So I can't view your code and see your application. Thanks Trang

Yes, I need to create a report. But I want to create a report inside the form. I don't want to exit the form and go to Ms Access and create a report via report witzard. Is there a way do it inside the form? If you know, would you please share the code with me. Thanks Trang

I can create a select query from 3 oracle tables via ODBC from a form (Ms Access 2000 with VBA) that the users enter the information. After I get the query, I would like to display the report on the screen without exit the form and go through Ms Access to generate the report via report wizard ...

Duane, I only have Ms Access. What do you mean by create one? (in Ms Access??) and would you please show me how to select my query as the record source. I am confused. I thought it is VB coding. Please don't laugh. Thanks. Here is my query coding: Set db = CurrentDb db.QueryDefs.Delete...

Johnwm, I posted the question in Visual Basic version 5 & 6 forum. I can't see VB 6 forum any where. I must be crazy, can not find it. I thought it is VBA because I start the form from Ms Access 2000. Please don't laught at me. I just played with it in Ms Access 2000 for a few days. I...

zemp, I only have Access tool. This is my first VBA program. I don't know which one is the easiest. I don't want to exit the form, and go to Access and create a report via Access wizard. I want the form display the report after the user enter the criteria and hit the 'Ok' button. The user...

Duane, I mean that I can create a select query from 3 oracle tables via ODBC from a form (Ms Access 2000 with VBA) that the users enter the information. After I get the query, I would like to display the report on the screen without exit the form and go through Ms Access to generate the report...

I can do the select statement from oracle database via odbc base on the user's request on the form in the query. After that I would like to generate a report. How do you proceed next? Thanks Trang tngo@fisk.edu