Search results

  1. L

    Problem with Access 2003 application with runtime on win 10 access 2016

    Thanks. The shortcut does not work because the program starts with .exe file. Thank you.
  2. L

    Problem with Access 2003 application with runtime on win 10 access 2016

    Thank you for the reply. The application works fine but it opens under the access window and all the menus go under the add-ins. Dear Minty, you replied that "You may need to point the application to use the runtime or create a specific shortcut that achieves that." How do I do that?? Thanks
  3. L

    Problem with Access 2003 application with runtime on win 10 access 2016

    Hello there, I have an accounting software which I bought many years ago, developed under Access 2003. It comes with Access runtime. It works fine on a computer which has no access or access 2003. Now I tried to install it on a computer with win 10 and access 2016. When I run the program, it...
  4. L

    Strange! Getting error 2486 when function is called from a query ???

    Hi guys, I tried what CRONK suggested and voila!!! it works like a charm. Thank you so much. GOD bless.
  5. L

    Strange! Getting error 2486 when function is called from a query ???

    Thank you all for the replies. I tried DoEvents and declaring "Function Sales_Values(code as string) as double " but it did not work. The problem starts at the first record. There are say 20 records in the table for now. I did this method several times with no problem. I explained in the...
  6. L

    Strange! Getting error 2486 when function is called from a query ???

    Thanks for the reply. The query is not open. The function works when called from a form or ... I need the result of Sales_Query_2 which needs Sales_Query_1. Query one has a parameter (Account Code) which changes every time, that's why I need to create it each time.
  7. L

    Strange! Getting error 2486 when function is called from a query ???

    Hi there, I have an annoying problem and hope someone could help me. I created a function which deletes a query and then creates a new one with CreateQueryDef. When I use this function from the immediate window, it works perfectly with no error. But when I call this function from a field in a...
  8. L

    Disable and Enable custom Menu items

    thank you
  9. L

    Disable and Enable custom Menu items

    Thank you for the replies. I created a custom menu (attached a sample). I need to disable some of the items for some users. In my application many users can be registered by the admin, each one with their password. I need to specify which user can have access to which menu according to their...
  10. L

    Disable and Enable custom Menu items

    Hi there, I created a menu for my application in Access 2003. I need to disable some of the menu items for some users. Can anyone help me? Thanks
  11. L

    Access 2016 - api functions

    Thank you so much. I will try it. Cheers
  12. L

    Access 2016 - api functions

    Many thanks. I attached a pdf file. I hope it's clear. Thanks again
  13. L

    Access 2016 - api functions

    Thanks so much. I tried your suggestion and it works fine for a text box on a form but when I use it on a sub form .... There is a sub form on the main form. There is a field in the sub form which I need to put the code on it's double click event. When I do that the co-ordinates of the...
  14. L

    Access 2016 - api functions

    Thanks so much. I will try your suggestion. It's appears to be much simpler. Thanks again. Cheers
  15. L

    Access 2016 - api functions

    Thanks. I can not use simple move method. If a text box (anywhere on the form) is double clicked, a specific form must be opened exactly below that text box. The co-ordinates of the text box relative to the screen is needed (not relative to the form). My code works fine for access 2003 and...
  16. L

    Access 2016 - api functions

    Hello, Thanks for the replies. My code works in one computer with Win10, access 2016 but I have this problem in another computer. My code is calculating the co-ordinates of a text box and moves a form there like a DatePicker. Dim hDC As LongLong, lngRetVal As LongLong hDC =...
  17. L

    Access 2016 - api functions

    Hello there, Many thanks for the replies. I changed all the LongPtr to LongLong and error disappeared BUT... At the beginning of my code I used these functions : hDC = apiGetDC(hWndAccessApp) XPIXELSPERINCH = apiGetDeviceCaps(hDC, LOGPIXELSX) YPIXELSPERINCH = apiGetDeviceCaps(hDC...
  18. L

    Access 2016 - api functions

    Yes. It works fine without error in one computer (Win10, Access 2016). On another computer with Win10 and Access 2016 gives me this "Type mismatch error"???
  19. L

    Access 2016 - api functions

    Hello there, I have used Windows API functions in access 2016 on Windows 10. I used the correct format for 64bit. It works fine in one computer but gives me "Type mismatch error" on another computer with Windows 10 and also Access 2016? Any help would be appreciated. Thanks a lot.
  20. L

    After_update problem

    Thank you all. I solved the problem with Me.refresh and also I changed the code procedure to a specific field "lost focus". It works like a charm. Cheers
Top Bottom