Recent content by MajP

Now I reread the thread and of course this was covered, and in fact it was me. I would not resurrect this thread because this is one of the stupidest threads I have ever read. The OP seemed to be trolling.

Bookmarks are recordset specific pointers so if you requery those bookmarks are invalid. So that error is expected and guaranteed. I did not read the entire 3 year old thread but assume this is fully covered. On easy way is to first save the primary key of the current record, then requery...

I did not look at your solution yet but some ActiveX controls support this Post in thread 'File Attachement Field' https://www.access-programmers.co.uk/forums/threads/file-attachement-field.334511/post-1972302

FYI, I have tried to put as many Calendars and date pickers into one thread. I will add these new ones. @Peter Hibbs . Yours has been referenced directly in that thread already. If the version is different I will replace with this one...

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