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
>
Tidak ada komentar:
Posting Komentar