473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to Link MS Access Report in VB


Hi.
Currently i have database MS Access. In the database there are some
Reports already designed. i am developing interface in VB and linking to
MS Access database.

My Problem is to access/Link the Reports made in MS Access. So that
i just click on the button in VB interface and its Open the report from
MS Access.

Is there any pssible solution to this problem. If there is no way
to link or call the report from VB then can any1 guide/tell me the Best
software to make reports exactly like the allignment in MS Access.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
1 3701
If a copy of Access will be installed on each user's machine, then you can
use COM Automation to execute the Access Reports from within Access. Of
course, if that were the case, _I_ would create the application's user
interface in Access and there wouldn't have been any problem.

If you haven't already invested a great deal of time and effort in the VB
user interface, perhaps you might find my article comparing classic VB and
Access as a database front end interesting -- it's available at
http://appdevissues.tripod.com/downloads.htm.

As far as I know, there is nothing anywhere that can _exactly duplicate_
Access Reports. Crystal Reports is a reporting tool that is often used with
"classic VB" -- I have never used it but have seen some impressive work done
with it in environments where Access Reports were not an option. (NOTE: the
author of this impressive work told me that if Access Reports had been
available, he'd have used them in preference to Crystal.)

Larry Linson
Microsoft Access MVP
"Bilal Iqbal" <im*********@yahoo.com> wrote in message
news:40**********************@news.newsgroups.ws.. .

Hi.
Currently i have database MS Access. In the database there are some
Reports already designed. i am developing interface in VB and linking to
MS Access database.

My Problem is to access/Link the Reports made in MS Access. So that
i just click on the button in VB interface and its Open the report from
MS Access.

Is there any pssible solution to this problem. If there is no way
to link or call the report from VB then can any1 guide/tell me the Best
software to make reports exactly like the allignment in MS Access.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
4
by: Glenn Mulno | last post by:
Off the wall question: Is there a way to set a hyperlink so that it opens the newest file in a directory? Why: I have a page that is a link to a daily set of reports. A new report gets...
1
by: Steve Edwards | last post by:
I am trying to use an existing report as a subreport in another report. I have the subreport added to the main report, but the only thing that shows up where the subreport should be is the name of...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
13
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text...
5
by: enginerd477 | last post by:
I am having trouble getting my database to do what i want. I have a form with autonumbers which are going to be the numbers of some inventory. the inventory has reports in word or other program. ...
13
by: paquer | last post by:
Ok' I have 2 tables. The first being my main table where each record has a 'FigureID' txt box. (Indexed - No duplicates) The second being my sub table where reporting is entered for these...
3
by: booner | last post by:
Is there any way to show an existing access database (.mdb) report inside a vb.net application? Any/all pointers much appreciated. BBB
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.