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...
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...
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.
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 =...
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...
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...
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...
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...
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...
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!!!
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...