Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » List in excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

List in excel

Resolved · Medium Priority · Version 2002/XP

Reply Fri 14 Nov 2008, 13:23Delegate Louise said...

Louise has attended:
No courses

List in excel

I am working in excel, showing properties returns relating to different funds. I would like to write a code so that when a fund is selected, a seperate list of all the properties available in that fund is shown. If that possible?

Many thanks

Louise

For upcoming training course dates see: Pricing & availability

Reply Mon 15 Dec 2008, 14:00Trainer Jacob said...

RE: List in excel

Dear Louise

Thanks for your post and our apologies for the delay in getting back to you, this post did slip through the net!

We may be able to find a solution to what you describe, but it will help us if you can supply some more information.

It looks like you have some specific spreadsheets you are working with so if you can list your main objectives, including key features you wish to have and even a copy of some example spreadsheets that will be great.

We can then let you know if we can help, and if so will most likely need to set aside some development time to work on the solution, we will let you know if there will be any associated costs.

If you wish to look into this in more detail then please let us know.

Regards

Jacob

Mon 22 Dec 2008: Automatically marked as resolved.

Access articles

· How To Use The New Navigation Form In Access 2010
· Discover The Top Ten Changes In Access 2010
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· How Does The Startup Work When Access 2010 Launches The Northwind Database
· How To Use Referential Integrity In Microsoft Access

Please browse our web site to find out more about
access database course and other Microsoft training courses.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips