Search results for query: *

I have a table that contains the following information: BadgeID - employee's ID # Punch - Date and Time Stamp Sequence - 1 (for in) and 2 (for out punches) There are usually 2 - 3 sets of sequences per day for each employee. I am trying to create a query that calculates the employee's time...

I am trying to delete an old project in Microsoft Project Server 2002 and I am getting a message that it is already checked out. It was only checked out by my user id and I can't find anywhere to force check it in. Any thoughts on how to force check-in a project in Microsoft Project Server...

I have created the following trigger that I am trying to use to update a work entry table for all of the work entries for a single work item (1 to many). When this trigger fires, I get the following error: Key column information is insufficient or incorrect. Too many rows were affected by...

I have an ADE file that contains some forms with some hyperlink fields. Users, however, don't have the ability to right-click in the program, so they have to manually type in the path name. Is there a setting somewhere that will allow users to right click while running an ADE file? Thanks...

Hello everybody, I have some stored procedure that move records from a production tables to archive tables and they SET IDENTITY_INSERT ON for the insert and then turn it off afterwards. The procedures do exactly what I am wanting them to do. My issue is that I would like some of the users...

Hello everybody, I have some stored procedure that move records from a production tables to archive tables and they SET IDENTITY_INSERT ON for the insert and then turn it off afterwards. The procedures do exactly what I am wanting them to do. My issue is that I would like some of the users...

I am working on an Access 2000 Project with SQL 2000 backend. I have a form that sets a textbox's value to Environ("UserName") and then uses this value to display all of the records for that user by passing the value of the textbox as the parameter for the SQL Stored Procedure. This...

I am trying to create a report that displays a single record from a table that matches the value of a text box on a form. I have a SQL Stored Procedure with the input parameter for this value. I am not sure how to pass the value from the form so that the report is populated by the appropriate...

I had a query in Microsoft Access that used the following WHERE clause to determine the rows in which to sum up. WHERE BillingDate BETWEEN #1/1/2003# and #1/31/2003# I am looking to recreate the same functionality in a SQL Server 2000 Stored Procedure and would like to make the stored...

Does anyone know how to very quickly find out the number of files in a folder including the number of files in all of its subfolders? I have been using the folder.files.count method in the FSO, but this only gives me the number of files in the top folder, not its subfolders. I know that I can...

I am looking to perform the following tasks in order to "archive" records from a production table to an archive table (both tables with the same definition) and am not sure if it would be best to do this through UDFs or Stored Procedures. -Select all of the records from the production...

I am currently creating an Access 2000 Project that ties into a SQL 2000 database. I am modeling it after an Access 2000 database that I had originally created (tables in Access). I have a form with a combo box that is populated by a query. Based on the selection in the combo box (in the form...

I exported a table from an Access 2000 Database into a text file that I am using to import into a table in SQL 2000 through DTS. I have created a format file that defines the columns in the text file and maps them to the appropriate columns in the SQL table. When I run the DTS Package, I...

Is there a way to set the backup file name in NTBackup to the current date so that if you schedule the job to run every week it will create a unique file name each time? Thanks for your help. Nickela