Search results for query: *

Thanks everybody. I will try a couple of these things out. I appreciate the help. Nickela

I appreciate your help, Remou. SELECT tblPunch.BadgeID, tblPunch.Punch, (SELECT Punch FROM tblPunch A WHERE A.Seq = 2 AND A.BadgeID = tblPunch.BadgeID) AS Seq2Time, Format([Punch]-[seq2time],"Short Time") AS Expr1 FROM tblPunch WHERE (((tblPunch.Seq)=1)); The only...

Thanks, Remou for the tip. When I tried this, I get a message "At most 1 record can be returned from this subquery" and it doesn't show any records. Any thoughts? Thanks, again.

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

This worked perfectly. Thanks for the help. Nickela

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

When they need to access a hyperlink, they definitely can just click on it, but in order to create the hyperlink in the field, they need to type the hyperlink in manually. I am curious if there is a way to enable the ability to right click in an ADE Project. Thanks for your help. Nickela

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

I have the identity insert for entries that get restored back to the production table. Sorry for the bad description. Any thoughts?

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

Does anyone know of a "Run As" type of command that I would be able to use preceding or during the call to the stored procedure in the VBA so that the user that clicked on the button would be assigned the dbowner server role for the running of the stored procedure, but would then be...

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

Thanks for your help. Nickela

Thanks Zhavic. This definitely gets the correct dates for the range. Where would I add in some logic to make the time for the end date 23:59:59? Nickela

This particular stored procedure is used to populate a field on a report that gives the monthly progress towards a revenue goal, so at all times it the current month what is needed. Thanks for the input, though. Nickela

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