Data on fom not displaying

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I have
checked everything I can think of and all appears to be in order. obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview, was the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan :)
 
Why are you printing a form? Forms are not designed for printing. They CAN
be printed, but that is not their purpose. You can't control the printout
very well.

If you wish to print data from an Access database, the proper approach is to
create a REPORT and print it. You can even add a button to your form that
will print the appropriate report. The button wizard will walk you through
all the steps once your report is built and saved.
 
Jan Il said:
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a
print preview, nothing shows up except the header information which
is in a label.

It was working properly then suddenly nothing is showing up. At first
it said that the data was wider than the paper, but, I rearranged the
controls and now it is far within the 8.5"w paper. I am no longer
getting the message but nothing is showing up. It is set to display
Always, and I have checked everything I can think of and all appears
to be in order. obviously, I am over looking something. The only
things that I added after I last checked that it was working and was
displaying in the Print preview, was the Save record and Cancel
buttons. After than, it would not display.

Any suggestions what else I might check?
Click to expand...

Hi, Jan -

First question: if you open the form normally -- that is, in form
view -- are any records displayed, not counting the blank "new record"?

Second question: when you open the form in print preview, how are you
doing it? Are you first opening the form in form view, and then
choosing Print Preview? Or are you selecting the form in the database
window and clicking Print Preview? Or are you doing it in code? If
code, please post it.

Third question: when you open the form in print preview and it shows up
blank, are there multiple pages for you to page through?
 
Hi Rick :-)
Why are you printing a form? Forms are not designed for printing. They
CAN
be printed, but that is not their purpose. You can't control the printout
very well.

If you wish to print data from an Access database, the proper approach is
to
create a REPORT and print it. You can even add a button to your form that
will print the appropriate report. The button wizard will walk you
through
all the steps once your report is built and saved.
Click to expand...

Yes...I klnow....and I have fully explained this to the client. They want
to print the data from the form. I created a really nice report, but, they
want the from printed as a report.

Thank you for your time and help. :-)

Jan :)
 
Hi Lynn! :-)

"> Are you talking about print previewing a Form and not a Report? If so,
then
quit that (j/k).
Click to expand...

I know! I know! It ain't 'spose to be that way. But....the client has
their idea of how it should be. :o)
Seriously, do page navigation buttons show at the bottom of the print
preview screen?
Click to expand...

No. Nothing but the label in the header.

Jan :)
 
If it were me, I'd make the report look very very similar to the form and
add a print button to the form. The client wants to print the data, how
that is accomplished is up to the database designer, not them. You can make
it look as close to the form as you'd like, if they can't get their head
around the fact that laying out items for data entry on a screen is not as
efficient for a printed document as if you build the item specifically for
printing. Do they screenprint their emails in Oultook or do they use the
handy dandy "print" button. Do they screen print a letter in Word?
 
Hi Dirk! :-)
Hi, Jan -

First question: if you open the form normally -- that is, in form
view -- are any records displayed, not counting the blank "new record"?
Click to expand...

No...there are no records displayed. Only the normal blank "new record"
appearance.
Second question: when you open the form in print preview, how are you
doing it? Are you first opening the form in form view, and then
choosing Print Preview? Or are you selecting the form in the database
window and clicking Print Preview? Or are you doing it in code? If
code, please post it.
Click to expand...

I am opening the form in Form view and all records are displayed. Then
doing the Print Preview. But, I just now tried it the other way, from the
database window and it is the same, nothing, just the header.

There is no code for this, it is just a plain, simple data entry form with
Save Record and Cancel buttons.

I have tried first copying the form details to a new form, same thing,.
Then I tried importing the form into new database, but, it is the same. I
have the database set to compact and compile on close.
Third question: when you open the form in print preview and it shows up
blank, are there multiple pages for you to page through?
Click to expand...

No....as this is not a fully functional database as yet, the client has only
entered a few records for testing purposes so there is only one page of
data.

Thanks for you time and help :-)

Jan :)
 
I know! I know! It ain't 'spose to be that way. But....the client has
their idea of how it should be. :o)
Click to expand...

Ah, clients! Can't live with them. Can't live without them...LOL.
No. Nothing but the label in the header.
Click to expand...

Since Dirk asked you a similar question, you might try adding some data
through the form and see if that fixes your problem.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Hi Rick :-)

You're right, and don't argue that printing the form process is not the
right way to do things. However, I am dealing with a client who is
self -taught in Access (as in... they have been at it for two months now),
and, feel they know what they are doing and what they want. Which is, for
me to 'assist' them in creating a database for their business. I already
have the report created.....and it is like the form....and ...you can even
print a form as a report. But...I have to convince the client that their
way is not the way to do it. However, right now they want to see the form
printed their way. ;o)

I have the puce and green candles burning, and my "Worry Beads' are at
hand.....right next to the Advil and Tums....<g>

Jan :)
 
Jan Il said:
No...there are no records displayed. Only the normal blank "new
record" appearance.
Click to expand...

That could be the problem right there, if we are understanding each
other. As you may have seen under other circumstances, if a form has no
records to display and no records can be added, the detail section comes
up completely blank. In form view, this sometimes happens when the form
has its AllowAdditions property set to No, or when its recordsource is
not updatable. Neither of those factors is true in this case, but
you're opening the form in Print Preview mode. In that mode, of course,
no records can be added. So if there are no existing records to display
on the form, the form's detail section is going to be blank.
I am opening the form in Form view and all records are displayed.
Then doing the Print Preview.
Click to expand...

But a moment ago you said that no records were displayed; just the
blank new record. Did I misunderstand?
No....as this is not a fully functional database as yet, the client
has only entered a few records for testing purposes so there is only
one page of data.
Click to expand...

Please clarify: are there records to be displayed on the form, or not?
 
...> "Jan Il said:
That could be the problem right there, if we are understanding each
other. As you may have seen under other circumstances, if a form has no
records to display and no records can be added, the detail section comes
up completely blank. In form view, this sometimes happens when the form
has its AllowAdditions property set to No, or when its recordsource is
not updatable. Neither of those factors is true in this case, but
you're opening the form in Print Preview mode. In that mode, of course,
no records can be added. So if there are no existing records to display
on the form, the form's detail section is going to be blank.


But a moment ago you said that no records were displayed; just the
blank new record. Did I misunderstand?
Click to expand...

Sorry, I misunderstood the questions....I meant that when I open the form in
Form view all the controls and such are visible. There is no data
displayed.
Please clarify: are there records to be displayed on the form, or not?
Click to expand...

Yes....the immediate data entered should be displayed when you do a print
preview 'before' the record is saved, after which, the data will be cleared
from the form controls, and of course there would be no data to display. It
is at this point that the client wants to print the details of the sale.
But, the data is not being displayed.

It may have to do with the way the client has set things up from the get go.
I think I need to dig into their basics and see what they have done.

Thank you very much for all you time and help. I really appreciate it.

Jan :)
 
Lynn Trapp said:
Ah, clients! Can't live with them. Can't live without them...LOL.
Click to expand...

Yup! Ya just gotta love it when you get a fresh Scout who, after earning
their second badge, says..."I just need a bit of help here and there to find
the forest"....LOL
Since Dirk asked you a similar question, you might try adding some data
through the form and see if that fixes your problem.
Click to expand...

Yeah...I did ...still now show....

Thank you for your time and help. I really appreciate it.

Jan :)
 
Jan Il said:
Sorry, I misunderstood the questions....I meant that when I open the
form in Form view all the controls and such are visible. There is no
data displayed. [...]
Please clarify: are there records to be displayed on the form, or
not?
Click to expand...

Yes....the immediate data entered should be displayed when you do a
print preview 'before' the record is saved, after which, the data
will be cleared from the form controls, and of course there would be
no data to display. It is at this point that the client wants to
print the details of the sale. But, the data is not being displayed.

It may have to do with the way the client has set things up from the
get go. I think I need to dig into their basics and see what they
have done.
Click to expand...

Hmm, I think you're right. Depending on how they've set it up and
arranged for controls to be cleared after the record is saved, the form
may have no records to display at that point. I think they must have
gone a step farther than just setting the form's Data Entry property to
Yes, because that would leave the previously entered records available
in the form's recordset, so they'd show up in the print preview. Maybe
there's code that requeries the form after a record is saved, and that
process results in an empty recordset.
 
Dirk Goldgar said:
Jan Il said:
Sorry, I misunderstood the questions....I meant that when I open the
form in Form view all the controls and such are visible. There is no
data displayed. [...]
Please clarify: are there records to be displayed on the form, or
not?
Click to expand...

Yes....the immediate data entered should be displayed when you do a
print preview 'before' the record is saved, after which, the data
will be cleared from the form controls, and of course there would be
no data to display. It is at this point that the client wants to
print the details of the sale. But, the data is not being displayed.

It may have to do with the way the client has set things up from the
get go. I think I need to dig into their basics and see what they
have done.
Click to expand...

Hmm, I think you're right. Depending on how they've set it up and
arranged for controls to be cleared after the record is saved, the form
may have no records to display at that point. I think they must have
gone a step farther than just setting the form's Data Entry property to
Yes, because that would leave the previously entered records available
in the form's recordset, so they'd show up in the print preview. Maybe
there's code that requeries the form after a record is saved, and that
process results in an empty recordset.
Click to expand...

Thanks, Dirk, this gives me some good areas to research. While I surely
don't consider myself an expert....as you know...I've had a bit more than a
couple months experience. But...as you also know, a headstrong newbie can
present some real problem areas to resolve. :o))..... (rolling eyes
innocently)

Jan :)
 
Yup! Ya just gotta love it when you get a fresh Scout who, after earning
their second badge, says..."I just need a bit of help here and there to
find the forest"....LOL
Click to expand...


LOL...Or better yet when the IT department at the college where my wife
teaches announces to the faculty that they are going to conduct a 1 1/2 hour
workshop on how to use Access. I shudder to think what kind of databases
they are going to come up with...LOL
 
Lynn Trapp said:
LOL...Or better yet when the IT department at the college where my wife
teaches announces to the faculty that they are going to conduct a 1 1/2
hour workshop on how to use Access. I shudder to think what kind of
databases they are going to come up with...LOL
Click to expand...

Ouch! Heh....if their IT folks are anything like those where I used to
work, a good many of them are Interns fresh out of computer school, I'd be
worried too!....LOL.

Jan :)
 
Ouch! Heh....if their IT folks are anything like those where I used to
work, a good many of them are Interns fresh out of computer school, I'd be
worried too!....LOL.
Click to expand...

Actually, they are pretty sharp but, as I told my wife, an hour and a half
to learn Access is worse than dangerous -- it's a nightmare looking for a
dream to pop out in.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top