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: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
jbloomstine@sbcglobal.net
Sent: Thursday, August 25, 2011 3:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA help needed for command button
To John V
Thanks for sharing your insights. Do you have any recommendations for a very
basic introduction to VBA?
--- In MS_Access_Professionals@yahoogroups.com, "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: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> jbloomstine@...
> Sent: Wednesday, August 24, 2011 5:56 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] VBA help needed for command button
>
> 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.
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar