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

John -

I've uploaded a database with just the relevant forms and tables....sorry!!! hope this helps!

Thanks for all your help!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kat-
>
> It's almost impossible to work with your database because you have a bunch of
> GroupWise library definitions that I don't have. It takes forever to open your
> database because I get a ba-zillion error messages from Access. Can you dump
> the relevant tables, queries, and forms into another database and just upload
> that?
>
> 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: Wednesday, June 01, 2011 3:27 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Open form using combo box and command button
>
> John,
>
> Thanks!!!!!!! That worked great!! However, I have an error popping up that says
> that the newrecords isn't working properly..... i didn't do anything with it not
> sure why its not working....this is on the find contract form. I've uploaded an
> updated database...
>
> Thanks!!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > Your previous message came in at midnight Paris time - sorry, I was sound
> > asleep.
> >
> > First, there should be NO Record Source for the FIND CONTRACT form. You'll be
> > changing the data in the first record in the contracts table every time to
> pick
> > search criteria if you do that!!
> >
> > Also remove the Control Source from the three combo boxes.
> >
> > The Where Condition for the Vendor macro:
> >
> > ="[VENDOR=" & [VENDOR ID]
> >
> > ..
> >
> > Should be:
> >
> > ="[VENDOR ID] = " & [VENDOR NAME]
> >
> > (Or you could do & [VENDOR ID] if you change the name of the combo box.)
> >
> >
> > You fixed the Row Source for Employee, but you didn't fix the macro. The
> Where
> > Condition should be:
> >
> > ="[EMPLOYEE ID] = " & [EMPLOYEE NAME]
> >
> > (Or, if you change the combo box name, use [EMPLOYEE ID] for the second part.)
> >
> >
> > 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: Wednesday, June 01, 2011 6:02 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Open form using combo box and command button
> >
> > John -
> >
> > Did you get a chance to look at the database? Still can't figure out what I'm
> > doing wrong... Please help! I've got a deadline and am in a bind.
> >
> > Thanks!
> >
> > Kat
> >
> > --- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@>
> > wrote:
> > >
> > > John -
> > >
> > > I changed the combo boxes on the search form to the match the ones on my
> > contract form, and I took off the quotes; however, it's still not pulling up
> the
> > information. I've uploaded an updated database showing what I did. Also, now
> > everytime I make a selection and hit the command button to pull of the
> > information it creates a new record in my contract table, not sure why it's
> > doing that now.
> > >
> > > Thanks!
> > >
> > > Kat
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> wrote:
> > > >
> > > > Kat-
> > > >
> > > > Well, you have a Vendor ID on the Contract Form, so you need to change
> your
> > > > filter rather than add the Vendor Information table. The combo box on
> your
> > > > search form should be exactly the same as the Vendor combo box on the
> > Contract
> > > > Form. That will bind the search combo to the ID, not the vendor name, and
> > you
> > > > can search using that. Don't put quotes around the parameter value
> because
> > > > you'll be searching on a number, not a text value. You need to do a
> similar
> > > > thing to your Employee search - search for the matching ID, not the name.
> > Your
> > > > search on "Category" (Type of Lease) should work because you're using the
> > text,
> > > > not an artificial ID.
> > > >
> > > > 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 8:13 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [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
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>