Stuart McLachlan
stuart at lexacorp.com.pg
Mon Apr 4 20:28:51 CDT 2011
Can you post the SQL behind qryBeneficiosAlt?
--
Stuart
On 4 Apr 2011 at 20:42, Ralf Lister wrote:
> Thank you all for your help.
>
>
>
> Charlotte, I`m gathering information data about one person, make some
> calculations and save this calculations in the fields of a query by
>
>
>
> Set dbs = CurrentDb
>
> Set rst = dbs.OpenRecordset("qryBeneficiosAlt")
>
>
>
> With rst
>
> .AddNew
>
> ![FechaCalculo] = Now
>
> ![Nombre] = gstrNombre
>
> ![Beneficiario] = gstrBeneficiario
>
> ![Edad] = gintEdad
>
> ![Sexo] = gstrSexo
>
> ![Densidad] = gintDensidad
>
> ![TasaActualUSD] = gsngTasaActualUSD
>
> ![TasaCompUSD] = gsngTasaCompUSD
>
> ![CC] = gsngCC ' CC = Compensacion de Cotizaciones
>
> ![PBR] = gsngPBR ' PBR = Pension Base Referencial
>
> ![LimSolInf] = gsngLimSolInf
>
> ![MSR] = gsngMSR ' MSR = Monto Salarial Referencial
>
> ![PR] = gsngPR ' Porcentaje Referencial
>
> ![BeneficiosAltPension] = gsngBeneficiosAltPension
>
> ![ValorAportes] = gsngValorAportes
>
> ![GF] = gsngGF
>
> .Update
>
> End With
>
>
>
> to be able to make a report on this very query as a Control Source.
> After printing the report I delete the data in the query with
> "DoCmd.RunSQL "DELETE FROM qryBeneficiosAlt"" and the whole thing
> begins again.
>
>
>
> But at "AddNew I get this error message " Error 3027 at run time./ You
> can't update. The database a/o object is "read only"."
>
>
>
> Saludos
>
> Actuary Ralf Lister
>
> La Paz, Bolivia
>
>
>
> De: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] En nombre de Charlotte
> Foust Enviado el: Lunes, 04 de Abril de 2011 07:24 p.m. Para: Access
> Developers discussion and problem solving Asunto: Re: [AccessD] Error
> 3027
>
>
>
> Another possible reason is a multiple table query. Anyhow, queries
> don't have AddNew and Update methods (although there are append and
> update queries), so can you clarify what you're actually trying to do?
>
> Charlotte Foust
>
> On Mon, Apr 4, 2011 at 4:04 PM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote: > Hard to say without seeing the
> query, but a common reason for a query being RO is that it > doesn't
> include the PK of the table you are trying to update. > > -- > Stuart
> > > On 4 Apr 2011 at 18:54, Ralf Lister wrote: > >> Hello, >> >> >> >>
> I wanted to fill a Query with AddNew and Update. But I get the error
> >> message " Error 3027 at run time./ You can't update. The database
> a/o >> object is "read only"." What can I do to fix this problem? >>
> >> >> >> TIA. >> >> >> >> Saludos >> >> Actuary Ralf Lister >> >> La
> Paz, Bolivia >> >> >> >> -- >> AccessD mailing list >>
> AccessD at databaseadvisors.com >>
> http://databaseadvisors.com/mailman/listinfo/accessd >> Website:
> http://www.databaseadvisors.com >> > > > > -- > AccessD mailing list >
> AccessD at databaseadvisors.com >
> http://databaseadvisors.com/mailman/listinfo/accessd > Website:
> http://www.databaseadvisors.com > -- AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com
>
> _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3550 - Release Date:
> 04/04/11
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>