Selasa, 30 Agustus 2011

Re: [MS_AccessPros] VBA help needed for command button -- Learn VBA

 

Hi John b,

> "very basic introduction to VBA?"

here is a place you can start ... then you will need a bigger book ;)

Learn VBA
By Crystal
http://www.accessmvp.com/strive4peace/VBA

Excel is used in the programming examples. The basics of VBA are the same.

This would be excellent for you to read ... no hands on, just reading for these chapters :)

Learning VBA is not hard, it just takes dedication and a bit of time, so plan to study -- print the chapters, get a highlighter, make a nice pot of tea, get comfy in your favorite chair, relax ... and enjoy!

~~~~

there are also lots of video tutorials on YouTube.com ...

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 8/30/11, jbloomstine wrote:

> John V,
>
> Thanks for the advice.
>
> John B
>
> --- "John Viescas" <john> wrote:
> >
> > John B-
> >
> > I recommend you get on Amazon and do a search on
> Visual Basic in Books.  Pick
> > one or two that appeal to you.  Or wander into
> your local B&N and browse the
> > computer book section.  All technical authors
> have different styles and cover at
> > different depths.  It's best to be able to browse
> through the actual book first.
> > Pick one, then work it cover to cover.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: jbloomstine@...

> >
> > To John V
> >
> > Thanks for sharing your insights.  Do you have
> any recommendations for a very
> > basic introduction to VBA?
> >
> > --- "John Viescas" <john@> wrote:
> > >
> > > John B-
> > >
> > > Yeah, Duane's solution is pretty slick.  No
> contacts, then the button can't be
> > > clicked.  Saves the overhead of opening and
> testing the form when there are no
> > > contacts (see my code), but adds the overhead of
> testing the contact count for
> > > each record displayed.
> > >
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: jbloomstine@

> > >
> > > Hi John V
> > >
> > > I pasted Duane Hookom's code in as an Event on
> the Customers form.  It worked
> > > great. When a customer does not have any customer
> contacts listed, the Open
> > > Customer Contacts form button is not
> functional.  Great approach and I do not
> > > need to use an error message.
> > >
> > > John Bloomstine
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com,
> "John Viescas" <john@> wrote:
> > > >
> > > > Dear jblookstine (name?)-
> > > >
> > > > Rather than post your entire database, all
> you need to do is post the code
> > > that
> > > > you currently have behind the command
> button.
> > > >
> > > > John Viescas, author
> > > > Microsoft Office Access 2010 Inside Out
> > > > Microsoft Office Access 2007 Inside Out
> > > > Building Microsoft Access Applications
> > > > Microsoft Office Access 2003 Inside Out
> > > > SQL Queries for Mere Mortals
> > > > http://www.viescas.com/
> > > > (Paris, France)
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com]
> On Behalf Of
> > > > jbloomstine@
> > > > Sent: Monday, August 22, 2011 12:53 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] VBA help needed for
> command button
> > > >
> > > > I have not being able to figure out how to
> revise the VBA code for my
> > 08_11_11
> > > > FEP_DB Access 2003 database.  The
> Customers form has a command button titled
> > > > "Open Contacts for this Customer." 
> When it is clicked, it displays the
> > > matching
> > > > records for the contacts that have been made
> for a client.
> > > >
> > > > If a customer does not have any Customer
> Contacts entered and the command
> > > button
> > > > is clicked, it displays a blank Customer
> Contacts form.  I need to have the
> > > > coding revised so it displays a message box
> that states there are not any
> > > > Customer Contacts for this customer.  I
> also don't want the Customer
> > Contacts
> > > > form to open when there are not any matching
> records in that form.
> > > >
> > > > I am hoping to be able to post my database.
> > > >
> > > >

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 579. A good idea is checking yours at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar