Not sure how to go about doing this

[hardhitter06]

I need to create forms and/or reports to display a very large set of records.

Is there a way to list records, lets say arranged by department, and have a feature capable of selecting a specific record and having something "pop up" to display more specfic data for that given record?

Also, is there a feature where you can select a key and have it jump to the departments that start with that letter?

 

[Moniker]

Make a combobox containing the names of each department and limit it to the list. They can type in the first few letters of the department name and it will get there.

Link a subform that contains all the department details to the department name and have it refresh in the AfterUpdate event of the combobox.

I'm being vague here because this has been covered about 50 times in the past month. See the attachment for how to link a combobox value to a subform.

~Moniker

 

[hardhitter06]

Um, I don't think thats exactly what Im looking for...lemme explain a little further and then tell me if i can still do somethin like that

Here's and example of how the data was presented in a previous program

Dept: Vendor: Beg Date: Amt:
Admissions ABC 1/1/07 100
Admissions DEF 2/2/07 100
Art Museum FFF 2/2/07 200
Budget YYY ... ..
Communications ...
Communications ...
Communications ...

And so on...so some departments are linked to more than one vendor so the combo box selection (at least the example you've shown me) probably won't work right?

Also, each of those records, has another 5 fields with information regarding them, is there any way i could click on one of the records and have something pop up, different than this current window. Although, i could jus use 75 percent of the screen to display these lines and have the other 25 percent be the subform displaying the other information...

I need some more guidance...btw thanks for your time and patience

 

[Moniker]

Here's the structure you want:

[b]TABLE: t_Departments[/b]

FIELDS:
DeptID (Primary Key)
Department_Name
.
.
<Other department details you want>
.
.


[b]TABLE: t_Vendors[/b]

FIELDS:
VendorID (Primary Key)
Vendor_Name
.
.
<Other vendor details you want>
.
.

[b]TABLE: t_VendorDetail[/b]

FIELDS:
DeptID (Compound Primary Key)
VendorID (Compound Primary Key)
Vendor_Date (Compound Primary Key)
Amount
.
.
<Other vendor_detail details you want>
.
.

Search the forum for how to do compound primary keys (I just posted about it somewhere). That same post explains how to make the relationships between all the tables.

If that structure is beyond what you're understanding, you can use a SELECT DISTINCT on the combobox's Record Source to avoid duplicates.

 

[hardhitter06]

my problem isn't that...i know how to relate the fields, its how to display them the way I want.

Instead of you assuming that there's 50 posts already given about my problem, maybe you should ask for some more clarification. Isn't that what these forums are for?

 

[Moniker]

Instead of you assuming that there's 50 posts already given about my problem, maybe you should ask for some more clarification. Isn't that what these forums are for?

I'm going to keep a cool head here. The person asking for help is the one that should be clear. The person answering can only make assumptions when the question itself is vague. I'm not making assumptions -- I've personally answered many questions very similar to yours.

The SELECT DISTINCT I suggested will provide the department list. If you would like to post a stripped down version of the DB, I'll be happy to answer it.

 

[hardhitter06]

Alright, my apologies..

I think this thread is something I'm looking forward too, but I'm very new to coding so Scotty's explination to me seems vague...

http://www.access-programmers.co.uk/forums/showthread.php?t=120418

 

[pbaldy]

Check that thread again, as I just posted a snippet there.