Search results

  1. speakers_86

    Create hyperlink to open Access form

    Wow, it does! MyShortcut.TargetPath = chr(34) & "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" & chr(34) & " " & chr(34) & "\\officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb" & chr(34) & " /cmd 2"
  2. speakers_86

    Will you upgrade to Windows 10?

    It looks cool. So you made me question myself, and according to this site, 10 performs better than 7. Thats a pretty good reason.
  3. speakers_86

    Closing a .pdf

    Here is some reading material. http://www.access-programmers.co.uk/forums/showthread.php?t=219605 I searched MS Access use digital signature.
  4. speakers_86

    Will you upgrade to Windows 10?

    I will go from 7 to 10, maybe not right away, but I'm ready for a fresh install anyway. My laptop has been a little sluggish lately. I'm a huge 7 fan, and if I don't like 10, I have the install disk for 7 still. I dual booted 7 and Linux for a while, but I didn't like Linux.
  5. speakers_86

    Create hyperlink to open Access form

    MyShortcut.TargetPath = chr(34) & "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE \\officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb /cmd 2" & chr(34) I would think it would be like this.
  6. speakers_86

    Closing a .pdf

    Is there an activex control for pdfs? Can you open the pdf inside of an Access form? I can't explore it on this computer. For the digital signature part, are you just using a pin, or are you using a token, like a digital card reader? If you are, then I think it works the same as the PKI system...
  7. speakers_86

    Create hyperlink to open Access form

    chr(34) is the ASCII code for double quotes. You can also use """ to do the same thing.
  8. speakers_86

    DB Practices

    Okay. On a different note (reading your signature), what is wrong with Access 2013? I basically had the same impression of 2010. You can see in my signature that I am still on 2007.
  9. speakers_86

    DB Practices

    You seem so passionate but I cant' tell why! Are you trying to tell me to do or not do something? Do you disagree with David Fenton? The steps I'm following seem to help prevent corruption. Before I did this, I felt like I was always fighting corruption, though it was probably just bugs and...
  10. speakers_86

    DB Practices

    Great, thanks. The ribbon table actually HAS to be in the front end. It will not work if it is in the backend. It took me a long time to trouble shoot that issue.
  11. speakers_86

    DB Practices

    I've been following David Fenton's advice from http://stackoverflow.com/questions/3266542/how-does-one-decompile-and-3-a-database-application thread for a while now. Should I perform these steps on both the backend and the front end? Also, when using the decompile flag, do I need to enable the...
  12. speakers_86

    Access 2013 Navigation Pane-too much real estate

    If you pm me an email address I can send you my addon if you want.
  13. speakers_86

    what can i delcare as a counter?

    Use Dim smith as integer or Dim smith as Long. Interger will cause a problem if you expect the counter to get very large. In that case, use long. If you are not sure how big it would be use long. Be conservative and assume the counter will sometimes be larger than you expect unless you are...
  14. speakers_86

    Access 2013 Navigation Pane-too much real estate

    Oh, I just rediscovered that I uploaded the msi instead of the exe. The moderators are hesitant to let me post it for security reasons, so I haven't been able to fix it. I'm planning on posting it somewhere else, but just haven't yet.
  15. speakers_86

    what can i delcare as a counter?

    But he said he is doing dim smith as counter vba, not sql
  16. speakers_86

    Object invalid or no long set

    I guess you might want to handle that case in your code to avoid this in the future.
  17. speakers_86

    what can i delcare as a counter?

    Counter is not a data type in access. You probably want as integer or as long. Also, why use variable name smith? Usually people use intI, lngI, or just i.
  18. speakers_86

    Create hyperlink to open Access form

    I think you could make this happen if you know how to write a Windows service. Something that watches for a click of a particular hyperlink. I've never done it, but maybe.
  19. speakers_86

    Access 2013 Navigation Pane-too much real estate

    You can try my NavBar addin. I don't know if it works with 2013. It duplicates the navigation bar and puts it on the home tab of the ribbon. It works well, but I do need to make some small changes. edit- here is the link.
  20. speakers_86

    Using Unbound Form Values to Update Table

    But why not make a bound form with unbound controls? Then just set the me!ControlName = me.txtControlName
Back
Top Bottom