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!

  • Congratulations Chriss Miller 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: itchyII
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. itchyII

    TransferSpreadsheet to specific sheet problem

    Hi Everyone, OK, this is driving me crazy. I am trying to export a query to an existing Excel spreadsheet on a specific worksheet. I first clear the data on the worksheet (this works fine), then I transfer the spreadsheet. I am using the range parameter of the transfer spreadsheet action to...
  9. itchyII

    Automatic reallocation of work hours in resource graph

    Hi Everyone, I have a project 2000 file with my projects and tasks are assigned to resources. I am using fixed work, therefore I have hours assigned to tasks and the duration can vary allowing for proper resource allocation. My problem is this. If I have a task that was set to 8 hours over...
  10. itchyII

    Can’t set the LimitToList property to no...

    Hi everyone, I posted this on the other VBA forum last week and got no response, maybe someone here would be better to answer.... Hello All, I have an Access 2000 database. I have a form that schedules events and on it I have a combo box that is populated by a query. The query filters...
  11. itchyII

    Query criteria from function giving problems...

    Hello all, I have an interesting problem. I am running Access 2003. I have a form that has a listbox. The listbox contains a set list of values (department numbers) and the Multi Select option is set to “Extended”. The purpose of the list box is so that the user can select one or many of...
  12. itchyII

    Can't set LimitToList property to no

    Hello All, I have an Access 2000 database. I have a form that schedules events and on it I have a combo box that is populated by a query. The query filters out any team names that are already assigned to an event at the selected time (another box on the form that gets populated before my...
  13. itchyII

    ActiveX Script to copy file

    Hello all, I am new to dts and I am trying to copy a file from one location on a server to another location on another server. I was told that I could do this using an Activex scripting task. I also want to append the date to the filename of the destination file. The problem with what I have...
  14. itchyII

    Run exe on a different server thru Shell

    Hi Everyone, I am in the process of automating an existing Access (2000) application. There is a series of about 50 queries that must be run in sequence, then an export of some data, a few FoxPro exe's that are run on the exported data, then a re-import of the data and a few more queries to...
  15. itchyII

    ADO run make table query with parameter

    Hello All, I have been asked to automate (in order to run as scheduled task) a multistep process in an Access application. The application was built entirely using the Access gui with about 50 queries and 50 tables. There are a series of queries that must be run and those queries call other...
  16. itchyII

    Access 2003 & Access 97 co-existance problem?

    Hello all, I recently got a new computer and have both Office 2003 (full package) and Access 97 installed. (Installed 97 first and then 2003) The reason being is that I have may client DB's that were created in 97 and they are not ready to convert to 2003. The problem that I have is an...
  17. itchyII

    Excel 2003 problem

    Hi Everyone, I have a worksbook that I created in Excel 2000. There is alot of code and charts. I have a button that I click to calculate the entire workbook. The problem is that in Excel 2000, the cells are recalculated and the charts refresh automatically. In 2003, the cells are...
  18. itchyII

    Return the chart number of a named chart

    Hello all, How can I retrieve the chart numbet of a named chart. If I have a chart named 'Public', I want to know what the chart number is. Or better still, how could I set the source data of a chart using the name of the chart to identify it. I currently have...
  19. itchyII

    Detect which form button has been clicked(Excel)

    Hi Everyone, I have an Excel 2000 spreadsheet. The first sheet in the workbook is kind of a 'Control Sheet'. It has numerous Excel form buttons (right on the page). There is a button for printing each report (the reports are basically other worksheets with al kinds of graphs). The code for...
  20. itchyII

    Excel Scatter Chart - X-axis with Months?

    Hi Everyone, I have a little bit of a problem. I am using Excel 2000 and I need to create a chart. I have data that consists of Projects, Dates, and averages. I need to plot these on a chart, in a realistic manner and have the chart plot a trend line. I have chosen to do this using a scatter...

Part and Inventory Search

Back
Top