Search results

  1. 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...
  2. 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...
  3. 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?
  4. 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...
  5. E

    Mass email downloading

    Hi, I need to download and parse 1000's of emails/day. I don't want to automate outlook for this. A while back I came across several inexpensive 3rd party tools that looked like they might do a good job but can't remember the names/find them. Any suggestions would be appreciated.
Top Bottom