Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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), '/', '')...

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

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

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