Search results for query: *

I’m using impersonation on my web application in order to identify who is currently logged onto the client. For example “John Smith”. This side of things works fine as the web page lists the name and email address of whoever is logged onto the machine. My web.config file contains…...

Hi I’m using this SQL query in 2005. USE [MIS] SELECT DasCompQty, DarQty, DarRWC, DasFlnRate / 60 * DarRwTime * DarQty AS FaultCost FROM dbo.AssemblyOperation AS [AO] INNER JOIN dbo.[Assembly] AS [A] ON AO.AopAssNo = A.AssPartNo INNER JOIN dbo.ListFlowline AS [LF] ON A.AssFlnId = LF.FlnId...

Hi I’m using a treeview control which lists staff members from my database. On the node_click event, I’m populating a datagrid with training record information from a table based on the staff member selected from the treeview. I’m using ADO code to populate a recordset and then setting the...

Hi I was wondering what the logic to use for comparing 2 recordsets. I have a RSCourseAttendedByStaff recordset (which is a list of staff members who have done a specific training course) My other recordset, RSAllStaff, is a full list of staff members. I want to compare the two and find out...

Hi I have a datatable which I want to write to a table in my database. Dim varSQL As String varSQL = ("SELECT * FROM [tblCost] WHERE [Part Number] = '" & txtPartNumber.Text & "' ORDER BY [Part Number]") Try Dim AccessCommandPartRetrieve As New...

Hi I’m trying to create a datagrid based on results from an Access database. I have achieved this using SQL but my new project uses Access. Basically, the user selects a part number from the main form and then clicks on a results button. A new form appears and a datagrid is dynamically built...

Does anyone know how to use the FileSystemWatcher? I want to watch a folder on the network. If a named text file gets copied into the folder, I want to automatically run an import function I have written and then after the import has completed, copy the text file into another folder to clear...

I'm trying to rewrite an old VB6 application in VB.NET. My old VB6 routine used to detect when a text file was placed in a folder and then it would import that delimited text file into an Access database. The old way of doing this doesn't work. I thought the way I would handle this is to use a...

I’m trying to create a simple login screen for my application in VB.NET. I’ve recently come over from VB 6! I have a login form which accepts a username and password. I want to lookup an Access table called Security to check that the username and password is valid. If it is then the main...

(I initially had this on the SQL forumns but they are telling me I need to post here as it's SQL through VB6) I'm running the following query through the visual basic 6 data designer against a SQL 2005 database. SELECT `Part No`, SUM(Val - `Cost Of Sale`) AS Margin, Description, `Product...

I'm running the following query through the visual basic 6 data designer against a SQL 2005 database. SELECT `Part No`, SUM(Val - `Cost Of Sale`) AS Margin, Description, `Product Group` FROM tblSales WHERE (`Invoice Date` BETWEEN (# 01 / 01 / 2006 #) AND (# 01 / 02 / 2007 #)) GROUP BY...

Hi I’m new to SQL so please bear with me! I know how to create a backup device called ASSETMAN and then make a backup of a database manually. I can then restore using the following. “USE master RESTORE DATABASE LDVTest FROM ASSETMAN WITH RECOVERY” This is OK for a one off backup. I have...

I have the following SQL command which I’ve written in the Visual Basic 6 data designer. It’s looking at a SQL 2005 database. SELECT viewInjectorPipe1.S1TestDate, SUM(viewInjectorPipe1.[CountOfInjector Pipe Moved] / viewInjectorPipe2.CountOfSerNo) AS InjPipe FROM viewInjectorPipe1 INNER JOIN...

Hi I have a .CSV file with an existing name column and a new name column. E.G. 3145.pdf, Item 3145.pdf I want to look at the first column (3145.pdf) find that file in a given directory (c:\temp) and then rename it to the second column (Item 3145.pdf) and then move to the next column until...

Hi I have a Visual Basic 6 application which looks at a SQL Server 2005 back end database. I have setup a command in the data designer which looks like this: SELECT S1TestDate, AVG(Crossover) AS AvgOfCrossover1 FROM LDVTestRec WHERE (Crossover > 0) AND (Crossover < 4.7) GROUP BY S1TestDate...

Hi I have a datagrid which displays a lot of data from an SQL table. The first row is a part number. I have a combo box with the relevant part numbers listed. All I want to do is select a part number from the combo box and have the datagrid select the row where the part number matches. I...

Hi I have a data report in my VB6 app which I open up through code. This works fine but the report opens up with a zoom level of 100%. I want to be able to open the report to 75% or maybe "fit to page" automatically as the bottom of the report is hidden under 100% zoom. Is there an easy way...

Hi I have a routine which I want to open an existing spreadsheet, switch to a specific named worksheet and then paste the contents of a recordset into the sheet. The recordset has been created successfully but I'm having trouble switching to a specific sheet. It opens the correct spreadhseet...

I have a very odd problem with some SQL. If I use the following code: “SQL2 = "SELECT Operations.OpID, OpDetail.OpNoID, OpDetail.SequenceNo From Operations, OpDetail WHERE Operations.OpID = OpDetail.OpNoID AND (Operations.PartNoID = '" & varPartNo & "') ORDER BY OpDetail.OpNoID...

Hi I have an SQL statement: SQL = “SELECT DISTINCT `Part No`, Description, `Invoice No`, `Planning Element`, `Invoice Line`, `Invoice Date`, `Invoice Creator`, `QTY Invoiced`, `Value (GBP)`, `Cost Of Sale`, `Currency Code`, `Customer Group`, Region, `Sold to`, `Delivery...