Search results for query: *

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

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

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.

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

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

I have a set of check boxes in excel one of them being "chkOther". when this is true i want the cursor to go to a text boxt "txtVendorPerfOther" and I want to make it required. If it's not true then i would like for txtVendorPerfOther to be locked. here is what i have so far... Private Sub...

I need to run a query that returns records that do not contain any numbers. I'm not sure what the criteria would be? Also it would be nice to do the opposite, return a query that returns records that do not have any letters. thanks!

I have a field, [_COMPLETE DATABASE].Floor, where i have multiple different formats... 1st, 1st floor, 2nd floor, 1, 2, etc... i would like to format all of the entries to equal 1st, 2nd, 3rd, 4th, 5th, etc... i know i will need to run an update query but am not sure what the SQL should be...

Just curious what the benefits/differences are between using a control txtBox and a form txtBox in Excel. Also, how come it won't let me use a form txtBox?

ok i know there has already been numerous post on splitting databases. i appologize, but i am not really finding what i need. we have a which is shared on a network drive. how ever i believe that everyone is using the same front end...so when i have a form or something open in design view...

I want to create a "New Account" form and am wondering if i should use excel or access? I need to email the form/questionaire to different Property Managers. I already have an Access Database set up for my needs of storing and keeping track of the information. I would like to take the...

I have this for a txtBank, and it works fine Private Sub bank_LostFocus() Bank = StrConv(Bank, vbProperCase) End Sub is there a way to set this for every txtBox in the form with out having to write the Private Sub procedure for each control? maybe... Private Sub Form(not sure...

I've been looking through strConv threads, but can't seem to find an answer. Can I convert the existing data in a table to Proper Case? Guessing I probably have to use a query or something?

The following code works perfect to send emails, but I am having a problem attaching a report (rptAccountVerification) to it. Your input would be greatly appreciated! Function SendNotesMail(varTo As Variant, strSubject As String, strBody As String, strFilename As String, ParamArray...

I am using the following code to send emails, but am having a problem attaching a report (rptAccountVerification) to it. I am thinking that I need to declare FirstFile as something? Function SendNotesMail(varTo As Variant, strSubject As String, strBody As String, strFilename As String...

I have a parameter query: SELECT [Account Information].AccountNbr, [Account Information].VendorID FROM [Account Information] WHERE ((([Account Information].AccountNbr) Like '*-' &...

I have the following query set up: SELECT [Account Information].AccountNbr FROM tblVendorID INNER JOIN [Account Information] ON tblVendorID.VendorID = [Account Information].VendorID WHERE (((tblVendorID.VendorID)=[Forms]![frmNewAcctSearch]![VendorID])); I have an AccountNbr i.e...