Search results

  1. E

    how to make accde file

    Try to do it on another machine having the same Office version Good luck
  2. E

    EVAL function

    Thanks a lot for your answers, I have to wait till our system people get the fix Any way have a nice day
  3. E

    EVAL function

    I want to put these date values in a list box whose RowSourceType is a value list
  4. E

    EVAL function

    in order to evaluate the string value "DateSerial(Year(Date()),Month(Date()),1)" or "DATE()" What else could be used?
  5. E

    EVAL function

    I am using a global type called Order Type Order ID As Integer Name As String SelectQueries() As String ActionQueries() As String ExtraQuery() As String deadDate() As String ResultedTables() As...
  6. E

    EVAL function

    Thanks ridders and June7 I don not have office 2016, we run office 2013 and just updated 2 weeks ago, we still have office 2013 I tested it on a pc of my collage, whos pc was not updated, it functions on his pc but on mine no.
  7. E

    EVAL function

    I have Many orders, every order has a dead date, one or many action queries, reports and so on. I store all these information in a global type Therefroe I have to retreive the date value through the eval function.
  8. E

    EVAL function

    Hello everybody, since 2 weeks we have updated our Microsoft Office 2013 Service Pack 1Access 2013, the update was isuued in 13 March 2018. Anyway, after the update the Function EVAL ("DATE()") does not function any more, get an error number 2426. Before the update it gave today's date...
  9. E

    Create system tray alerts in Access

    Ridders, thanks a lot for your example and including the 64-bit version. Have a nice day.
  10. E

    Create system tray alerts in Access

    Thanks a lot for the nice example, I am wondering whether there is a way to * change the Foregrround /BackGround colors (Black on yellow) of the tray alert window also its * to be able to click the icon in the tray (after disappearing of the alert) to retain the last...
  11. E

    VBA Disable Escape Key (ESC), Interrupting Queries

    Do you use sub forms on your main form?
  12. E

    search button

    You can use the next Function to extend your SQL and call it every time you exit a search box Public Function ExtendSQL(pstrSQL As String, pstrWhere As String, Optional pstrOrderBy As String) As String '----------------------------------------------------------------------- ' Funktion...
  13. E

    Sending keystrokes to a windowless application

    Please search the net for some examples about the API function FindWindow Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
  14. E

    Access minimized to system tray

    I guess you have used API calles
Top Bottom