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