473,326 Members | 2,136 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,326 software developers and data experts.

Linking of Database with Reports in MS Access

Dear Friends,

I am writing a program for cheque printing.

There is one database called bank name in which there are different banks (like HSBC, UTI etc) and which are programmed in drop box of bank name.

I have different report for different banks (all different settings as per the cheques of the concerned bank). I have created reports for all the banks with different settings.

I want to run the report based on the selection of bank. When ever they select HSBC in the banks name it should run the report of the HSBC bank cheque priting.

Please help me out in getting the solution.

Thanks & Regards,

Srinivas
Mar 30 '07 #1
3 1234
Rabbit
12,516 Expert Mod 8TB
Well, if you want to open the report when they select a bank from the combo box then you can use a select case in the after update event of the combo box. If you want it to open when they click a button then do it in the on click event.
Mar 30 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
Assuming bank name combobox is called cboBankName. You will need something like the following code behind your command button:
Expand|Select|Wrap|Line Numbers
  1. Dim rpt As String
  2.  
  3. SELECT cboBankName
  4.  
  5. CASE "HSBC"
  6.    rpt = "HSBC Report Name"
  7. CASE "UTI"
  8.    rpt = "UTI Report Name"
  9. >
  10. >
  11. etc.
  12. >
  13. End Select
  14.  
  15. DoCmd.OpenReport rpt, acViewNormal
  16.  
Mary
Apr 1 '07 #3
HI

I am not still able to solve this.

Can u pl write a code for me.

The details are :

Bank Name Report Name

Ing Vysya Bank Cheque Printing - Ing Vysya Bank
Indusind Bank Cheque Printing - Indusind Bank

Please help me

Thanks & Regards,
srinivas




Assuming bank name combobox is called cboBankName. You will need something like the following code behind your command button:
Expand|Select|Wrap|Line Numbers
  1. Dim rpt As String
  2.  
  3. SELECT cboBankName
  4.  
  5. CASE "HSBC"
  6.    rpt = "HSBC Report Name"
  7. CASE "UTI"
  8.    rpt = "UTI Report Name"
  9. >
  10. >
  11. etc.
  12. >
  13. End Select
  14.  
  15. DoCmd.OpenReport rpt, acViewNormal
  16.  
Mary
Apr 4 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Ken | last post by:
I have a win 2000 database of autographs and scanned photos. They are in the SAME directory. In the table, my "ImagePath" text field shows JUST the image name (i.e. "blank.jpg"). I have an image...
0
by: gasturbtec | last post by:
please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...
2
by: jayjay | last post by:
In the database I have, its split into front end screens and reports and backend tables for data. Of course, this means the linked tables are linked using the linked table wizard to the network...
2
by: Galka | last post by:
Hello We started using Blackboard learning system in our college. We would like to link Blackboard SQL-server backend to an Access database for writing reports. Does anyone have an experience of...
5
by: chrisse_2 | last post by:
Hi, All the records in my database will contain at least one picture. At the moment all the images are part of the database as ole objects although the database is way to big and there is only...
2
by: jomonto | last post by:
Hello- Here is my situation. I have multiple copies of the same database on our MS SQL server (same program, but differnet funding streams). I have an Access 2003 front end that I link to the...
4
by: Supa Hoopsa | last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I...
11
by: John Ortt | last post by:
Hi everyone. I have a database which I have developed in Access 2000 which is working nicely. The problem is that my customer only has Access 97. I tried to convert the database but the main...
4
by: steve i | last post by:
Greetings; I have a project in which the client would like the database shared within an office enviornment, it is networked. My thinking is to create two databases, one with the data tables only...
7
by: coolsti | last post by:
I have the task to set up an application at work,using MS Access as a front end to a MySQL database. This will be done using an appropriate ODBC driver, and linking the MySQL database to Access. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.