ACCESS FEED: RE: [MS_AccessPros] Open form using combo box and command button

Selasa, 31 Mei 2011

RE: [MS_AccessPros] Open form using combo box and command button

Kat-

The Find Contract form doesn't apply *any* filter in either the Find Contract or
Employee Find macros. If I try to use one of your search buttons, I get an
error in the Current event of Contract Form trying to subtract today's date from
a contract that has no date.

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 ka0t1c_ang3l
Sent: Tuesday, May 31, 2011 4:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Open form using combo box and command button

John -

It's the Find Contract Form I'm having problems with. Each time I select a
contract or employee name to find a contract it prompts me for either the vendor
name. I have uploaded the database I'm currently using that has a few of my
contracts already put in.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kat-
>
> I get no prompt at all when I use your Find Vendor form - after I entered at
> least one row in Vendor Information.
>
> 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 ka0t1c_ang3l
> Sent: Tuesday, May 31, 2011 3:38 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Open form using combo box and command button
>
> Good Morning John,
>
> This is the SQL of the Record Source.....
>
> SELECT [VENDOR INFORMATION].[VENDOR NAME]
> FROM [VENDOR INFORMATION]
> ORDER BY [VENDOR INFORMATION].[VENDOR NAME];
>
> I have also uploaded a zipped file of my database under Kats Files if you want
> to look at it.
>
> Thanks!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > What is the SQL of the Record Source of the form you're trying to open?
> >
> > 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 ka0t1c_ang3l
> > Sent: Friday, May 27, 2011 10:37 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Open form using combo box and command button
> >
> > Hello all!
> >
> > I have a search form with several combo boxes and command buttons. When I
> click
> > on the combo box and select a name I want to then click on the command
button
> > which will open up my form based on the selection made in my combo box.
> > Currently, what is happening after I select a name in the combo box and hit
> the
> > button is another box pops up asking me to enter the vendor name again. How
> do
> > I get rid of that and have the command button take me directly to that form
to
> > bring up the information selected for the vendor? Any help is appreciated
it!
> >
> > Thanks!
> >
> > Kat
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links