Search results for query: *

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

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

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

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

Thanks PHV...exactly what i needed.

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

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

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.

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

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

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

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

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

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

i have, doesn't seem to wanna work.

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

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

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

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?

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