Search results for query: *

Anyone have experience or ideas of how to find out the last time local administrator privilege was used/escalated in Windows 7. I'm sure theres a way but kinda stumped. Thanks.

I've been using functions like datepart for years and have used to get the date part of quarter before. My question is....Why does microsoft have several interval types available for quarter (ie. q, qq, quarter). For instance datepart(q,getdate()) and datepart(qq, getdate()) and...

I recently started prepping for the 70-432: SQL Server 2008 Implementation and Maintenance exam. My plan is to use the Microsoft Self Paced training kit and the Microsoft BOL (Books OnLine) reference and of course hands on prepping. Would anyone who's passed suggest anything else? Also, Are...

I am developing a crystal report that has a graph in the report header. I also have a subreport (that contains a cross tab) in the report footer. Everything works fine but if the results of the cross tab in the subreport expands past the width of the subreport container it truncates the...

I have created a macro that formats a worksheet for the users. It runs fine in Excel 2003 and takes about 8 seconds. However when I run it in Excel 2007 it will run but takes about 2.5 minutes. Is there something I can do to make this run faster in Excel 2007? I am setting the calculate mode...

I am trying to figure out how to use a stored procedure. It is locked so I can't view the code inside the stored proc. I've understand the first 2 parameters, but the last one (cursor parameter) I can't figure out. Has anyone had experience in using Cursor Input/Ouptput parameters. I'm not...

I need some direction on writing VBA code that will do the following in Excel. When I put a value in column 2 on sheet1, If the value = "A" then have it show on sheet 2. Thanks.

I need some direction on writing VBA code that will do the following in Excel. When I put a value in column 2 on sheet1, If the value = "A" then have it show on sheet 2. Thanks.

I have an asp.net application that I need to export data from a Oracle table to excel. I am writing data to an existing excel template. I was able to do this using OLEDB, however, when I write the data to the spreadsheet it inserts all data as text. How can I do this and keep each fields...

I have an asp.net application that I am trying to push data into an excel spreadsheet in my vb codeBehind. When I add the Microsoft Excel Object Library 11.0 reference and then save or run the application I get the following error. An error occured saving the project file...

I recently added a function in my DataHandler to pull data from a database. However when I run the application and try to use the dataset that should be returned from the DataHandler I get 'Method Not Found: System.Data.DataSet DAL.DataHandler.getGLData()'. It's as though my DataHandler is not...

I have a small web application that reads from a sql server database and displays results in a data grid. Everything works fine until there is no data in the dataset. What is the best way around this. I have included the function below that reads from the dataset. Any help appreciated...

I need to be able to open a client side application (i.e. Quickbooks) from an asp.net page when user clicks a hyperlink. Can anyone help with this? I was told to post this in the javascript forum. Thank you.

I need to be able to open a client side application (i.e. Quickbooks) from an asp.net page when user clicks a hyperlink. Can anyone help with this? I didn't know if it would be better to post in this forum or the a javascript forum. Thank you.

I have a asp.net page with a vb.net backend. In my Page_Load event I have placed the following code to set focus to the password text box. It works but when I click the login button I get this error Microsoft JScript runtime error: 'document.getElementById(...)' is null or not an object. It...

When I close the main form in my application I get the following message and I don't know why I get this: "An unhandled exception of type 'System.InvalidCastException'occurred in system.windows.form.dll. Additional Information: QueryInterface for interface IConnectionPoint failed." and...

I have the following code written in vb.net behind a asp.net page. It errors (Invalid Cast) out on the line fstr = fso.OpenTextFile(fname, 2, Not fso.FileExists(fname)). Any help will be appreciated. Dim fso As Object Dim fstr As StreamWriter Dim qbTranHdr As String...

How do you use a excel com object in vb.net behind a asp.net page. I have tried using the following code but is not successful. I basically need to be able to write to a spreadsheet cell by cell from a dataset (not just push a whole datagrid out to excel). Any help is appreciated. Thanks...

I am trying to export data from a dataset in some vb script behind my asp page. When I run the code I get an error that says "Specified Cast Not Valid". This is the code I have so far. Didn't know whether to post this in the vb forum or the asp. Any help is appreciated. Thanks. Private Sub...

I am trying to export data from a dataset in some vb script behind my asp page. When I run the code I get an error that says "Specified Cast Not Valid". This is the code I have so far. Didn't know whether to post this in the vb forum or the asp. Any help is appreciated. Thanks. Private Sub...