Search results for query: *

Thanks. I will try it with the array. I think it will be faster (although seemingly tedious!)

Hmmmm.... What would be more efficient?. The array would hold aproximately 10000 entries and I will be searching the array approximately 10000 times. Would it be more efficient to populate the array once through iteration and then use the 'Filter' function for the 10000 search items, or loop...

Ok, so I guess I have no choice to iterate through the column to populate my array.....arghh.....

Hi, thanks for the response. Thats it. I just explicitly set the dimensions of the array before loading it and now I get the error on the loading of the array with my range of data. So, the question now is, how come it sees my named range as multi-dimensional? It's only one column! I tried...

Hi all, I am trying to populate an array with a named range in Excel and then search the array for a value. All I have read on it has suggested that I should be able to use the 'Filter' funtion to accomplish this, but I keep getting a Type Mismatch error. As I understand it, the search...

Hi All, I have an Excel file (Excel 2007) that has links to an MS Project file (Project 2003). Both files are stored on a Sharepoint site in the same directory. When I first created the links, everything was fine, and the vales from the project file were properly linked and showing...

Sorry for the late response, but thank you. OK, so I figured I could just copy my macros to a module in the normalemail.dotm file and then access them from the email editor, but unless I am doing something wrong, this still doesn't work. I opened the normalemail.dotm file and added a new...

Hi All, I have just upgraded to Office 2007 and I am trying to figure out why my macros setup in Word 2007 (Normal.dotm file) are not available to be used in my Outlook 2007 email editor. Word is the email editor, so I don't understand why I cannot access them. I've gone through all the...

That's perfect! Thanks!!!

Hi All, I am pretty new to SQL. I have a simple query, and I am trying to figure out how to add a condition to my where clause. The query looks something like this: SELECT tblItem.fldItemId, tblItem.fldInDate, tblItem.fldStartDate, tblItem.fldSchStart, tblItem.fldScopeId FROM...

Hi Everyone, Before I spend hours trying to figure this out, maybe someone has a quick answer. I have a project with multiple tasks and multiple resources assigned to multiple tasks during a given week. (My schedules tasks are fixed duration) For instance, Res1 is assigned to a task that is...

Thanks! I will keep this for reference. In the mean time, I have not found a solution. I may have to explore another app....

Hi Everyone, Does anyone know if it is possible to create an area graph that has smooth lines instead of jagged ones? I've searched everywhere and can't find any information on it. I will explain what I am trying to achieve as maybe there is another way. I have many series of data. I plot them...

Yeah! tell me about it! The problem is this app is not home grown. And we have no control over the original table structure. I would agree that this is probably not the best way to do this, but changing procedures around here is like like trying to get the govt to reduce taxes! But why...

Good morning hovercraft, If I open the ODBC table directly, I get the same problem. I took a look at the link you provided and saw some interesting information, but I'm not sure it really applies here. The table I am looking at is, for all practical purposes, read only. This table only gets...

Hi Everyone, thanks for the replies. BPhilb - already checked this, its not the case. hovercreaft - the table I am talking about is an archive table. The only updating that takes place is once an hour when they drop the table and reload it. PHV - I'm not sure what you mean by 'NO BitField'...

That is not the case here, there are no nulls in the key field. Thanks anyway!

Same.

Yes, the table does have a primary key but it does not change from the previous days dump. I wouls only see new records with new primary keys.

Hi Everyone, Does anyone know why I get '#Deleted' for all fields and all records when I am querying a certain ODBC (SQL server) table? The query is a simple select query with only the one table. The table is on SQL server and I have other tables on the same server that I query without this...