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

    Join error for date range

    I am trying to join two tables on ID1, ID2 and when Date > Start AND < End but I keep getting an error when I add the date fields in. Just joining on ID1 and ID2 works fine, but I'm of course getting duplicated records because in my right table I can have two lines for ID1, ID2 with a different...
  2. Ebes1099

    Subscript out of Range when using Sheet CODENAME

    I'm not understanding why this line of code gives me a Subscript out of Range error. I'm using the sheet CODENAME because the tab name in Excel gets changed occasionally. If I use the actual tab name in excel it doesn't give me any errors. "MA_BPT_Rng" is a named range in my workbook. I've...
  3. Ebes1099

    Format File Help

    I'm trying to create a Format File for a bulk insert into SQL because I have a comma delimited file with some currency fields that have a comma to separate the thousands and it's causing issues on import. The currency fields have a text qualifier of a ". I've attempted to write an import file...
  4. Ebes1099

    Comparing cells in different columns

    I have a number of columns that contain a letter and I want to be able to check if all letters of "selected" columns match. I'm using an indicator in row 2 with either a '1' or '0' to indicate whether the column is selected. I know the Exact function will return a True or False for comparing...
  5. Ebes1099

    Method for Break Links not working

    I've used this code in the past on a workbook and I can't figure out why it's not working now. I can't even break the links by selecting the "Edit Links" button in the Ribbon and clicking Break Links in that prompt. Sub BreakLinks() Dim vLinks As Variant Dim lLink As Long '...
  6. Ebes1099

    Break Links not working

    I've used this code in the past on a workbook and I can't figure out why it's not working now. I can't even break the links by selecting the "Edit Links" button in the Ribbon and clicking Break Links in that prompt. Sub BreakLinks() Dim vLinks As Variant Dim lLink As Long ' Define...
  7. Ebes1099

    Bypass User Input from someone else's Macro

    I have a workbook that is interfacing with another workbook tool maintained by a separate team so I don't have authority to make changes to their tool. A little background info on what the other team's tool does. It grabs information from a SQL into their workbook and pastes it into sheets...
  8. Ebes1099

    ListBox Object and Looping Through

    I'm having a problem in trying to loop through a listbox. I've never worked with the ListBox before so this is all new to me. I want to check if the value in a cell is found in the listbox, and if it's found, is that item in the list box selected? I get an error on the line If...
  9. Ebes1099

    Change Values in cell from Check box?

    I have a list of Items that I have a Macro setup to grab info on but I want the user to be able to select a subset of these items based on some characteristics. Right now I have a "flag" in Column A that I've just hard-coded in as a 0 or 1. Each item has a Color, Size, Type. The list of items...
  10. Ebes1099

    Object does not support method on Copy Destination

    I'm getting a Runtime error 438 Object does not support this property or method on the bolded line of code below. It's a pretty simple copy and paste so I'm not sure why. The named range "Plan_Name_Hdr" exists in the destination workbook, supp. Dim model_one As String, model_one_Full As...
  11. Ebes1099

    Method 'Range' of object '_Global' failed

    I'm getting an error that I can't seem to figure out. I'm trying to search for a value in column F and set my Range to that cell. Then assign a value to a nearby cell using the offest formula. But I keep getting this error and I can't figure out why. The first line of code finds the matching...
  12. Ebes1099

    New table from Multiple Tables

    I am trying to combine data from multiple tables into one master table. Each table has a Field called [MbrID], [Amt_Cost_Tbl1], [Amt_Paid_Tbl1], [Amt_Cost_Tbl2], [Amt_Paid_Tbl2], etc.. The Tbl1, Tbl2, etc are specific to the table names and I would like to keep them that way. I have 4 tables...
  13. Ebes1099

    Conditional Running Totals

    I'm trying to figure out something in SQL but thought I might be able to use a VBA macro (in excel or access) to solve this problem so I am posting this question in here as well. I'm thinking there might be a way to loop through in a VBA macro and write in formulas in the calculated columns to...
  14. Ebes1099

    Running total by ID#

    I'm trying to calc a running total by each person in my table. I would like to do this for the Paid column. Here are the field I have in my table Date, ID, Billed, Paid. This is the code I'm using. Right now it's calculating a total for each ID and putting that number in each line. (e.g. If...
  15. Ebes1099

    Grab Filename from linked cell formula

    Is there a way I can grab the filename out of a cell that has a formula linking to it? In my VBA code, I want to open another workbook and count the number of rows in a tab but I won't know the name of the other workbook. I will have to pull the filename out of a cell formula in my current...
  16. Ebes1099

    Copy/Paste non contiguous cells with same spacing

    Is it possible to Copy and Paste non-contiguous cells in a column with the same spacing in the destination? Right now, I can copy rows, 6, 8, 10, 12 but when I paste them, it pastes it into 4 consecutive rows. I've got a column of data where I want to copy some cells as values and some as...
  17. Ebes1099

    Create columns without Absolute formula, copying problem

    I'm running into an interesting problem. I am writing a macro to copy data from one workbook to another. All of the information to be copied is compiled into one main worksheet in my first workbook. There are columns that have an Offset formula which reference another cell on the worksheet for...
  18. Ebes1099

    Open form to specific record (without filter)

    I'm trying to open another form from a button on a different form to the matching record on the open form and have it not be filtered to just that one record. Right now I have it opening to the correct record but it's filtered to just that one record and you can't scroll left or right to get to...
  19. Ebes1099

    Dynamic Year field in table

    How can you create a field in a table that contains the year, but changes dynamically with the turn of the calendar? I've tried the now() function and that doesn't seem to work. The premise of this is that I have a separate table that contains a year and a salary value, in the table I'm trying...
  20. Ebes1099

    Run Time Error 1004 App Defined or User Defined Error

    I'm getting a Runtime 1004 error on my macro. I orginially recorded the macro, then created a separate sub since I want to run the macro for multiple sheets. The 1 parameter for the Sub is a String that contains the Worksheet name. What I'm trying to do is copy data from multiple sheets into...

Part and Inventory Search

Back
Top