Recent content by davidcie

  1. D

    Spurious 'SELECT [Id] FROM [Table]'

    Well, sorry to spam but after writing all the above I had a hunch I could try re-writing the query and... voila, we have a solution to the problem. Basically you have to enclose the GUID in quotes rather than use the Access-specific {guid {}} notation – even though I came across errors before...
  2. D

    Spurious 'SELECT [Id] FROM [Table]'

    Thank you for your input, I'd love to get to the bottom of this. After some more testing it seems that GUIDs appear to be the source of my problems. I've prepared a simple test case with the same customer data stored in two tables: one with uniqueidentifier as the primary key, and second one...
  3. D

    Spurious 'SELECT [Id] FROM [Table]'

    In converting another monolithic app to Access UI + SQL Server backend and trying to squeeze as much performance out of them both as possible, I noticed a weird Access thing when accessing a linked table: even if a particular query has a WHERE clause limiting the resultset by primary key value...
  4. D

    How To Distinguish Odbc Errors From Other Types In Form_Error

    Trouble is that these are generic error messages, in essence "Something went wrong". If you're trying to debug a more serious frontend<->backend communication error (eg. a validated constratint, foreign key relationship) you need the full ODBC error message that contains actual SQL Server's...
  5. D

    How To Distinguish Odbc Errors From Other Types In Form_Error

    Let me humbly add that I think Tom's solution is the only real complete solution if you are unable or unwilling to log errors database side (using SQL Server here) and, once you get used to looking at Win32 API code, it's not as hacky as it looks at first blush. Secondly and to deal with the...
  6. D

    change hyperlink color

    I know it's been twelve years since the OP but people like me will occasionally stumble across this looking for answers so please forgive me for resurrecting – hopefully will be useful to someone down the line. What I wanted to add is that conditional formatting seems to override whatever's...
  7. D

    AllControlsLoaded event?

    @theDBguy I have indeed, the trouble with the document is does not go into great detail on more complex arrangements. @MajP thank you for your useful thoughts. In particular I like the idea of loading subforms in a manual, controlled manner once the main form is up and running by setting source...
  8. D

    AllControlsLoaded event?

    I have a bit of a convoluted design which I will try to explain as best as I can so bear with me. There is a full-screen form whose source is set to "Orders" (let's call it frmOrders). On it there's a few controls with order details and (1) a small continuous subform that displays a...
  9. D

    Sum in Footer on Form with ADO Recordset

    This is exactly where I'm coming from - we use a lot of detached ADO recordsets that are results of queries run on a centralized SQL Server in a multi-user environment. Thought the crashes might stem from something really strange we're doing on the database front and hence the test case to...
  10. D

    Sum in Footer on Form with ADO Recordset

    Thanks for letting us know! Great to have some closure regarding your experience, unfortunate as it may be :) No, I'm on the latest and greatest Access 2016, .accdb. More than happy to share a test case, please find it attached to this post. What bugs me about this issue is that we don't seem...
  11. D

    Sum in Footer on Form with ADO Recordset

    (Apologies for raising an old thread from the grave but seems like I'm having the exact same problem; considered it wise to continue with prior wisdom and report.) @Glaxiom I realise it's been a while but do you perhaps recall if you've ever managed to find a solution to this problem? In my...
  12. D

    Thanks for being here!

    Have used this forum for reference a countless number of times and have to say this is the most professional and helpful Access related forum I've come across so far. None of the "please try to reboot your computer maybe this will help" rubbish like in many other places! So I'd like to thank...
Top Bottom