Search results for query: *

I'm trying to write an application that 'hosts' an application within itself... I want to run the IBM ISeries emulator software, however, I would like to have my own UI that provides a couple buttons below the actual application. So basically, I would like to write a .NET app that provides a UI...

The Default Property is not a static value and changes dynamically with each input from the user. D

Yes, I know that, but how can I set the Default Property of a textbox via VBA, and not manually through Access? D

Hey guys, I have a simple form that interfaces a table with the following fields: License, Vehicle_Make, Vehicle_Type, Vehicle_Color, Time, Direction, Vehicle_Markings, Misc, Location The user enters data in each field and then proceeds to the next record to do the same. I would like for the...

Hey guys, I need to parse a SQL query within a stored procedure to check the syntax and see if it is a valid query. If it isn't, the error will go in an OUTPUT variable. However, I'm having trouble parsing a string within the stored procedure because SET PARSEONLY ON isn't work. It tells me...

Sorry needed to bump this thread because we still can't figure out this issue! Does anyone have an idea what could be going on? Thanks Dustin

Can you think of anything else it might be? Dustin

Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\Documents and Settings\dlyons>dir \\devweb\upload\AmazonQue\test_7_7_2005_9_ 2_12.xls Volume in drive \\devweb\upload has no label. Volume Serial Number is 0251-237B Directory of \\devweb\upload\AmazonQue...

Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. Same error. I...

(1 row(s) affected) (1 row(s) affected) (0 row(s) affected) (1 row(s) affected) (0 row(s) affected) (1 row(s) affected) INSERT INTO tblQueItem SELECT e.ISBN, 121, "A" FROM ExcelSource...Sheet1$ e LEFT OUTER JOIN tblQueItem q ON q.chrISBN = e.ISBN WHERE...

No, sorry that is commented out. It appears on two lines because of the limits on my post. However, in the code those are commented out. What is running is: -- Build insert string SET @SQLstring = 'INSERT INTO tblQueItem SELECT e.ISBN, ' + cast(@intQueID as varchar(128)) + ', "A"...

Hi guys, I am trying to run the following code: -- local variables DECLARE @Worksheet AS varchar(255) DECLARE @SQLString AS varchar(255) DECLARE @RC int DECLARE @server nvarchar(128) DECLARE @srvproduct nvarchar(128) DECLARE @provider nvarchar(128) DECLARE @datasrc nvarchar(4000) DECLARE...

Hey guys, I was wondering if anyone could help me in the right direction. I have a query that returns many results. I would like to create a form that has 4-5 textboxes/comboboxes that are used to select the criteria for the query. I guess they would be establishing a filter for the query and...

Hey guys, I need to check on load of a form if the database is already open by another user. If it is, I need any subsequent tries to open the database to only open it as READ ONLY and tell the user what the Windows username is of the person logged in. How is this possible? What do I need to...

.ConnectionString = "Data Source=devcat;Initial Catalog=abc_AmazonQue;user ID=IntranetUser; password=IntranetUser; application name=AmazonQue" When I do a 'pooling=false' in the CONNECTION_STRING i don't have the problem anymore. When it is 'true', we step through the code, see the connection...

Hey guys, I have a VB.NET app connecting to SQL Server. We are having a strange problem where we will step through our code, watch connections being open, but when they close (and VB says the object is closed), SQL Server won't reflect this and the connection will stay open. Sometimes when we...

Hello everyone, I am having some issues with my service writen in VB.NET. I have checked all my connection objects within my code, however, somehow when the service runs connections are staying open to our database and it keeps growing and growing. I can't figure out where in my code this is...

Hey guys, I'm having a weird problem. I have a Windows service in .Net that runs fine for a while but then seems to stop. Here is a bit of the timer code: ' AmazonQue ' The registry values for storing the time intervals are: ' HKEY_LOCAL_MACHINE/SOFTWARE/AmazonQue/SuccessTime ' Time used if...

It returns 1.

No, the tblQueryItem table does not have multiple rows for each ID... the query generates 3 rows for each 1. Do you see from the example above?