[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Expand Collapse Forms API or Active X?

Posted on 2007-10-01
6
Medium Priority
?
319 Views
Last Modified: 2013-11-18
Dear Experts,

Windows XP Pro
Access 2003 Pro SP3

I am looking for an API or active X that can I use in a Form, where I can expand  Collapse, use icons and enter description of each item

This URL shows some samples that my client wants in his form

http://www.jedikeeper.com/rebelscum0000/windows_screen.htm
 
I did a search at Google and I found several Active X most or them for .NET

http://www.windowscontrols.com/treeocx.html

http://www.ssware.com/fldrview.htm

They are very expensive, my client I am sure he will not paid for these Active X, and I sure I am not going to need for further databases.

In a few words as always I am lost

Can someone please help?

TIA

Regards,
Antonio Macias
0
Comment
Question by:rebelscum0000
  • 3
  • 3
6 Comments
 
LVL 14

Expert Comment

by:ragoran
ID: 19993492
You could use a regular MS Treeview, with Fixed font and count spaces and characters to simulate columns.  You can add icons, and descriptions, but editing directly into the treeview will be cumbersome.  You could have a subform that you synch with the treeview: when the user click on a node, the subform goes to that record.  In the subform if the user edits the description, then the subform refreshes the selected node description.

It involves a lot of code, but I did that on a previous project.  Not perfect, but you don't have the buy an OCX control.  Although if your client is paying your time to code this, it may be more expensive...
0
 

Author Comment

by:rebelscum0000
ID: 19994272
Dear ragoran,

I have intermediate skills of Access, in fact I am silk screen printer but I love visual basic programming, my client is not paying extra for my time to code this like in the USA, here in Mexico we quote for project, suddenly my client wants this into his database when we were finished this project, also I want to learn more. Is possible to learn from your previous project? As mdb

Please let me know

Thank in advance
Regards,
Antonio Macias
0
 
LVL 14

Accepted Solution

by:
ragoran earned 2000 total points
ID: 19998303
Antonio,

This involved 300-400 lines of code and is larger than intended as solution to Experts-Exchange questions.  I can't post the project as is because 1) it was a very large application and 2) more importantly, it was on previous job so I don't have the source code with me anymore.  

As for your comments on project, we too are sometimes doing "fix cost" project.  But we then define the scope of the project and if the client ask for more, then there will be a change request.  If not, you have just give your client a blank check...

If you have to put this in place, I will consider buying the OCX yourself as it will save you hours of coding and testing. Better pay a little money and be done with it.  BTW, most OCX comes with a licence for developpers to include a "free run time" version of the control in the applications they distribute to their clients. So you keep the OCX for other projects, you save many hours not reinventing the wheel, and our client is very happy....

My opinion anyway.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:rebelscum0000
ID: 20008397
Sir, I agree with you.
Now wich OCX should I buy, any suggestion?

TIA

Regards,
Antonio
0
 
LVL 14

Expert Comment

by:ragoran
ID: 20009275
Maybe other experts may want to jump in. Since I don't personally have any experience with such OCX, I can't recommend one more than the other.

0
 

Author Comment

by:rebelscum0000
ID: 20009314
repeat the question
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question