Msg Box question

I have several reports that are run by queries.  Most of these queries have 
date range parameters that must be entered by the operator.  I have one query 
that I ask only for a week ending date.  This is driving mgmt nuts because 
they are used to entering a beginning date first, followed by the ending 
date.  I hard wire the beginning date myself.  How can I get a msg box to pop 
up to tell people what my hardwired date is?  Ideas?
0
Utf
10/26/2007 7:10:01 PM
access 16762 articles. 3 followers. Follow

11 Replies
926 Views

Similar Articles

[PageSpeed] 37

I believe you're describing pop-up Parameter Input Boxes, not message boxes.

One option is to use a form to enter the parameter values rather than simply 
having dialog boxes pop up. In that way, you can put as much or as little in 
the way of instructions as you like.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Bunky" <Bunky@discussions.microsoft.com> wrote in message 
news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
>I have several reports that are run by queries.  Most of these queries have
> date range parameters that must be entered by the operator.  I have one 
> query
> that I ask only for a week ending date.  This is driving mgmt nuts because
> they are used to entering a beginning date first, followed by the ending
> date.  I hard wire the beginning date myself.  How can I get a msg box to 
> pop
> up to tell people what my hardwired date is?  Ideas? 


0
Douglas
10/26/2007 8:10:45 PM
I haven't ever used a form that way but I like the sound of it.  Let me see 
if I get it.  I would design a form and on this form would be a textbox for 
end date and I would hard wire the date I want to always use as begin date 
also in a textbox.  After client enters data, somehow the query is launched 
(how would that happen?).  Is that close?
"Douglas J. Steele" wrote:

> I believe you're describing pop-up Parameter Input Boxes, not message boxes.
> 
> One option is to use a form to enter the parameter values rather than simply 
> having dialog boxes pop up. In that way, you can put as much or as little in 
> the way of instructions as you like.
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >I have several reports that are run by queries.  Most of these queries have
> > date range parameters that must be entered by the operator.  I have one 
> > query
> > that I ask only for a week ending date.  This is driving mgmt nuts because
> > they are used to entering a beginning date first, followed by the ending
> > date.  I hard wire the beginning date myself.  How can I get a msg box to 
> > pop
> > up to tell people what my hardwired date is?  Ideas? 
> 
> 
> 
0
Utf
10/27/2007 7:44:00 PM
Close. You need to change your queries so that rather than having [Enter 
Start Date:] as a parameter, they refer to the control on the form 
(Forms![NameOfForm]![NameOfControl]). You'd add a command button on the form 
that invokes the OpenReport method.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Bunky" <Bunky@discussions.microsoft.com> wrote in message 
news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
>
> I haven't ever used a form that way but I like the sound of it.  Let me 
> see
> if I get it.  I would design a form and on this form would be a textbox 
> for
> end date and I would hard wire the date I want to always use as begin date
> also in a textbox.  After client enters data, somehow the query is 
> launched
> (how would that happen?).  Is that close?
> "Douglas J. Steele" wrote:
>
>> I believe you're describing pop-up Parameter Input Boxes, not message 
>> boxes.
>>
>> One option is to use a form to enter the parameter values rather than 
>> simply
>> having dialog boxes pop up. In that way, you can put as much or as little 
>> in
>> the way of instructions as you like.
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
>> >I have several reports that are run by queries.  Most of these queries 
>> >have
>> > date range parameters that must be entered by the operator.  I have one
>> > query
>> > that I ask only for a week ending date.  This is driving mgmt nuts 
>> > because
>> > they are used to entering a beginning date first, followed by the 
>> > ending
>> > date.  I hard wire the beginning date myself.  How can I get a msg box 
>> > to
>> > pop
>> > up to tell people what my hardwired date is?  Ideas?
>>
>>
>> 


0
Douglas
10/27/2007 8:42:58 PM
OK.  I have a query that has the following as the criteria.
([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the 
control.  It is a simple textbox.  Then I also would like the form Data Entry 
Driver to have a combo box on it to select a supervisor & have that value 
passed to the query as well.  It does not recognize either the textbox or the 
combo box.                   
([Forms]![Data Entry Driver]![Combo3]) is what I have as the criteria to get 
the supervisor.  Ideas?

"Douglas J. Steele" wrote:

> Close. You need to change your queries so that rather than having [Enter 
> Start Date:] as a parameter, they refer to the control on the form 
> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on the form 
> that invokes the OpenReport method.
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
> >
> > I haven't ever used a form that way but I like the sound of it.  Let me 
> > see
> > if I get it.  I would design a form and on this form would be a textbox 
> > for
> > end date and I would hard wire the date I want to always use as begin date
> > also in a textbox.  After client enters data, somehow the query is 
> > launched
> > (how would that happen?).  Is that close?
> > "Douglas J. Steele" wrote:
> >
> >> I believe you're describing pop-up Parameter Input Boxes, not message 
> >> boxes.
> >>
> >> One option is to use a form to enter the parameter values rather than 
> >> simply
> >> having dialog boxes pop up. In that way, you can put as much or as little 
> >> in
> >> the way of instructions as you like.
> >>
> >> -- 
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >> >I have several reports that are run by queries.  Most of these queries 
> >> >have
> >> > date range parameters that must be entered by the operator.  I have one
> >> > query
> >> > that I ask only for a week ending date.  This is driving mgmt nuts 
> >> > because
> >> > they are used to entering a beginning date first, followed by the 
> >> > ending
> >> > date.  I hard wire the beginning date myself.  How can I get a msg box 
> >> > to
> >> > pop
> >> > up to tell people what my hardwired date is?  Ideas?
> >>
> >>
> >> 
> 
> 
> 
0
Utf
10/30/2007 7:06:02 PM
Is the form open when you run the query? Access will not open it for you.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Bunky" <Bunky@discussions.microsoft.com> wrote in message 
news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
> OK.  I have a query that has the following as the criteria.
> ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
> control.  It is a simple textbox.  Then I also would like the form Data 
> Entry
> Driver to have a combo box on it to select a supervisor & have that value
> passed to the query as well.  It does not recognize either the textbox or 
> the
> combo box.
> ([Forms]![Data Entry Driver]![Combo3]) is what I have as the criteria to 
> get
> the supervisor.  Ideas?
>
> "Douglas J. Steele" wrote:
>
>> Close. You need to change your queries so that rather than having [Enter
>> Start Date:] as a parameter, they refer to the control on the form
>> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on the 
>> form
>> that invokes the OpenReport method.
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
>> >
>> > I haven't ever used a form that way but I like the sound of it.  Let me
>> > see
>> > if I get it.  I would design a form and on this form would be a textbox
>> > for
>> > end date and I would hard wire the date I want to always use as begin 
>> > date
>> > also in a textbox.  After client enters data, somehow the query is
>> > launched
>> > (how would that happen?).  Is that close?
>> > "Douglas J. Steele" wrote:
>> >
>> >> I believe you're describing pop-up Parameter Input Boxes, not message
>> >> boxes.
>> >>
>> >> One option is to use a form to enter the parameter values rather than
>> >> simply
>> >> having dialog boxes pop up. In that way, you can put as much or as 
>> >> little
>> >> in
>> >> the way of instructions as you like.
>> >>
>> >> -- 
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
>> >> >I have several reports that are run by queries.  Most of these 
>> >> >queries
>> >> >have
>> >> > date range parameters that must be entered by the operator.  I have 
>> >> > one
>> >> > query
>> >> > that I ask only for a week ending date.  This is driving mgmt nuts
>> >> > because
>> >> > they are used to entering a beginning date first, followed by the
>> >> > ending
>> >> > date.  I hard wire the beginning date myself.  How can I get a msg 
>> >> > box
>> >> > to
>> >> > pop
>> >> > up to tell people what my hardwired date is?  Ideas?
>> >>
>> >>
>> >>
>>
>>
>> 


0
Douglas
10/30/2007 7:22:28 PM
Yes, I punch a command button on the open form after I fill in the two entry 
boxes; one pull down and one entry.  

"Douglas J. Steele" wrote:

> Is the form open when you run the query? Access will not open it for you.
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
> > OK.  I have a query that has the following as the criteria.
> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
> > control.  It is a simple textbox.  Then I also would like the form Data 
> > Entry
> > Driver to have a combo box on it to select a supervisor & have that value
> > passed to the query as well.  It does not recognize either the textbox or 
> > the
> > combo box.
> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the criteria to 
> > get
> > the supervisor.  Ideas?
> >
> > "Douglas J. Steele" wrote:
> >
> >> Close. You need to change your queries so that rather than having [Enter
> >> Start Date:] as a parameter, they refer to the control on the form
> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on the 
> >> form
> >> that invokes the OpenReport method.
> >>
> >> -- 
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
> >> >
> >> > I haven't ever used a form that way but I like the sound of it.  Let me
> >> > see
> >> > if I get it.  I would design a form and on this form would be a textbox
> >> > for
> >> > end date and I would hard wire the date I want to always use as begin 
> >> > date
> >> > also in a textbox.  After client enters data, somehow the query is
> >> > launched
> >> > (how would that happen?).  Is that close?
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> I believe you're describing pop-up Parameter Input Boxes, not message
> >> >> boxes.
> >> >>
> >> >> One option is to use a form to enter the parameter values rather than
> >> >> simply
> >> >> having dialog boxes pop up. In that way, you can put as much or as 
> >> >> little
> >> >> in
> >> >> the way of instructions as you like.
> >> >>
> >> >> -- 
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no private e-mails, please)
> >> >>
> >> >>
> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >> >> >I have several reports that are run by queries.  Most of these 
> >> >> >queries
> >> >> >have
> >> >> > date range parameters that must be entered by the operator.  I have 
> >> >> > one
> >> >> > query
> >> >> > that I ask only for a week ending date.  This is driving mgmt nuts
> >> >> > because
> >> >> > they are used to entering a beginning date first, followed by the
> >> >> > ending
> >> >> > date.  I hard wire the beginning date myself.  How can I get a msg 
> >> >> > box
> >> >> > to
> >> >> > pop
> >> >> > up to tell people what my hardwired date is?  Ideas?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 
0
Utf
10/30/2007 7:40:01 PM
When you say it doesn't recognize the two controls, what do you mean? Are 
you saying that it still pops up a prompt rather than accepting what you've 
got in the controls, or are you saying that it's returning everything?

What does the SQL of your query look like now?

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Bunky" <Bunky@discussions.microsoft.com> wrote in message 
news:366343F4-F3B4-477F-A7EC-9D10B4708FC4@microsoft.com...
>
> Yes, I punch a command button on the open form after I fill in the two 
> entry
> boxes; one pull down and one entry.
>
> "Douglas J. Steele" wrote:
>
>> Is the form open when you run the query? Access will not open it for you.
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
>> > OK.  I have a query that has the following as the criteria.
>> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
>> > control.  It is a simple textbox.  Then I also would like the form Data
>> > Entry
>> > Driver to have a combo box on it to select a supervisor & have that 
>> > value
>> > passed to the query as well.  It does not recognize either the textbox 
>> > or
>> > the
>> > combo box.
>> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the criteria 
>> > to
>> > get
>> > the supervisor.  Ideas?
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> Close. You need to change your queries so that rather than having 
>> >> [Enter
>> >> Start Date:] as a parameter, they refer to the control on the form
>> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on 
>> >> the
>> >> form
>> >> that invokes the OpenReport method.
>> >>
>> >> -- 
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
>> >> >
>> >> > I haven't ever used a form that way but I like the sound of it.  Let 
>> >> > me
>> >> > see
>> >> > if I get it.  I would design a form and on this form would be a 
>> >> > textbox
>> >> > for
>> >> > end date and I would hard wire the date I want to always use as 
>> >> > begin
>> >> > date
>> >> > also in a textbox.  After client enters data, somehow the query is
>> >> > launched
>> >> > (how would that happen?).  Is that close?
>> >> > "Douglas J. Steele" wrote:
>> >> >
>> >> >> I believe you're describing pop-up Parameter Input Boxes, not 
>> >> >> message
>> >> >> boxes.
>> >> >>
>> >> >> One option is to use a form to enter the parameter values rather 
>> >> >> than
>> >> >> simply
>> >> >> having dialog boxes pop up. In that way, you can put as much or as
>> >> >> little
>> >> >> in
>> >> >> the way of instructions as you like.
>> >> >>
>> >> >> -- 
>> >> >> Doug Steele, Microsoft Access MVP
>> >> >> http://I.Am/DougSteele
>> >> >> (no private e-mails, please)
>> >> >>
>> >> >>
>> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
>> >> >> >I have several reports that are run by queries.  Most of these
>> >> >> >queries
>> >> >> >have
>> >> >> > date range parameters that must be entered by the operator.  I 
>> >> >> > have
>> >> >> > one
>> >> >> > query
>> >> >> > that I ask only for a week ending date.  This is driving mgmt 
>> >> >> > nuts
>> >> >> > because
>> >> >> > they are used to entering a beginning date first, followed by the
>> >> >> > ending
>> >> >> > date.  I hard wire the beginning date myself.  How can I get a 
>> >> >> > msg
>> >> >> > box
>> >> >> > to
>> >> >> > pop
>> >> >> > up to tell people what my hardwired date is?  Ideas?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>> 


0
Douglas
10/30/2007 7:46:23 PM
It does not ask for a prompt; justs gives me nothing but a report heading.

SQL - 
SELECT Staff.Specialist, Sum(Attendance.Points) AS SumOfPoints, 
Attendance.[Attend-Date], Max(Attendance.[Attend-Date]) AS [MaxOfAttend-Date]
FROM Staff LEFT JOIN Attendance ON Staff.Specialist = Attendance.Specialist
WHERE (((Staff.Supervisor)=([Forms]![Data Entry Driver]![Combo3])))
GROUP BY Staff.Specialist, Attendance.[Attend-Date]
HAVING (((Attendance.[Attend-Date])=([Forms]![Data Entry Driver]![Text1])));

"Douglas J. Steele" wrote:

> When you say it doesn't recognize the two controls, what do you mean? Are 
> you saying that it still pops up a prompt rather than accepting what you've 
> got in the controls, or are you saying that it's returning everything?
> 
> What does the SQL of your query look like now?
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:366343F4-F3B4-477F-A7EC-9D10B4708FC4@microsoft.com...
> >
> > Yes, I punch a command button on the open form after I fill in the two 
> > entry
> > boxes; one pull down and one entry.
> >
> > "Douglas J. Steele" wrote:
> >
> >> Is the form open when you run the query? Access will not open it for you.
> >>
> >> -- 
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
> >> > OK.  I have a query that has the following as the criteria.
> >> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
> >> > control.  It is a simple textbox.  Then I also would like the form Data
> >> > Entry
> >> > Driver to have a combo box on it to select a supervisor & have that 
> >> > value
> >> > passed to the query as well.  It does not recognize either the textbox 
> >> > or
> >> > the
> >> > combo box.
> >> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the criteria 
> >> > to
> >> > get
> >> > the supervisor.  Ideas?
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> Close. You need to change your queries so that rather than having 
> >> >> [Enter
> >> >> Start Date:] as a parameter, they refer to the control on the form
> >> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on 
> >> >> the
> >> >> form
> >> >> that invokes the OpenReport method.
> >> >>
> >> >> -- 
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no private e-mails, please)
> >> >>
> >> >>
> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
> >> >> >
> >> >> > I haven't ever used a form that way but I like the sound of it.  Let 
> >> >> > me
> >> >> > see
> >> >> > if I get it.  I would design a form and on this form would be a 
> >> >> > textbox
> >> >> > for
> >> >> > end date and I would hard wire the date I want to always use as 
> >> >> > begin
> >> >> > date
> >> >> > also in a textbox.  After client enters data, somehow the query is
> >> >> > launched
> >> >> > (how would that happen?).  Is that close?
> >> >> > "Douglas J. Steele" wrote:
> >> >> >
> >> >> >> I believe you're describing pop-up Parameter Input Boxes, not 
> >> >> >> message
> >> >> >> boxes.
> >> >> >>
> >> >> >> One option is to use a form to enter the parameter values rather 
> >> >> >> than
> >> >> >> simply
> >> >> >> having dialog boxes pop up. In that way, you can put as much or as
> >> >> >> little
> >> >> >> in
> >> >> >> the way of instructions as you like.
> >> >> >>
> >> >> >> -- 
> >> >> >> Doug Steele, Microsoft Access MVP
> >> >> >> http://I.Am/DougSteele
> >> >> >> (no private e-mails, please)
> >> >> >>
> >> >> >>
> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >> >> >> >I have several reports that are run by queries.  Most of these
> >> >> >> >queries
> >> >> >> >have
> >> >> >> > date range parameters that must be entered by the operator.  I 
> >> >> >> > have
> >> >> >> > one
> >> >> >> > query
> >> >> >> > that I ask only for a week ending date.  This is driving mgmt 
> >> >> >> > nuts
> >> >> >> > because
> >> >> >> > they are used to entering a beginning date first, followed by the
> >> >> >> > ending
> >> >> >> > date.  I hard wire the beginning date myself.  How can I get a 
> >> >> >> > msg
> >> >> >> > box
> >> >> >> > to
> >> >> >> > pop
> >> >> >> > up to tell people what my hardwired date is?  Ideas?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 
0
Utf
10/30/2007 8:09:03 PM
What's in Attend-Date: a valid date, or a date/time (because it was 
populated using the Now function)? If it's a date/time and all you're 
entering is a date, that's likely a problem. Try

HAVING DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry 
Driver]![Text1]

instead, although realistically it would be more efficient to combine both 
of those into the Where clause:

WHERE Staff.Supervisor=[Forms]![Data Entry Driver]![Combo3]
AND DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry Driver]![Text1]

If that doesn't solve the problem, while the form is open and populated, 
open the Immediate Window (Ctrl-G)

Type

?[Forms]![Data Entry Driver]![Combo3]

(complete with the question mark) and hit Enter. What's returned? Does it 
correspond to what you expect to find in the Supervisor field?

For that matter, what are you typing into Text1?

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Bunky" <Bunky@discussions.microsoft.com> wrote in message 
news:0D23960D-82C5-4515-960F-84DDE6211C60@microsoft.com...
> It does not ask for a prompt; justs gives me nothing but a report heading.
>
> SQL -
> SELECT Staff.Specialist, Sum(Attendance.Points) AS SumOfPoints,
> Attendance.[Attend-Date], Max(Attendance.[Attend-Date]) AS 
> [MaxOfAttend-Date]
> FROM Staff LEFT JOIN Attendance ON Staff.Specialist = 
> Attendance.Specialist
> WHERE (((Staff.Supervisor)=([Forms]![Data Entry Driver]![Combo3])))
> GROUP BY Staff.Specialist, Attendance.[Attend-Date]
> HAVING (((Attendance.[Attend-Date])=([Forms]![Data Entry 
> Driver]![Text1])));
>
> "Douglas J. Steele" wrote:
>
>> When you say it doesn't recognize the two controls, what do you mean? Are
>> you saying that it still pops up a prompt rather than accepting what 
>> you've
>> got in the controls, or are you saying that it's returning everything?
>>
>> What does the SQL of your query look like now?
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> news:366343F4-F3B4-477F-A7EC-9D10B4708FC4@microsoft.com...
>> >
>> > Yes, I punch a command button on the open form after I fill in the two
>> > entry
>> > boxes; one pull down and one entry.
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> Is the form open when you run the query? Access will not open it for 
>> >> you.
>> >>
>> >> -- 
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no e-mails, please!)
>> >>
>> >>
>> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
>> >> > OK.  I have a query that has the following as the criteria.
>> >> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
>> >> > control.  It is a simple textbox.  Then I also would like the form 
>> >> > Data
>> >> > Entry
>> >> > Driver to have a combo box on it to select a supervisor & have that
>> >> > value
>> >> > passed to the query as well.  It does not recognize either the 
>> >> > textbox
>> >> > or
>> >> > the
>> >> > combo box.
>> >> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the 
>> >> > criteria
>> >> > to
>> >> > get
>> >> > the supervisor.  Ideas?
>> >> >
>> >> > "Douglas J. Steele" wrote:
>> >> >
>> >> >> Close. You need to change your queries so that rather than having
>> >> >> [Enter
>> >> >> Start Date:] as a parameter, they refer to the control on the form
>> >> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on
>> >> >> the
>> >> >> form
>> >> >> that invokes the OpenReport method.
>> >> >>
>> >> >> -- 
>> >> >> Doug Steele, Microsoft Access MVP
>> >> >> http://I.Am/DougSteele
>> >> >> (no private e-mails, please)
>> >> >>
>> >> >>
>> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
>> >> >> >
>> >> >> > I haven't ever used a form that way but I like the sound of it. 
>> >> >> > Let
>> >> >> > me
>> >> >> > see
>> >> >> > if I get it.  I would design a form and on this form would be a
>> >> >> > textbox
>> >> >> > for
>> >> >> > end date and I would hard wire the date I want to always use as
>> >> >> > begin
>> >> >> > date
>> >> >> > also in a textbox.  After client enters data, somehow the query 
>> >> >> > is
>> >> >> > launched
>> >> >> > (how would that happen?).  Is that close?
>> >> >> > "Douglas J. Steele" wrote:
>> >> >> >
>> >> >> >> I believe you're describing pop-up Parameter Input Boxes, not
>> >> >> >> message
>> >> >> >> boxes.
>> >> >> >>
>> >> >> >> One option is to use a form to enter the parameter values rather
>> >> >> >> than
>> >> >> >> simply
>> >> >> >> having dialog boxes pop up. In that way, you can put as much or 
>> >> >> >> as
>> >> >> >> little
>> >> >> >> in
>> >> >> >> the way of instructions as you like.
>> >> >> >>
>> >> >> >> -- 
>> >> >> >> Doug Steele, Microsoft Access MVP
>> >> >> >> http://I.Am/DougSteele
>> >> >> >> (no private e-mails, please)
>> >> >> >>
>> >> >> >>
>> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
>> >> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
>> >> >> >> >I have several reports that are run by queries.  Most of these
>> >> >> >> >queries
>> >> >> >> >have
>> >> >> >> > date range parameters that must be entered by the operator.  I
>> >> >> >> > have
>> >> >> >> > one
>> >> >> >> > query
>> >> >> >> > that I ask only for a week ending date.  This is driving mgmt
>> >> >> >> > nuts
>> >> >> >> > because
>> >> >> >> > they are used to entering a beginning date first, followed by 
>> >> >> >> > the
>> >> >> >> > ending
>> >> >> >> > date.  I hard wire the beginning date myself.  How can I get a
>> >> >> >> > msg
>> >> >> >> > box
>> >> >> >> > to
>> >> >> >> > pop
>> >> >> >> > up to tell people what my hardwired date is?  Ideas?
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>> 


0
Douglas
10/30/2007 9:12:31 PM
Attend-Date is a date/time with a format of short date and has an input of 
Date().

I entered the HAVING - - - - on the query and it gave me a syntax 
error(rats).  Checked closely and rekeyed - still syntax error.  Then I took 
all of criteria out and went to SQL view and typed WHERE - - - .  When I went 
to the Data Entry Driver form, I entered 10/31/07 in text1 and pulled down a 
name for Combo3.  Then I clicked the command button.  It showed me the report 
but with no data.  I went back to the open form and keyed Ctrl-G, entered the 
line you gave me and it shows the values entered on the form in both cases.  
I copied the query and hardwired date and supervisor and report looks fine.  
I am typing 10/31/07 in text1.  Ideas?

"Douglas J. Steele" wrote:

> What's in Attend-Date: a valid date, or a date/time (because it was 
> populated using the Now function)? If it's a date/time and all you're 
> entering is a date, that's likely a problem. Try
> 
> HAVING DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry 
> Driver]![Text1]
> 
> instead, although realistically it would be more efficient to combine both 
> of those into the Where clause:
> 
> WHERE Staff.Supervisor=[Forms]![Data Entry Driver]![Combo3]
> AND DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry Driver]![Text1]
> 
> If that doesn't solve the problem, while the form is open and populated, 
> open the Immediate Window (Ctrl-G)
> 
> Type
> 
> ?[Forms]![Data Entry Driver]![Combo3]
> 
> (complete with the question mark) and hit Enter. What's returned? Does it 
> correspond to what you expect to find in the Supervisor field?
> 
> For that matter, what are you typing into Text1?
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:0D23960D-82C5-4515-960F-84DDE6211C60@microsoft.com...
> > It does not ask for a prompt; justs gives me nothing but a report heading.
> >
> > SQL -
> > SELECT Staff.Specialist, Sum(Attendance.Points) AS SumOfPoints,
> > Attendance.[Attend-Date], Max(Attendance.[Attend-Date]) AS 
> > [MaxOfAttend-Date]
> > FROM Staff LEFT JOIN Attendance ON Staff.Specialist = 
> > Attendance.Specialist
> > WHERE (((Staff.Supervisor)=([Forms]![Data Entry Driver]![Combo3])))
> > GROUP BY Staff.Specialist, Attendance.[Attend-Date]
> > HAVING (((Attendance.[Attend-Date])=([Forms]![Data Entry 
> > Driver]![Text1])));
> >
> > "Douglas J. Steele" wrote:
> >
> >> When you say it doesn't recognize the two controls, what do you mean? Are
> >> you saying that it still pops up a prompt rather than accepting what 
> >> you've
> >> got in the controls, or are you saying that it's returning everything?
> >>
> >> What does the SQL of your query look like now?
> >>
> >> -- 
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> news:366343F4-F3B4-477F-A7EC-9D10B4708FC4@microsoft.com...
> >> >
> >> > Yes, I punch a command button on the open form after I fill in the two
> >> > entry
> >> > boxes; one pull down and one entry.
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> Is the form open when you run the query? Access will not open it for 
> >> >> you.
> >> >>
> >> >> -- 
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no e-mails, please!)
> >> >>
> >> >>
> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
> >> >> > OK.  I have a query that has the following as the criteria.
> >> >> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
> >> >> > control.  It is a simple textbox.  Then I also would like the form 
> >> >> > Data
> >> >> > Entry
> >> >> > Driver to have a combo box on it to select a supervisor & have that
> >> >> > value
> >> >> > passed to the query as well.  It does not recognize either the 
> >> >> > textbox
> >> >> > or
> >> >> > the
> >> >> > combo box.
> >> >> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the 
> >> >> > criteria
> >> >> > to
> >> >> > get
> >> >> > the supervisor.  Ideas?
> >> >> >
> >> >> > "Douglas J. Steele" wrote:
> >> >> >
> >> >> >> Close. You need to change your queries so that rather than having
> >> >> >> [Enter
> >> >> >> Start Date:] as a parameter, they refer to the control on the form
> >> >> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on
> >> >> >> the
> >> >> >> form
> >> >> >> that invokes the OpenReport method.
> >> >> >>
> >> >> >> -- 
> >> >> >> Doug Steele, Microsoft Access MVP
> >> >> >> http://I.Am/DougSteele
> >> >> >> (no private e-mails, please)
> >> >> >>
> >> >> >>
> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
> >> >> >> >
> >> >> >> > I haven't ever used a form that way but I like the sound of it. 
> >> >> >> > Let
> >> >> >> > me
> >> >> >> > see
> >> >> >> > if I get it.  I would design a form and on this form would be a
> >> >> >> > textbox
> >> >> >> > for
> >> >> >> > end date and I would hard wire the date I want to always use as
> >> >> >> > begin
> >> >> >> > date
> >> >> >> > also in a textbox.  After client enters data, somehow the query 
> >> >> >> > is
> >> >> >> > launched
> >> >> >> > (how would that happen?).  Is that close?
> >> >> >> > "Douglas J. Steele" wrote:
> >> >> >> >
> >> >> >> >> I believe you're describing pop-up Parameter Input Boxes, not
> >> >> >> >> message
> >> >> >> >> boxes.
> >> >> >> >>
> >> >> >> >> One option is to use a form to enter the parameter values rather
> >> >> >> >> than
> >> >> >> >> simply
> >> >> >> >> having dialog boxes pop up. In that way, you can put as much or 
> >> >> >> >> as
> >> >> >> >> little
> >> >> >> >> in
> >> >> >> >> the way of instructions as you like.
> >> >> >> >>
> >> >> >> >> -- 
> >> >> >> >> Doug Steele, Microsoft Access MVP
> >> >> >> >> http://I.Am/DougSteele
> >> >> >> >> (no private e-mails, please)
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >> >> >> >> >I have several reports that are run by queries.  Most of these
> >> >> >> >> >queries
> >> >> >> >> >have
> >> >> >> >> > date range parameters that must be entered by the operator.  I
> >> >> >> >> > have
> >> >> >> >> > one
> >> >> >> >> > query
> >> >> >> >> > that I ask only for a week ending date.  This is driving mgmt
> >> >> >> >> > nuts
> >> >> >> >> > because
> >> >> >> >> > they are used to entering a beginning date first, followed by 
> >> >> >> >> > the
> >> >> >> >> > ending
> >> >> >> >> > date.  I hard wire the beginning date myself.  How can I get a
> >> >> >> >> > msg
> >> >> >> >> > box
> >> >> >> >> > to
> >> >> >> >> > pop
> >> >> >> >> > up to tell people what my hardwired date is?  Ideas?
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 
0
Utf
10/31/2007 10:09:02 PM
I found the problem finally.  It was a combination of mistakes in the query.  

Thanks for your time and efforts.

"Douglas J. Steele" wrote:

> What's in Attend-Date: a valid date, or a date/time (because it was 
> populated using the Now function)? If it's a date/time and all you're 
> entering is a date, that's likely a problem. Try
> 
> HAVING DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry 
> Driver]![Text1]
> 
> instead, although realistically it would be more efficient to combine both 
> of those into the Where clause:
> 
> WHERE Staff.Supervisor=[Forms]![Data Entry Driver]![Combo3]
> AND DateValue(Attendance.[Attend-Date])=[Forms]![Data Entry Driver]![Text1]
> 
> If that doesn't solve the problem, while the form is open and populated, 
> open the Immediate Window (Ctrl-G)
> 
> Type
> 
> ?[Forms]![Data Entry Driver]![Combo3]
> 
> (complete with the question mark) and hit Enter. What's returned? Does it 
> correspond to what you expect to find in the Supervisor field?
> 
> For that matter, what are you typing into Text1?
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
> 
> 
> "Bunky" <Bunky@discussions.microsoft.com> wrote in message 
> news:0D23960D-82C5-4515-960F-84DDE6211C60@microsoft.com...
> > It does not ask for a prompt; justs gives me nothing but a report heading.
> >
> > SQL -
> > SELECT Staff.Specialist, Sum(Attendance.Points) AS SumOfPoints,
> > Attendance.[Attend-Date], Max(Attendance.[Attend-Date]) AS 
> > [MaxOfAttend-Date]
> > FROM Staff LEFT JOIN Attendance ON Staff.Specialist = 
> > Attendance.Specialist
> > WHERE (((Staff.Supervisor)=([Forms]![Data Entry Driver]![Combo3])))
> > GROUP BY Staff.Specialist, Attendance.[Attend-Date]
> > HAVING (((Attendance.[Attend-Date])=([Forms]![Data Entry 
> > Driver]![Text1])));
> >
> > "Douglas J. Steele" wrote:
> >
> >> When you say it doesn't recognize the two controls, what do you mean? Are
> >> you saying that it still pops up a prompt rather than accepting what 
> >> you've
> >> got in the controls, or are you saying that it's returning everything?
> >>
> >> What does the SQL of your query look like now?
> >>
> >> -- 
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> news:366343F4-F3B4-477F-A7EC-9D10B4708FC4@microsoft.com...
> >> >
> >> > Yes, I punch a command button on the open form after I fill in the two
> >> > entry
> >> > boxes; one pull down and one entry.
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> Is the form open when you run the query? Access will not open it for 
> >> >> you.
> >> >>
> >> >> -- 
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no e-mails, please!)
> >> >>
> >> >>
> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> news:1A82C761-6402-4B68-9F73-72D9A00B13B5@microsoft.com...
> >> >> > OK.  I have a query that has the following as the criteria.
> >> >> > ([Forms]![Data Entry Driver]![Text1]) where Text1 is the name of the
> >> >> > control.  It is a simple textbox.  Then I also would like the form 
> >> >> > Data
> >> >> > Entry
> >> >> > Driver to have a combo box on it to select a supervisor & have that
> >> >> > value
> >> >> > passed to the query as well.  It does not recognize either the 
> >> >> > textbox
> >> >> > or
> >> >> > the
> >> >> > combo box.
> >> >> > ([Forms]![Data Entry Driver]![Combo3]) is what I have as the 
> >> >> > criteria
> >> >> > to
> >> >> > get
> >> >> > the supervisor.  Ideas?
> >> >> >
> >> >> > "Douglas J. Steele" wrote:
> >> >> >
> >> >> >> Close. You need to change your queries so that rather than having
> >> >> >> [Enter
> >> >> >> Start Date:] as a parameter, they refer to the control on the form
> >> >> >> (Forms![NameOfForm]![NameOfControl]). You'd add a command button on
> >> >> >> the
> >> >> >> form
> >> >> >> that invokes the OpenReport method.
> >> >> >>
> >> >> >> -- 
> >> >> >> Doug Steele, Microsoft Access MVP
> >> >> >> http://I.Am/DougSteele
> >> >> >> (no private e-mails, please)
> >> >> >>
> >> >> >>
> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> >> news:965E1F54-BB7C-491F-BA40-190ED8594A2A@microsoft.com...
> >> >> >> >
> >> >> >> > I haven't ever used a form that way but I like the sound of it. 
> >> >> >> > Let
> >> >> >> > me
> >> >> >> > see
> >> >> >> > if I get it.  I would design a form and on this form would be a
> >> >> >> > textbox
> >> >> >> > for
> >> >> >> > end date and I would hard wire the date I want to always use as
> >> >> >> > begin
> >> >> >> > date
> >> >> >> > also in a textbox.  After client enters data, somehow the query 
> >> >> >> > is
> >> >> >> > launched
> >> >> >> > (how would that happen?).  Is that close?
> >> >> >> > "Douglas J. Steele" wrote:
> >> >> >> >
> >> >> >> >> I believe you're describing pop-up Parameter Input Boxes, not
> >> >> >> >> message
> >> >> >> >> boxes.
> >> >> >> >>
> >> >> >> >> One option is to use a form to enter the parameter values rather
> >> >> >> >> than
> >> >> >> >> simply
> >> >> >> >> having dialog boxes pop up. In that way, you can put as much or 
> >> >> >> >> as
> >> >> >> >> little
> >> >> >> >> in
> >> >> >> >> the way of instructions as you like.
> >> >> >> >>
> >> >> >> >> -- 
> >> >> >> >> Doug Steele, Microsoft Access MVP
> >> >> >> >> http://I.Am/DougSteele
> >> >> >> >> (no private e-mails, please)
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "Bunky" <Bunky@discussions.microsoft.com> wrote in message
> >> >> >> >> news:87F1EF1A-E01E-4CC7-8DD5-164DB159EDE7@microsoft.com...
> >> >> >> >> >I have several reports that are run by queries.  Most of these
> >> >> >> >> >queries
> >> >> >> >> >have
> >> >> >> >> > date range parameters that must be entered by the operator.  I
> >> >> >> >> > have
> >> >> >> >> > one
> >> >> >> >> > query
> >> >> >> >> > that I ask only for a week ending date.  This is driving mgmt
> >> >> >> >> > nuts
> >> >> >> >> > because
> >> >> >> >> > they are used to entering a beginning date first, followed by 
> >> >> >> >> > the
> >> >> >> >> > ending
> >> >> >> >> > date.  I hard wire the beginning date myself.  How can I get a
> >> >> >> >> > msg
> >> >> >> >> > box
> >> >> >> >> > to
> >> >> >> >> > pop
> >> >> >> >> > up to tell people what my hardwired date is?  Ideas?
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 
0
Utf
10/31/2007 10:21:08 PM
Reply:

Similar Artilces:

Saving Question
Why does Excel sometimes ask me if I want to save my spreadhseet even though I haven't made any changes? For example, I just brought it up, made no changes, did nothing, and when I close it out I'm asked if I want to save. Never understood that. Some functions are "volatile" and force a recalculation upon opening the workbook. These commands include TODAY(), NOW(), AREAS() and some others I can't think of right now. Once the workbook is recalced, Excel assumes that it has changed, even if you didn't really change anything. -- Cordially, Chip Pearson Microsoft...

Max Limit for Values in List Boxes and Combo Boxes in Outlook forms
Folks, a user is setting up a form. She wants to have several combo boxes and list boxes with between 75 and 300 (yes, 300 -- that's not a typo!) possible values in the combo box or list box. Before she starts work on this, she would like to know if there is a limit on the number of possible values for a combo box or a multi-select list box. Is there a limit? Is it defined by the number of characters in the values box, or the number of actual values? What is the limit? Any help here would be appreciated. Thanks. David consulttech2004@hotmail.com ...

Tab control question about updates
Searched but couldn't see this discussed. I have a form with 5 tabs. Data can be loaded three ways, manually entered, imported from a text file, and imported from a Word template. On one of the tabs (the second) when the user enters information such as a social sec. number (SSN) that matches a file already in the system, a flag goes off and alerts the user. Works fine. On the import functions, the data is loaded and appears correctly, but when the user moves to the second tab where the SSN number appears, it does not set off the flag when the page opens. I can make it happen with a c...

outlook 2007 cached mode question
With the cached mode a copy of the mailbox is stored locally. Does this mean that a user can go to another user's cached copy and open/read it? Each of my users has to be a local administrator because of a records management system we use, so each person's "private" folders are mapped to a shared network drive where security settings restrict access. If a local administrator would have access to the cached copies of mailboxes I would have to manually change the storage location. If I disable the cached mode what, if any, functionality do I lose? Bill Bill <trai...

Excel should default to autoformat for chart text boxes
Excel in (Office 2003 and as far as I can tell all previous versions of Excel) should default to autoformat for chart text boxes - it currently selects "none" for outline and background options ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.micr...

how do I increase drop list font and box size I created
Font is small and you have to scroll through list due to box size If the dropdown was created using Data Validation.............Font size is set at 8pt Dropdown box height cannot be changed. For workarounds like using a ComboBox and using Zoom see Debra Dalgleish's site on DV Lists. http://www.contextures.on.ca/tiptech.html Gord Dibben MS Excel MVP On Fri, 4 Apr 2008 11:36:02 -0700, cdietz1 <cdietz1@discussions.microsoft.com> wrote: >Font is small and you have to scroll through list due to box size ...

Balancing Question
As posted before, I never got my July/August statement from my bank. I know my statement is up to date, and when I tried to balance it with september, it left me with 200 bucks in bank charges as a descrepency because the starting/ending balance was different. My bank charges me 5.00 for each statement I need because they don't offer it on their webpage. My question is this: Do I have any other option to fix my account/balancing problem besides paying 10 dollars for old statements? Would reinstalling money and starting a new money file with just my September purchases/withdrawls, and ba...

Help with Combo-box
Hey everyone, hopefully someone's run across a problem similar to this and their is a (simple :) solution). Basically I have a simple combo-box that is displayed in a dialog. Now, the problem is that I have around 7200 entries that I want to appear in that box as valid selections...well thus far I haven't been able to get that many entries as a possibility (the combo-box simply refuses to allow me to enter that many fields of data). :( Okay, I tried googling this (thought maybe there was a readily defined maximum on combo-box data size) but I couldn't find anything that wou...

pre-select new record in combo box
Hi, I have a form (frmActivity) with a combo box (cboStore) that gets its data from a table (Store). If there is a new store which dose not show in the combo box I have a command button on the same form that open a popup window for entering the name of the new store. In the 'on close' event of the popup I requeary the combo box (cboStore) on the main form so that the new store will appear. What I would really like is to have the new store already selected in the combo box when the popup is closed. Is this possible and if so how? Thanks, Phil Try after the requery of the ...

Outlook 2007 question
I installed outlook 2007 and now I try to customise it but I notice that the Tools/Opions and Tools/Customize menus are disabled. Why and how to enable them? thanks I notice now that the problem is more severe. I cannot reply to messages, save is not working. It seems that most of the functionality is disabled. I can receive emails but cannot answer them. Any clue? this is very bothering. Thanks! "YLY" wrote: > I installed outlook 2007 and now I try to customise it but I notice that the > Tools/Opions and Tools/Customize menus are disabled. Why and how to enable > t...

Reference column question
Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is when I do my formula which is a subtraction for each column,I want to use a refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so to=Sum(P1-D3)Rather than enter each manually,because cut and paste adds 1 to each column how can I get to use f1 as reference for that column G1 for that column.Thanx If I understand correctly, try putting a $ in front of the row reference. Also, sum is not necessary for what you are doing. =F$1-D3 as you copy that down it becomes =F$1-D4 copied across to the ri...

Keeping track of which listbox has focus: Best approach question
Access 2007 working in compatibility mode with a 2003 database. I have three list boxes on a tab page. I also have buttons that operate based on which list box has focus. So my approach has been to keep track of which list box has focus by having the following kind of code in the On Got Focus function of each list box: Private Sub lbx_suspendedIndefinitely_manageMyTasks_GotFocus() If Not (IsNull(Me.lbx_suspendedIndefinitely_manageMyTasks)) Then Set suspendedListBoxWithFocus = Me.lbx_suspendedIndefinitely_manageMyTasks End If End Sub in which suspendedListBoxW...

Question #10
If possible... How do I get excel to change the color of a "grid" if I enter say specfic letter or word in it. Example. 800 columns by 800 rows All columns and rows are small as possible Each letter would mean something, and I would need the grid with tha letter to be a specifc color. To allow easy viewing of the information V = red R = grey H = blue So instead of filling in each color per grid myself, I would get exce to auto-fill Any help would be greatly appreciat -- dirtytongu ----------------------------------------------------------------------- dirtytongue's Profi...

2 Formatting Questions
Date Fields: Can we, in the CRM forms, format dates to read into the “15 Aug 2005” format? This is possible in reports, but by default, the forms use only numbers for dates, but in any format. Currency: Any ideas of how to track multiple currencies in the same application - specifically USD and Canadian? I know a Microsoft CRM installation currently supports one language. But aside from using a picklist to specify "USD", "CAN", "MEX", or other I'm concerned about how their forecasting. -- Carroll Little Vis.align, LLC 610-692-3290 x3326 www.visalign.c...

Outlook 2003: Cursor automatically in To box when
Whenever I create a new message; reply to one; or forward one in Outlook 2003 on a machine I inherited from someone else at work, the blinking text cursor is automatically placed in the To box. I've never seen this happen before in Outlook or any other email app and its quite annoying. I end up having to either retype the beginning of my message again in the body of the email or cut and paste what i've already began to type. Please help, DMarrs@biziteks.com On Wed, 28 Jul 2004 14:16:12 -0700, <DMarrs@biziteks.com> wrote: >Whenever I create a new message; reply to one...

Moving comment box leader arrow head
Can I move the position of the head of a comment arrow from one corner of the cell it references to another corner? When I display the comment box/arrow for printing it looks as if it is refering to the cell on the right, since the comment arrow points to the upper-right corner of the cell, instead of the upper-left. Francisco ...

Outlook Client on CRM 1.2 Server Box for Demos
Hi, Did a CRM 1.2 install on Windows 2003 Server and all is working well. I have been seeing things on this newsgroup that say I should be able to install the Outlook client as well on this machine although it is an unsupported configuration. This is for demo's only. I am running it under Virtual PC. I would like to not have to have 2 Virtual PC images running just to show the Outlook integration to CRM. When I try to install the Outlook client I get a message at the start saying that the Outlook client is already installed. It is not. Suggestions anyone? Alan ...

VBA date question
Why isn't this working? I have a form which has a text box for an attribute of type DATE. This attribute, foo, is normally null when the form is loaded. I tried setting the default value for the text box to "Date()" but it doesn't show up (i'm thinking it's because I'm actually running a join query to generate the record for the form so the form never gets the opportunity to display the default value for foo since it thinks it's supposed to be null, the result from the query) So I added some code like this: Private Sub Form_Open(Cancel As Integer) If (I...

Access 2007 Rich Text Question 04-28-07
Hi All In the plan text version of a Memo field you can easily add a date by pressing Ctrl+Colon which makes life easy for the end user. However, if the Memo field is set to the Rich Text Property this no longer works. Or am I missing something? Tom gave me a part answer last week but I cannot see a way of inserting a date on a Rich Text Memo field by using keystrokes Thanks ...

A Question about CTreeCntrl
I'm writing an application from an example that uses a CTreeCtrl. I'm don't understand the usage of the InsertItem methods and its parameters. HTREEITEM InsertItem( LPTVINSERTSTRUCT lpInsertStruct ); HTREEITEM InsertItem( UINT nMask, LPCTSTR lpszItem, int nImage, int nSelectedImage, UINT nState, UINT nStateMask, LPARAM lParam, HTREEITEM hParent, HTREEITEM hInsertAfter ); HTREEITEM InsertItem( LPCTSTR lpszItem, HTREEITEM hParent = TVI_ROOT, HTREEITEM hInsertAfter = TVI_LAST ); HTREEITEM InsertItem( LPCTSTR lpszItem, int nImage, int nS...

Text box and formatting?
I am working on class schedule and have one text box which spans a few pages. Pages are double columns. I have a header for each class and paragraph given for class description. On the last page, last column, one description appears at the top with empty space for the rest of the column. I would like to change the formatting of the text in the whole text-box so that most of the last column is used. I can select the text in the text box which expands over the few pages and play with the font size, but that would mean that all the text would be the same size. Is there a way that text...

RPC/HTTP Question
I have two questions about implementing RPC over HTTP: I need to setup about 4 users to work from home over broadband..... I am considering the use of RPC/HTTP but have some questions about it. 1) Can RPC/HTTP be implemented on a single Exchange 2003 server? 2) Once implemented, will the data be downloaded on the user's remote desktops (i.e, PF,? Thank you , Rafael Rafael wrote: > I have two questions about implementing RPC over HTTP: > > I need to setup about 4 users to work from home over broadband..... I > am considering the use of RPC/HTTP but have some questions ab...

Vlookup question #8
Hi- I have a spreadsheet that looks at individuals and the amount they paid within a certain year for healthcare expenditures. Based upon this level of expenditure, I would like Excel to spit out the Category that the individual falls into. Here is what the table for looking up the category looks like: A B C Category Min Max 00 $0 $20 01 $20 $165 Thus, if the expenditure is $17, they would fall into category 00. How do I do this in Excel? I know its probably an easy VLOOKUP function but I'm not sure how to do the VLOOKUP function when telling Excel th...

my question did not post
I've posted a question that didn't show up in the excel community so I posted it again. Although I did find both when I clicked on my name and recent posts by user...what am I doing wrong? Where will this on go... :) Rene, These newsgroups will die in a few days. We will all meet again at http://social.answers.microsoft.com/Forums/en-US/category/officeexcel best wishes -- Bernard Liengme Microsoft Excel MVP "Rene" <Rene@discussions.microsoft.com> wrote in message news:D606C0F8-CBB8-46A8-818D-4151615980A9@microsoft.com... > I've posted a ques...

Msg: You are about to append.....
Access 2007 - - I have a tblLog that at the opening and closing of the main form gets written to with the date and time. I have set warnings unchecked in Access Options. All is well UNTIL I convert it to an MDE, then I get the message about appending when I open or close the main form, and ONLY the main form. No other table writes trigger the warning msg. Any ideas? Here is the code in the form's load event: 'DoCmd.SetWarnings = False (I tried adding this and it triggered an error msg) strsql = "INSERT INTO tblLog (LogonTime) values( Now() )" DoCmd.RunS...