Search results for query: *

I'm using RS2008 R2. I've created a report that has Action:Go to URL expressions. The expressions link to another report detail that render directly to Excel and work just fine. The issue I'm having is coding the expression to work in all three of our deployment environments. We have a...

I'm not certain this can be done so I'm posting the question to see if anyone can respond with a possible solution. Since describing what I want to do is somewhat confusing I'll try to define it with an example. Here is what I want my code to look like when using the Helper Class: Dim...

I've researched the heck out of this one and cannot find a solution using the DataGridView control. Using VS2005 I'm trying to display one of two Icons in a datagridview control column based on the boolean value of the columns row data. The data source is based on a Person table with a Name...

I'm not certain if this can be done so I'm wondering if anyone has been able to do this. I want to use the Highlight (No Highlight) toolbar menu item in my application. It's found in MS Word, under the Formatting toolbar. When selected it allows the user to select one of several color...

I'm new with .NET and trying to figure out the use of encryption. I've created an app that utilizes XML as a data source and I want to learn how best to encrypt the xml file. What I'm missing in this code is the ability to shut the application down and run it again later without losing the...

I've got a weird problem to address and after numerous attempts trying to solve this using Visual Studio 2005 I've nearly given up. Please note I am a beginner to VB.NET. Problem Defined: Given an .xls file containing contact data from MS Outlook (Export the contact list to an excel file). I...

I need some help creating a function that will return a string formated like hh:mm:ss. The function will have two parameters and is set up as follows... Create Function ftnGetElapsedTime(@x_StartDate DATETIME, @x_EndDate DATETIME) Returns CHAR(08) The business logic excludes "Off" hours in...

Problem: I've been asked to determine if it's possible to read the "Out Of Office" status of Outlook users. The point here is that we've got Help Desk operators using Help Desk software. They take in calls and assign technicians to handle the problem. I want to check to see if the technician...

I've got a unique problem I need to address and would appreciate some assistance if possible for solving this problem. Scenario: Retail Store(s) having 2 or more workstations + 1 server computer. Access97 database located on server computer. Workstations have an front end application that...

What would be the easiest way to determine if a valid internet connection exists? I've got an A2K app that utilizes FTP commands to send a file to a remote site address. I use a Shell Object to execute a .bat file. The shell object returns a result which I can use to determine success or...

I need to dynamically populate a table with a date range given two date variables. Any ideas on how this can be done??? I would like to create a stored procedure that accepts two date parameters. The first parameter is 'FromDate', and the second parameter is 'ToDate'. I'd like to start by...

I'm finding it difficult to find information on retrieving directory information from a known FTP site. Could someone please assist me in accomplishing the following while using VB6.0... Goal: Create a text file on my C:\ drive that lists the file names of files located in a particular FTP...

I'm looking for help in creating a text file that lists all the programs on a computer listed in 'Add/Remove Programs' (In the Control Panel) I'd like to use VB or VBS to do this for the purpose of auditing some of the content of our remote workstation and server computers. Any thoughts or...

I've been assigned a project that involves the following steps... Step 1 - Create recordset returning unique Store Numbers from SQL server database. Step 2 - For each store number, create a new database and name it the same as the new database. Step 3 - Create two local tables in the new...

I am attempting to run a DTS package in SQL7.0 from code in ACCESS2000. Is this possible? Here is my situation. I create 13 .txt files in Access using a loop structure for over 200 branches. Each loop creates 13 .txt files of branch data. What I want to do is execute a pre-existing DTS...

I am attempting to run a DTS package in SQL7.0 from code in ACCESS2000. Is this possible? Here is my situation. I create 13 .txt files in Access using a loop structure for over 200 branches. Each loop creates 13 .txt files of branch data. What I want to do is execute a pre-existing DTS...

I'm trying to send by e-mail a query result. I'm using the following code but keep getting an error. Any advise on what I can do to resolve the problem. All declarations are complete... DoCmd.SendObject acSendQuery, "qry_EMail_Changes", acFormatXLS, strEMailAddress, , ...

I've searched all the previous Questions regarding 'Rounding' and could not find an answer to my problem. I have to calculate a number of points based on the difference between two sales totals. The points are calculated as follows... For each $1000 difference in sales between current year...

I've got an Error Handling routine that I call from my program sub's and function's. One of the routine's parameters ( a string) is the name of the sub or function from which it is called. For example... Private Sub button1_OnClick() On Error Goto HandleError ' code here Exit_Gracefully...

I'm trying to create a pass-through query in Access2000 that will allow me to EXEC a stored procedure in SQL7.0 that accepts a parameter from a txt field on one of my forms. In the pass-through query, I know that the syntax must be like this... EXEC sp_GetData 'Variable' The problem is...