Recent content by antifashionpimp

  1. A

    Bypass entering password to ODBC data sources

    Hi everyone, I was hoping somebody could assist me in this issue. I am quite a newbie to ODBC connections and was struggling to search for related topics. Here is my situation: I have a Access 2000 .mdb file which has several linked tables to a ODBC data source, namely an Oracle back-end. I...
  2. A

    Slow query using a global variable

    I gave it a go with referencing the form's controls, and it showed an improvement. Thanks!
  3. A

    Excel Automation: I am confused

    Hi all, I have a problem automating an Excel object from Access. I have the following fucntion that creates a table in Excel from an Access query: Function CreateTable2(strSourceName As String, _ strFileName As String) As Variant Dim xlApp As Excel.Application Dim xlWrkbk As...
  4. A

    Slow query using a global variable

    Hi, So you are saying that if I get the variables directly from the forms controls, like you suggested, and do away with the functions, the query might even be faster? Regards, J
  5. A

    Slow query using a global variable

    Thanks for your help, Pat I got a suggestion from someone: add return types for my functions. This seemed to elude me from the start. :p It works much faster now.
  6. A

    Slow query using a global variable

    Hello, I have the following query that I set up as a test, and it runs fine: SELECT STATUSHISTORIE.* FROM STATUSHISTORIE LEFT JOIN PROBLEM_DE ON STATUSHISTORIE.PROBLEM_ID = PROBLEM_DE.PROBLEMNR WHERE (((STATUSHISTORIE.STATUSDATUM)<#1/1/2005#) AND ((PROBLEM_DE.DATENBEREICH)='SPMO') AND...
  7. A

    Query: Count (amount of (xDates later than GivenDate))

    Hello all, I have the following data (Note: dates in dd-mm-yyyy format) ID DEPT TARGET70 TARGET90 TARGET100 -- ---- -------- -------- --------- 12 ACCT 12/06/2005 31/07/2005 21/12/2005 14 MKT 30/08/2005 02/09/2005 11/04/2006 19 ACCT 13/04/2004...
  8. A

    SELECT clause with LAST function causing problems

    Thanks guys, I used the MAX function in the end, and it works. Much more clearer than the LAST function Regards, J
  9. A

    SELECT clause with LAST function causing problems

    Hello all, I have the following data, that was queried and sorted to columns PROBLEM_ID and then by STATUSDATE (ascending): STATUS_ID STATUSDATE PROBLEM_ID --------- ---------- ---------- 10________12/04/2005___1234 40________15/05/2005___1234 10________11/11/2004___1235...
  10. A

    Two lists: "Available" and "Selected"

    Thanks John, nifty download I willl give it a go! J
  11. A

    Two lists: "Available" and "Selected"

    Hi Could someone please point me in the right direction? I am looking for a control (or a was to implement the functionality) of something that is used in Windows. I dont know what the correct term is for this control, but it looks like this. It allows you to select items from an "Available"...
  12. A

    Exporting query data to Excel and hyphen character

    Found the solution: INT(Nz([qryAbtGruppenProblemSumme_MaTerminÜber].[ANZPROBPUNKTEMASSUEBER],0)) AS ANZPROBPUNKTEMASSUEBER changes the format to Integer
  13. A

    Exporting query data to Excel and hyphen character

    OK, now I am stuck again: The following query is causing the problem: SELECT qryAbtGruppenProblemSumme.ABTGRUPPE, qryAbtGruppenProblemSumme.ANZPROBPUNKTE, Nz([qryAbtGruppenProblemSumme_MaTerminÜber].[ANZPROBPUNKTEMASSUEBER],0) AS ANZPROBPUNKTEMASSUEBER FROM qryAbtGruppenProblemSumme LEFT JOIN...
  14. A

    Exporting query data to Excel and hyphen character

    I actually had a look here, and this has given me a tip. :)
  15. A

    Exporting query data to Excel and hyphen character

    Hello all, I have always been wondering why this happens, and now I have a problem with it. When I export a Table/Query from Access to Excel (be it with Right CLick -> Export...or TransferSpreadsheet) there is an apostrophe character (') appended to the front of some/each cell in Excel. You...
See more
Back
Top Bottom