Search results

  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

    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 =...
  4. 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...
  5. 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...
  6. 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...
  7. The Rev

    Solved Creating query with different table fields

    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...
  8. The Rev

    Importing table data from other databases

    My database has gone through several iterations, as have we all, and I'd like to code a button that will browse for an older version of the DB and import some table data from the old into the new. I don't need every field, just some of the ones that users input data in. I know how to code the...
  9. The Rev

    Solved VBA code to bold part of a a string in Powerpoint

    I have a slide on a Powerpoint that I fill with some calculated values from my database. The PowerPoint template slide has 7 bullet items. I treat each one as a paragraph and format each paragraph as I need. However, on my 6th paragraph, I need to bold the date portion of the string using the...
  10. The Rev

    Solved Working with a PowerPoint table

    Good morning, I have a PowerPoint slide that has a table as one of the elements on the slide. I need to select the table and then replace the string "<Co Name>" with my stored variable of CompanyName. I don't know how to call the table and loop through the table cells for that string. Here's...
  11. The Rev

    Solved Business day calculation

    Trying to get a date 14 business days in the future. Thought the "weekday" option was my help... FourteenDay = DateAdd("w", 14, Date) FourteenDay = Format(FourteenDay, "mmm dd, yyyy") No dice. Apparently, "weekday" just gives you the day of the week, not a business day. Sigh. I need to get a...
  12. The Rev

    Solved Using Access VBA to change a Powerpoint text box value

    Good afternoon, I am trying to have my Access database open up a Powerpoint presentation template .pptx and replace a value with a value from the database. Currently, on the main slide and a few others in the template, we have a placeholder of "XXXXX" for the company name. That value is already...
  13. The Rev

    Tool Tips for text box content

    Using Access 2016. I have a form with a discussion textbox. Is there a way to parse the text for specific terms and hover over the term in the text box and get a "tool tip" popup with a definition for that term? Thanks.
  14. The Rev

    Solved Query returning no records causes erro on form command

    I pilfered the code from this thread: https://www.access-programmers.co.uk/forums/threads/dynamically-search-multiple-fields.188663/ And removed the logic for trailing blanks because I don't care about them. I built my form and the query exactly as described. It works fine except if no results...
  15. The Rev

    Solved IIF 3 conditions

    I am trying to get a total deducted field in my query. Here is my SQL statement that doesn't work... TotalDeducted: IIF([Requirement_Satisfied]=True, "0", IIF(([Requirement_Other_Than_Satisfied]=True),[Requirement_Score], ([Requirement_Special_Considerations_Satisfied=True]...
  16. The Rev

    Solved Combine 2 textbox fields into one and store in record

    I have a hopefully easy question... I have a single form tied to a table. I have a "User_Name" field and an autonumber field. I have a third field called "request_ID" that I would like to concatenate the "User_Name" field and an autonumber field but have that value stored in the table as a...
  17. The Rev

    Solved Import spreadsheet command truncating data in long text field

    Greetings, I have an Access 2016 database that I am importing data from a spreadsheet. Below is the command I am using to do so: DoCmd.TransferSpreadsheet acUpdate, acSpreadsheetTypeExcel12Xml, "Tbl_Objectives_Import", strSelectedItem, True Everything works as anticipated except my long text...
  18. The Rev

    Need main form checkbox to check based on sub-form checkboxes

    Evening!. I am working on my main form. I have a main form with a checkbox labeled "Sub_Family_Satisfied". The sub-form is a single Form with a checkbox on each record for "Requirement_Satisfied". I need the "Sub_Family_Satisfied" checkbox in the main form to check when all of the filtered...
  19. The Rev

    Need help with query to get totals as records

    Good morning. I have a table that lists 30 bills that are paid monthly, and separate checkbox fields for husband and wife. As a bill gets paid, I check the box for who paid. I need a query that will produce a list of how many bills the husband paid, how many the wife paid, and how many are...
  20. The Rev

    Working on a form with filtering

    Good evening. I have a Professor's table with the professor's unique employee ID as my primary key on the Professor's table. I also have a "Classes" table with the unique class ID as the primary key. I have a linked master table with professors getting assigned to classes. I need to be able to...
Top Bottom