Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TMRO
  • Content: Threads
  • Order by date
  1. TMRO

    To add a subreport

    Hi, I would like to add a subreport at the end of the main report. But I don't want the subreport to have the page - report header/ page - report footer. How can I accomplish this? Thank you
  2. TMRO

    NL file extension

    Hi guys, anybody knows what the nl file extension stands for? I have seen this extension on websites before like app/site/backend/setshoppercurrency.nl but I don;t know for what programming language or OS stands for. Thx a lot
  3. TMRO

    query to change the column type

    hi all, i need to write a query to change a column type from int to int identity (1,1) How do I do that? Thx
  4. TMRO

    Formating Parameter

    Hi, I have a parameter for a report, that is actually the paramter that I sent to the stored procedure that will bring the data in CR. In the SP I declared the parameter as integer but When I run the report in the windows box the parameter has 4 decimals (4 zero's). How can I remove the default...
  5. TMRO

    Formating formula

    Hi, I have a formula with this underlying code: if isnull({sp_not_expired.QTY}) then formula = "" else formula = CStr({sp_not_expired.QTY}) end if where sp_not_expired is a stored procedure and QTY a numeric field, which I don't want to display if it's null. Now when I display the...
  6. TMRO

    Radiobutton List

    Hi everybody, I'm populating a radiobutton list through C# code. for (int i = 1; i <= 40; i++) { rbnlstep2.Items.Add(new ListItem(i.ToString())); } The issue that I have is that the radiobuttons are displayed in this format: 1 radiobutton 2 radiobutton ... 40...
  7. TMRO

    Visual Studio Educational Edition

    Hi guys, anybody knows to which edition is the educational edition VS 2005 similar? To Standard / Professional? What are the difference? I tried to find it on the web with no luck. Thanks, TMRO
  8. TMRO

    Job to create a folder and copy a file

    Hi, I need to create a job in SQL 2000 that will copy a specified file in a specified directory. If that directory doens't exist then it should create it. Is this possible in SQL? Thanks, TMRO
  9. TMRO

    Finding weekends in a time interval

    Hi guys, anybody knows a function to calculate how many saturdays or any other day are in a time interval? I need to find out the number of working days in a variable time interval. Thank you, TMRO
  10. TMRO

    Returning many records Timeout

    Hi guys, I trying to return a lot of records (the table holds 30,000,000 records) from the MS SQL. The lines to call the stored procedure are as follow: set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionTimeout = 0 conn.CommandTimeout = 0 set objrs =...
  11. TMRO

    Formating Emails Body sent with xp_sendmail

    Hi, I'm using xp_sendmail to send automatically emails from SQL Server 2000, regarding different status from the main database. Is there a way to format the email body so that it looks more friendly? Like breaklines / hyperlinks / bold ??? Thank you
  12. TMRO

    Returning Record Set

    Hi guys, I'm calling in my asp page a stored procedure with 2 parameters. Here is the code set cn = Server.CreateObject("ADODB.Connection") cn.CursorLocation = adUseClient cn.Open "Provider=SQLOLEDB;Server=servername;Database=DB;UID=user;PWD=password" set rsresults =...
  13. TMRO

    Remeber Password in XP

    Hi, We are using web applications in our intranet where in order to access them, users have to authenticate themselves. So, when they access the internet address, they have to enter username & password. (integrated windows authentication from IIS). They have the option to remember password...
  14. TMRO

    Fields overlapping

    Hi everybody, I have 2 fields in my report. (actually there are more, just for explanation is easier to use only 2) The top one has to option "can grow" checked. Underneath is the 2nd field. If the top field grows (10 rows), this field is overlapping the 2nd field that was underneath it...
  15. TMRO

    If inside the Cursor statement

    Hi everybody, I need to declare a cursor but depending on the current day the select statement is different (the where condition actually is different). declare cursorname cursor for if @day = '1' begin select a, b, c from table where ... end if @day = '2' begin...
  16. TMRO

    DB Owner

    Hi everybody, I created a new user in the SQL 2000 in the Security --> Logins area and I assign that user to be db_owner to a specific database. Now, if I go to any table from the above mentioned database and view the permission for that table, you notice that the newly created user doesn't...
  17. TMRO

    Special Software Voice - Text

    Hi guys, Anybody of you knows a software that will transcribe a .wav file into a word document? Thank you TMRO
  18. TMRO

    NEW Session Variable

    Hi everybody, I have designed a shopping basket. The Order ID is stored in a session variable. What I noticed is that if users right click on a link while they browse my application and choose "open link in a new window" the Order ID will stay the same in the new opened window. So to say...
  19. TMRO

    Contact Card

    Hi everybody, I have a problem here (kind of strange) and I don't know if it's possible. When you open a contact card in Outlook under the general tab bellow the full name field there is another field called: job title. Is there a way to remove this field and put another one like "shoe...
  20. TMRO

    Partition Resize

    Hi guys, I'm looking for a software that should resize / reduce partitions on a Windows 2000 Server. I noticed that PArtition Magic 8.0 doens't support Windows 2000 Server or Windows NT Server. Any ideas? Thx, TMRO

Part and Inventory Search

Back
Top