[JuJu]

Hi,
I have two questions on Access 2000:
1. I have an old database that I can't get into its design view!! How do we show/hide the design view?

2. I want to creat a report, that prompts the user for several parameters. For example, when I click on the report, I want it to prmopt me for (Country) and when I enter that I want it to prompt me for (Sector)...etc. In other words, I want to have the control of what data to be shown in the report using several parameters.

Anyone??

[Advertisements]

Hi JuJu

1. I think that you will find that to be able to get into the design view you will have to convert the database to Access 2000 format. Earlier versions used a different format for the database.

2. Your Report should be based on what is called a Parameter Query. Without going into a long run down on them, look in the Help Files on the Overview and Creation of these type of Queries. You will find that they will perform the actions that you wish to perform.

HTH
"O"

[Octagonal]

Hi JuJu

1. I think that you will find that to be able to get into the design view you will have to convert the database to Access 2000 format. Earlier versions used a different format for the database.

2. Your Report should be based on what is called a Parameter Query. Without going into a long run down on them, look in the Help Files on the Overview and Creation of these type of Queries. You will find that they will perform the actions that you wish to perform.

HTH
"O"

[JuJu]

Thanks Octagonal,

How do I convert a db into a newer version?
and I used a parameter query, and it works now, but I want now to use a combobox when the query prompts the user instead of a text box (so the user will have to choose a predetermined value from the combobox instead of typing things in the query prompt box)..
For example, when I click on the report I want it to prompt me using a combobox for:
Sector: commodities, investment, etc.
and when I choose investment, the report will open showing all the records under investment for example..and so on..

Thanks in advance..

[peterm]

Try This
Access help