Search results for query: *

I have a system in which I scan in signature cards (sigcards). These sig cards have keywords on them called CIFKey. They can have one or more CIFKeys on them. The docnum for the sig card is stored in one table and the keywords are stored in another and linked by docnum. So I have a...

I have a table with Acct #'s and CIF #'s. Some Accts have multiple customers associated with them (ie. Husband and wife). See Example below. example: Acct# CIF# 123 CIF01 123 CIF02 345 CIF01 567 CIF03 789 CIF02 789 CIF03 We have an imaging system where we scan in Signature...

following is some sample asp code: Dim docProperties On Error Resume Next set docProperties = documentDataProvider.GetDocumentProperties( docID, requestProperties ) If Err.number <> 0 Then Err.Clear On Error Goto 0 webService.PresentError response, documentDataProvider...

I'm not sure what I did but when I went to setup a web share for our wwwinc directory I accidently put in &quot;/include&quot; with the forward slash. This somehow caused the alias/share to be hidden or something because now when I try to reshare the wwwinc directory as &quot;include&quot; a...

I created the following (simple) Stored Procedure. The real one is a lot more detailed but I created this simple one to make sure that it worked CREATE PROCEDURE spTest AS Create Table #Date ( Branch int, ) INSERT INTO #Data (Branch) (SELECT Branch FROM tblSalesInc) SELECT Branch from...

I have a form, let's say for simplicity sake, with 2 input fields <input type=&quot;text&quot; name=&quot;empNum&quot; onchange=&quot;empName.value=GetUserName(this.value)&quot;> <input type=&quot;text&quot; name=&quot;empName&quot;> Now i have a db that stores all the employee information...

I'm running MSSQL 2000 and trying to link to an Access 97 database on a separate Novell Server. It seems that everything I've read says that the Access db needs to reside locally on the SQL Server. Is there anyway around this?? I have 24 db's that are downloaded on a nightly basis from our...

I want to write an SQL Pass Through query that takes records from an Access database and inserts them into my SQL Database. I know I can write an Append query or do a db.execute (&quot;Insert....&quot;), but from what I've read, the only way I can use qdf.execute dbRunAsync is if I'm using and...

I have 24 facilities in which we download a journal.mdb every night. In the morning I run a program that I wrote in VB that consolidates all 24 journal.mdb files into one file. This creates one big journal.mdb file which has anywhere from 15-20,000 records in it. I added to my VB program a...

I made 2 simple changes to my stored procedure and now it takes 3 times as long to run it. Here is the part of the code where I've made the changes: Here was my code before: CREATE PROCEDURE spStaffingModelsRpt ( @StartDate datetime, @EndDate datetime ) AS CREATE TABLE #Data (...

I created a stored procedure called spStaffingModelsRpt that passes the name of the month as @Month. I then create a #Temporary table that selects records from the @Month table but it will not allow me to use @Month in the FROM Clause. I saw another posting that said to create the SQL statment...

I was wondering if there was a way to show the progress of a file being copied whether through the status bar or through a created form. We copy files across a WAN and these files are about 4 mb a piece and takes about 3 minutes to copy each of them over to our main office and it would be nice...

I work for a bank and every night we have a program that connects to all 24 branches and downloads a file called 'Journal.mdb'. When I come to work in the morning I need to check all the date & time stamps of the files to make sure that they are yesterday's date and the time is after 5:00 PM...