Recent content by The Rev

  1. The Rev

    Updating table from spreadsheet only if unique value for name

    Good day. I have a table in Access called Tbl_Interviewee and a spreadsheet that I give to my interviewers to have locally for job fairs. It's a simple 2 column table with fields named Int_Name and Int_Ptn. I want to be able to use an import button with VBA script to import the spreadsheets into...
  2. The Rev

    Making a custom checklist that saves to a table

    Good evening all! I have a need to build a checklist form. We have 19 steps that our leads have to do every engagement. Items 1-4 are pre-engagement, 5- 8 are mid-engagement, and 9- 19 are post-engagememt. I need a checklist form that saves checked items for the next time the DB is opened and I...
  3. The Rev

    Solved DriveExist error

    So somehow, a non-ASCII character got in my string for the drive letter. I deleted the line and retyped it and it now works. That was just strange...
  4. The Rev

    Solved DriveExist error

    the DriveExists line is highlighted with the "Object doesn't support this property or method" error. I have Access on another PC and I put this code into a blank DB and it worked there. Just not on my laptop.
  5. The Rev

    Solved DriveExist error

    Trying to see if a drive is mapped before I run some code on that drive path from my database. It may be empty so fileExists or FolderExists won't help. It's supposed to work simply, but I'm getting the" Object doesn't support this". Banging my head against the wall.... Set objFSO =...
  6. The Rev

    Solved Dealing with long file paths

    Ugh. figured it out. strSelectedItem = StrShortItem.ShortPath & "\" &StrShortItem.Name gives the full shortpath name and then I added the full long file name at the end with & StrShortItem.Name. So basically I had the file name twice. Dumb me...
  7. The Rev

    Solved Dealing with long file paths

    Not copying it at this point. Just opening it for modification from its path. If the file's full path character count exceeds 218, Access can't find it. I am trying to get around the character limit by converting the file's path to 8.3 format (short path option). It works up until the next to...
  8. The Rev

    Solved Dealing with long file paths

    I have a script that is assigned to a button that open an Excel template and then some auto filling. I am running into an issue when the file path is too long for Access' VBA. I am trying to work around it using ShortPath. But when I try to open the template, it says it can't find the path...
  9. The Rev

    Solved Retrieve full file path of selected file

    Indeed I do. And the variable worked just like you said. I hate when something is that simple and I just missed it. Thanks for the sanity check
  10. The Rev

    Solved Retrieve full file path of selected file

    Well poo. I sure missed that one! I'll try the variables length and let you know.
  11. The Rev

    Solved Retrieve full file path of selected file

    Good day! I have a button coded in my database to select an Excel file for import into my DB. We have some particular requirements for folder and file names, and we are running into file path length issues. If the file path is over 255 characters, the file errors on import. I'm trying to come up...
  12. The Rev

    A stupid find question

    See? I always forget about the Chr objects... Appreciate the assist!!
  13. The Rev

    A stupid find question

    I need to find a string in a textbox on a PowerPoint slide I am filling from my database. I need to replace the entire string <with quotes> with the word Observation: "Other than Satisfied" requirements I have xh = objShape.TextFrame.TextRange.Find("Other Than Satisfied") If xh = ("Other...
  14. The Rev

    Solved Creating query with different table fields

    This worked like a charm!! I'll use it for now and work the redesigned normalized table into the next version. Can't tell you how much I appreciate your help!!!
  15. The Rev

    Solved Creating query with different table fields

    I really appreciate the tips. The assignments table was honestly just a trash table to hold an assortment of junk data for an in-brief slide show. But, like all good intentions, boss wants more and scope creep happens. Should have known better when I started this table. Sigh. I'll try this on...
Top Bottom