Selasa, 31 Mei 2011

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

 

John,

I uploaded a new database that shows the arguments in the Find Contract Form. I'm not sure how to add the vendor name into the record source of the contract form. At this point I feel if I add anything I'll mess up my database.....

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kat-
>
> I found no argument in the macro to open the contract form. What is in the
> Where Condition? Note that Vendor Name isn't in the Record Source of the
> contract form, so perhaps that's why you're getting prompted.
>
> 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 6:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Open form using combo box and command button
>
> John,
>
> I do have an argument in the Where Condition; however, when I make a selection
> and click on the command button it pops up another small window asking me to
> type either the vendor name or employee name, depending on which command button
> I'm using, instead of immediately taking me to the contract form and pulling up
> the information i've requested. I'm not sure what's wrong with my argument.
>
> Thanks!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > You need to add an argument in the Where Condition of the OpenForm action in
> > your macro. Depending on what you're filtering, it needs to look something
> like
> > the filter in the Embedded Macro in the Find Vendor form.
> >
> > 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 5:39 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> >
> > John,
> >
> > Yes, I saw that, but what it should do is when you make a selection and click
> on
> > the control button it should open up that record in the contract form, but
> it's
> > not working. I'm not sure what I'm doing wrong, and the reason for the error
> on
> > the dates is because I didn't put in a contract end date. How do I get the
> > control button to work so that when I make a selection it opens up that
> record?
> >
> > Thanks!
> >
> > Kat
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > 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
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar