Search results for query: *

Skip, Thanks for the quick response. Odd thing is now that I am goign back into the worksheet after closing EXCEL it all works fine. Sorry for the trouble.

thread707-1606291 My first attempt at VBA includes a combo box that starting today has the text within the box getting smaller and smaller everytime it is selected. I have tried changing the Autotsize properties from Tur to Fals with no change. Here is the code: Private Sub...

I can't get Outlook to open to check that. It will start to load the profile, then a user name and password window pops up, that I fill in, then the error that "the exchange connection is not available" and a pop up opens to enter the exchange serve info again to check the name. Another "Name...

Issue: Cannot set up new e-mail profile for Outlook 2010 Windows 7 operating system on hosted Outlook Exchange 2007 server at GoDaddy.com. I enter all the parameters exactly as described by the GoDaddy support team, but the error always comes up "Outlook must be online to connect". The supprt...

We are just starting to use shared tasks for our project managmente teams. Can't seem to be able to add notes to the body of a shared task. We have given author permissions to all share parties by name.

We lost a terminal server and had it rebuilt by someone unfamiliar with the active directory. terminal server is windows 2000 SP 4 sql server is on an NT 4.0 Access 2002 SP 3 SQL 6.0 We now cannot get an ADP project, existing or new to connect to our sql server. We are able to locate the...

Amiel, To be clear, I have a data sheet with approx 1500 rows of scheduled tasks, each having eight columns (fields) of data per task. I want to be able to list the tasks scheduled for each day of a 4 week period in a way that keeps all eight fields of data together. Curently I have use 4...

I do not need it to be able to update. A slave file would be fine, but it has to be current to the master file. I have posted in the excel forum, but the only answer has been to install the borland ODBC engine. The queries are the stumbling block, I use them to pull out a list of tasks to be...

No I am opening it manually with the password necessary for write priveledges. There may be another network user with the file open in read only mode. I just now thought of that but it does not effect the operator generated attempt at saving the file.

I am a novice programmer trying to write a macro to save a write protected fil. The macro is activiated through a control box, after the file has been opened with read/write priviledge. I get an error saying file is write reserved. Here is tha code for the save, that was recorded through...

Zack, That identifies unique projects , but the G2 value is doing wierd things when there are not more than one project in the week, I can use your unique project field as criteria for a sumif function, which I can then also set for each weeknum. I will set up summary fields with the sumif...

Sorry, I am trying to do too many things at once as evidence by my previous posts. Based on the sample data there are 3 jobs total $500. I can add whatever "helper" columns needed to the data. There are "duplicate" entries since we send the same price to multiple contractors. Your...

While you are in the folders tab that xlhelp suggested, make sure all the other excel file extensions are opening with excel. someone may have saved one of your files as html at one time and no one has ever changed it back.

Actually pivot tables as I am using them do not solve my problem, they are still adding the same job multiple times.

Geoff, For the record I took your advice and looked at other ways to structure the pivot table. By using the contractor as the row, and the week as the column I get the info I need, thought not in the format I originally intended. Thanks again for the quick response.

Geof, I have, but I end up with the same problem, columns of weeks, rows of projects, sum of $ in table, What am I doing wrong?

I have a bid list that may list multiple entries for the same project. bid date project $ contractor 5/12 a 100 abc const 5/12 a 100 bcd const 5/14 b 300 abc const 5/16 c 100 bcd const I need to know the total number of unique...

We share on the network an excel 2000 version 9.0 file that uses MS Query within the workbook. We have protected write permissions using the tools/options/password to modify command. When ever a user has the file open with the password to modify only the file creator can access the file. All...

Thanks Geof, I thought that the "format as text" also converted the numbers to strings. I guess I was wrong.

I have mixed data in a field that is queried from a excel 2000 table. Even after formating the cells as text, the cells that are inputted as numbers do not display in the query results. Only after I insert the ' prefix in the data field do they display. Is there a setting somwhere to modify this?