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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.