Search results for query: *

I'm really not sure... nway, i think i have to ask our system/network admin if he have done something in my PC... nway, tnx for the reply...

i'm using oledb....i just tried odbc and it works so i dont know what really happens with my crystal report designer why it wont connect anymore using oledb.

I'm trying to connect my report to an MSSQL server but i get an error, "Unable to connect to sql server jeffrey" (Jeffrey is the name of my computer where my sql server is running)... what could have been possibly wrong... pls help... i don't know what happen becoz i created this report in the...

in cross tab summary, group options, a row will be printed for each week, why is it that it only displays 5 days record and not 7 days? how can I make it 7 days.... pls help.....

I have an application that uses com+ architecture. The idea is, a user from a different place will connect to a MSSQL 2000 database using dial-up internet connection by setting the datasource to the ipconfig of the system where the database resides. However, it won't connect as nothing is...

anyone who knows how to pass a parameter value in the subreport... i launch the report in VB.net using reportdocument object. below is my code in lauching the report with name RptNAme with a parameter ParamName... my problem is in this report there is a subreport say SubRptName with a parameter...

tnx Dave.. a star 4 u...

this is what i want to do. I created a text wherein it will display when there are no records found so i created a formula in the suppress object button. my problem is what would be the formula. I've tried the formula 'recordnumber=0' yet the text still displays even if there are records found...

Imports System.Data.OleDb Imports System.Data Public Class clsDataAccess Inherits ServicedComponent Private Shared gstrConnectionString As String Private mobjConnAccess As OleDbConnection Public Function DARetrieve(ByVal SqlCmdTxt As String) As DataSet Dim...

tnx for the reply.. i just install vb6 and it now works...:) tnx..

i have a class that use mscomm control, however it creates an error "class is not license for use".. help,what shoud i do? Private MSCOMM1 As New MSCommLib.MSComm

Hi, ive tested my program instead of using @@identity, i use scope_identity but the problem is it returns a null value. I'm using vb.net in my development and in my program, I have a class for my database connection named clsDataAccess where it has a function insert defined as public function...

thanks for that great discussion...it really answered my question. Actually, we have the same reason with rdroske where since it is a stored procedure then no other processes can interrupt it.:P But thanks to SQL Sister... point is taken.:) i'm going to share this to my ofcmates, and i'm going...

we have just a little discussion in the ofc with @@identity vs @@ident_current... it's like this, i have a stored procedure define as.. CREATE PROCEDURE [uspInsertData] @FldName varchar(1000), @FldValue varchar(1000), @tablename varchar(100) AS declare @sql varchar(8000) set @sql = @sql +...

thank you for all your replies.:) Patrick, thanks for the solution...i haven't thought about it. probably because i'm looking for a solution that requires less code... and effort.:P thanks most to "cmmrfrds" .... it's just the answer that i wanted...:) i'm not sure though what errors...

thanks for the reply... however, michaelred, where can i find faq700/184? cheerio, what i really want is to know what number was assigned to the new record inserted? because in MSSql, it is possible to know the identity number assigned to the newly inserted data by the function @@Identity...

Help, pls... i have a program that uses mssql for its database.In my program, i use a stored procedure to insert a datarow in the database wherein the stored procedure also returns the Last Identity number of the row being inserted. Now, I am converting the database to Access however, there are...

thank you very much for the help.. i'm just so happy.. again, thank you... jeffrey

Why is this not possible? CREATE PROCEDURE [uspInsertNotes] @OwnerID varchar(50), @Subject varchar(50), @Notes ntext(16), @DateCreated varchar(50), @CreatedBy varchar(50), @tableName as nvarchar(256) AS INSERT INTO @tableName (OwnerId,Subject,Notes, DateCreated, CreatedBy) VALUES (@OwnerID...

my program use flash for its menu, however, when i install it on another computer, the menu won't show... what could have been the reason for it? the ocx use for the flash has been included in the installation which is the plugin.ocx... is there any thing else which should be included... please...