Search results for query: *

I am running Win2k Server and can't get IIS working. I have tried restarting it and everything seems to be running fine but when I try to view a page I get: Bad Gateway The following error occurred: A DNS lookup error occurred. The host was not found. Any ideas? Thanks, Chris

Rob, I think that the "Missing: MS Office XP Web Components" reference may have been causing the problems...I don't understand why but this seems to have been affecting many common functions. I'll try running it again tomorrow morning on the PCs which gave me grief and I'll let you...

p.s. Thanks for all of your help!

Hi Rob, I'm going nuts over here :-). I installed XL2000 on my home PC and the app runs fine... The problem seems to vary by PC (XL install). The code that wasn't working on the 2 other PCs at work includes what I posted earlier but also it does not recognize the "str" command...

Hi Rob, I just ran the app on 2 PCs with XL 2000 and each time I get strange erros such as XL not recognizing the "str" function... Is something wrong with the libraries? Chris

Hi Rob, The was "An Error Occured in a Hidden Module" of something along those lines...it was on someone else's PC so I need to play around with it as soon as I find a PC with Excel 2000 on it :-). About the button, I know that placing it on the main menu bar is unorthodox but it...

Hi, I have developed an application in Excel XP which causes several errors when run on an earlier version of Excel. The first error occurs in the auto_run macro where I attempt to create a button with the following code: Set bb = Application.CommandBars(1).Controls.Add(msoControlButton)...

Hi, I have a user form which has several text boxes linked to spreadsheet cells via their Data Control property. The problem I am having is displaying formating in the textbox as it appears on the spreasheet. For example the spreadsheet contains a cell with 45%, in the text box this appears...

That's perfect - thanks Rob. I'm assuming the icon represented for a given FaceID differs from PC to PC (based on what is installed), is this the case?

Hi, I would like to create an Excel file that, when opened, a few custom buttons are created, renamed and new icons selected. I have been able to create the buttons with the macro but I don't know how the make the macro change & show the button name and change the button's picture to...

I have made arrangements to try and get a copy of the original database. Unfortunately it does not have any of the changes or data manipulation I have done. I wish I had a backup but this company is determined to cut IT spending at any cost... Thank you for your quick responses guys. Chris

Hi, I was updating a table when my server crashed. Once the server was back online I could not access the database so I tried detaching it. Now when I try to re-attach it I get error message 823 (torn page). The help file says to restore the database from a back-up but this is unfortunately...

Hi, I am running a Dell PowerEdge 6400 server with 2 Gig of RAM. For the last few days about 50% of this RAM has been chewed-up by the SQL Server Service Manager - without any queries being run. Any ideas why this could be and how I can remedy it? Thanks, Chris

Is there a way to have a macro execute everytime the value in a given cell is changed??? Thanks, Chris

Hi, I have a column with numbers in it but the data type is text. I would like to take the numerial value of these and update them into another (numeric) column. In Access I would use the VAL function...what can I use in SQL Server? Thank you, Chris

Hi, When trying to import data from an excel spreadsheet I always have to open the excel file in order for it to work. Any suggestions? Chris

Thanks a lot Rick - I can't believe I missed that! Chris

I know that TEXT is valid because the statement worked when I put an actual string in it. The variable contains one of several CMSA (Consolidated Metropolitan Statistical Area) names. e.g. "Denver-Boulder-Greeley, CO". Any thoughts? Thanks, Chris

Hi, I want to do the following: dbs.execute "ALTER TABLE example " _ & "ADD COLUMN " & Variable & " TEXT;" I get a syntax error. Any suggestions? Thanks, Chris

Thank you! I put the randomize statment in the button code and it seems to have fixed the problem. The button has the randomize and then calls the query that uses the random function. I'm not positive that the randomize statement is carrying over to the function but it seems to be ok. I...