Recent content by MajP

One thing that may be challenging for your design is what you want to do when selecting a Service Item. Like all the other combo you want to show a descriptive item name and store the temID. But you have a category which suggests that list could be very long. So there are several things you...

If not familiar here is a good video

One thing that has been said here is that First() and Last() will return the first record added or the last record added. That is definitely not true and not guaranteed. You might get lucky, but likely you may not. So you cannot count on these and therefore they should never be used for...

If not familiar with using sql here is the designer.

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...