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 Mike Lewis 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: *

  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...
  16. socomfort

    Advanced CountIF Formula Help

    Thank you all so very much for your help. Skip, I tried your code and it worked great. Hats off to you! LaurieOZ, Fenrirshowl, and xlbo..thank you all for pointing me in the right direction. What a terrific site. sincerely, Ben [pipe]
  17. 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...
  18. socomfort

    Trouble getting string function to work correctly

    Hello Skip and HarleyQuinn: Skip, thanks for your input. I will look at your code straight away. One question: when you say that, "The string argument does not seem to do ANYTING for this function..." are you referring to the first 'As String' argument within the function prototype...
  19. 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...
  20. socomfort

    How to insert cell data into comment field.

    Hi Macropod, This works great! Thanks so much for your help. Enjoy the star, bud. Ben

Part and Inventory Search

Back
Top