Search results for query: *

Yeah, I actually found that this morning. I guess I was not typing my GOOGLE questions correctly! LOL. Thanks,

Does anyone know how to close an ADP/ADE through code? I guess I could use a shell command, but would rather have the ability to control through the code in the application, if posible.

I guess a good question to ask is if there is "one" record per form (or are you using a collection in the Continuous Forms?). If it is a Continuous form, you will not be able to conventionally lock down the record as read only. You will have to perform various checks (like in the Before_Update...

This does work, however, only on the first page. If you have more than one page, it still only shows on that first page (and not the other 2 that follow). Any ideas? You actually can use the Report Header as well (same result as I mentioned above).

Thanks again for the help Jason. I am still working with the 2.0 framework still. I made some adjustments and the code is fine. However, it did not pull the childs for my MenuStrip (which have pretty much the same properties of the parent). Doing a simple do loop on the each control will get...

I will see what i can do with this, though i did figure out another solution. One thing thoug, I did not see the method SelectMany as part of control, is that a typo?

When you say you display, you mean in Excel you are seeing that? Have you verified that font type is supported (available) in Excel? I would think that just exporting as straight text, it would not have an issue. Have you tried exporting to just a text file as well (maybe it is something with...

Need to get ALL the controls on a form. I know you are saying this is easy, well, when I say all, I really mean all (menu lists, nested trees, ect.). Currently I can grab all the top most using the Controls collection from the form. However, I need all the children as well (and childrens...

We have a "Admin Module" that a client can configure roles for the application. There is a small disconnect with what we should do in the C#.net code to handle this security. Note, this is NOT Windows Security. It is security driven off of the Admin Module and what settings are "set" for a...

This actually relates to the ADE compiled file. We have tested these files on XP machines and no issue at all. Now when we try it on a users Vista machine, get the following error: "Connection Error" -2147467259 Cannot open database "" requested by the login. The login failed Not sure what...

Nice one, way to go.

Thanks for the help guys, I found another solution that I was using. I will check out yours Duane. Thanks also Tyrone, I found some help using the qryDefs too (did not go that route though). Tim

All the times that I have ever printed more than one set of reports in the past is I have setup a loop structure and performed this the number of times that the user needs (then you dont hard code it either).

I have created a dynamic crosstab qry that works great and does exactly what I expect of it. However, I am finding it impossible to set fields in the report at runtime. Has anyone done this? I was setting the record source at runtime as well, is this incorrect? Should I set the recordsource...

DECLARE @MyTable VARCHAR(50) DECLARE @SQL NVARCHAR(MAX) DECLARE @MaxTradeDate datetime SET @SQL = N'SELECT @MaxTradeDate = MAX(StartDate) FROM ' + @myTable EXECUTE sp_executeSQL @SQL , N'@MaxTradeDate datetime OUTPUT', @MaxTradeDate OUTPUT SELECT @MaxTradeDate bborissov pretty much had it...

What do you mean manually mrdenny? exec 'spnamehere' 'parameterhere'? I did this way and executed the sp with the right click and execute. Yes I did recompile, did not help. I also dropped and recreated, thinking something maybe got screwed up in the system tables (this has happened...

We are on SQL Server 2005 SP2. I will read the log and let you know if that will help. Thanks, Rocco

Sorry, but the code is confidential information that I cannot post. I assure you the code is just copied from the stored proc and pasted in query analyzer. An idea of the code is below: SELECT Columns FROM TableA INNER JOIN TableB ON TableA.Col1 = TableB.Col1 INNER JOIN TableC ON TableA.Col2...

I have serveral stored procs that seem to be taking for ever to complete (about 50 sec). I take the same code and run the TSQL statement in query analyzer (about 1/2 sec). I have ran the estimated execution plan on both. The main thing that is different is the "Index Spool". The Stored proc...

Hey MRDenny, it is apparently due to a know bug with < SQL Server SP2. When creating a maintenance plan, I used a 10% free space (within the maintenance plan). Well, when you view the TSQL it shows a 10 Fill Factor (I did not bother checking the TSQL when I created the plans, so I would have...