Recent content by jambai

Thanks for your suggestion. Is it possible to use a single stored procedure or query to use for all the 3 forms and do you have any sample or link for this. Thanks

Hi John, Right now, i have a recordset and 2 Group Section and a Detail Section in my report. Group 1 section will be grouped by Phone Group 2 Section will be Grouped by Name Detail section will have the other details for each records and will have a button to navigate to the other form. So i...

Thanks John, Appreciate your valuable reply... Do you have any reference links to achieve this functionaliyt in a form (May be some example for Main form and 2 Sub forms etc). Thanks again..

Hi John, Thanks for your reply. Actually i have designed a Report in 2007 with 2 Groups and 1 detail section with a buttons in the detail section. So each buttons will open a separate form. So right now everything works fine in 2007 using the code DoCmd.OpenReport "rpt_CallList"...

Thanks John, Appreciate your reply, But acviewPreview will open the report as a Printpreview mode, but i have some command buttons in my report for each records, so if i open the report using acviewreport, then i am handling some click event for each records. So i want to open my report in...

Hello, I could open the report in Report view in Access 2007 using acViewReport, DoCmd.OpenReport "rpt_CallList", acViewReport The same code doesnot works in access 2003, instead of opening the report in Reportview, it is behaving as acnormal and tries to print the report.I believe...

First thanks for your response. In my form load, i am loading the ole unbound control like this : Private Sub Form_Load() Dim wrdApp As Object Set wrdApp = CreateObject("Word.Application") With Me![olePreviewLetter] .Enabled = True .Locked = False '...

Hi, I am using a OLE unbound Control to Embed the word document in the form load, event like this http://support.microsoft.com/kb/209990 and When i double clicks (In Place activation), the documents gets activated (A WINWORD.EXE process is opened) and i can edit the document and in the button...

Hi, I am using a OLE unbound frame control to embed a word document and when i double click the control, it is activated, a winword.exe process is opened and i could edit the document and save it to a new document file. But i couldnt close the winword.exe, so when i do the same process again, i...