Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-01-2011, 06:30 PM   #1
cardio614
Newly Registered User
 
Join Date: Jun 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
cardio614 is on a distinguished road
printing and generating forms problem

hey guy.. just found out about this form and hoping for some advice.

i have a form that collects information on different clients (each record is a client). i continuously update the form with new records (clients).

what i want to do is to have a button in my form that generates a report for the specific client (or record). i have tried many things and reading other suggestions.

i am having two problems: one, my report does not update to include the new records i added (just the old one). two (major problem) i really cannot get a single record to print, just all of them!

any help is greatly appreciated!!!

thanks

cardio614 is offline   Reply With Quote
Old 06-01-2011, 08:45 PM   #2
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,320
Thanks: 11
Thanked 721 Times in 671 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: printing and generating forms problem

The newly entered record not being included in the report is probably due to clicking on the print report button before saving the new record. To have a single record as the source for the report you have to identify the record for the Access Gnomes! Allen Browne has an excellent paper outlining how to take care of both of these things:

http://allenbrowne.com/casu-15.html

Linq ;0)>
__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
Old 06-02-2011, 05:12 AM   #3
cardio614
Newly Registered User
 
Join Date: Jun 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
cardio614 is on a distinguished road
Re: printing and generating forms problem

Perfect!

I was able to solve the printing of each record issues.

For some reason, however, despite saving my records, when I open my report, it only contains my first two records (probably the same time when the report was created) and does not update to include more records on the report.

Did I set up my report incorrectly? During the creation of a report, are there features/selections for it to continuously update and include more records?

Thanks so much!! Very appreciated!

cardio614 is offline   Reply With Quote
Old 06-02-2011, 07:40 AM   #4
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,320
Thanks: 11
Thanked 721 Times in 671 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: printing and generating forms problem

The report should include all records currently in the table or query that it is based on, each time it opens. Is it based on a table or a query? If based on a query, when you open the query independently, does it show all records?

Have you actually printed this report out or are you looking at it in Report Preview?

If you're simply Previewing it, are you sure that your current formatting isn't such that it only allows 2 records per page? In Preview is there more than one page in the report?

Linq ;0)>
__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)

Last edited by missinglinq; 06-04-2011 at 10:23 AM.
missinglinq is offline   Reply With Quote
Old 06-04-2011, 07:31 AM   #5
cardio614
Newly Registered User
 
Join Date: Jun 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
cardio614 is on a distinguished road
Re: printing and generating forms problem

Thanks for you reply!

My report is based on form that is linked to a table (not a query).

When I open the form itself, it only shows record #1. When I open record 1 or 2, the corresponding report opens. But for the other records, the form is blank.

I am looking at the form in Report Preview - have not printed it yet. In the preview window, there are multiple pages for the report.

Hope this helps to clarify your question and I appreciate any help!
cardio614 is offline   Reply With Quote
Old 06-04-2011, 10:40 AM   #6
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,320
Thanks: 11
Thanked 721 Times in 671 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: printing and generating forms problem

Quote:
Originally Posted by cardio614 View Post
My report is based on form that is linked to a table (not a query).
Reports are based on Tables or Queries, not on Forms. In Report Design View, go to Properties-Data; what is the Record Source listed there?
Quote:
Originally Posted by cardio614 View Post
When I open the form itself, it only shows record #1. When I open record 1 or 2, the corresponding report opens. But for the other records, the form is blank.
In Form Design View, go to Properties-Format; what is the Default View for the Form?
Quote:
Originally Posted by cardio614 View Post
In the preview window, there are multiple pages for the report.
What do you see if you move to one of the other pages of the report? In Report Design View you have to be very careful of how long, top-to-bottom, you have the report set up; having it too long can result in the report only showing a few records per page.

It would probably help if you could
  • Save the database in 2003 or earlier file format, if you're using version 2007/2011 necessary
  • ZIp it up
  • Attach it to a post here
Sometimes these things can only be diagnosed by the actual laying on of hands.

Linq ;0)>
__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
Old 06-11-2011, 11:23 AM   #7
cardio614
Newly Registered User
 
Join Date: Jun 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
cardio614 is on a distinguished road
Re: printing and generating forms problem

Perfect! I got it to work! Thanks so much!

Another question: Is there a way or feature in Access where I can have a Main Form that opens once the database in finalized that lists my records (by last name) and I can simply click on the name and it will take me directly to the form?

cardio614 is offline   Reply With Quote
Old 06-11-2011, 12:16 PM   #8
VilaRestal
';drop database master;--
 
VilaRestal's Avatar
 
Join Date: Jun 2011
Location: UK
Posts: 1,046
Thanks: 20
Thanked 220 Times in 205 Posts
VilaRestal is on a distinguished road
Re: printing and generating forms problem

Quote:
Originally Posted by cardio614 View Post
Another question: Is there a way or feature in Access where I can have a Main Form that opens once the database in finalized that lists my records (by last name) and I can simply click on the name and it will take me directly to the form?
Deserves a separate thread.

This recent one might be what you're talking about:

http://www.access-programmers.co.uk/...d.php?t=210953

VilaRestal is offline   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
Generating and printing invoice through form and report NISSAR Queries 1 02-10-2011 06:28 AM
[SOLVED] Problem generating Access 2K Queries PBREP Queries 4 12-16-2003 09:10 AM
Problem with timeslot generating code David b Modules & VBA 4 11-18-2003 07:22 AM
generating, printing shipping report - need help bricklebrit Reports 8 02-11-2002 03:59 AM
[SOLVED] Printing problem with Tab-devided Forms Onno Modules & VBA 1 03-13-2000 04:08 PM




All times are GMT -8. The time now is 08:07 AM.


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