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

John -

Ok...I think I got it this time! I didn't import any of the modules.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kat-
>
> Nope, try again. That database still has Module1 in it and references to the
> GroupWise libraries. You need to create a new clean database and import only
> the relevant tables, queries, forms, and macros, then post 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 5:01 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>