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 derfloh 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: ironj32
  • Order by date
  1. ironj32

    linking Excel to Access

    A B C D 1 user name vendor name 2 $12000 12/14/07 3 renewing (123)123-4567 4 city name.name@email.com 5 state...
  2. ironj32

    linking Excel to Access

    is there a way to attach a file? it'll be much clearer to just attach a sample.
  3. ironj32

    linking Excel to Access

    Thanks Skip! that works, however, that put's every workbook.xls all into the same table still formatted exactly like the excel book what i want to do is to take certain cells from the workbook and make that one entry (row) in the access table. example: vendor1.xls cells a1, b3, b6, c7 would...
  4. ironj32

    linking Excel to Access

    hi everyone, here's what i have...i am going to be receiving a couple thousand seperate workbooks over the next few months. all of the workbooks have one sheet all formated the same. i would like to set something up to put the data into my access database. i do have a table in access with all...
  5. ironj32

    combining duplicate entry's

    Thanks PHV...exactly what i needed.
  6. ironj32

    combining duplicate entry's

    this is probably easy but i cannot figure this out for some reason. i have a table (tblDescription) with two fields: "barcode" & "additional description" there are some duplicate records that have the same "barcode", but different "additional description". is there a way to combine the two...
  7. ironj32

    attach two files using SendObject?

    thanks for the quick answer. i am using lotus notes and have code for that...i was just hoping i could use something simple.
  8. ironj32

    attach two files using SendObject?

    Is it possible to attach two files using the DoCmd.SendObject function? I would like to send a report as a RTF and also as an XLS. I have it so that it puts them into two seperate emails, but would like them in the same email. Thanks.
  9. ironj32

    File, Get External Data, Import

    Yeah, didn't realize it was that simple. Thanks!
  10. ironj32

    File, Get External Data, Import

    I need code that will go to: "File", "Get External Data", "Import". Private Sub cmdGetTable_click() ? End sub Thanks!
  11. ironj32

    attaching rtf report in email is converting to .xls???

    I have a form that has a command button that opens up lotus notes and attaches a report as an .rtf. this works on all of our pc's, but for some reason it attaches as an .xls file one persons computer. any thoughts as to why this is happening? Private Sub cmdSendReport_Click() Dim Subject...
  12. ironj32

    option button group

    Thanks for you help. I guess firstly I need to have this question answered before I move on to the IF Statements. This is also a thread from the other forum. thanks! thread707-1332575
  13. ironj32

    option button group

    Private Sub optReplaceVendor_click() If optReplaceVendor = True Then txtReplacedVendor.SetFocus Else txtReplacedVendor.Enabled = False End If End Sub
  14. ironj32

    option button group

    Tried posting this in the VBA for Microsoft forum but no luck. In an excel userform that i have a group of option buttons with the GroupName of "SelectOne". It contains 4 optbuttons: optNewContract optRenewContract optUpdatedContract optReplaceVendor I also have a...
  15. ironj32

    selecting optButton value into worksheet

    i have, doesn't seem to wanna work.
  16. ironj32

    selecting optButton value into worksheet

    I've got a UserForm that is connected to another worksheet. I am having a problem figuring out the code for selecting the value of a option Button group the GroupName is "SelectOne". this is probably really easy. thanks! Private Sub cmdSave_Click() Dim irow As Long Dim ws As Worksheet Set ws...
  17. ironj32

    excel survey...activeX or UserForm

    I am creating a survey that is going to be emailed out to many people and am wondering if i should be using ActiveX controls or UserForm controls. The survey is going to consist of many input text boxes, options buttons, and check boxes. I would like some text boxes enabled/required/locked based...
  18. ironj32

    if then statement in excel

    ......aaannnnnd it does! things might be a little easier now. at this point you can all ignore my posts in this thread. thanks!
  19. ironj32

    if then statement in excel

    i should note that the check boxes i am using are from the Form tool bar...does it make a difference if it is a Form object or a Control object?
  20. ironj32

    if then statement in excel

    this code does not seem to do anything...? Private Sub chkVendorPerfOther_Click() If chkVendorPerfOther = True Then ' Ticked txtVendorPerfOther.SetFocus Else ' Not ticked txtVendorPerfOther.Enabled = False txtVendorPerfOther = "" End If End Sub

Part and Inventory Search

Back
Top