Search results

I went to a very interesting presentation yesterday on the subject. The focus of the talk was on creating a digital twin of Blenheim Palace. The concept is to digitise every aspect of the palace, gardens and other properties, the estate (circa 12500 acres), power consumption, type and quality...

Any advice appreciated. My client asked me to add in some additional reporting facilities to an excel file and not to use macro's. Basically, the requirement was to click on a value to display the records that relate to that value (easy in Access, not so easy in excel). I used the excel LET...

It needs further development to meet specific requirements but ChatGPT came up with this as a basic editor. Thought I'd share it in this forum. To use, unzip and modify the path in the edge browser controlsource to wherever you put the html file

Copying and pasting a table or query to a post looks as expected until you save it - then its all code and unreadable. e.g. I copy/paste: but go to preview or save and it looks like this: what an I missing? Query1 PricesOrderedFromFK PricesQuantity RegisteredOn PricesRegisteredBy...

I have an app which creates an Access instance and populates it with another db that the user selects for analysis. Even if I do nothing and then close the instance it remains in memory. It was reported as a bug about 3 years ago (although that seems to be more about closing access in general...

I'm using a sub in ms Access to open an instance of Excel, which in turn opens a csv file. It then manages the data into a standard format (delete header rows, calculate some columns and change the sort order) to then save as a csv file for subsequent upload into an Access table. The files are...

Does anyone know if it is possible to download purchase invoices from Amazon to be stored in a windows folder? I found this link https://developer-docs.amazon.com/sp-api/reference/getinvoicesdocument so looks like it is possible - a two stage process to get the document ID's (for a given...

Using win11, Access 365 64bit I have this simple bit of code: Function setReconciled() Dim PT As POINTAPI GetCursorPos PT Set YNctl = Me.accHitTest(PT.X, PT.Y) End Function Which has worked fine for many years, but I've discovered the above error can be generated in certain...

I know how to query outlook using sql to return emails in an outlook folder. One of the fields returned is a boolean to indicate whether the email has attachments. I also know how to get the attachment names (and the files if required) via the outlook object, but wondered if there is a sql way...

The snipping tool serves me well but is let down by its drawing capabilities - all freehand and no ability to draw boxes or circles. Had a look at snip & sketch but doesn't seem to have any additional features. Lots of apps out there, some free, some subscription - does anyone have any...

Unlike the msgbox, the inputbox has X & Y parameters to position the box where you want - in twips from top/left of the screen This can be useful for being able to open the inputbox close to the current position of the cursor or a standard position such as top left of the screen However it...

There have been a few recent posts about msgboxes, so I thought I would share what I use. Unlike inputboxes the msgbox does not have parameters to specify the top/left position - typically a msgbox appears mid screen and often well away from where the user is actually working. The problem is a...

I needed a means to quickly view boolean values in a combo or listbox (I didn't want to use a subform). However since these lists are text, checkboxes cannot be shown, instead you get true/false. However with a small modification to the recordsource, you can get checkboxes Better still, with...

Taking my inspiration from this thread concerning buttons on a continuous form https://www.access-programmers.co.uk/forums/threads/button-visible-invisible-in-a-continuous-form.281824/page-2#post-1909317 I investigated what else could be done with the paint function since conditional formatting...

There is no doubt that enforcing referential integrity (a child record cannot exist without a parent record) is a good thing to do, But the blanket statement that a design is not good because you cannot enforce RI is not always true. You can have a child record providing the parentFK is null...

I have a need to use a scrollbar that has events - and the built in one doesn't generate an event. I can use the form mousewheel event but users typically like to use a scrollbar for moving rapidly from top to bottom. I can get the form2 scrollbar to work, but I can't see how to associate the...

Thought I would just put up this simple example for FAYT for a combo on a continuous form/datasheet. It is based on a similar principle to the cascading combo examples for continuous forms/datasheets I have provided in the past. It involves using the combo change event to apply a 'Like'...

As a result of this post https://www.access-programmers.co.uk/forums/threads/emulate-reports-grouping-levels-with-forms.326697/ I thought I would diddle around and come up with some examples. This is a simple format - only shows the customer once and uses conditional formatting to change the...

I have a need to display a variety of file types on a form - pdfs and html can be displayed in a web browser control and images in an image control for example At the moment I need to manually open a (MS Outlook) .msg file then save as htm to display the msg in a web browser, but I would prefer...

I'm trying to create a routine to list all the properties and values used by commandbarcontrols (there are 5 types of control, many common properties and some unique to certain types. In total around 44 properties) in a commandbar. Unfortunately commandbarcontrols don't have a properties...