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 Rhinorhino 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: *

  1. itchyII

    Filter Array Type mismatch

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

    Filter Array Type mismatch

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

    Filter Array Type mismatch

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

    Filter Array Type mismatch

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

    Filter Array Type mismatch

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

    Excel links to MS Project file broken

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

    Normal.dotm not available in Outlook 2007 editor

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

    Normal.dotm not available in Outlook 2007 editor

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

    Where clause condition help

    That's perfect! Thanks!!!
  10. itchyII

    Where clause condition help

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

    % Allocation by week - possible?

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

    Excel Area Chart with smooth lines possible?

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

    Excel Area Chart with smooth lines possible?

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

    Getting '#Deleted' when querying ODBC table

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

    Getting '#Deleted' when querying ODBC table

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

    Getting '#Deleted' when querying ODBC table

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

    Getting '#Deleted' when querying ODBC table

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

    Getting '#Deleted' when querying ODBC table

    Same.
  19. itchyII

    Getting '#Deleted' when querying ODBC table

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

    Getting '#Deleted' when querying ODBC table

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

Part and Inventory Search

Back
Top