Search results

  1. B

    Column data missing from Excel export.

    Hi, i am using the code below to export a Query to Excel ... Dim sSQL as String sSQL = "qry_CustomerDataIO_EncompassSiteTemplate" DoCmd.TransferSpreadsheet acExport, , sSQL, exportFilePath, False ... the problem is that on just 1 particular PC (out of 12), the 1st column does not get populated...
  2. B

    Question Ieee 829 ?

    Hi, does anyone have a sample .mdb that can store software Test Cases in a suitable format to conform to the IEEE 829 Standard ?. Many thanks. Mark. mark.davies@rwe.com
  3. B

    Colour Code rows in subform datasheet ?

    Hi , is it possible to colourcode rows in a subform datasheet based upon them being higher / lower than the previous row ? ... Subform datasheet has, e.g. Row1 £12.50 Row2 £10.25 Row3 £15.50 So, i would want Row2 to be Red because it is less than Row1 value, but then Row3 to be Green because...
  4. B

    PSION Links ?

    Hi, does anyone know if / how it's possible to download data from a Psion Organiser into an MS Access database ?. I presume i will need to link the Psion to PC, download the Psion data (in ? format. .txt / .scv ?) and then load it into Access tables ?. Any ideas most appreciated.
  5. B

    SQL Syntax Error ?

    Hi , i'm trying to execute the following ... DoCmd.RunSQL "UPDATE tbl_Sites RIGHT JOIN (qry_ExportCARLock_DCDA INNER JOIN tbl_MPANs ON qry_ExportCARLock_DCDA.MPANCore = tbl_MPANs.MPANCore) ON tbl_Sites.SiteRef = tbl_MPANs.SiteRef SET [tbl_Sites].[CALock_DCDA] = Now();" and am getting the error...
  6. B

    Advanced DLookup ?

    Hi, i am using the following DLookup in the On_Load() event of my form :- txtNextBillDue = DLookup("[NextBillDue]", "[tbl_BillitReportHistory]", "[SiteRef]='" & Forms![frm_Site]![AccountNo] & "'") It works fine but the problem is that there are multiple values for the "NextBillDue" result...
Back
Top Bottom