Search results

Hi, I need a single SQL query string so that I can use it as a Graph's RowSource in my VBA code. My SQL query combines two sub-Queries: 1) data 2) SQL-calculations performed on that data (Please don't judge me for doing it this way :) ). Queries 1 and 2 work separately, if I refer to Query1 as...

Hi, For a while now I've been researching for a way to precisely capture Form resizing (to do actions when user starts or finishes resizing). I know of the workaround with Form_Resize() and Form_Timer(), but I'm not a fan of looping events at 100-200ms intervals to capture resizing status of a...

Hi, I have encountered a problem where my expressions for a text box work out just fine on my machine, but fail (mostly) on a friend's machine. There are two differences between our machines: 1) Friend has German version of Windows and German (I think?) Access2016 runtime 2) Friend has a runtime...

Hi, I'm trying to insert a RichText field into a Word document at bookmark by first exporting the field contents into a temp HTML file and then inserting the HTML file into Word. The export to HTML works, Access opening Word document and finding the Bookmark works, but what doesn't work is...

Hi, I'm trying to design a planner/weekly calendar form that shows items assigned to several people for each day on one screen. Here's a schema of how I want to arrange this: i63.tinypic.com/2reigzs.png So far I've created a working concept up to PersonA, but can't figure out how to display...

Hi, I'm trying to reference to a control on a form or subform, that has a part of it's name variable, ie it is named txtBox1, txtBox2, or on a subform control subForm1, subForm2, subForm3... I have trouble injecting the variable part of the address into the string. For example: Sub...