Prev: combo box look up text box error
Next: Out of Memory message
From: Bretona10 on 24 Mar 2010 16:29
I have a form with a subform, both default to datasheet views. I want to put
a Print Preview button on the form, but it doesnt show up in the datasheet
view.

Is there a way to do this?

Thanks,
Bret
From: Al Campagna on 24 Mar 2010 18:01
Bretona10,
You can create a continuous form that "looks" just like a
datasheet view, but can have button/s in the header/footer.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Bretona10" <Bretona10(a)discussions.microsoft.com> wrote in message
news:59EE209A-3834-471C-8B3B-41726F9DB5E0(a)microsoft.com...
>I have a form with a subform, both default to datasheet views. I want to
>put
> a Print Preview button on the form, but it doesnt show up in the datasheet
> view.
>
> Is there a way to do this?
>
> Thanks,
> Bret


From: fredg on 24 Mar 2010 18:04
On Wed, 24 Mar 2010 13:29:02 -0700, Bretona10 wrote:

> I have a form with a subform, both default to datasheet views. I want to put
> a Print Preview button on the form, but it doesnt show up in the datasheet
> view.
>
> Is there a way to do this?
>
> Thanks,
> Bret

Forms are not designed for printing. Reports are.
Create a report that displays the data the way you want it to.
Then open the report from the command button on your form.
DoCmd.OpenReport "ReportName", acPreview
will display all the records.

If you wish to just report on the one record displayed on the form,
add a where clause to the above OpenReport code.

Assuming the Unique Field is a Number datatype, then:
DoCmd.OpenReport "ReportName", acPreview , , "[RecordID] = " &
Me.[RecordID]

However, if the Unique Field is a Text datatype, use:
DoCmd.OpenReport "ReportName", acPreview , , "[RecordID] = '" &
Me.[RecordID] & "'"


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: Gina Whipp on 24 Mar 2010 18:17
Bretona10,

That would be one of the pitfalls of using datasheet view. Perhaps creating
a form that *loks like* datasheet view, then you could use a button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Bretona10" <Bretona10(a)discussions.microsoft.com> wrote in message
news:59EE209A-3834-471C-8B3B-41726F9DB5E0(a)microsoft.com...
I have a form with a subform, both default to datasheet views. I want to put
a Print Preview button on the form, but it doesnt show up in the datasheet
view.

Is there a way to do this?

Thanks,
Bret

 | 
Pages: 1
Prev: combo box look up text box error
Next: Out of Memory message