Search results

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

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

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

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

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

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

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

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

The auditor gets assigned to the group. Each group consists of several requirements. Requirements are sequential from 3.1 through 3.14. The first group is 3.1, 3.3, and 3.5. The other groups are listed above. There's more below that, but that's the meat of what I need. There are dozens of...

I need a query that is based on 2 separate tables. I have a Requirements table and an Assignments table. We assign different groups of requirements to 5 different groups of auditors (1_3_5, 2_9_10_11_12, 4_7_8, 6_13_14, and On-Site). My Assignments table has 5 separate fields in them to assign a...

I have no idea what listbox you are referring to in your code.

Again, I don't know exactly how to do the SQL code to make that happen. I tried the following: "SELECT Tbl_Requirements.Req_Validation INTO Tbl_Requirements IN " & strSelectedItem & " FROM Tbl_Requirements;" But it gives me the error that it must include a table or a query.

I don't understand why what I am asking for is so difficult. Maybe if I boil it down... I need to: 1) Select an old database from the msoFileDialogFilePicker (Already have this down) 2) Get all of the [Requirement_Satisfied] field's data from that database's Tbl_Requirements 3) Insert that data...