I found out the spreadsheet had hidden worksheets. These hidden worksheets contained the values that populated the dropdown boxes. Went to Format - Sheet - Unhide and selected each hidden worksheet. Was then able to change, update, modify the cells in the unhidden worksheets and this did the...
Thanks for the replies one and all alas still cannot find the code associated with this macro/module/worksheet. I tried every suggestion and still no go. Could I possible send/email this spreadsheet to someone willing to take a stab at finding this code.
Thanks
I'm attempting to debug a spreadsheet fm an unknown developer. On the spreadsheet are a number of dropdown objects. I right-click on one of the dropdown objects go to Assign Maco... option and see a macro name such as DropDown4_Change assigned to this object. I don't see the code for this...
Go into server - properties - security - authentication set to sql server and windows hit ok..no change still get same error...go back to server - properties notice change didn't take place windows authentication is selected - why won't change I made stay selected?
Yes using ColdFusion MX and using the default drivers when set the system dsn - problem is don't know sql server and don't know if the problem is the user set up in sql server is valid or not
Went into SQL Query Analyzer - attempted to connect to local server I can successfully connect using Windows authentication when I attempt connect using SQL Server authtentication unable to connect - getting 18452 error "Login failed for user 'user1' Not associated with trusted SQL Server...
Trying to set datasource thru CF Administrator and
getting the following error in CF Administrator:
"The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info."...
I'm using Microsoft SQL Server 2000 Developer Edition.
It's a System DSN, I've tried Windows NT authentication,
and SQL Server authentication, and used remaining default
settings.
Help - I'm getting SQL Server error 18452
Login failed for user...Not associated with a trusted
SQL Server connection.
Trying to set this DSN and connect to SQL Server db.
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.