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: fmt
  • Content: Threads
  • Order by date
  1. fmt

    DTS Global variable

    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...
  2. fmt

    Auto email the report

    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
  3. fmt

    Refresh button

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

    Stored Procedure

    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
  5. fmt

    select duplicates

    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...
  6. fmt

    Number records in detail

    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
  7. fmt

    Place holder

    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
  8. fmt

    Dynamic controls

    Hello, I have created few dynamic text controls and I have a button which becomes visible when these controls are created. After I enter some text and press button, my text in dynamic text boxes is diappearing. Please advice Thanks
  9. fmt

    Dynamic controls

    Hello, I have sql table which stores controlnames and control types controltype controlname TextBox txt1 TextBox txt2 I want to give controlids dynamically from controlname but I am getting stuck when I am looping through controls,please advice.here is code private void...
  10. fmt

    Best way to check authentication

    Hello, I have three domains and one security group. What is the best way to check if the users are 1. members in all the three domains 2. members of security group? Thanks
  11. fmt

    Users in domain

    Hello, How do we find if logon user is member of particular domain? Thanks
  12. fmt

    Users in group LDAP

    Hello, How do determine if user is member of a particular group using LDAP Thanks
  13. fmt

    Windows user account

    Hello, I have simple C# Windows Application. How do I get windows user account in order to build security to this app. I am trying to get windows user login and check if they belong to particular security group and give them access to application thereafter. Thanks
  14. fmt

    split database

    Hello, I have a problem. We split an access database and have backend on a netwrokdrive and frontend part of it on users c:\drive. someone moved the backend to different network drive. Now the frontend part is looking for backend part of it in previous drive and cant find it. How can we fix this...
  15. fmt

    Email access report/excel format

    Hello, I have an access report which is exported to excel and emailed using DoCmd.SendObject acSendReport, strReport, acFormatXLS, , , , cboCenter & _ " - " & "Aging Report - Excel", , False Can we send multiple access reports in same email in excel format? Thanks
  16. fmt

    subreport different page

    Hello, How can I make subreport print on a different page? I have two subreports in report footer. Thanks
  17. fmt

    xp_cmdshell

    Hello, I have this statement to copy file from location a to location b. I ran this in query analyser, it says file copied but i dont see file in destination folder.Please advice. Here is code. DECLARE @fn char(6), @cmd varchar(100) SET @fn = REPLACE(CONVERT(char(8), getdate(), 1), '/', '')...
  18. fmt

    export to rtf

    Hello, I have access report which has somecolumns in page1 and rest of columns in page 2. When I export this to word, i see all the column,but when I print it, it only prints one page.Please advice. Thanks
  19. fmt

    Horizontal report

    Hello, How do I get details in access report with groups to print horizontally rather than vertically group1 a1 a2 a3 group2 b1 b2 to print like below group1 group2 a1 b1 a2 b2 a3
  20. fmt

    export to excel

    Hello, I am trying to export an access report to excel.Access has subreport in report header. I cannot see subreport in execl.Any suggestions? Thanks

Part and Inventory Search

Back
Top