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 Rhinorhino 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: mpadgett
  • Content: Threads
  • Order by date
  1. mpadgett

    Considering Infopath

    I've never used Infopath and am just learning about it. I'm wanting a way to easily create data entry forms for users to enter data into a SQL database as well as run pre-created reports or views of the data (possibly web based). Would Infopath be a good solution for that? The DB is SQL 2000.
  2. mpadgett

    Using Worksheet_SelectionChange

    I'm trying to use Worksheet_SelectionChange to identify if a user selects cells F4 through F30 to thus execute a macro but I'm having some difficulty with the syntax to define the F4:F30 range. Thanks for any help.
  3. mpadgett

    Read Only Access

    The company I work for is moving off of its current business software to a new one. The current application runs on SQL 2000. We want to leave the server and the application active just for referencing history data. What would be an easy and suitable way of rendering the database read-only...
  4. mpadgett

    vlookup #N/A error

    I can't figure out why a vlookup formula will not work. I'm getting #N/A errors. I've used vlookup numerous times but never had this big of a challenge. It's almost like a data type problem. In the table_array, I have alpha-numeric data in column 1 and numeric data in column 2. I've changed...
  5. mpadgett

    InDesign on a Mac MINI

    Does anyone have any production experience with InDesign on a Mac MINI? If so, how does it perform? My reason for asking is that my wife, a magazine Creative/Art Director (MAC and Adobe CS products), is losing her job. She will be doing some freelance work soon so we've got to get outfitted...
  6. mpadgett

    Adding AD user account to local group on Win 2K3 Server

    Someone told me that AD user domain accounts could be added to local groups on a Win 2K3 server with said server not part of the domain but a stand-alone server on the network. Can anyone confirm that this is true? Thanks!
  7. mpadgett

    Excell Connection Problem

    I'm using the following to connect to an Excel spreadsheet from VB6. Dim xlConn As Object Set xlConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=k:\clad\form 102\31 plate\237C1003-31.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" When I RUN the code I get a TYPE MISMATCH error...
  8. mpadgett

    Printing Excel Files from a Visual Basic App

    I'm developing a simple VB app to manage the creation of some MS Excel files. Nothing complex, just some List Boxes, File List Boxes & some Command buttons. I'm using the Shell function in a button to allow the user to open a selected file with MS Excel. I'd like to do the same for printing a...
  9. mpadgett

    Last row in another spreadsheet

    I'm trying to put some data from one spreadsheet into another. I'm automatically getting the filename of the target spreadsheet and opening it with no problem. I just need some help finding that last row in the newly opened spreadsheet. Thanks -MP
  10. mpadgett

    Write data from one spreadhseet to another

    I'm going to develop some code to write some data from a currently opened Excel spreadsheet to another. Is the best way to accomplish this to do a Workbooks.Open and Workbooks.Close or is there a way to write to the file with out opening it? Thank - Mike P.
  11. mpadgett

    Automate Install of Patch

    I've downloaded the Daylight Saving Time OS patch as well as the Outlook DST patch from Microsoft & wanted to automate the installation to user's computers. I've never written any vbscripts but I do some VB and VBA coding. I figured that I could come up with a script that would reside on a...
  12. mpadgett

    Recipient in Global Address List not in Recipients List

    I need to get some users names into the Recipients List that show up only in the Global Address List when using Outlook 2003. How can I accomplish this? Thanks - Mike P.
  13. mpadgett

    Excel Data to Table in SQL database

    I just finished taking an SQL Programming class to get an understanding of SQL's coding syntax and capabilities. What I want to do now is take an existing Excel spreadsheet which I've developed and code it to do an INSERT into a table in our SQL Database. Currently the spreadsheet is coded...
  14. mpadgett

    Excel Data to SQL Database

    I just finished taking an SQL Programming class to get an understanding of SQLs coding syntax and capabilities. What I want to do now is take an Excel spreadsheet and code it to INSERT some specific data into a table in our SQL Database. Currently I've coded the spreadsheet, with VBA, to email...
  15. mpadgett

    Redirect Excel Temp Files

    Does anyone know if the Excel Temp Files can be redirected to a different folder? I have a custom Excel VBA spreadsheet that users of a particular Domain group have read/write access to but I've removed the ability to delete. The problem is that since the temp files are located in the same...
  16. mpadgett

    Multiple copies of the same email

    I've got an Outlook (pop3) user who is receiving numerous copies of the same email. The Email account is set to not leave copies on the Exchange Server. Can anyone help?
  17. mpadgett

    Clicking on Cells to execute code

    I've successfully written some code to execute a certain task if the user clicks on a cell. This is done by have a conditional statement in the Work Sheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$13" And Target.Value = "" Then "code...
  18. mpadgett

    SendMail Working but recieving an error

    Using the following code my workbook gets emailed to the appropriate recipients from a listbox but I get an error after execution. Any idea as to why? Thanks! Code is: Private Sub CommandButton4_Click() Dim email_person Dim entry_counter As Integer entry_counter = -1 Do While entry_counter...
  19. mpadgett

    SendMail Command

    I'm using the following code to email the Active Workbook with email_person as a variable. I 'm getting an error and the email is unsuccessful. Any suggestions? ActiveWorkbook.SendMail Recipients:=email_person
  20. mpadgett

    Can't get Loop to work correctly

    I'm trying to use the following code to read entries in Column J (starting at row 1) of Sheet 1 and add each value to a list box until a blank entry is found. I can't figure out why it's not working. Help would be appreciated. Private Sub UserForm_Activate() Dim Insert_Name Dim Counter...

Part and Inventory Search

Back
Top