Search results

  1. The Rev

    Importing table data from other databases

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

    Importing table data from other databases

    I'll explain. We have a database that assessors use to assess the NIST 800-171a objectives. Each assessment is for a different company. Each assessment has 4 assessors who divide the requirements up and a lead assessor who aggregates the assessor data. There are no front end and back ends. It's...
  3. The Rev

    Importing table data from other databases

    We do over a hundred assessments per year. Each database is a stand-alone database due to our restrictions on connecting to customer wifi with our company issued laptops. As I update versions and make improvements based on feature requests, I would like to be able to import the data from prior...
  4. The Rev

    Importing table data from other databases

    I trust them to know at least what they are doing here, so that's not an issue. Since the tables have the same name, would this work to link them? For Each strSelectedItem In .SelectedItems DoCmd.TransferDatabase acLink, "Microsoft Access", strSelectedItem, acTable, "Tbl_Requirements"...
  5. The Rev

    Importing table data from other databases

    Not doing this for me. I have assessment leads that need to be able to click a button and select the old database and everything happen in the background. In your article, I don't see how in SQL to "call" the remote table in order to create the join between tables. Thanks
  6. The Rev

    Importing table data from other databases

    So, I was wondering if I can just do an Update Query in SQL and just call the SQL in a DoCmd.Run SQL line? Is this the right way to do so? SQL = UPDATE Tbl_Requirements ( Requirement_Validation, Requirement_Satisfied ) FROM strSelectedItem SELECT _ Tbl_Requirements.Requirement_Validation...
  7. The Rev

    Importing table data from other databases

    I've seen some examples where the new table is deleted and the old DB table is imported. Will this mess with joins?
  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

    Adding business days and holidays to a date.

    I know this is an old thread, but I'd like to offer my solution to this problem with the code below: Public Function AddWeekdays(datDateIn As Date, intDays As Integer) As Date ' Modified from example at Total Visual SourceBook On Error GoTo PROC_ERR Dim intCounter As Integer Dim...
  10. The Rev

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

    Got it. So simple, it's almost stupid... objShape.TextFrame.TextRange.Paragraphs(6).Words(2, 4).Font.Bold = True
  11. The Rev

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

    Unfortunately, no.
  12. 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...
  13. The Rev

    Solved Working with a PowerPoint table

    I tinkered and finally got it to work. Dim t As Table Dim tRow As Long Dim iCol As Long Dim oSh As Shape Dim tText As String For Each objShape In objPresentation.Slides(13).Shapes Set t = oSh.Table With t For tRow = 1 To objShape.Table.Rows.Count For tCol = 1 To...
  14. The Rev

    Solved Working with a PowerPoint table

    Still no luck. Here's the table by itself on a slide.
  15. The Rev

    Solved Working with a PowerPoint table

    Still no idea why this isn't working...
  16. 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...
  17. 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...
  18. The Rev

    Solved Using Access VBA to change a Powerpoint text box value

    Out of curiosity, is there a character limit for the SQL statement? Mine's 758 characters long because I need lots of different data for the query, but only 5 data fields from the query will get combined into the text I need to paste into the text box.
  19. The Rev

    Solved Using Access VBA to change a Powerpoint text box value

    So far so good. I have the presentation making duplicates temporarily based on an input box, and each slide is individually edited based on the slide number. Now, here comes the hard part... I have an existing query that gives me all of the failed requirements in table format. I have no idea how...
  20. The Rev

    Solved Using Access VBA to change a Powerpoint text box value

    So, next task is a bit more complicated. In the middle of the slide deck, I have on slide 5 of the template a slide where I list failed requirements. It has 3 text fields on it, but I need to only replace what is in the second with my failed requirements report information. The stickler is that...
Back
Top Bottom