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

    Select first row of data from autofilter

    I have an autofilter set up through VBA in an Excel 2007 worksheet. Once it filters, I want to delete all the values it returns and remove the autofilter. The problem I'm having is how to select the first row of the filtered data- sometimes it's row 2, sometimes it's row 456. How do I select...
  2. mcongdon

    Insert Column Alters Formula- Any way to turn off???

    This might be an answer that is super easy, but I can't quite figure out how to do it. I have a macro that inserts a column as part of a larger procedure. The problem is that there are formulas based on this data on other sheets that change when the column inserts. For example, the formula...
  3. mcongdon

    Dell Recovery Partition

    Hi Everyone, I have a Dell Inspiron 6400 Laptop that I bought 3 years ago. Performance wise it hasn't failed me yet, so I'm not looking to replace quite yet. One problem I have is that I'm very low on hard drive space. I recently dropped under 1GB available on my C:\ drive. When I bought the...
  4. mcongdon

    "Blank" cells are being counted as values- clear contents with VBA?

    Hi everyone, I have an Excel workbook that I'm having some trouble with. Here's the formula that is giving me trouble: =COUNTA('Data'!AB:AB) In the sheet 'Data', there is a formula in column AB like this: =IF(D2<>"Part Executed",T2,"") =If(D3<>"Part Executed",T3,"") When the COUNTA function...
  5. mcongdon

    Zero-Length String Error

    Hi Guys, I have an Access form with a command button that will copy certain fields to the next record to be entered. The code for that button is: Private Sub Command367_Click() Me.BuySell.DefaultValue = "=" & Chr(34) & Me!BuySell.Value & Chr(34) Me.TradeDate.DefaultValue = "=" & Chr(34) &...
  6. mcongdon

    Checking for entries that shouldn't exist in more than 1 column

    Hey everyone! I have an Excel 2007 spreadsheet containing 2 columns of names. One with last name, one with full name. I was wondering if there is any way to check the list of full names to see if it contains any of the last names in the other column. If there is, highlight the full name that...
  7. mcongdon

    Conditionally Add Values to Cells in a Table

    Hi All, I have a table in excel that has Y-axis of Share Price, X-axis of Price per Share, and the data in the middle is the associated charge. I want to be able to add a certain amount to cells that have a principal amount between certain ranges. For Example: Price...
  8. mcongdon

    Programmatically Installing and Referencing Solver.xla

    Hi Guys, I've been having some major issues with a workbook that I have to distribute throughout my company. It's a basic solver application, but as expected not everyone has solver. I've tried several different methods that I've found, but I can't seem to (a) consistently get the solver.xla...
  9. mcongdon

    Help Automatically Sorting and Summing

    Hi Everyone, I'm not sure if I should be posting here or in the VBA forum, but I think that starting here would be good. I have a spreadsheet with 38,000 lines in it. They contain data from stock trades. When buying or selling a stock, the shares don't always necessarily get bought or sold in...
  10. mcongdon

    Sum and Group by Date

    This is both a report and a query question. I have a table with the following fields: Date Rep Quantity Price I want to create a report that takes the sum of (Quantity*Price) for each rep on each day of the month specified in an unbound form that launches the report. In the end, I want to...
  11. mcongdon

    Delete Text After Comma (Excel 2007)

    I have a list of names in the format LastName, FirstMame. The whole text string is in one column, not separated into two separate columns like I need. Eventually this whole spreadsheet will be imported into Access. Is there a way I can write a script to go into each cell of the column, select...
  12. mcongdon

    Grouping In Queries

    Hi all, I think this is a pretty easy question. I've looked in a couple of beginner books and online and I can't quite find what I'm looking for. I have a table tblBlotter. In this table I have fields RepName, Quantity, Comission, Date. Basically, I eventually want to create a report that...
  13. mcongdon

    Reset Default Value of Control to Blank

    I didn't want to piggy back this on the other question I just posted because I haven't been able to find an answer in past questions. I set the default value of my controls with this method: Me.SecurityDescription.DefaultValue = "=" & Chr(34) & Me!SecurityDescription.Value & Chr(34) I want to...
  14. mcongdon

    Command Button to Add Next Entry With Some of the Same Data

    Hi Everyone! I have a form, frmNewTicket, that I would like to add a command button to. Right now, everytime someone goes to add the next entry, they have to re-enter a lot of data. I would like to add a button that will bring up the form for the next entry, but automatically fill in some...
  15. mcongdon

    Pivot Table Criteria from Combo Box

    I have a worksheet with 2 pivot tables with criteria options of Apple or Orange. There is a separate drop down combo box with 2 options: Apple and Orange. My goal is to have the value in the combo box change the criteria of both pivot tables. Right now, the combination box sets the value of...
  16. mcongdon

    Run-Time Version of Access 2003 Problems

    I must admit, I'm pretty new at database design, but I have tried really hard to keep standardized naming and relationships as well as asking questions about anything I'm not sure of. I built a database that works perfectly on my computer, but when I tried to use it on the end user's computer...
  17. mcongdon

    Currency Format Doesn't Display in Report

    I have a simple report based off of a query. All 7 fields are set to be formatted as currency when displayed on the report. When opened in print preview view, 5 of the text boxes show up as number fields displaying as many decimal points as were calculated. When I go back and check how they...
  18. mcongdon

    Excel Duplicate Entry Sums

    Hey Everyone, I have a spreadsheet that has been generated by a different program with about 27000 rows. It has 6 columns: EXDATE,ACCT#,SYMBOL,SHARES,PRICE,and CLIENTCHARGE. I have sorted it by SYMBOL(ascending), EXDATE(ascending), then ACCT#(ascending). What I want to do is look for entries...
  19. mcongdon

    Duplicate Entry Summing

    Hey Everyone, I have a spreadsheet that has been generated by a different program with about 27000 rows. It has 6 columns: EXDATE,ACCT#,SYMBOL,SHARES,PRICE,and CLIENTCHARGE. I have sorted it by SYMBOL(ascending), EXDATE(ascending), then ACCT#(ascending). What I want to do is look for entries...
  20. mcongdon

    Sorting Reports into Weeks Using Daily Data

    I have database for stock trading. At the end of each day, the database creates a report of all the stock trades during that day (called a blotter), as well as totalling the commissions on those trades. The end of month report needs to be layed out in a fashion that each row is a business day...

Part and Inventory Search

Back
Top