Search results

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

Posting on forms because that is the most likely place this font would be used. The issue was raised in this thread https://www.access-programmers.co.uk/forums/threads/trouble-getting-textbox-as-checkbox-to-function.325357/ where it appears font characters have changed. If it was just the OP...

Some time ago Isladogs developed a suggestion of mine for a toggle button - https://www.isladogs.co.uk/on-off-toggle/ This was then taken up by Mike Wolfe and further improved by Steve Halder - https://nolongerset.com/triple-state-modern-on-off-switch/ Problem is, it doesn't work well with a...

At the moment if you want to find some data you write a query. To do so you need to know the table relationships and which field holds the data you are looking for. but on this forum and other forums there is a search option whilst search engines such as Google and bing will take a phrase and...

Attached is a zip file containing 32 and 64bit versions of Access Studio as demonstrated at a number of Access user group meetings over the last few months. It is also available here https://accessusergroups.org/europe/ and also hosted here https://www.isladogs.co.uk/add-ins/index.html The zip...

Thought I would put this up since it is a fairly common topic and I have put it up elsewhere - selecting records from a list for onward processing without the need for a table based tickbox. Similar in concept to the conditional formatting version I provided here...

Attached is a simple form that enables a user to move or resize a control at runtime utilising the mouse events. There are two controls in this example, a textbox and an image control. The code will work with any control that has mousemove events. For the purposes of this example I have applied...