Data on fom not displaying

"Jan Il" wrote in message


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

No...there are no records displayed. Only the normal blank "new
record" appearance.

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.

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.

I am opening the form in Form view and all records are displayed.
Then doing the Print Preview.

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

Third question: when you open the form in print preview and it
shows up blank, are there multiple pages for you to page through?

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.

Please clarify: are there records to be displayed on the form, or not?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

LOL

Well, good luck to you! I don't envy you your task.

--
Rick B



"Jan Il" wrote in message
...
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

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?



--
Rick B



"Jan Il" wrote in message
...
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.

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

--
Rick B



"Jan Il" wrote in message
...
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

... "Jan Il" wrote in message


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

No...there are no records displayed. Only the normal blank "new
record" appearance.

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.

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.

I am opening the form in Form view and all records are displayed.
Then doing the Print Preview.

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

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.


Third question: when you open the form in print preview and it
shows up blank, are there multiple pages for you to page through?

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.

Please clarify: are there records to be displayed on the form, or not?

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



--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Lynn Trapp" wrote in message
...
I know! I know! It ain't 'spose to be that way. But....the client has
their idea of how it should be. )

Ah, clients! Can't live with them. Can't live without them...LOL.

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

Seriously, do page navigation buttons show at the bottom of the print
preview screen?

No. Nothing but the label in the header.

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

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

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

Jan



--
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/conrad...essjunkie.html

"Jan Il" wrote in message


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?

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.

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, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Rick B" Anonymous wrote in message
...
LOL

Well, good luck to you! I don't envy you your task.

Thank you....me neither! I just hope their checks don't bounce! :-))


Jan



"Jan Il" wrote in message
...
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

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?



--
Rick B



"Jan Il" wrote in message
...
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.

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

--
Rick B



"Jan Il" wrote in message
...
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

"Dirk Goldgar" wrote in message
...
"Jan Il" wrote in message


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?

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.

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.

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. ))..... (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


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
MS Access MVP

"Lynn Trapp" wrote in message
...
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


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

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.

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/conrad...essjunkie.html