Search results

Can't follow the idea to use the conditional compilation constant `Is365` or `IsM365`... Where does it come from? Is it set by VBA environment automatically (I have no Office 365 to test it myself)? If not, when is it set and based on what?

Some workbook properties can be accessed in a kind on non-early-binding way by using the 'BuiltinDocumentProperties' property of the workbook. Since I don't have a current version of Microsoft Excel I can't test it myself, but you could give this code a try: On Error Resume Next Dim...

Ok, thanks for explanation. I'm not really happy now, but for sure I know why not, now. :-) Have a nice evening. AtzeX

Thanks for your great reply Banana! So if I sort all out, the consequence is: If I want to prevent SQL-injection, I would have to use a parameter query, which unfortunately has a bad performance in many cases. One question I have now: In your sample of a parameter query [/code]you ARE using a...

Hi folks, today I was asking myself if SQL-Injection is a topic for Access (and maybe for linked SQL-Server tables/views). I expect problems for example in the filter-property and when sql-statements are 'glued' together in VBA and finally used as a query: Sample: strSQL = "SELECT Field1...

Ok, this last idea works quite well. But now, during my tries, I found a cool possibility to speedup the refresh of calculated fields: Private Sub Form_Current() Me.Recalc End Sub The calculated form-fields appear simultaneously now with all others. So this seems to be the 'master-way'...

Kind of english humour? :D Ok, the second solution sounds quite nice. Will give it a try. Thanks!

Thanks for reply. Yes, this could be a solution. But for sure much work, if there are multiple of such fields... So this would mean, that there is (still) no other way... What a pity. :(

Hi folks, an every few months recurring question I have is, that I would need a kind of DropDown-Box without a dropdown. :) Or lets call it a DLookup-field. Reason: In a table-field there is a value stored (a '1' for example). In the form now, I want to display the regarding text, which should...

Hi. Thanks for replying. No, it isn't. I wanted to prepare a sample for you, so i spent an hour again. And now i got it. Here is the code: Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long Private Declare Function...

No one? Are my requests so irregular? ;)

Hi. As you know it's not possible to set the "BorderStyle"-property of a form during runtime. But thats a kind of functionality, i need to use in my Access 2003 application. I need to 'simulate' the value "none" during runtime, that means that there is absolutely no frame/border around the...

Nobody else has an idea?

Yes and no. This table-property seems to be only changeable via code. But even then, the forms datasheetview does not change it's behaviour. :-/

Hi out there. Not one did reply? Is it such an unknown topic?

Hi folks. I would need some help with Access 2003. I have a mainform, which contains a subform. The mainform is bound via the recordsource-property to a query. The subform is NOT bound to any recordsource and is NOT 'bound' to the mainform in any way. It is just beeing displayed (i use it for...