Recent content by AndreAraujo

hi everyone, i have a form that is binded to 2 datatables in the same dataset. i need to determine if tha values where changed when i move to the next record or when leave the form. I use the DS.haschanges but i get haschanges= true when i move to the next record but the data was not changed...

Tanks, hmckillop. Its Working.

Hi, i have this stored procedure to return only values that are not null CREATE PROCEDURE list_serie AS SELECT Num, Line, case Serie (isnull(serie,'') then '' else 'serie:' + serie, case Ref (isnull(ref,'') then '' else ' ref:' + ref, case Marca (isnull(marca,'') then '' else 'marca:' + marca...

problem solved

Hi, im creating an Crystal report in VB.net , i use 3 Sql stored procedure with parameters, my problem is that i pass the parameters values, but the report continue to ask me for the value for that parameter. This is tha code i use in load event inthe form that contains the ReportViewer...

hi chrissie1, the total and desc still display the D after the number. Thanks anyway.

hi everyone, im having some problems performing operations to get currency values. the result total and desc returns a strange value. if total = 1 * 74.80 the total is 74.80D dim total, desc as decimal total = (txt_quant.Text * txt_unit.Text) desc = ((total * txt_desc.Text) / 100) Any ideas...

Problem solved, thank vongrunt, the problem is that i need the @parametro to perform an insert into a other table. and i have to respect this code/sequence format, because the original app uses this format year+lab+counter. Andre

Hi, i´m having some problems in a stored procedure. i need to calculate a numeric value @parametro declare @parametro numeric (11,0) , @ano int select @parametro=max(id) from tbl__cabecalho where id_lab=1 set @ano= (@parametro/10000000 ) if @ano = year(getdate()) begin set @parametro...

Hello, im new to .net, im using a windows form with a datagrid, in that data grid i display information about my costumers, id, Name, Country, pay method, pay conditions, .. I´m using a DataGridComboBoxColumn to display not the code of the country (table Costumers) but the name of the country...

Hello, I run a diff b2d every day and Full at weekend, then backup the file to tape, the problem is that the b2d file is overwrited but keeps the same label ,so the catalog refers to the same b2d file , is there a way to create a diferent b2d label every day and delete/erase the day before? i...

Hi, i get the solution from a thread by Trevor Best. DoCmd OpenReport "rptWhatever", A_PREVIEW Do While IsReportLoaded("rptReport") DoEvents Loop DoSomeThingElse Function IsReportLoaded(pstrReport As String) IsReportLoaded = SysCmd(SYSCMD_GETOBJECTSTATE, A_REPORT, pstrReport) End Function...

Hi, I'm a having a problem with 2 reports, i have to print 2 reports , but the users need to preview the first report and print, and only then see the preview of the second report. Is there a way to hold the program until the print of the first report???? Thanks in advance André Araujo

Hi, the problem is in the fields that you are using in the relation. When you insert data in the subform, the Field "CmpnyID" must exist in both tables, you are inserting a record in the subform that doesn´t exist in the mainform Andre

Hello Everyone, a user in my Office keeps receaving a deleted without being read notification and those mails whore read, the notification arrives about 2:00Am, Ghoosts??? :) The workstation that sends the email is using Office 97 and Win NT with SP6 , the workstation that send's the...