Search results for query: *

Hi all, I have a 4G HDD and I want to wipe out everything and install a fresh copy of win2k. I have never done this before .... would someone walk me through the steps. any help is greatly appreciated Azita

I have installed Win 2000 Pro on my computer and now when I try to install any software of hardware I get this message: "The Windows Installer Service Could not be accessed. This can occur if you are running Windows if safe mode, or if the Windows Installer is not currently...

I am trying to upgrade my win98 to 2000 but this is the error massage that I get: Setup detected 16Mbytes of main memmory but 32 Mbytes is required. can anyone help me what I should do. Thanks

Hi All, I want to print my code as it is displayed on the screen with different color text. comments green, text black and other stuff blue. I'm using a color printer and there is nothing wrong with my printer but it comes out black and white. Any help would be appreciated Azita

Hi All, I am trying to add string variables which contain commas to a listbox. let say my variable is "DAVID CRAIG CONSTRUCTION, INC" the listbox looks like DAVID GRAIG CONSTRUCTION INC so If my variable has 2 commas I get 3 lines!! how can I fix this problem? Azita

Hi All, I have a 3 layer form: frmMain(Main Form) which contains a Sub Form(frmSubLocation) which contains a sub form(frmsubCountyLocation) frmMain ---> frmSubLocation ---> frmsubCountyLocation now I have a Recordset in my frmMain which I need to use in the frmCountyLocation(subform of...

Hi All, I have a very long form and the user has to scroll up and down a lot. Can I add a few buttons that would take the user right to a specific part of the form? For example: my form contains data about Applicant, Owner, Application and receipt. Can the user go right to the Application...

Hi All, I am using Recordset to retrieve data from SQL server. After the rst is back I do Set Me.Recordset = rst and then populate the Detail section of my form. but when I wana use this form inside another form as a subform I can't find a Recordset property for the subform I was trying Set...

Hi All, I have been struggling with this error for 3 days now.I have a stored procedure as following: Create procedure dbo.Search (@BeginDate DateTime, @EndDate DateTime) As DECLARE @vBeginDate NVARCHAR(20) DECLARE @vEndDate NVARCHAR(20) DECLARE @vStrSQL NVARCHAR(2000) IF @BeginDate IS NOT...

Hi All, when I execute my sproc, passing a null value, I get this error: Warning: Null value is eliminated by an aggregate or other SET operation. here is the sproc Create procedure dbo.Search (@BeginDate DateTime, @EndDate DateTime) As DECLARE @vBeginDate NVARCHAR(20) DECLARE @vEndDate...

Hi All, I am using VB 6 and SQL server 2000. I have a sproc with a DateTime IN Parameter. I am using a Recordset, pass the parameter to sproc and execute it. Here is the Error I get when I execute the .open line: " The object you entered is not a valid Recordset property" However...

Hi All, 1. Is there a max for the number of IN parameters? 2. When passing a DateTime parameter to a sproc, do I need to format it before passing it in VB code? When I pass a DateTime prameter to my sproc from VB form I get this error: "The object you entered is not a valid recordset...

Hi All, I am trying to put this expression into a nvarchar variable, but I am having problems with single quotes! Here is the expression (ISNULL(installer.installername,'') + , + ISNULL(Installer.Dba, '') + , + ISNULL(Installer.BusName,'')) as Installer SET @strInstaller = the above...

Hi All, in my sproc I have a local variable @strSQL. I keep concatenating to this variable in my sproc and I wana use it in my "WHERE" clause at the end. IF ... SET @strSQL = @strSQL + .... IF . . . @strSQL contains something like this : 'TBL.ID = 345' BEGIN SELECT .... WHERE...

Hi All, In my tblInstaller I have 3 fields that I wana return as one string. But when any of 3 is NULL the whole string retruns NULL SELECT (InstallerName + ' , ' + Dba + ' , ' + BusName) as 'Name' From tblInstaller Any help would be greatly appreciated Azita

Hi All, My tblclient has both individual clients and company clients data It has the following data Pkclient FirstName LastName CompanyName Etc … I want to select the companyName if there is one, otherwise select FirstName and LastName. Here is my Pseudocode: If CompanyName is not null...