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

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