Search results

  1. B

    msgbox question

    instead of a msgbox use Dim info as string info = inputbox ("blah blah")
  2. B

    Question on How to Grab an Excel file on the local hard drive

    it places the focus on that control try placing a " ' " in front of it and see what happens.
  3. B

    msgbox question

    what are trying to do exactly?
  4. B

    Question on How to Grab an Excel file on the local hard drive

    try searching the forum. Also I bought this book to work with Automation. The link has many sample on importing data. http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764559044,descCd-download_code.html
  5. B

    Awesome Search Form

    Glad to help. Bones
  6. B

    e-mail from a form

    You can use DoCmd.SendObject acSendNoObject, "", "", Me.EMAIL, "", "", Me.sub, Me.Text23 just use your controls. In this example me.email is the email address on the form, me.sub is the subject control and etc... where the "" is, its for CC or bcc and such.
  7. B

    click image hyperlink in form to load image to form

    try here: http://www.access-programmers.co.uk/forums/showthread.php?t=108698
  8. B

    Question on How to Grab an Excel file on the local hard drive

    First Check out Ghudson's example on how to browse and find a file here: http://www.access-programmers.co.uk/forums/showthread.php?t=97787 to import an excel file, you'll need to use Automation. Just do a search and there is plenty of threads on this. Good luck
  9. B

    Awesome Search Form

    The list box has a bound column. When you clicmk on it, it returns the value of the bound column (defaults to 1). try changing it.
  10. B

    Awesome Search Form

    Check which column the list box is bound to.
  11. B

    Cant lock record HELP!

    No luck.... any other ideas?
  12. B

    Cant lock record HELP!

    ok I'll try, but I thought check boxes returned values of 0 and -1????
  13. B

    Creating a Pop-up calendar

    Check the sample database tread. I believe there are several. here is one http://www.access-programmers.co.uk/forums/showthread.php?t=103747
  14. B

    Cant lock record HELP!

    Hi All, I've searched the forum and have found a lot of info on locking records/forms. I pulled this from a thread but it doesnt work. I have a subform with many fields with a check box. if the check box is true then I want to lock that record(or the form). I loaded this in the on current event...
  15. B

    VB FileCopy Help

    OK, I wasnt sure. A variable is like this Dim path as string path = Query_Filename.Filepath filecopy path, "C:\Pulse Local Database" & path
  16. B

    VB FileCopy Help

    Try assigning your file path to a variable. Also, I am not sure what "Query_qryFilename.Filename" returns, but I know your missing a "\" in " "C:\Pulse Local Database"" it should be ""C:\Pulse Local Database\" Good Luck
  17. B

    List all Active users?

    thx...that what I have now. I thought that a quick popup could list all the active users. Thanks anyway
  18. B

    List all Active users?

    Hi, I am trying to list all active users on my DB. I need this so I can tell who is on when I need to edit the db. Currently I log the users in a table. I want to know how to list all the active users. This code only shows me being logged in. Any ideas? Dim user Dim i user = Environ("UserName")...
  19. B

    set a default choice in a combo box

    on form open: me.combo2 = "what ever"
  20. B

    How to find the author of a TXT File?

    I was having some fun with your code and tweaked it a little. This will open up a file dialog, select a file and load all the info into a list box. Thanks for the help! Dim path As String Dim TBfile As String Dim fullpath As String Dim FD As FileDialog Dim name As String Dim loc As String Dim...
Back
Top Bottom