Recent content by MajP

I only know what you did because the first time I did it I too thought something was broken and took a long time to figure it out..

You cans size the columns and size the whole window. So it looks that you did is the following 1. Normal window 2. You can expand the columns. So the label of the property is bigger. 3. Now you can slid the whole properties window to the right and you lose ability to see the second column with...

Yes it is not editable until you double click. before when just scrolling none of the fields are editable until you hit the edit button But if you double click it goes straight to the edit mode.

It is a good tool but not a panacea. If the code project is completely corrupted then you are likely out of luck. This technique is good when the database still opens, but you cannot open or use a specific form or report. Most of the time a decompile and recompile will work, but in a few cases...

FYI the SaveAsText loadFromText is one of the best, and at times the only method to fix database corruption caused by corrupt objects (not at the table level). Keep that code in your toolkit.

I think that is purposeful. When you double click it puts it into edit mode on the left. You need to hit save or cancel.

Yes the icon idea is not new. In the link I provided @CJ_London demos how to create those. That coloring for a listbox using that technique is pretty limited as the link demos. You are better off asking Chat to redesign this with a continuous form instead of a listbox. That will give you far...

No that is not what George said. The autonumber will reflect the "sequence in which the rows were inserted", but the order in which they were inserted may not be the order in which they should have been entered. They could get entered out of order. So this is not a solution to his example. He...

I am not sure if this is much new here. Here are several examples of doing the same thing from different people that use a listbox to fake a treeview. @CJ_London proposes another interesting approach using an ADO recordset and continuous form. There are many others out there...

As I pointed out it is unclear, but it appears that the OP wants the record with the greatest ID not the value of the greatest ID

you can use the Top X predicate Select Top 1 * from sometable order by ContactID Desc This returns the last record. You could query on the max Select * from someTable where ContactID = dmax("ContactID","SomeTable") But you ask 2 different things. You want the most recent record Or do you...

I looked at the example and it is acting as expected. It needs a line of code to make it work. If you need this solution then you can simply do a full load and it will work. If you need a solution that allows you to do a light load but still mark all descendants then simply modify the code to...

That would do it because in the light load not all the descendants are loaded. Only enough to show the expander icons. So that is just offspring for that visible level. I could write additional code to check and overcome this condition. It would first expand all levels below the selected...

Assuming you do not always have equal groups you would want to make sure that employee x is not always getting the remainder so you would want to assign them each time in a different order. Public Sub AssignRandom() Dim EmployeeCount As Integer Dim CityCount As Integer Dim...

Are you open to a code suggestion where you push the results into a temp table. The reason is you can do a query that pulls a random number between 1 and N, but that will assign the assignments randomly, but not ensure that the groups are as equal as possible. They may be close to equal but not...