Recent content by expat1000

  1. E

    Solved Syntax Error while updating

    Hi - the link for SqlDebugPrint is not working for me.
  2. E

    Access going away?

    I know who you mean. I've the utmost respect for the cleverness and capability of all the Access MVPs but holy cow, to recreate the forms for even a moderately complex Access database in PHP seems like it would be a very complex and time consuming task to me.
  3. E

    Not getting error msg on failed insert query

    OK. That's got it - sort of. I get a generic error "ODBC--call failed" - better than nothing! Thank you.
  4. E

    Not getting error msg on failed insert query

    I think the dbSeeChanges is required. This gives me argument error qry.Execute dbSeeChanges, dbFailOnError
  5. E

    Not getting error msg on failed insert query

    Access FE, SQL Server BE. I run a simple insert query in Access in the GUI. A no dup index on two fields in the table rejects it with an error message as it should. However Set qry = CurrentDb.QueryDefs("query2") qry.Execute dbSeeChanges also fails but without an error being displayed so I...
  6. E

    time count

    Old post and code but I just want to say it works perfectly for me. Way better than a form timer.
  7. E

    Updateable query problem.

    Hi, This list https://stackoverflow.com/questions/24267398/why-is-my-query-not-updateable The table is updateable in Access, including that specific field. Also, I append to it from ztWebRelay in another query without any problems so I'm leaning to thinking it has to be in the join but can't...
  8. E

    Updateable query problem.

    I've been through the list of potential reasons for a query being non-updateable. I cannot spot any reason. UPDATE twebrelay INNER JOIN ztWebRelay ON twebrelay.WebRelayID = ztWebRelay.SerialNo SET twebrelay.CBWIdentifier = [ztWebRelay].[CBWID]; twebrelay: Linked ODBC SQL Server table has...
  9. E

    cbo displays yes/no not checkbox

    Not exactly. You've built a subform with a combobox on top, yeah? It's cool, but would take too much time and would be more complex than I want. This was more something I just wanted to know if it could be done or not - I can work around it for this particular form with command buttons
  10. E

    cbo displays yes/no not checkbox

    I want a checkbox on his cbo not yes/no (see checkbox4 for the way it is displaying). Is it possible the problem is the cbo is unbound?
  11. E

    Import SpreadSheet Specification

    For anyone else searching on this.. DoCmd.RunSavedImportExport but the import file name has to be static - can't change it runtime.
  12. E

    SQL help on syntax

    I should have caught that. That works. Thanks, all!
  13. E

    SQL help on syntax

    There is no driver.ProNO field, nor any ProNO field in the source. Using tload.pro_no gives this error. Note I ran the calling code with simpler criteria. Syntax error (missing operator) in query expression 'PKDATE Between #03/02/2014# And #04/30/2014# AND & InStr(tload.PRO_NO, '.') = 0
  14. E

    SQL help on syntax

    Thanks, but no. Just a typo. The quoting I used is clearly wrong. I just don't know what is right.
  15. E

    SQL help on syntax

    Hi, I'm setting query SQL dynamically from a search form. Typical output is like this: qry.SQL = "SELECT DISTINCT dpay.PRO_NO, dpay.PKDATE, dpay.FROM, dpay.DPDATE, dpay.TO, dpay.DHMILE, dpay.LDMILE, dpay.MITOT, dpay.STOPTOT, dpay.UNLOAD, dpay.HOURS," & _ "dpay.HRTOT...
See more
Top Bottom