473,320 Members | 1,612 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,320 software developers and data experts.

Finding a Record then Previewing a Report

Hi all

My problem is this, I am trying to get my report which works fine, to open at a user specified place in the total amount of records.

So in other words, when the user clicks the button to run the report on the Front End Form, they should be prompted with a box to enter some information, be it record number, or the unique reference each record has, and then they should be taken directly to that record, rather than having to manually seach for it.

Has anyone got a clue how best to do this?

Currently I simply have the button set up as an event procedure to preview the report, but it defaults to the first record in the DB, which when there is going to be 3000+ records added in the first year, will become cumbersome to say the least.

Any help will be greatly appreciated.

Thanks

Martin
Jul 19 '07 #1
1 1217
missinglinq
3,532 Expert 2GB
I think you've gotten the cart before the horse, Martin! You need to go to the desired record then open the report for Preview! To get started, take a look at this tutorial by ADezii on finding a specific record thru code. He actually gives three different methods for doing this:

http://www.thescripts.com/forum/thread667899.html

If you have problems/questions get back to us.

Welcome to TheScripts!

Linq ;0)>
Jul 19 '07 #2

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

Similar topics

5
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle...
1
by: kkrizl | last post by:
I have a form that displays general information about an alarm permit location. There's a subform that shows detailed information about burglar alarms that have gone off at the location. When a...
0
by: Ray | last post by:
Hi all, I would like to ask is there any method for printing the crystal report directly by choosing printer without previewing the report using CrystalReportViewer? Thanks a lot, Ray
1
by: Ray | last post by:
Hi all, Is it possible to print the crystal report directly in vb.net without previewing it? Thanks a lot, Ray
1
by: vermutmb | last post by:
I'm totally stuck. When I click on the "Preview" button for a report on the database window, pressing the <ESCAPEkey simply closes the report. But when I use DoCmd.OpenReport with acPreview on a...
7
ADezii
by: ADezii | last post by:
Use the FindRecord Method of the DoCmd Object (least efficient) - The simplest approach for finding a specific Record is to create an Event Procedure for the Combo Box that mirrors each step of the...
4
by: ARC | last post by:
I have a function in the OnNoData event for all my reports. Since converting to Access 2007, some reports w/ no data will come back fine with the following code. However, it seems a few that are...
1
by: cek172 | last post by:
Currently I have a report that opens from a form and can be printed by pressing the print button on that page. I want to be able to print the report straight from the form without previewing it. Is...
11
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.