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!

Recent content by socomfort

  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?

    Thanks combo! That's just what I needed. Each reference that is listed in the VBE Dialog Box is registered. Therefore, I can find the Type Library information within each CLSID in HKEY_SYSTEM_ROOT. thanks again dude, [thumbsup2] Ben
  3. socomfort

    How to list ALL references available in Excel VBE?

    Hi combo, Thanks for your reply. Your code does return the properties for the checked (selected) references. I'm trying to figure out how to return this information for the refs that ARE NOT checked (not selected in the dialog box). Here are the NAMES of the refs that are currently selected in...
  4. 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...
  5. socomfort

    How to store ActiveX OLEData?

    Hi PHV, I may not be saying this right, but what I'm trying to do is build an entire form (including the controls) on the fly (using code). The form may or may not persist after this; right now I just want to see if it is possible. I can actually build the form AND all of the commonly...
  6. socomfort

    Need help showing HTML text in form.

    Hi embryo, That was very useful. I wound up creating some void functions (private subs w/o return values) that enable me to create a file on the fly and place it in the active directory. Then I use the WebBrowser control to view the stored data and delete the file when done. It took me a while...
  7. 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...
  8. socomfort

    Need help showing HTML text in form.

    Hi Steve, Thank you for your response. The form is in an ADP (MS Access). Basically, the HTML text is stored in a field that is used in the body of a email message that the app. builds using CDO (collaborative data objects). I found the webbrowser control (MSHTML. VBE reference). However, I do...
  9. 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"...
  10. 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...
  11. 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...
  12. socomfort

    Building hyperlinks to a cell in another workbook.

    Aw Shucks Glenn! Sorry about that; no it does not work. It creates a link (looks like a link including the default underline and font color) but when you click the link a message dialog box appears with the following text: 'Cannot open the specified file' I successfully recorded a macro while...
  13. 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...
  14. socomfort

    Trouble creating Excel drop down list using VBA

    Thanks for you help, Mike! That did the trick. I'm rather new at all of this, and the help sections of the IDE can be quite confusing. Just wondering, is there a book or website that you can recommend for MS Excel VBA? I have a copy of VBA for Dummies (4th ed.) but it doesn't go as much in...
  15. 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...
See more

Part and Inventory Search

Back
Top