Search results

  1. S

    Filtering a query using a variable

    Hi I'm always trying to use the english expression with thoose problem You describe as a fact. Well it is as it is...
  2. S

    Filtering a query using a variable

    Hi thanks for Your effort... Gasman solved this a bit easier this time
  3. S

    Filtering a query using a variable

    Hi ! First sorry for my late respons... As You alredy has notice, "Formulär" is a swedish translation for "forms". Its rather stupid of access to make country versions.... I saw Your code... I have never seen that... So easy and it workes perfect. Thank You // Stefan
  4. S

    Filtering a query using a variable

    Hi ! I'm bit frustrated, I just can't select all in a query. It is allways hard to explain so I have made a small access program to show what I mean. If You start frmProject_Filter and chose Adam Adamsson in the dropdown meny and press "Start Filtering" It start up start up and show a...
  5. S

    Finding coordinates for the textcursor

    I know... But in my case I run a complete diffrent program by vba code. In this case I want to scroll down an invoice opened in Foxit Reader by pressing a key... Its not so hard as i sounds, pretty easy infact... When Key pressed down..... I move the mousepointer to Foxit and click in it to...
  6. S

    Finding coordinates for the textcursor

    Hi ! Got stucked... I have no problem to find the coordinates för the mouse pointer but when I tried to get it for the text cursor it won't work. Is there someone who can give me some help // Shas
  7. S

    Print any file dont work on new installation

    You gave me just that kind of hint I was needed... Thanks ! I use Foxit pdf reader and have forgot to install it. So simple and yet so frustrating Thanks onces more // Shas
  8. S

    Print any file dont work on new installation

    Hi ! Now I'm totally lost... I have a just installed a new workstation and that use a program developed in access. The code prints an external pdf:file and that works in every old installations but not this new 2201. I have tried with three different way of programming all works on the old...
  9. S

    Moving data from one program to another by VBA

    Yepp.. its a buissness program för economy called Softone I'm not very god at this but I'm thinking of doing a batfil that execute the command and after that returns to Access... But how ?
  10. S

    Moving data from one program to another by VBA

    I guess I found out what the problem is... If I step throw the program by pressing F8 it works fine until after command SendKeys "%{TAB}", True This piece of code switch program and after that nothing happends.... I'll guess it never execute SendKeys "^v", True Atleast nothing happends if...
  11. S

    Moving data from one program to another by VBA

    I have tried SendKeys "^c", True that but it wont work... About the cordinates You have ofcourse right.. In my case I'm solving this by a question "Click on the upper left corner followed by Click on the lower right corner" by this information I can calculate were the fields are..
  12. S

    Moving data from one program to another by VBA

    CopytoClip is a subroutin that copy to the clipboard I translate it to english to better describe the problem... it it has nothing to do with the issue...
  13. S

    Moving data from one program to another by VBA

    Hi ! I have now started to fin a sollution to move data from access to a non windows program and I need some help... Here is the code... Private Sub Kommandoknapp537_Click() Dim XKordinat, YKordinat As String 'CopyToClip (txtCoustumerNr) '1. This copy the textfield from Access to the...
  14. S

    Control a external program

    Works perfect, thanks ! and the otherway pageup x 4 ? It still an uggly solutions but I'm so glad I finaly have access to it. This is opening a new world. If You for an example whant to automaticly fill in data in an external program You can do it by vba copy past... Its a bit tricky to find...
  15. S

    Control a external program

    In my case it is invoices, normaly just one page. But You got a point... I solve it like this, uggly, I know but an uggly solution is better than no solution SendKeys "{PGDN}{PGDN}{PGDN}{PGDN}"
  16. S

    Control a external program

    Eureka! - I have found it!... I actually found a easy way to solve the problem... So much time I have spend on this and what a simple sollution... When I search the web I also found out that I'm not alone... The sollution: 1. By vba move the cursor to the program You want to control. 2. By...
  17. S

    Control a external program

    To jdraw: well it was not the case. The problem is to get the code behind buttom 2.Page down to work... To the Doc_Man.. I have tried but no luck I have to give it some more efforts...
  18. S

    Control a external program

    Hi ! This is a thing that I have tried to solve many times but with no success. I have done a program that explane the issue. I have a embedded PDF file in Access and a whant to set focus on "Foxit" or Adobe or what ever program is used and scroll down to the buttom with a click on button in...
Top Bottom