Search results

  1. F

    Installing ODBC driver in code?

    AccessBlaster -- you're right. I'm not sure but I think the standard installs here all let the driver installations be run "as an administrator"... maybe there's a backdoor there I can use... hmm. Ever more questions!
  2. F

    Installing ODBC driver in code?

    Thanks very much! I hadn't thought of just going into the Registry to add it, but that's a very cool idea. This may be just what I needed!
  3. F

    Installing ODBC driver in code?

    That's great -- "just thoughts" exactly what I was looking for! Thanks again for continuing to mull. :)
  4. F

    Installing ODBC driver in code?

    Thanks, that's a great suggestion, but no -- all VBA. The app is just a form with a listbox displaying the DBs available to the logged-in user; they pick one and click the "GO" button. Everything that happens goes on inside that button (and a few general-purpose subs/functions I've included from...
  5. F

    Installing ODBC driver in code?

    Hi all -- have any of you had any experience installing missing drivers on a client machine, using VBA? The Windows 10 disk image used by my IT department does not automatically include SQL Server and/or Oracle ODBC drivers required by my applications. Those drivers may or may not be installed...
  6. F

    Different results-Access 2016 passthrough query vs MSSQL

    Thank you very much, Pat Hartman! I actually have such an app myself, since the back-end links change periodically (from development to production server)... just never knew (or really thought much) about a need to do so for pass-through queries as well. I did a search on your name and...
  7. F

    Different results-Access 2016 passthrough query vs MSSQL

    Thanks, Galaxiom -- but yes, I knew all that about pass-through queries. I did NOT know that they had a connection string which must be properly set to the back end, because pass-through queries (unlike regular Access queries) don't simply rely on the names assigned to tables in the Access front...
  8. F

    Different results-Access 2016 passthrough query vs MSSQL

    I am soooo relieved to report that I now know what the problem was. ("Was" being the key word, lol.) It had nothing at all to do with VBA or, really, with anything else I could imagine. Short version of the critical information: as you all know, a table linked via ODBC has a Connect property...
  9. F

    Different results-Access 2016 passthrough query vs MSSQL

    Thanks to all who responded. I still have no idea why this is happening. I've traced the process line-by-line in the VBA: as Pat Hartman says, copying-and-pasting the SQL code into an MSSQL view's SQL produces X when run, but produces X-1 when run as a passthrough query in Access. I don't...
  10. F

    Different results-Access 2016 passthrough query vs MSSQL

    Thanks, Doc_Man! Unfortunately, when the pass-through query is generated I'm doing exactly that: saving it in a named query. As users tinker with the various filters and sort options available to them, that saved query's .SQL property is constantly being re-written (and saved); therefore, in a...
  11. F

    Different results-Access 2016 passthrough query vs MSSQL

    Yes, thanks DBGuy, that would be the most obvious question. Unfortunately, there's NOTHING special about the one missing, except that it's the most recently added. (When I view the raw underlying table data, it's right where it should be.) I even went back to a development version of the back...
  12. F

    Different results-Access 2016 passthrough query vs MSSQL

    Hello all -- first time this has ever happened to me: I have an Access 2016 front end using data from a SQL Server back end. In Access, I created a passththrough query which returned 859 records. This was one record fewer than expected. So I copied the SQL code to a real SQL Server view...
  13. F

    Form not displaying date/time as explicitly formattd

    No change once I recreated the control. Because I will be going out of town next week and can't solve it immediately, I built a rather ugly workaround: Added another text box (call it NewControl) to the form Set its value to Format([OriginalControl], "mm-dd-yyyy") Repeated the conditional...
  14. F

    Form not displaying date/time as explicitly formattd

    As a quick-and-dirty sanity check, instead of rebuilding that control from scratch, I re-copied the front end from the main distribution server where all users get their copy. No difference: his one PC stubbornly displays that field incorrectly, even though all other users of the same front end...
  15. F

    Form not displaying date/time as explicitly formattd

    That's something good to try, thanks again. I'll give that a shot next time I'm at that computer. (Just saw the "banging head against brick wall" smily. Probably should've employed that by now...)
  16. F

    Form not displaying date/time as explicitly formattd

    Follow-up: deleting the conditional formatting has no effect on the way the field is formatted. (I'd just change it to a properly formatted string if I didn't need to do some calculations with the date.)
  17. F

    Form not displaying date/time as explicitly formattd

    A simple form includes a text box holding a date/time field (on SQL Server back end, if that matters); the format explicitly set in the form design is "mm-dd-yyyy." It works exactly as expected... except on ONE user's computer. (And it only happens on that user's desktop, not his laptop!) On...
  18. F

    Add HTML tags to your rich text

    FWIW, I've done a little experimentation along these lines, if anyone is still following this thread. When you concatenate multiple text fields to make one longer one which is rich text, you can specify their fonts by bracketing them with the deprecated HTML font element. So for instance to...
Top Bottom