Recent content by fmt

Hello, I have a stotred procedure which grabs the parameter value from a table in a loop. I need to execute dts package and pass this parameter to it. I created a global variable and used the following sql statement declare @run_me varchar(1000) set @run_me = 'dtsrun /S devsql2k /U...

Thanks a lot... will try this..

Hello, I am using Access2000 and we generate report every morning and email it to different people. Is there anyway to automate this process. Run the report at scheduled time and email to recepients? Thanks

Sorry about that... I am using Crystal 10. The other buttons I see are export,showhidegroup tree and print. Thanks

Hello, I just added a report to crystal enterprise but cannot see refresh button. Please advice. Thanks

Hello, I have a report running off of stored procedure.The report works fine on some computers but not on others. The stored procedure istiming out on computers where report doesnt run.Any advice??/ I am running access 2000. Thanks

Thanks cLFlaVA !!! but I have one more field to be selected. If I select that field the results are not same. Date Tag1 Tag2 2005-10-08 09:00:00.000 0 0 2005-10-08 09:00:00.000 1 1 2005-10-08 09:15:00.000 0 0 2005-10-08 09:15:00.000 1 0 2005-10-08...

Hello, How do I get max tag1 for given distict dates? DATE TAG1 2005-10-08 06:15:00.000 0 2005-10-08 06:15:00.000 1 2005-10-08 06:30:00.000 0 2005-10-08 06:30:00.000 1 2005-10-08 06:45:00.000 1 2005-10-08 07:00:00.000 0...

Thanks dhookom , pampers....That worked

Hello, How do we number records in detail section?something like office center 1. td la 2. th chicago 3 tj phoenix 4 tk scity Thanks

Thanks RTomes for your time. I will try that. Thanks ca8msm for your suggestion.

Thanks...Here is code ASP.NET <TABLE> <TR> <TD align=center> <asp:PlaceHolder id="phControl" runat="server"></asp:PlaceHolder></TD> </TR> <TR> <TD> <asp:Button id="btnPrint" tabIndex="8" runat="server" Text="Print"></asp:Button></TD> </TR> </TABLE> C#...

Hello, I have place holder in my form in a table row. I am adding dynamic controls as a table inside the palace holder. The controls add fine, but theres empty space before table.The place holder shows a big space and then table with controls. Any idea why this is happening? Thanks

Request.servervariables(logon_user)

Thanks tgreer. I sure will try.