Search results for query: *

This code works very well and does split the files into word and pdf from my access table, however, it groups them into one file. For example, if I have two names in my table: John Doe Jane Doe It will create a PDF/Word named John Doe and Jane Doe, however, John and Jane are in the same file...

I have a code that is working where I can select multiple employees from a list box to create a table and then mail merge the data to a word document. Here is my current code: Dim currentDbName As String Dim strList As String Dim ObjWord As Word.Document DoCmd.SetWarnings False strList =...

The script below works for a small SharePoint list but I cannot seem to get it to work with a large list over 900,000 rows. Any suggestions would be greatly appreciated. I am very new to PowerShell but I think I am missing the loop. $SiteName = "https://folio.com/mysite" $list = "Audit Only...

Hello, since my pc was upgraded, this code will not run. It goes directly to the "File selection was canceled." It worked fine before the upgrade but I had to put PtrSafe declarations in the following to get it it even open. Any help would be greatly appreciated on ideas to fix???

Hello, I am running into a problem where I need to update an employee's record with a date based on two matches from a list box (EID & TERM DATE). The first part of my code works fine if I just have one criteria to match where the [EID] equals my first column in the list box but when I add [Term...

I have the following code that creates the body of an outlook mail message. I want to be able to insert a page break for printing. I have searched but cannot find the HTML code that works. Any ideas? 'Create email message and attach data from recordset Set oLook =...

I have a database that creates an email message and I would like to put a hyperlink in the beginning of the message like this: bodytext = bodytext & "<a href='English'>English</a>" & "<br>" and then link to a location within the email body. I cannot find the code to create a bookmark or...

I am trying to build a message box flag if the row count is over 3 which works AND if the person's age is over 40 in colEcell. It recognizes the value in colEcell but it pops up the flag no matter what. I just want it to pop up if the used row count is over 3 and if anyone in colEcell is over...

My goal is to send a query result to each email receipient. The email is in the same query. I am so close on this code but my loop keeps appending the query data in the next email after the first one. Any assistance will be greatly appreciated. Dim db As DAO.Database Dim rs As...

This used to work in Access 2003, but I am getting an object defined error in Access 2007 on this code: Set objCell = .Cells(.Rows.Count, "A").End(xlUp).Row What am I doing wrong? Thx, Dim strCurrProjPath As String Dim objExcel As Object 'Excel.Application Dim objWorkbook As Object...

Okay, I thought I could almost figure out anything in excel but this has me stumped. I am trying to extract the number corresponding to each alleged in a cell. Now, the instance of "Alleged" can be anywhere in the cell and multiple times. Also, if "Alleged" is by itself in the cell, there is...

I have a form in Word 2007 (.docm) made up of legacy and content controls. The form was fine until I plugged in a couple of macros for copying and pasting data and a spell checker because it is protected. I can open and enable macros and then even save the document but after I run any macro, I...

New PostJimLes (IS/IT--Management) 1 Mar 11 17:48 Hello, I have an excel 2007 spreadsheet that imports data from a PeopleSoft Query output (excel). The code works perfectly when the headers are in the same place (row 3) but depending on how you run the query (straight to excel or scheduler)...

Hello, I have an excel 2007 spreadsheet that imports data from a PeopleSoft Query output (excel). The code works perfectly when the headers are in the same place (row 3) but depending on how you run the query (straight to excel or scheduler) you will get extra rows for the prompts (5). What...

Can anyone tell me why this error handling won't work? I am trying to error the code out if nothing is selected in my listbox (AcctList). It gives me an invalid call procedure when nothing is selected and the error number is 5. Everything works perfect if I select an item. Private Sub...

I am getting an error on the AS clause int this SQL when I input it into VGA. Any ideas to fix? Thx! strSQL = "SELECT qrySeveranceCalculations2.EID," & _ " tblSeverancedata![First Name] & " " & tblSeverancedata![Last Name] AS [Employee Name]," & _ " tblSeveranceData.Salary...

This code works great but I need the text to be formatted when I paste it. Any ideas? Private Sub CopyButton_Click() Dim myRanges As Range Dim newsection As String Set myRanges = ActiveDocument.Bookmarks("Interview").Range newsection = myRanges.FormattedText With...

Hello, I currently have a pop up form that filters data on another form. The pop up form has 7 fields. The first six work perfectly but the 7th one is a date. Below is my current code. I know you have to surround dates by # but I can't seem to figure out how to tweak the code to accept the...

Hello, I have a scroll bar set up in excel with a linked cell to pull its value. Is there a way to have this scroll bar move through data in a column so I can pull its value as I scroll? I am using an advance filter to continually refresh the list in this column and I want the scroll bar to...

I have a combobox called SelectDate on a form that dictates which date should be updated in a multi select listbox. I am using the select case to use the values in the combo box as you can see in the code below. This code works perfectly if I manually select the items in the list box but I...