John V,
Thanks for the advice.
John B
--- In MS_Access_Professionals@yahoogroups.com, "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: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> jbloomstine@...
> 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