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
>
Tidak ada komentar:
Posting Komentar