Recent content by jflachman

Bizarre but I had to reboot my computer for something else and the issue totally went away. It wasn't the code. It must have been some weird MS Excel bug. Jonathan ________________________________________ It is not fair to ask of others what you are unwilling to do yourself. -Eleanor Roosevelt

Excel 2007 before and after the HD reformat. There are three buttons in the sheet with different functions. The behavior is the same with all three buttons. There is no overlap in code. One only adds fill color to various rows in the sheet (not where the button resides) depending on the...

I created a button with a VBA routine tied to it. The button has always worked perfectly. However, now when I click on the button, the button font size increases. The routine does execute also. If I click again, the font size continues to increase until I can no longer read the text. I am not...

I clearly didn't provide sufficient information to make this easy to answer. I'll try again. The Layer field is the number of layers down in the resource tree. i.e. Paul is the boss, so he is Layer 1 Bill, John and Thom report to Paul, so they are Layer 2, etc. The TreeID field is required...

I need to create a resource tree / org chart. I have a table Resources --------------------------------------------------- ResID Name MgrID Layer TreeID 1 Bill 2 2 Paul 0 3 Mary 4 4 John 2 5 Thom 2 6 Carl 4...

I don't seem to be able to set the filter or filteron properties in VB for a subreport. I have tried doing it in the parent report Open event, the parent report Detail section format event and the child report Open event. In all cases I get a Run-time Error 2101 - The setting you entered isn't...

There were three steps to my solution: 1) Turn off the autocorrect option in Tools/Options/General 2) In the Backend file, set the subdatasheet property to [none]. This required step 1 in order to work. 3) Use a UNC file path rather than a mapped network drive for the location of the backend...

I am trying to chagne the subdatasheet property in the backend mdb. It still doesn't stick. Some additional info: - If I put the backend on my desktop, it works fine - When the BE is on the network, my network bandwidth is still < 10-20% and my MSACCESS cpu utilization is < 10% Jonathan...

The performance on my database is so bad it is unusable. I have a small database - It has 9 tables and very little data because it is still under development. The database is split into a front end and back end. The back end is on the network, the front end is on my desktop. When I try to...

All, Thanks for the suggestions. I used a recursive subroutine to fill a temporary table with the NodeID, ResourceID and layer. I then join that with the Resource table to pull in a the rest of the data in a query and dump that recordset into the report. J Jonathan...

lbigk and annie420, I had started down that path and ran into a critical problem. It groups each layer independently. So all VPs, followed by all Directors, then Managers, then Workers. MajP, The TreeView won't work because of the quantity of additional information I need to display...

I have a table with a structure that can be simplified to: Resource ID Autonumber Name, etc Multiple fields Manager ID Number (long) The manager ID is a link to another record in the same table. That person may also have a manager and so on. I want to write a report that...

You do actually have a 1 to 1 relationship amongst your tables. You have One order in your TblOrders table and One Note in one of your notes fields that are connected. The way you have this database structured is fine. However, to make it work smoothly will require some automation that may be...

vbCrLf just adds a Carriage Return and Line Feed at the end of the text string. The first one starts a new line. The second one starts ANOTHER new line immediately, hence the first one is blank. Jonathan ________________________________________ It is not fair to ask of others what you are...

In Microsoft Excel, you can create a XY scatterplot with a column of X data for each column of Y data. This is especially useful when the various columns of Y data are taken at different X values. I need to graph some test data. The X axis is Frequency, the Y axis will be distance. Each test...