Listing a field to create reports?

[megavolt121]

I'm updating a database(duh). What I have is a table with an field named Part Name of type Memo. Then using switchboards, I have a switchboard that does view Parts. once in that switchboard i have the option to view all parts. now what i want to happen when i click on view all parts is for access to bring up a list of all the parts (via Part Name on the table) in alphabetical order. On top of that I would like to make each name linked to the corresponding report for that item. How should I go about doing this? Forms, Hyperlinked reports?(I tried this, but the mouse stays in the magnification mode so I can't click on hyperlinks). Please help, I'm stumped.

 

[gusbrunston]

[tt]
Hi:

Looks like you need a form with a combo box with one column: Part Name (type of Memo?)

Design a query that selects from the parts table in alphabetical order. Make that query the data source for your combo box.

If you're not comfortable designing the query or combo box, then use the wizard. It does a pretty good job, and you can easily edit what it comes up with.

I hope this helps. Gus Brunston An old PICKer, using Access2000
Intermediate skills. Back up before taking my suggestions!

 

[JeremyNYC]

Can't sort on Memo. Your part names are probably short enough to be stored in a text field, no? If so, change the data type of your field.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[megavolt121]

Gus
thanks for the tip ont eh combo box. I've now changed my Part Name to type Text. I created a Query and had it sort alphabetically too. So i have one colum in alphabetical order with each part in its own row. Ok so now when I make the combo box, it shows me the first query result in the combo box, but then I drop it down by click the arrow and its blank. On my form I have to go to entry 2, 3, 4 etc to see the rest. Is there anyway to make them all show up in the combo box?

 

[megavolt121]

Oh yea, On top of that I'd like to make it so once the user selects the part, it automatically brings up the correstponding report for that part.

 

[gusbrunston]

[tt]
Hi:

Look at the property sheet_Data for the combo box. What is the Data Control source? The combo box should be bound to Part Name or the name of the related control.

Look at Data_Row Source Type. It should be Table/Query.

Look at Data_Row Source. It should be the name of your query.

Let us know.



Gus Brunston, using Access2000 Intermediate skills.