I think that I posted this tread in the wrong places...
So let´s see if here at VB I could find a good soul who could help me.
Attached is the spreadsheet that I´m working with, which have some macros in it to allow the user to create a New Final Tax Report according to my Country Regulations.
The RED Sheet (DATOS) is filled with the get external data tool in excel from My Data Base (CEDRO)
The formulas in the GREEN Sheet (CAMBIAR AQUI) are made in the way to determinate if there is wrong entrys in the Data Base before to Print the Final TAX report in the Blue Sheet (LIBRO DE IVA)
The original SQL that I Copy from the MSQUERY to import the data is as Follows:
SELECT cast(CONVERT(varchar(8), B.FechaE, 112) AS datetime) , B.NumeroD, B.Descrip, B.ID3, B.Monto, B.MtoTax, B.RetenIVA, A.TipoCli, A.EsGranCont, B.CodUsua, B.CodVend
FROM CEDRO.dbo.SACLIE A, CEDRO.dbo.SAFACT B
WHERE A.CodClie = B.CodClie AND ((B.FechaE Between ? And ?) AND (B.TipoFac Between ? And ?))
ORDER BY cast(CONVERT(varchar(8), B.FechaE, 112) AS datetime), B.NumeroD
What I need is to give the user the chance to update the field ID3 (Column D in DATOS Sheet) and then with a Button UPDATE the SQL TABLES: SACLIE and SAFACT (Both Tables linked by CodClie (KEY) and the ID3 which is the field I need to Change.
SERVER NAME: SERVIDOR
DATA BASE: CEDRO
TABLES: SACLIE (Main Table...contains all Customer Details) and SAFACT (Contains Invoice Info)
WORKBOOK NAME: CREAR NUEVO LIBRO DE VENTAS
I´m really new in VB features...some superficial knoledge only and even when I find some similar situations here I´m not able to use it in my case...If you can help me please do it...I´ll put your picture as my default desktop