(Msg. 1) Posted: Tue Nov 25, 2008 1:06 pm
Post subject: Form to open report based on several combo boxes Archived from groups: microsoft>public>access>gettingstarted (more info?)
I need to open a report based on three conditions. Contractor, Card, and
Statement, which is provided from combo boxes. I am able to to open the
report based on the Contractor combo box, I'm just not sure how to
incorporate the other two and have them all work together. Here is what I am
using to pull from the contractor combo box. How can I add the other two to
make it all work? Any help is greatly appreicated!
(Msg. 2) Posted: Tue Nov 25, 2008 1:15 pm
Post subject: RE: Form to open report based on several combo boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> I need to open a report based on three conditions. Contractor, Card, and
> Statement, which is provided from combo boxes. I am able to to open the
> report based on the Contractor combo box, I'm just not sure how to
> incorporate the other two and have them all work together. Here is what I am
> using to pull from the contractor combo box. How can I add the other two to
> make it all work? Any help is greatly appreicated!
>
> Dim StrWhere As String
>
> StrWhere = "[Contractor] = """ & Me.Contractor & """"
>
>
> DoCmd.OpenReport "coding", acViewPreview, , StrWhere
>
(Msg. 3) Posted: Tue Nov 25, 2008 1:46 pm
Post subject: RE: Form to open report based on several combo boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I changed it to that now when I go to run it, I get a debug error and the
following comes back highlighted in yellow. Can you help with what is wrong
with this part?
> This assumes that they are all text data types;
>
> StrWhere = "[Contractor] = """ & Me.Contractor & """ And [Card]= """ _
> & Me.Card & """ And [Statement]= """ & Me.Statement & """"
>
>
> --
> _________
>
> Sean Bailey
>
>
> "Momof2" wrote:
>
> > I need to open a report based on three conditions. Contractor, Card, and
> > Statement, which is provided from combo boxes. I am able to to open the
> > report based on the Contractor combo box, I'm just not sure how to
> > incorporate the other two and have them all work together. Here is what I am
> > using to pull from the contractor combo box. How can I add the other two to
> > make it all work? Any help is greatly appreicated!
> >
> > Dim StrWhere As String
> >
> > StrWhere = "[Contractor] = """ & Me.Contractor & """"
> >
> >
> > DoCmd.OpenReport "coding", acViewPreview, , StrWhere
> >
(Msg. 4) Posted: Tue Nov 25, 2008 2:25 pm
Post subject: RE: Form to open report based on several combo boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Are [Contractor], [Card] and [Statement] all text data types, and are
they the bound columns in their respective combo boxes?
--
_________
Sean Bailey
"Momof2" wrote:
> I changed it to that now when I go to run it, I get a debug error and the
> following comes back highlighted in yellow. Can you help with what is wrong
> with this part?
>
> DoCmd.OpenReport "coding", acViewPreview, , StrWhere
>
> "Beetle" wrote:
>
> > This assumes that they are all text data types;
> >
> > StrWhere = "[Contractor] = """ & Me.Contractor & """ And [Card]= """ _
> > & Me.Card & """ And [Statement]= """ & Me.Statement & """"
> >
> >
> > --
> > _________
> >
> > Sean Bailey
> >
> >
> > "Momof2" wrote:
> >
> > > I need to open a report based on three conditions. Contractor, Card, and
> > > Statement, which is provided from combo boxes. I am able to to open the
> > > report based on the Contractor combo box, I'm just not sure how to
> > > incorporate the other two and have them all work together. Here is what I am
> > > using to pull from the contractor combo box. How can I add the other two to
> > > make it all work? Any help is greatly appreicated!
> > >
> > > Dim StrWhere As String
> > >
> > > StrWhere = "[Contractor] = """ & Me.Contractor & """"
> > >
> > >
> > > DoCmd.OpenReport "coding", acViewPreview, , StrWhere
> > >
(Msg. 5) Posted: Mon Dec 01, 2008 1:01 pm
Post subject: RE: Form to open report based on several combo boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
yes I believe they are
"Beetle" wrote:
> Are [Contractor], [Card] and [Statement] all text data types, and are
> they the bound columns in their respective combo boxes?
> --
> _________
>
> Sean Bailey
>
>
> "Momof2" wrote:
>
> > I changed it to that now when I go to run it, I get a debug error and the
> > following comes back highlighted in yellow. Can you help with what is wrong
> > with this part?
> >
> > DoCmd.OpenReport "coding", acViewPreview, , StrWhere
> >
> > "Beetle" wrote:
> >
> > > This assumes that they are all text data types;
> > >
> > > StrWhere = "[Contractor] = """ & Me.Contractor & """ And [Card]= """ _
> > > & Me.Card & """ And [Statement]= """ & Me.Statement & """"
> > >
> > >
> > > --
> > > _________
> > >
> > > Sean Bailey
> > >
> > >
> > > "Momof2" wrote:
> > >
> > > > I need to open a report based on three conditions. Contractor, Card, and
> > > > Statement, which is provided from combo boxes. I am able to to open the
> > > > report based on the Contractor combo box, I'm just not sure how to
> > > > incorporate the other two and have them all work together. Here is what I am
> > > > using to pull from the contractor combo box. How can I add the other two to
> > > > make it all work? Any help is greatly appreicated!
> > > >
> > > > Dim StrWhere As String
> > > >
> > > > StrWhere = "[Contractor] = """ & Me.Contractor & """"
> > > >
> > > >
> > > > DoCmd.OpenReport "coding", acViewPreview, , StrWhere
> > > >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other