Search results

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

The reason I'm asking is that I've was told many years ago when first setting out on the Access learning curve that they apply a filter and reviewing a number of posts on this forum, many others think the same thing. Typically 'as a demonstration remove these properties and all the records are...

I developed this because datasheets have some useful functionality, but limitations as well - among them Datasheets can't show controls such as buttons, images, attachments, etc Datasheets can't show a record over multiple rows within the detail section Datasheets don't have header and footer...

You can use the mousemove event to detect whether the mouse is over a specific control, but you can't tell when it is no longer over the control without using a mousemove or other event such as click from another control or perhaps the section background. But move the mouse quick enough and that...

I'm experimenting with data macros and want to insert into a history table the newly changed record. In real life, the history table is in a remote database which cannot be accessed using a data macro so calling a vba function seems the way to go. Since I'm still in testing mode, I have set up a...

I cdnuolt blveiee taht I cluod aulaclty uesdnatnrd waht I was rdanieg. The phaonmneal pweor of the hmuan mnid Aoccdrnig to rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoatnt tihng is taht the first and last ltteer be in the rghit...

preamble: this is extracted and tweaked from a report I provide to a client. Because every app is different, it is more about WHAT you can do rather than HOW. Please don't respond to this thread asking HOW, start your own thread and reference this one if necessary. However will be happy for...