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

I've renamed one of referenced DLLs (Word) to tempotrarily break refereces on my machine and indeed the control expression enumeration started failing on my machine. Seems there's some code around that goes through References and even repairs them. At least I sohuld be able to capture another...

Thanks fir the file sneuberg. Long story short, code works if I move the test form with a barebones table into your database. your form i.imgur.com/B1NDtvC.pngmy form i.imgur.com/WGqdWNd.pngyour dependancies i.imgur.com/kBuAkRw.pngmy dependancies i.imgur.com/SgH5Jyt.pngUgh, this is going to be...

I've tried changing my regional settings to use comma instead of dot, but that didn't produce the #Name? error. If trying to use semicolon in the expression, I get a message that the syntax is incorrect, it accepts only the colon for me. The expressions are entered directly into textbox's...

Hi, I've saved .accde on the machine used for developing the .accdb I have Access 2016 and 2010 on this machine and the expressions resolve fine in either version, both as .accdb and .accde Of two people I've asked to try the .accde (both installed Access 2016 runtime version), who have German...

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

Thanks for sharing, sneuberg. You've pointed me in the right direction, also your approach will be useful to me in the future ^^ I'll return the favour and hopefully you'll find these useful as well. Injecting using Range Set doc = appWord.Documents.Open(document.docx, , True) Dim rawrnge As...

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

Hmm, this might work, but I'm still devastated about the continuous form/subform limitations :/ The problems I would face are (my brain is dead atm, so these might be trivial): 1) Preventing the main form from displaying scrollbars if the extra controls that are hidden and not hold data are...

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

Ahh, thank you, placing the variable in brackets is one thing I've forgotten to try. The code resolves if cycling through textbox names as follows: Sub DoSomething() Dim i As Integer Dim counter1 As String For i = 1 To 5 counter1 = "txtBox_" & CStr(i) Debug.Print...

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