prompt for parameter/criteria
 

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

Sorry, I guess I should have been more specific. I am using a database query.
I am not using any "buttons". I go to the data menu and then choose refresh -
this is when the parameters dialog box appears but it is doesn't have a
caption. As mentioned, if I go to Data menu/Import External Data/Edit Query -
then click refresh, the caption is there.

It also may be usefull to note that when I go to Edit Query in the Data
Menu, I get a dialog box that appears that says "This query cannot be edited
by the Query Wizard." I select ok and then it opens up Microsoft Query. In
here I have a criteria value of: <=[Period?] When I click refresh
(without going in to Edit Query) the words "Period?" do not appear.

I am not very knowledgeable in these queries and am basically self taught,
so I am sorry if any of this is confusing or if I am not using the right
termanology. Let me know if you need more info.

Thanks for the help!

"Joel" wrote:

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

I'm just a user of MS Access queries. I just went into one of my Databases
and have not been able to duplicate your steps. I don't get a refresh
option. I'm using excel 2003.

I think there is some macro that is running in access. I would open up
access with you database and see which macros are setup. I don't think this
is an excel problem.

"Randi" wrote:

Sorry, I guess I should have been more specific. I am using a database query.
I am not using any "buttons". I go to the data menu and then choose refresh -
this is when the parameters dialog box appears but it is doesn't have a
caption. As mentioned, if I go to Data menu/Import External Data/Edit Query -
then click refresh, the caption is there.

It also may be usefull to note that when I go to Edit Query in the Data
Menu, I get a dialog box that appears that says "This query cannot be edited
by the Query Wizard." I select ok and then it opens up Microsoft Query. In
here I have a criteria value of: <=[Period?] When I click refresh
(without going in to Edit Query) the words "Period?" do not appear.

I am not very knowledgeable in these queries and am basically self taught,
so I am sorry if any of this is confusing or if I am not using the right
termanology. Let me know if you need more info.

Thanks for the help!

"Joel" wrote:

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

Sorry, again I didn't provide enough information. My query is not from an
access database. The driver is a: Microsoft ODBC for Oracle.

It is a program that was created internally and I am pulling from it's
database files to create custom reports.

"Joel" wrote:

I'm just a user of MS Access queries. I just went into one of my Databases
and have not been able to duplicate your steps. I don't get a refresh
option. I'm using excel 2003.

I think there is some macro that is running in access. I would open up
access with you database and see which macros are setup. I don't think this
is an excel problem.

"Randi" wrote:

Sorry, I guess I should have been more specific. I am using a database query.
I am not using any "buttons". I go to the data menu and then choose refresh -
this is when the parameters dialog box appears but it is doesn't have a
caption. As mentioned, if I go to Data menu/Import External Data/Edit Query -
then click refresh, the caption is there.

It also may be usefull to note that when I go to Edit Query in the Data
Menu, I get a dialog box that appears that says "This query cannot be edited
by the Query Wizard." I select ok and then it opens up Microsoft Query. In
here I have a criteria value of: <=[Period?] When I click refresh
(without going in to Edit Query) the words "Period?" do not appear.

I am not very knowledgeable in these queries and am basically self taught,
so I am sorry if any of this is confusing or if I am not using the right
termanology. Let me know if you need more info.

Thanks for the help!

"Joel" wrote:

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

I have never written an Oracle script. Oracle is just a Front End Scripting
Language for accessing a database like access.

"Randi" wrote:

Sorry, again I didn't provide enough information. My query is not from an
access database. The driver is a: Microsoft ODBC for Oracle.

It is a program that was created internally and I am pulling from it's
database files to create custom reports.

"Joel" wrote:

I'm just a user of MS Access queries. I just went into one of my Databases
and have not been able to duplicate your steps. I don't get a refresh
option. I'm using excel 2003.

I think there is some macro that is running in access. I would open up
access with you database and see which macros are setup. I don't think this
is an excel problem.

"Randi" wrote:

Sorry, I guess I should have been more specific. I am using a database query.
I am not using any "buttons". I go to the data menu and then choose refresh -
this is when the parameters dialog box appears but it is doesn't have a
caption. As mentioned, if I go to Data menu/Import External Data/Edit Query -
then click refresh, the caption is there.

It also may be usefull to note that when I go to Edit Query in the Data
Menu, I get a dialog box that appears that says "This query cannot be edited
by the Query Wizard." I select ok and then it opens up Microsoft Query. In
here I have a criteria value of: <=[Period?] When I click refresh
(without going in to Edit Query) the words "Period?" do not appear.

I am not very knowledgeable in these queries and am basically self taught,
so I am sorry if any of this is confusing or if I am not using the right
termanology. Let me know if you need more info.

Thanks for the help!

"Joel" wrote:

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???

prompt for parameter/criteria
 

Ok, Thanks for the help Joel. I can't get in to the actual database so I
guess I will just have to deal with it!

Thanks again for the help!

"Joel" wrote:

I have never written an Oracle script. Oracle is just a Front End Scripting
Language for accessing a database like access.

"Randi" wrote:

Sorry, again I didn't provide enough information. My query is not from an
access database. The driver is a: Microsoft ODBC for Oracle.

It is a program that was created internally and I am pulling from it's
database files to create custom reports.

"Joel" wrote:

I'm just a user of MS Access queries. I just went into one of my Databases
and have not been able to duplicate your steps. I don't get a refresh
option. I'm using excel 2003.

I think there is some macro that is running in access. I would open up
access with you database and see which macros are setup. I don't think this
is an excel problem.

"Randi" wrote:

Sorry, I guess I should have been more specific. I am using a database query.
I am not using any "buttons". I go to the data menu and then choose refresh -
this is when the parameters dialog box appears but it is doesn't have a
caption. As mentioned, if I go to Data menu/Import External Data/Edit Query -
then click refresh, the caption is there.

It also may be usefull to note that when I go to Edit Query in the Data
Menu, I get a dialog box that appears that says "This query cannot be edited
by the Query Wizard." I select ok and then it opens up Microsoft Query. In
here I have a criteria value of: <=[Period?] When I click refresh
(without going in to Edit Query) the words "Period?" do not appear.

I am not very knowledgeable in these queries and am basically self taught,
so I am sorry if any of this is confusing or if I am not using the right
termanology. Let me know if you need more info.

Thanks for the help!

"Joel" wrote:

I think you need to enter design mode and chage the caption on the button.
I'm not sure if you are using a VBA Userform of a spreadsheet button so I
will tell you how to change both

VBA Userform
1) In the project window select the userform you are modifying
2) From the VBA menu - View - Properties Window.
3) Select the Button with mouse, the property window will show the button
properties. Change the Caption property


Worksheet button
1) From spreadsheet menu - View - ToolBars - Control Toolbox
2) Press triangle to Enter Design Mode
3) Press Properties Button on toolbar (hand holding square object)
4) Press button. change Caption Property .
5) Press Triangle again the exit design mode.
6) Spreadsheet should now function like normal. In Design mode the button
will not operate.



"Randi" wrote:

I have parameter's set-up in Excel for data that changes. My prompts a

e.g. =[Enter Date]

I don't have a problem with the parameter itself actually working. But
instead - when I used the Data/Refresh button, the prompt appears but there
are no words, - the "Enter Date" does not appear, it is just a blank
parameter box. When I have more than one parameter in a query it makes it
hard to figure out what info I am supposed to be entering when.

If I go in to Data/Import External Data/Edit Query, then hit the refresh
button in there, the words appear, then if I go back to my spreadsheet and
use the refresh command the words appear again. But if I save, close, then go
back in, the words do not appear until I go back in to Edit Query.

Any suggestions???