Search results

Looping the properties of the current db and showing the type value and the name of that type. If the value of the property exists show that too. ---- DAO Properties of CurrentDb ---- Name: Name Type: 12 (Memo/Long Text) Value: C:\\Downloads\dashboard_raptorraptur.accdb Name: Connect Type...

It is the Data Type of the property you are creating. This property is a string (name of the form) so it is text. But these constants are used throughout the DAO model. So these are also used for things like fields and defines their data type.

I would rephrase that because you said it backwards. Properties of the object model are a subset of those in the properties collection not the other way around. So in some cases you can only reference a property through the properties collection "myDb.Properties("propertyName"), while other...

To be clear the Properties of the object are a subset of the properties of properties collection. That means certain properties will never show in the object browser. Also means you have to call them through the properties collection and not the object. So properties of the object can be...

Here is a demo of using the Temp Table idea to create a columnar form. It allows you to filter products and show the results in columns https://www.access-programmers.co.uk/forums/threads/access-product-catalogue-website-style.333196/post-1949643 This would work better than an pure unbound form...

That is because many properties do not exist until you add a value. That is not saying that the property has a null value, but that the property does not even exist. You can see a demo here where the props do not exist until you add a value in the GUI...

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