Re: Question on Albert's video regarding A2010

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx> wrote in
news:9gDOm.35057$We2.21278@xxxxxxxxxxxx:

"Salad" <oil@xxxxxxxxxxx> wrote in message

Wanting some more info. In Access I might have
Docmd.OpenReport "Parts"
and this will display all the parts in the table. I might then
have Docmd.OpenReport "Parts",,,"PartType = 'Engine'"
and all the parts of type "Engine". Can one have filters like
that as well? IOW, create dynamic reports?

Yes, you simply use the openform action. It really the same as
what we always had.

Note the terms of art, "openform action" -- that is, you use an
embedded macro, as web forms can't use VBA.

When you create a new database now there are 2 options; blank
database and blank web database. What's the difference?

Well, taking a guess? ;-)

Yes, choose blank web if you want to create a web database.

I think the question is:

What do you get with a web database?

What do you lose?

It seems to me that you gain the ability to publish to Sharepoint so
that Access Services can make your app available in any web browser.

What you lose is VBA, anything not supported in embedded macros and
perhaps some of the events (I am guessing about that). But the UI is
different for web objects, so you immediately know what's supported
and what's not.

Yes?

[]

In the afterupdate even of these options I call a sub to set the
filter to display the matching filtered records. And I might have
a dbl-click event to display a single detail employee record. Is
such caabilities available in a web app?

Yes, just try creating a web form. You can well note that you can
place buttons
on the form, and when you choose the click event, you see the
macro editor, and
can write code. So, in this case you could use the setfilter
command.

It's not really code in the sense that we are accustomed to using
the term, i.e., to mean VBA code. It's a structured "code" editor,
but the result is not VBA. And its functionality is not unlimited,
as VBA is unlimited.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Picture property for Access 2K forms
    ... and it works great...until you look at the database size involved. ... or by simply scaling down the image display in the ... > supported by those filters. ... To associate a graphic file with an OLE Server, ...
    (microsoft.public.access.devtoolkits)
  • Re: Picture property for Access 2K forms
    ... I don't use Office Filters, ... >> database to the image files. ... or by simply scaling down the image display in the ... >> display the image, or, if there is no OLE Server installed, then we use ...
    (microsoft.public.access.devtoolkits)
  • Re: General Question about VBA F1 Help Key
    ... I had a problem with my help display and behaviour a while back. ... The exception to this is Windows 2000 with SP4 installed. ... Jean-Guy Marcil - Word MVP ... I previously posted this on VBA Beginners ...
    (microsoft.public.word.vba.general)
  • Re: Strange form behavior with AllowAdditions
    ... the entire purpose is to suppress the AutoNumber display. ... used for the user to select filters, which are then applied to the form (& ... When I set the form's AllowAdditions property to False (for the sole ... the property of Control #1 when it does not have the focus; ...
    (microsoft.public.access.modulesdaovba)
  • Re: beginner programmer with a problem.
    ... ' Opens the theme form. ... ' Filters records relating to the active song on the song form. ... Method applies in VBA code. ...
    (microsoft.public.access.modulesdaovba)