Recent content by Bumi66

  1. B

    Open Website in Chrome with credentials

    Hi I have a table with URL's and the matching login information, username and password. Is there a way in VBA when I click on a field to take the information open the URL in chrome enter username and password to login to the website ? Thanks
  2. B

    Compile Error

    I don't know what all this code does and he also says in the video that you don't have to understand what all this code does, at least it worked. I copied all that into a new module but for some reason it didn't copy the whole module to the other PC what was really weird since I copied the whole...
  3. B

    Compile Error

    Solved !! I followed "Computer Learning Zone on Youtube to add the sleep function For some reason the module 2 wasn't copied to the other computer as it should #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal Milliseconds As LongPtr) #Else Public Declare Sub...
  4. B

    Compile Error

    HI Everyone, I have an access database that runs perfectly on one of my computers, when I copy the file to another PC I get a compile error and it looks like it's because I have an entry in a query : Date: Date() Both PC's run the same Access 365 version 2309. Please help Thanks
  5. B

    Looping through report

    I want to see everything, I just want to run through everything and I also want to be able to stop it with a hit of a key
  6. B

    Looping through report

    Hi everyone, I have a report that I just want to loop through with a little wait time. The report shows errors in red so when I see the 12 pages I can see the error right away. As of now I have to hit the curser right button to loop through all the pages. Is there a way to do this automatically...
  7. B

    Save file in specific location

    Thank you so much it works, you made my day
  8. B

    Save file in specific location

    Thank you so much, you made my day, It works
  9. B

    Save file in specific location

    I'm trying to save a file in a specific location on my hard drive. The location should be m:\Order acknowledgment\Customer name\Order number.pdf The customer name is in a field in my form "match" this varies also the Order number is in a field in the form under "Order number" This is my Code...
  10. B

    Extract a few words

    I know I have to look more into VBA Codes there are much more possibilities, but that's a little too complicated for me right now and I don't have the time right now to learn it. So far I get around with Queries and Macros, but my database gets bigger and bigger, I probably don't get around...
  11. B

    Extract a few words

    Thanks a lot everyone I use thebdguy's option and it works great Expr1: Left([Item]![Description],InStr([Item]![Description]," ")) Expr2: Left(Mid([Item]![Description],InStr([Item]![Description]," ")+1),InStr(Mid([Item]![Description],InStr([Item]![Description]," ")+1)," ")) Expr3...
  12. B

    Extract a few words

    Awesome Thanks a lot the dbguy, that's exactly what I was looking for (y)
  13. B

    Extract a few words

    Thanks Gasman but I want to do this in the query
  14. B

    Extract a few words

    I want to do this in the query without VBA coding
Top Bottom