generating access report on click

2013-03-19  Source: Original Site  Category:Visual Basic 4 / 5 / 6  Views:0 

Advertisement

sir i want when user click on the button access report should open.
can anyone help me ?. here is the code what i have written but it
hangs again and again.

Private Sub Command6_Click()
On Error GoTo cancel
Dim Access As New Access.Application
Access.OpenCurrentDatabase ("\\asfserver\itp$\Product_tabletest.mdb")
Access.DoCmd.OpenReport "MR", acViewNormal
DoCmd.OutputTo acOutputReport, "MR", acFormatHTML, "c:\Report1.html"
Application.CloseCurrentDatabase
Shell "RUNDLL32.EXE URL.DLL,FileProtocolHandler " & "C:\Report1.html", vbMaximizedFocus
Access.Quit
done:
Set Access = Nothing
Me.WindowState = 2
Exit Sub
cancel:
MsgBox Err.Description & vbCrLf & Err.Number
End Sub

Related articles
  • generating access report on click 2013-03-19

    sir i want when user click on the button access report should open. can anyone help me ?. here is the code what i have written but it hangs again and again. Private Sub Command6_Click()On Error GoTo cancelDim Access As New Access.ApplicationAccess.Op

  • window.open calling a servlet which generates excel report problem 2012-05-08

    I have one jsp ( Users.jsp ) where admin user filters the clients accordingly some filter criteria. Based on the results it provides a List of users matching Criteria. I have one another button - Extract - when onclick event - a javascript window.ope

  • Access Report: SQL Statistical queries 2013-10-25

    guys, I'm trying to generate Access reports here using linked Oracle tables. (The tables are completely unrelational and almost all the data is in one column which I have to slice and dice. The db design is out of my control.) I'm attempting to get a

  • Access report in vb: Type "access.application" not defined 2014-05-20

    I am new to visual basic 2008. I am trying to open access report in visual basic. I am using visual basic 2008 express and access 2010 (beta) version. I have following reference added. 1. Microsoft Access 14.0 Object Library 2. Microsoft.Office.Core

  • Generating Monthly Report in MS ACCESS 2013-08-29

    I am creating a database in MS ACCESS for data-entry of records, where the system should track the date of record entry. I am using the function date() to track the user entry date, which automatically saves the system date in short date format (12/2

  • Run Access Report 2012-03-25

    Does anybody know how to run a Access Report from a Visual C++ dialog when I click a button ? Or , How to display an access report in a dialog window Thank you very much .. this is quite urgent as I have to finish a program until February 6 Any help

  • How do i print Access Report In Dialog Base APP 2012-04-10

    guys, need some help here, i already check this site, but did not understand much. http://www.codeguru.com/mfc_databas...rts_class.shtml does anyone know how to print an access report from a click of a button, in a dialog base application? can u show

  • Can we use a signature pad to sign Access reports and/or forms? 2012-05-03

    Hello. I've been spending the last few months developing a database to keep track of our employee recruitment. I took an introductory course before getting started and have been learning a lot as I go, but I still consider myself quite the novice. On

  • Access Report in VB 2012-10-18

    I have a module in my program in VB that calls MS Access to generate the reports I need but the problem is, the second report is place exactly on top of the other one. Is is possible to display the two reports in tiled format or cascading? I want the

  • can't make access report go to labels 2012-11-23

    I am using a report that is generated from a parameter query. I want to print the info to labels. However, I only want to print one label at a time (different info on each label). I have had no luck with "labels" in access or exporting to Word and us

  • Access Report on the fly 2013-04-18

    I run a query in VB the recordset that is generated i want to create a access report on the fly and display it?

  • data report designer or access reports ? 2013-07-01

    i am developing a project in vb 6 which deals with printing lots of forms and invoices - all containing user-filled details. The invoices have different structures - some are tabular (with irregularly placed columns, however) while some are plain tex

  • Error running access report from VB6 2013-08-25

    I have been calling an Access 97 report from within VB 6 as a reporting tool. This works fine on my pc and most others. However, a pc on which it worked fine has just upgraded to Office Pro 2000, and now when I click the report button to launch the A

  • Converting MS Access Report to Word 2013-11-06

    I have an annoying problem with converting Access reports into Word. I preview a report. Then when I click on the “Publish it with MS Word”, it opens up Word & converts the report into Word. However, 1. the formatting is changed (sometimes bar li

  • how to hide group of excel rows from vb 6.0 while generating excel report ??? 2013-11-08

    i want to hide particular number of excel rows while i am generating excel report from vb 6.0 it is just like what we do in excel --> data(menu)-->group and outline here in this sub menu we can group particular number of rows/ columns by select

  • Tutorial: Convert Access Reports -> PDF 2014-02-25

    Have been trying to find a good way to convert access reports to PDF effortlessly, and http://www.mvps.org/access/reports/rpt0011.htm didn't quite work either; even if it did, it would prompt you for the file output address....so here's a easier one

  • disable the page navigation in access reports 2014-03-07

    i want to disable the page navigation bar in access reports while its generating reports. anyone know the method to disable the property of page navigation in reports.very urgent

  • Oracle How to generate statspack report 2014-05-18

    We have to generate a statspack report. We are accessing the oracle server which is in a remote machine. The platform is windows. But we are not able to generate a report. We have to know whether we have to specify the path of that machine along with

  • Saving a Access Report As HTML via Automation 2014-07-01

    I am automating Microsoft Access. If you use access vou can click in the Menu to export and there you can export Reports as HTML files. How can I export a rerport via automation? I found out that the RunCommand Method accepts a parameter called acCmd

  • Generate dynamic reports with hyperlinks? 2014-08-15

    I've downloaded the JobReport routine from ADN and it seems to work fine. I'm just somewhat curious to how it differs from the standard 'generate html report' functionality that already exists in Designer? There's not that much difference from what I