Search results for query: *

well done sir, thank you.

Hello, I made a custom column in my query that adds two colmuns and then divides by another. The problem is sometimes that column dividing is zero thus i get an "#Error" as the column data. Does anyone know how to fix this? I would like it to just show up as 0 rather then #Error AHT...

I'm brand new to write procedures so bare with me. I need to transfer data from one SQL server to my server. Does anyone have a good tutorial on how to do this? Also the current way to connect to the server I am transferring from with this an OpenLink ODBC connection and access, has anyone...

Bow

Here is error message i got: The Microsoft Jet Database enine does not recognize 'Forms!frmUsers!txtStart' as a vaild field name or expression. I have a select query feeding the crosstab that the WHERE is tied to the 'Forms!frmUsers!txtStart' on the form. The select query opens up all good...

I have a table that has a list of order information, there are multipule records per order that have information about when the order was processed. There is a day tied to the process time of each record, I need to filter out the duplicate records and get one record for an order, but that one...

I am trying to connect to a Sql Server 2005 and am having a very hard time doing it. I found lots of other people with this problem on google but all of their solutions did not work for me. I am using VS 2005. I have this error: Request for the permission of type...

try this at a class level: Imports System.Data.OleDb

I need help specing out the resources i need for this project. here is what i have: I am looking at a project that will have around 1000 people using a vb.net application to send insert row commands to a SQL Server 2005. The row they insert has around 2500 charaters in it. on average...