Search results

I have a listview control on an Access 2007 form that I'm trying to get the vertical scrollbar to display. In the control properties there horizontal scrollbar properties available, but nothing for the vertical scrollbar. Does anyone know how to get the control to display the vertical...

I'm using the Microsoft Windows Common Controls 6.0 (SP6) which uses mscomctl.ocx.

David, Thanks for the help, but the control I'm working with is a listview ActiveX control, not an Access listbox. Ken

I have a listview control on an Access 2007 form that displays four columns of information. The third column (CEU Cert Request) shows a Yes or No value for each record in the list. I want to create and email a pdf certificate for each record where the CEU column value is Yes, but can't figure...

Noob, Since "Value" is the default property of a textbox control, your second VBA statement can be made even shorter to: strTxtBox = Me.txtBoxName Ken

Ashley, So the data type of the field Plot is memo? I ran a test string that was 317 characters before processing. The function worked fine, returning a string ending in the double hyphen that was 261 characters in length. I had no problem with the code updating the field in my table. If...

Sorry about the space issue. That was a typo.

Ashley, Before you do that try changing the code to the following. I think some of the Access 2003 is coming back to me. Remove the line: Dim rs as DAO.Recordset Replace with the following two lines. Dim db as database Dim rs as recordset Remove the line: Set rs =...

Ashley, I think you're almost there. In the VB editor click on the menu item Tools, and select References. You'll see a list box of available references. Find the item called, Microsoft DAO 3.6 Object Library and select it. I'm running Access 2007 and can't remember the 2003 library...

Ashley, If the file has been imported into a table called "DVDIMPORTFROM" and the field you need to process is called "Plot". Make the following changes to the code in the On Click event of the command button on your form where the processing will occur. You will not have to do anything...

Ashley, The line: Set rs = CurrentDb.OpenRecordset("tblImportFile") assumes the file has been imported into an Access table called tblImportFile. The rest of the code then processes each record's txtString field. In your application you'll need to import the text file first and then...

Ashley, Put the fTrimString function into a code module. Create a command button on the appropriate form and enter the following code into the On Click event of the command button. — Ken Private Sub cmdProcessImportFile_Click() Dim rs As DAO.Recordset Dim strImportText As String...

Ashley. You could use a function like the following. Public Function fTrimString(strInput As String) As String Dim intStringLength As Integer Dim intDoubleDashPosition As Integer Dim strNewString As String intStringLength = Len(strInput) intDoubleDashPosition = InStr(strInput, "--")...

In an Access 2007 application I'm trying to read the properties of Outlook email messages stored on a server in related project folders. I have utilized treeview and listview controls that allow the user to see all the files within various project folders, but when the file type is an Outlook...

I'm using an ActiveX listview control on an Access 2007 form and would like to have the data displayed with alternating backcolor, but can't figure out how to do so. Any help will be greatly appreciated.