Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-26-2019, 09:39 AM   #1
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Reports displaying multiple records

Thanks for the opportunity to send my db. Have a good laugh at my code. It's alright.

After "we' solve the multiple display problem on the reports, the next and final hurdle is to combine the trip sheet & fueling report on a single page.

This post was requested by DBguy.
Attached Files
File Type: accdb 2019 AgHog Driver T&F Sheets DB_2019-10-26.accdb (1.65 MB, 9 views)

Punice is offline   Reply With Quote
Old 10-26-2019, 10:07 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Reports displaying multiple records

check and test.
some trips don't have fuel records.
Attached Files
File Type: accdb 2019 AgHog Driver T&F Sheets DB_2019-10-26.accdb (1.54 MB, 8 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Punice (10-27-2019)
Old 10-26-2019, 10:38 AM   #3
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Reports displaying multiple records

I know that that some of the records are incomplete,They contain enough information to exist as records with a T_TN or F_SerNo, which is sufficient to demonstrate my problem.

Thanks for replying.

Punice is offline   Reply With Quote
Old 10-27-2019, 07:44 AM   #4
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Reports displaying multiple records

Arnelgp, my apologies for not recognizing what you did, until this morning. I didn't test all of the controls on the 'Select' form, only the middle one. What you achieved eliminated the need for the opening the individual 'trip' & 'fuel' reports. Thank you for performing that magic. You solved one of my problems.

The second problem with the reports is, for example: when I pick the 'Select a trip number to preview both reports' control and pick '1' from the drop-down menu, the report that opens still displays multiple records, like '1', '10' thru '19' or '2', '20 thru 31'. (if all of those records existed), where what I want is for all of trip '1's leg records to display

Perhaps, I didn't describe that problem clearly enough in my previous submissions.

If that problem can be resolved, the db will be finished and I will be able to relax.

Thanks for everybody for you help.
Punice is offline   Reply With Quote
Old 10-27-2019, 09:26 AM   #5
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Reports displaying multiple records

no worries, i get that all the time.
check the code, its very simple.
Attached Files
File Type: accdb 2019 AgHog Driver T&F Sheets DB_2019-10-26.accdb (1.48 MB, 4 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Punice (10-28-2019)
Old 10-28-2019, 06:34 AM   #6
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Reports displaying multiple records

I see the modification to the code. Neat. Another learning opportunity. I guess it's a never ending journey, this Access stuff.

One final nit picking problem: only the first fueling record appears, even though the tables contain more than one (like trip 2 & 7). Hopefully that is an easy fix for you to do If, with all of the help that I've received from this forum, the design of this db is over
Punice is offline   Reply With Quote
Old 10-29-2019, 01:30 AM   #7
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Reports displaying multiple records

fix the report.
Attached Files
File Type: accdb 2019 AgHog Driver T&F Sheets DB_2019-10-26.accdb (1.48 MB, 7 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-29-2019, 09:52 AM   #8
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Smile Re: Reports displaying multiple records

Ok arnelgp,

You did it. You, graciously, tolerated my ignorance and performed the magic that I desperately needed: the solution to my last problem with the never-ending-database project.

Now, I can sleep soundly. As time went on, without my being able to complete the development, I've become obsessed with the damn thing. It occupied every waking moment.

Than you, theDBguy, PBaldy and those of you took time to read my initial post and offer help. All help is greatly appreciated.

Punice is offline   Reply With Quote
Old 10-29-2019, 09:59 AM   #9
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,593
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Reports displaying multiple records

Hi. Congrats! Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple records from query not displaying on form texassynergy Forms 6 11-21-2013 11:05 PM
Forms and reports displaying records out of sequence Mauru74 Reports 4 11-09-2010 02:24 AM
[SOLVED] Displaying Multiple Records using Form Search red0151 Forms 0 03-07-2006 03:05 PM
Displaying multiple records in control bees292 Forms 1 08-03-2005 09:22 AM
Displaying multiple records on a form ShadyOne Forms 1 08-08-2000 08:21 AM




All times are GMT -8. The time now is 08:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World