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, Thank you so much Jim, it works fine now. Azita [thumbsup]

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

Once again, I figured it out myself! Set Forms!frmMain!frmSubView!frmSubCountyLocation.Form.Recordset = rstCL Azita [ponytails2]

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...

Thank you guys Azita

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...

Hey guys, Thanks for your help. I figured it out. the subform does have a Recordset property. Here is how you use it: SET Forms!frmMain!frmSubSearch.Form.Recordset = rst Azita (:I

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...

Thanks guys, The error was in my Stored Procedure I had to SET NOCOUNT ON Azita [bigsmile]

after running the trigger, type in : show error and it will show you the line that is causing the compilation error. I hope this helps Azita

I looked it up, SET NOCOUNT Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Syntax SET NOCOUNT { ON | OFF }

cmmffrds, set nocount on did it, it works fine now. But I would like to know what nocount is doing? Thank you so much for your help. Azita

VicM, the @BeginDate and @EndDate are the parameters passed to the sporc and @vBeginDate and @vEndDate are local variables I declared to convert the IN parameters form datetime to nvarchar. The if statement checks for the null values of the IN params.

the upper code is a SQL Stored Procedure. I am using Access unbound Forms with SQL 2000 backend.

Thanks Terry, I will Azita

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...