Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: socomfort
  • Content: Threads
  • Order by date
  1. socomfort

    Populate a list box on the fly

    Hello experts, I am trying to build a form on the fly and populate list box control on the form with the sheets names I store in an array as follows (partial code segment): Dim objTempForm as Object Dim ctlListBox As MSForms.ListBox Dim intNumWS as Integer Dim arrWSList() As Variant Dim xlWB...
  2. socomfort

    How to list ALL references available in Excel VBE?

    Hello experts, I was wondering if it is possible to list all object library references in MS Excel VBE References Dialog Box. I know that the code below will print those references in the ActiveProject (the ones that are checked in the dialog). Function ListAllRefs() For Each my_ref In...
  3. socomfort

    How to store ActiveX OLEData?

    Hello experts, I am trying to build a control on a form in access on the fly. Here is the code segment: Dim ctlNew As Access.Control '******************************************** ' add web browser control in details section. ' a.) OLE Class: Microsoft Web Browser ' b.) Class...
  4. socomfort

    Need help showing HTML text in form.

    Hello, I have a Access Data Project with a table that stores HTML text in a field. That text is used to populate the body of a email message (MS Outlook). The HTML code is stored in the table as a string (nvarchar in the SQL back end). <HTML><BODY><font color=black face="Arial"...
  5. socomfort

    Need help altering an existing VIEW in ADP

    Hey guys, I am trying to alter an existing VIEW in a ADP. The following statement is not working and I'm not sure what the correct syntax is: ALTER VIEW dbo.zView2 (Field1, Field2, Field3, Field4) AS SELECT Field1, Field2, Field3, Field4 FROM dbo.zView1 I have tried this and ALTER PROCEDURE...
  6. socomfort

    Set Default Database window

    Hello, Does anybody know if there is a way to programmatically set the Default Database window in MS Access? I am using OfficeLinks to output my data to an excel spreadsheet. Or is the only option to consistently send data to Excel(to a specific and known folder) to use DoCmd.OutputTo? thanks...
  7. socomfort

    Building hyperlinks to a cell in another workbook.

    Hello all, I am trying to build code using VBA (MS Excel 2003) that will create a hyperlink in a source workbook to a target workbook with a different fully qualified path. Here is the code segment in question: 'Create a hyperlink for the ADDRESS field to the original file...
  8. socomfort

    Trouble creating Excel drop down list using VBA

    Hi, I would like to create a drop down list on the fly using only VBA. I know how to create a single column drop down using the following: Public Sub CreateList() With ActiveCell .Validation.Delete .Validation.Add xlValidateList, , , "=" & "MyRange" End With End Sub...
  9. socomfort

    Advanced CountIF Formula Help

    Hello all: I have detail data in a sheet where the first column contains a transaction date. The date format is "MMM-YY". So several records dated 1/1/2007, 1/31/2007, 1/19/2007 will all show as "Jan-07". What I want to do is count the number of instances that "Jan-07" exists on this sheet...
  10. socomfort

    Trouble getting string function to work correctly

    Hi: I have a public function that is supposed to concatenate several field values into one string. For example if: JobNo = 12345 Jobtype = priority, hold PartNo = 67 Shape = round Then I want to concatenate as follows: 12345/priority/67/round 12345/hold/67/round There should be two...
  11. socomfort

    Trouble with Excel Named Range and Charts

    Hello, I am exporting data from a MS Access database to an existing spreadsheet. This data is used as the SourceData of a chart. I create a named range on the 'Open Workbook' event as follows: Private Sub Workbook_Open() ThisWorkbook.Names.Add Name:="dynamRange1", _...
  12. socomfort

    How to insert cell data into comment field.

    Hi, I have a spreadsheet that has 7 columns of data (Sheet2). Another sheet in the same workbook (Sheet1) has one column and it is the same as the first column in Sheet2. I use code generously provided by someone in response to an earlier question to search for like values in that first...
  13. socomfort

    Trouble looping through a MS Excel range

    Hello: I am trying to create a looping structure that finds a value and compares it to another value on two different spreadsheets using VBA. I have already figured out how to push MS Access data to MS Excel into a blank sheet. I need to be able to loop through the data pushed to excel by the...
  14. socomfort

    Trouble with TransferSpreadsheet Method

    I am very new at this so please bear with me. I am trying to send the result of a SQL select statement to a spreadsheet in MS Excel. The version of MS Office I am using is 2003. After reading several FAQs, it looks like I cannot use DAO to export a query result directly from MS Access 2003 to...
  15. socomfort

    Problem Building Strings: Is the following possible?

    I am trying to build a string based upon a recordset by concatenating the fields as follows: Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer Dim db1 As dao.Database, rs1 As dao.Recordset, myString As String, strTxtAttach as String Set db1 = CurrentDb myString =...
  16. socomfort

    Disabling back-end short cut keys

    Hello: Does anyone know what the VBA code representation for the following are? 1. SHIFT + ENTER (opens MS Access DB in Object View) 2. ALT + F11 (opens the MS Access VBA IDE) 3. F11 (Does same as in 1. above) I am trying to figure out a way to add these options in my Users table and...
  17. socomfort

    VBA code behind Schedule Style Report

    Hello: I am grateful to all of you who have helped me with my questions in the past. I am now trying to create a schedule type report that shows how long a job will be in a furnace for a particular process. The report looks like a horizontal bar chart. Before I post the code, here are the...
  18. socomfort

    Help with date/time function calc

    Hello: I have written a couple of public functions in a separate module that I call in the select statement of a qdef. They are used to populate values in a form that runs when the user clicks a button. All is well with the exception of the End_Date calculation. The code for the functions...
  19. socomfort

    Time calculation in a query

    Hello all: I have the following fields in a table: StartTime (date/time datatype) RampTime (float) HoldTime (float) In a query, I am calculating the following: EndTime: Format(DateAdd("h",[HoldTime],[StartTime]),"Long Time") This sort of works, except that fractional parts of the HoldTime...
  20. socomfort

    Question on aligning concatenated fields in a string

    Hello everybody: I am inserting a string resulting from a record set loop into an unbound text box. However, I am unable to align the text (column headings) with the rs results. The record set code and the string assignment follow: Set db = CurrentDb sql = "SELECT tblWorkOrder.WOID...

Part and Inventory Search

Back
Top