Search results for query: *

Sorry experts, I thought this might be the best place to post this problem. I'm actually using VBA to find multiple windows running under XP and determine if the window is busy or not, ie waiting for user input. I have some code that can enumerate through all top level windows and identify the...

I posted this in the VBA forum thinking it was an appropriate place for the question - with the stunned silence that followed I guess maybe it was more of an API question. I'm trying to write this code in VBA but I guess it will be similar in VB. Here goes ........ I've been working on this for...

I've been working on this for the last few hours and I can't seem to get it working properly. Any advice would be appreciated. I'm trying to get Excel(2003) to print (through XP platform) to a shared network printer but select the paper source (tray) at the same time. In Excel this seems...

Hello everyone, I have a table "TREND" that has data like this :- WEEK LOCN COST === ==== ===== 45........A......10 46........A......12 47........A......15 45........B......18 46........B......16 47........B......11 45........C......13 46........C......14 47........C......10 How do I...

In Excel 2003 I'm creating a very simple area chart with a legend placed to the right of the plot area. If I move the legend to say bottom of the plot area (right mouse click and "Format Legend/Placement/Bottom") the plot area itself automatically resizes to maximise the visibility. This is good...

Hello, I'm using Crystal 9 to access an Oracle 8 Database with several hundred thousand records. I want to identify records from this database that do not exist in a specific Excel 2003 file (circa twenty thousand records). I know this is a bizzare request because of the non-index Excel sheet...

Im using Excel 2003 with VBA to extract data from one spreadsheet to another. This has been working great for sometime now using DAO and applying an SQL routine. The problem I have now is that the spreadsheet Im copying from now contains a string in a cell that is quite large (potentially...

I want to use DAO within Excel (2003) to access two other seperate Excel workbooks to merge the data. I can access the data from the two other workbooks already but not sure how to merge the data. This is a snippet of my code so far ....... Dim db1 As DAO.Database, db2 As DAO.Database Dim rs1...

In Excel 2003 is there a formula that can find the first VISIBLE cell contents from a filtered AUTOFILTER list. I want to use a command like "=FIRST(A2:A100)" and it will return the first cell that is showing from the filtered list regardless how its filtered (assuming of course some data is...

I'm using MS Outlook 2003 on a MS Exchange Server setup. I've created a Group Schedule for a small team of people (5 people). The schedule works great for managing that team in a short term view because it only allows a three month forward view ("No Information" available for future dates). How...

Im using Excel 2003 for a userform that has a MS TreeView (V6) on it. I want to color certain nodes to create differences between them. I believe there is a Backcolor and Forecolor option but I can't get them to work on the nodes. All I get is a complete blackout of the node no matter what...

Is it possible to write a SQL SELECT statement that can retrieve in-built column descriptions from an Oracle(10) database? Example: SELECT * with column_headings FROM "TABLE_NAME" Any ideas ?

Is it possible to write a SQL SELECT statement that can retrieve in-built column descriptions from an Oracle(10) database? Example: SELECT * with column_headings FROM "TABLE_NAME" Any ideas ?

In ANSI SQL is it possible to append a string field together over many records that are grouped ? Example a database list contains 10 records as follows :- number letter 1 a 1 b 1 c 2 d 2 e 3 f 3 g 3 h 3...

I hope this is the right forum for this type of question. Is it possble to return an incrementing record count with SQL. I'm using Crystal Reports 9 sql editor against an Oracle database. For example I have a simple SQL query like this ...... SELECT employee_name FROM employees which...

Is it possible to have a custom function that not only updates its own cell but another cell aswell in (Excel XP)? This example code does not work ....... Function function_test() As Boolean function_test = True Range("A1").Value = "Function Has Worked" End Function The code returns a...

This is driving me mad, any help would be appreciated. I have a listbox (multi select) on a userform in Excel 2003. The userform is presented to the user with a quick find facility to save the user scrolling through the listbox if he wants. I can make the find facility select the item in the...

Previously I had an Excel 97 file that would open a modal form (main menu), then after user interaction, open another modal form (sub menu) over the top of the original form. This would work fine in Excel 97. Now in Excel 2003 the sub menu form randomly decides if it will show over the top of...

I have a Crystal 9 report that has a running formula that puts together a dynamic array at runtime. The array collects date values. The formula is something like this .......... WhilePrintingRecords; dateVar array demand_dates; numberVar d; demand_dates[d] := date({Command.Date}); d := d + 1...

Is it possible to create an SQL command line for Crystal Reports 9 that automatically gets the current date. In Crystal Report Designer I can create a selection formula that can look up the current date (today date). When I look at the SQL statement behind the selection formula it specifically...