Search results for query: *

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

Hi everyone, My problem is that this new machine doesn't work with NT so i cant install and DCpromo the machine, is possible to sincronize or import the accounts information from the BDC with NT to this new Machine with 2000? André

Hello everyone, I have 4 Servers with NT, recently my PDC failed and was replaced by a new machine with Win 2000 server. The BDC was promoted to PDC and the new server was instaled as a stand-alone. Now i need to promote this Win 2000 server to DC, i have to install Active Directory using...

Hello wcburton, In the moment i have a Win NT server, that was promoted from BDC to PDC because te PDC failed. the new server that will replace the old PDC is Win 2000, my question is can i have 4 servers with NT and a new PDC with Win 2000. The problem is that only one of my servers is using...

Hello everyone, I' m having some questions about 2000 server. i have 6 Nt 4 Servers , recently the PDC was replaced, the new server has the Win 2000, the bdc was promoted to PDC during the time the server was off line,the client installed the server as a stand alone server,Now i need to...

Problem solverd, I had to Format the label in client computer.