Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

ACCESS 2000, Report!


  • Please log in to reply

#1
JuJu

JuJu

    Member

  • Member
  • PipPip
  • 25 posts
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??
:tazz:
  • 0

Advertisements


#2
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
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"
  • 0

#3
JuJu

JuJu

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
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..
  • 0

#4
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
Try This
Access help
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP