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

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...

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...

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

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

I have identified my problem but have no idea why it is occuring: - I designed a query (in design view) that calls my random function (Randomize statement followed by RND). - If I run this query from the query window everything works fine and the random numbers do not repeat themselves BUT if...

How can I move a column to the first position of an existing table using VBA? Thanks, Chris

I have a function that populates a table from an excel spreadsheet. I want to be able to prompt the user to indicate the location of the file (open a browse directory window) to be imported. Thanks, Chris

Hi I am currently using the RND function to add a random number to each record in a table in order to sort them randomly. I have read on discussion boards that the RND function is not truly random and many people seem to have had problems with it. 3 Questions: - Does anyone know what this...

Just looking for a recommendation for a good website/book for learning about writing queries & working with recordsets in SQL within an access VBA module. Thanks, Chris

I want to have a select querry from which the first x records can be appended to another empty table. x being a variable. Thanks, Chris

I have a table with 3 fields. The first is an address, the second is a destinatino address and the third field is the distance between the two. I want to group by the first address and take the Minimun for the distance column and simply display the destination address that corresponds with...

I want to automate a process where the most recently imported table's name is changed to "Example". I was also wondering if it might be possible to save the name of the most recently imported table as a variable.