Search results for query: *

I have been given a Excel 2003 spreadsheet to support. This was originally developed in Excel 97. In Excel 2003 it requires a password when the workbook is opened. Apparently this was not the case in Excel 97 (I assume because of some Excel setting). Could somebody give me some guidance on how...

Could someone please tell me how I can simulate using the Back button in IE. I want to give users the option to go to the previous page, either to re-start with a clean selection or modify the existing selection (i.e. the Back button). From what I have read, the answer seems to be to use...

Could someone please tell me how I can simulate using the Back button in IE. I want to give users the option to go to the previous page, either to re-start with a clean selection or modify the existing selection (i.e. the Back button). From what I have read, the answer seems to be to use...

I am working on an Access 2003 database with a SQL Server 2005 back end. I need to run a SQL Server Stored Procedure that requires one input parameter (to run a process) and an output parameter to show whether the process was successful. I have created the SP and pass thru query but I cannot...

I need to extract the dollar and cents portions of an amount as separate integer values. I can't find a method of doing this. Any assistance would be appreciated.

I am working on an Access 2003 application where the data has been upsized to SQL Server 2005. I need to make a change to a form's processing when a new record is added. This requires inserting a record in a second table using the same key. The key for the original table is identity...

I have been trying to use the SQL Server 2005 Restore function to install a copy of a database on to my PC. The .bak file is 29MB and when the Restore started, it quite quickly reached 50%. The dat and log files appear to have been built as they have stopped growing, but the function has...

I'm a bit rusty with Access, but have an application to modify. I have two forms. One is unbound (form1) and has just a listbox (with a record key and description from table1) and a button. The other form (form2) is bound to table1 and has a textbox for each column of the table. On the...

I have come across a problem today that is most bizarre...... I have been working on an ASP.NET application (VB.NET/VS.NET) that has around 16 webpages. The three pages involved in this problem are index-user.aspx, index-supervisor.aspx and approve.aspx. When the user logs-in...

I have been trying to create a Class Library that can be used by both VB.NET and Access 2003. For VB.NET, the dll lets me view the properties and functions as expected. The problem is with Access. I went through the documented process of creating a Com Callable Wrapper and created a tlb...

It is possible to run a Windows Service that runs another program using System.Diagnostics.Process.Start? I have tested this successfully as a Windows application but when I run the same code in a similar Windows Service it will not start the process. Any suggestions would be appreciated.

I'm not sure that this is the right forum but... Does anybody know of a utility that would enable me to view the contents of a text file including any embedded characters such as carriage returns and line feeds? Obviously Wordpad and Notepad will display the text but not other characters in...

Is there a way to determine whether a specific registry key exists? I want to check whether the key exists, and if not create it. Thanks.

I am changing an application that includes a public class. I am adding a session variable that will pass between forms and hold any error messages encountered. This works fine except when it accesses the class. Then the session contents are lost. I added a watch and when it enters the class I...

I am changing an application that includes a public class. I am adding a session variable that will pass between forms and hold any error messages encountered. This works fine except when it accesses the class. Then the session contents are lost. I added a watch and when it enters the class I...

I am reading from a SQL Server table and displaying a money amount in a label on the webpage. I cannot get this to format correctly. For example I can see a record with a money amount of 1245.0000 but when I display this in the label I cannot get to to show as 1,245.00 Any assistance would...

I have a script that FTPs files to a remote server using the code below: Set objShell = CreateObject("WSCRIPT.SHELL") Set objFso = WScript.CreateObject("Scripting.FileSystemObject") Set myFile=objFso.CreateTextFile("c:\ftprun.txt", True) myFile.WriteLine "open " & strServer myFile.WriteLine...

I am using VS.NET to build an application that contains a DataGrid with a column showing images based on the path (text field) from a column in the database table (Jet 4.0). I used the Property Builder to format the DataGrid, then Edit Template (Item Template) and Data Bindings to attach the...

How is it possible to find a file's last modified date without using FileSystemObject? I ask this because my program has to run on XP and Win98, and so far as I am aware FSO will not run on Win98. Any help would be appreciated.

I have read a number of threads concerning the Scheduler (including this which is quite detailed: http://www.tek-tips.com/viewthread.cfm?qid=794484), but I cannot see how to code my program to add a scheduled task to run at a specific time daily. Do I have to setup a task for each day of the...