locking data

Hi folks,

I have a database that pulls pricing data over from an AS400 for quotes. I
want to be able to lock that data once the quote is accepted as the link to
the pricing file is live so if a price change occurs, it will change the
quotes themselves which I don't want.

Is there a way of doing this without having to move data to another table?
I'd like to be able to keep current and old records together for analysis
purposes.

Thanks,

Al

Alan wrote:
Hi folks,

I have a database that pulls pricing data over from an AS400 for quotes. I
want to be able to lock that data once the quote is accepted as the link to
the pricing file is live so if a price change occurs, it will change the
quotes themselves which I don't want.

Is there a way of doing this without having to move data to another table?
I'd like to be able to keep current and old records together for analysis
purposes.

Depends on how you have a quote accepted on your system. If you are using a
checkbox to confirm the quote, then something like

if checkbox = true then
txtQuote.enabled = false
end if

that is if you want to lock just that one box. if you want to lock the whole
form, then I would go with:

me.AllowEdits = false

and the only way i know of keeping old and current records together would be
to have multiple fields (if you want to keep it on the same table), and test
to see if the field has a value in it, otherwise enter the data into the
other field.

IIf(Nz(Me.quote) = "", me.txtquote1.visible = true, (me.txtquote1.visible =
false) & (me.txtquote2.visible = true))

hope that helps

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200706/1

Thanks for replying and the suggestions. I'd like to lock the all the data
related to that quote so the main form and all the subforms. I'll try your
second suggestion. I did think about the passing data to a second field to
lock but wasn't sure if that was the best way to do it as it essentiallys
doubles the number of fields I'm dealing with. I'll play around with it
though and see how it works.

Thanks again for the suggestions.

Alan

"OTWarrior via AccessMonster.com" wrote:

Alan wrote:
Hi folks,

I have a database that pulls pricing data over from an AS400 for quotes. I
want to be able to lock that data once the quote is accepted as the link to
the pricing file is live so if a price change occurs, it will change the
quotes themselves which I don't want.

Is there a way of doing this without having to move data to another table?
I'd like to be able to keep current and old records together for analysis
purposes.

Depends on how you have a quote accepted on your system. If you are using a
checkbox to confirm the quote, then something like

if checkbox = true then
txtQuote.enabled = false
end if

that is if you want to lock just that one box. if you want to lock the whole
form, then I would go with:

me.AllowEdits = false

and the only way i know of keeping old and current records together would be
to have multiple fields (if you want to keep it on the same table), and test
to see if the field has a value in it, otherwise enter the data into the
other field.

IIf(Nz(Me.quote) = "", me.txtquote1.visible = true, (me.txtquote1.visible =
false) & (me.txtquote2.visible = true))

hope that helps

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200706/1