Search results for query: *

This is difficult to explain, so I'll give an example. I have the following array of file names: Array ( [38] => CP.W.CC.0805 [39] => CP.W.CC.0812 [42] => CP.W.S.0805 [43] => CP.W.S.0812 [66] => IP.W.CC.0805 [67] => IP.W.CC.0812 [70] => IP.W.SP.0805 [71] =>...

I'm trying to do a stored procedure to update data in a couple of tables. I've written the following code: CREATE PROCEDURE procPostInvoice @InvNumber nvarchar(15) AS --SET XACT_ABORT ON --if one fails, they all fail and all data is rolled back --BEGIN TRANSACTION --GO INSERT INTO...

Can you use a SQL server stored procedure (uses one parameter) as the record source for a MDB (non-ADP) Access Report? Thanks, Rob

I am using Access 2002 SP-2 (XP) under Windows 98. I'm developing a database that will be shared and I want to enable record-level locking. If one using is editing record X (through a form), another user should have full access to every record in the underlying table except record X. I do not...

I am using Access 2002 SP-2 (XP) under Windows 98. I'm developing a database that will be shared and I want to enable record-level locking. If one using is editing record X (through a form), another user should have full access to every record in the underlying table except record X. I do not...

Assuming the following tables (fields): tblJobs (Job#, Closed, JobName, ...) tblPhases (Job#, Phase, PhaseName, PctComp, ...) tblCats (Job#, Phase, Category, MonthEnd, PctComp, ...) There is a 1-M relationship between tblCats and tblPhases based on (Job# and Phase), and between tblPhases and...

I have a report that will print line-item details of any number of timesheets, and I want a summary by Job of the jobs they worked on after each change in worker. Primary Tables: tblTSHeader (TSID, WorkerID, ...) tblTSDetail (EntryID, TSID, TSDate, JobID, HrsReg, HrsOT1, HrsOT2 ...) Sort order...