Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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