Search results

So I'm trying to understand working with tables by using structured references and need a push. How would you write the formula below using only structured reference? The table name is "Activity" and the "L" column is "GA#" and the "N" column is "FlowingClients"...

Hello, I am new to working with tables and have an issue when sorting. The issue seems to be related to the relative positioning when referencing an adjacent cell. Before sorting, the top cell and all the ones below show the correct relative action ($b2, $b3, $b4...). But after sorting it...

Hello, I have an existing worksheet that has a table of data and column 1 had no data or formula in it unless numbers are entered into column 2 & 3. I have seen this before but can't remember where, I think it has to do with tables? Can anyone tell me how this is working and how I can change...

Hello, We just converted from Excel 2003 to 2010 and I am getting the following error "Error 1004 - Method 'SaveAs' of object_Workbook failed".. The code worked fine in 2003. The macro uses the contents of the clipboard to supply the Workbook name. and uses "DataObj.GetText" to do this. I have...

Hello, I would like to modify the formula below to get the "Baker, Tom" part of the formula from a cell like "A1" and am not quite sure how to do it? Row A contains the names of the other worksheets. =SUMPRODUCT(--('C:\Documents and Settings\MyProfile\Desktop\Meeting\Lists\[Baker...

Hi, The crappy code I made below is designed to condisionaly format on 2 columns, "Group Nmber" and "50/50 Category". Under "Group Number" I want all rows highlighted grey that are "or" contain "69472". And "50/50" I would like the entire row to be bold and italic if the cell contains either...

Hello, I'm just trying to get the concept (not on a project). In the code below, the first function defines a range and calls it "myrange". I then want to use that range in another fuction (2nd one down) to select it. I might want to do other things with this range in other functions too, not...

Hello, Below is a partial sample of conditional formatting code I have. Basically in the code I am looking for instances of "69472", but that value may not be the only number in a cell. It may show as: 2205,69472,123. I can get my code below to work only when 69472 is in the cell by itself...

Hello, I have not been here for quite some time, but I just got stuck on this one and would love any help I can get... I have the following in some VBA and want to refine it a bit "=IF(OR($bf1=""At Risk"",$Bf1=""Default: Please Reassign""),1,0)" I would like to colunm reference "$Bf1" tends...

Hello, I have a sheet that I have created an outline on, each group has a total below them. It takes the 1st columns name and adds "totals" to it and then the columns that I get totals for get brought down. There are columns that I do not run totals on and they do not get brought down to the...

Hello, I should know how to do this by now, but reporting is one of my weak spots :( My report groups: Campaign District Basic info: This is a mailing tracking database. We mail letters out and track results. The main form contains a field called "MailListSize" (number of letters sent), there...

The query has a 2 tables, one called tblMSR and it contains a field called "MailListSize" and the other table is a detail table called tblCampaigns. if the detail table only has one item then of course the "MialListSize" shows onece, but if the detail table has 2 records in it then the...

Hello, I have a some code from the following site that keeps giving me a "type mismatch" error. I have used this code with sucess quite a while ago and don't remember having this sort of problem. The code is supposed to look at column A and based on unique values make new sheets within the...

Append from multiple workbooks I have looked around and can't seem to find a solution... I have a folder with many workbooks that are all layed out the same, with 1 worksheet that has three columns of data with varied row counts. I would like to copy each workbooks contents starting at cell...

Just a general question... Is there a way to have the contents of a text file become included in a query. Say I have a list of names in a text file like: Bill Bob Chuck... Can I connect to that file and have the names be part of the query? Thank you!

Hello, At work we have Citrix which is like a shared desktop on a network. Our company will most likely be getting rid of it soon and we have many Access applications that we share. I have heard about replicating, but never used it and would like to know your thoughts on it. We currently...

Hello, I have posted this problem in the past and just haven't quite got it down yet. I think primarily because the way i explained the issue, so I going to try starting over... I have 2 tables: tblMSREntry * This has a field in it called "MSRCampaignID" (which is a number datatype)...

Hello, I have the following: 1.) qryEventsMasterReport1 << main query This consist of tblEvents 2.) qryEventsMasterReport1a << used inside of the main query This consist of a crosstab query with the General Ledger Coders I am tracking for the events and the EventID field to link the queries...

I have a combobox that has a list of values that come from a table called campaigns. What I want is to have the user choose one of the values from the list (combobox) and store that value in the data entry table (which the form is bound to). Currently as it is setup, it does exactly what I...

Hello, I am using Access 2003 and would like to design a field format (color, length...) and copy that design so that every time I lay a new field on the form it looks like the one I first designed. Kind of like "AutoFormat" but with my design. I have done this before, but just can't remember...