Does EN (US) version of Access have the same bug? See
http://groups.google.co.uk/group/mic...3fa2b7ea938dac

It's A2002 form/query RecordsetType property that I can't change in design
view.

TIA

Vlado

There's no problem setting the RecordsetType in English (in form design
view.)

Internally the value is stored as a Byte, so if there is a problem with
setting it in your language, you may be able to set it programmatically.

With Form1 open in design view, press Ctrl+G to open the Immediate window,
and enter something like this:
Forms("Form1").RecordsetType = CByte(2)

Substitute the name of your form for Form1, and for 2 one of these:
0 Dynaset
1 Dynaset (Inconsistent Updates)
2 Snapshot

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Does EN (US) version of Access have the same bug? See
> http://groups.google.co.uk/group/mic...3fa2b7ea938dac
>
> It's A2002 form/query RecordsetType property that I can't change in design
> view.
>
> TIA
>
> Vlado

Thank you, Allen.

I've been using code to set RecordsetType property for a while. I just
wanted to know if it has to be done due to poor translation to Czech. :-(
It's also possible to set form's RecordSet property in VBA's properties
window... but not for query, of course.

Vlado

P.S. To show you what MS CZ translators do:
In MS Office 97's dictionary there's a translation of English 'n' (And), ie.
n in dictionary, to Czech a (a for Ano = Yes). As to the logic, the
translation is correct. But it's the following couple in the dictionary: n
=> a. Can you imagine automatic corrections in that case? Especially for
boolean A/N in Excel or Access?! (Ano/Ne = Yes/No). I don't know what are
these people paid for. :-(
I instruct people either do delete the "a n" couple from dictionary or not
to use automatic corrections at all...

"Allen Browne" <(E-Mail Removed)> píše v diskusním pøíspìvku
news:(E-Mail Removed)...
> There's no problem setting the RecordsetType in English (in form design
> view.)
>
> Internally the value is stored as a Byte, so if there is a problem with
> setting it in your language, you may be able to set it programmatically.
>
> With Form1 open in design view, press Ctrl+G to open the Immediate window,
> and enter something like this:
> Forms("Form1").RecordsetType = CByte(2)
>
> Substitute the name of your form for Form1, and for 2 one of these:
> 0 Dynaset
> 1 Dynaset (Inconsistent Updates)
> 2 Snapshot
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Does EN (US) version of Access have the same bug? See
>> http://groups.google.co.uk/group/mic...3fa2b7ea938dac
>>
>> It's A2002 form/query RecordsetType property that I can't change in
>> design view.
>>
>> TIA
>>
>> Vlado
>

Sorry, Vlado: I can't comment on the translation into Czech part.

You can set the RecordsetType property for a query programmatically:
CurrentDb.QueryDefs("Query1").Properties("RecordsetType") = 0

Love your of A - N example. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thank you, Allen.
>
> I've been using code to set RecordsetType property for a while. I just
> wanted to know if it has to be done due to poor translation to Czech. :-(
> It's also possible to set form's RecordSet property in VBA's properties
> window... but not for query, of course.
>
> Vlado
>
> P.S. To show you what MS CZ translators do:
> In MS Office 97's dictionary there's a translation of English 'n' (And),
> ie. n in dictionary, to Czech a (a for Ano = Yes). As to the logic, the
> translation is correct. But it's the following couple in the dictionary: n
> => a. Can you imagine automatic corrections in that case? Especially for
> boolean A/N in Excel or Access?! (Ano/Ne = Yes/No). I don't know what are
> these people paid for. :-(
> I instruct people either do delete the "a n" couple from dictionary or not
> to use automatic corrections at all...
>
> "Allen Browne" <(E-Mail Removed)> píše v diskusním pøíspìvku
> news:(E-Mail Removed)...
>> There's no problem setting the RecordsetType in English (in form design
>> view.)
>>
>> Internally the value is stored as a Byte, so if there is a problem with
>> setting it in your language, you may be able to set it programmatically.
>>
>> With Form1 open in design view, press Ctrl+G to open the Immediate
>> window, and enter something like this:
>> Forms("Form1").RecordsetType = CByte(2)
>>
>> Substitute the name of your form for Form1, and for 2 one of these:
>> 0 Dynaset
>> 1 Dynaset (Inconsistent Updates)
>> 2 Snapshot
>>
>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Does EN (US) version of Access have the same bug? See
>>> http://groups.google.co.uk/group/mic...3fa2b7ea938dac
>>>
>>> It's A2002 form/query RecordsetType property that I can't change in
>>> design view.

For queries I've created a public function (about three months ago) so that
I can shorten the command in debug window to a simple ?fncQryN("qryName").
But instead of 0 I set 1 (Dynaset (Inconsistent Updates)) in fncQryN! ;-)

Vlado

"Allen Browne" <(E-Mail Removed)> píše v diskusním pøíspìvku
news:(E-Mail Removed)...
> Sorry, Vlado: I can't comment on the translation into Czech part.
>
> You can set the RecordsetType property for a query programmatically:
> CurrentDb.QueryDefs("Query1").Properties("RecordsetType") = 0
>
> Love your of A - N example. :-)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thank you, Allen.
>>
>> I've been using code to set RecordsetType property for a while. I just
>> wanted to know if it has to be done due to poor translation to Czech. :-(
>> It's also possible to set form's RecordSet property in VBA's properties
>> window... but not for query, of course.
>>
>> Vlado
>>
>> P.S. To show you what MS CZ translators do:
>> In MS Office 97's dictionary there's a translation of English 'n' (And),
>> ie. n in dictionary, to Czech a (a for Ano = Yes). As to the logic, the
>> translation is correct. But it's the following couple in the dictionary:
>> n => a. Can you imagine automatic corrections in that case? Especially
>> for boolean A/N in Excel or Access?! (Ano/Ne = Yes/No). I don't know what
>> are these people paid for. :-(
>> I instruct people either do delete the "a n" couple from dictionary or
>> not to use automatic corrections at all...
>>
>> "Allen Browne" <(E-Mail Removed)> píše v diskusním pøíspìvku
>> news:(E-Mail Removed)...
>>> There's no problem setting the RecordsetType in English (in form design
>>> view.)
>>>
>>> Internally the value is stored as a Byte, so if there is a problem with
>>> setting it in your language, you may be able to set it programmatically.
>>>
>>> With Form1 open in design view, press Ctrl+G to open the Immediate
>>> window, and enter something like this:
>>> Forms("Form1").RecordsetType = CByte(2)
>>>
>>> Substitute the name of your form for Form1, and for 2 one of these:
>>> 0 Dynaset
>>> 1 Dynaset (Inconsistent Updates)
>>> 2 Snapshot
>>>
>>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Does EN (US) version of Access have the same bug? See
>>>> http://groups.google.co.uk/group/mic...3fa2b7ea938dac
>>>>
>>>> It's A2002 form/query RecordsetType property that I can't change in
>>>> design view.
>

Vlad;

why in the hell would you use a MDB and DAO?

both of those have been obsolete for 10 years

seriously

use Access Data Projects.. it's a much better solution for projects
small, medium or large.
and of course-- ADO is _FASTER_ than DAO for _EVERYTHING_

if you're not putting performance first; then you don't care about
your customers




On Apr 2, 2:28Â*am, VladimÃ*r Cvajniga <nos...@thank.you> wrote:
> For queries I've created a public function (about three months ago) so that
> I can shorten the command in debug window to a simple ?fncQryN("qryName").
> But instead of 0 I set 1 (Dynaset (Inconsistent Updates)) in fncQryN! ;-)
>
> Vlado
>
> "Allen Browne" <AllenBro...@SeeSig.Invalid> pÃ*Å¡e v diskusnÃ*m pøÃ*spìvkunews:(E-Mail Removed)...
>
>
>
> > Sorry, Vlado: I can't comment on the translation into Czech part.
>
> > You can set the RecordsetType property for a query programmatically:
> > CurrentDb.QueryDefs("Query1").Properties("RecordsetType") = 0
>
> > Love your of A - N example. :-)
>
> > --
> > Allen Browne - Microsoft MVP. Â*Perth, Western Australia
> > Tips for Access users -http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
>
> > "VladimÃ*r Cvajniga" <nos...@thank.you> wrote in message
> >news:(E-Mail Removed)...
> >> Thank you, Allen.
>
> >> I've been using code to set RecordsetType property for a while. I just
> >> wanted to know if it has to be done due to poor translation to Czech. :-(
> >> It's also possible to set form's RecordSet property in VBA's properties
> >> window... but not for query, of course.
>
> >> Vlado
>
> >> P.S. To show you what MS CZ translators do:
> >> In MS Office 97's dictionary there's a translation of English 'n' (And),
> >> ie. n in dictionary, to Czech a (a for Ano = Yes). As to the logic, the
> >> translation is correct. But it's the following couple in the dictionary:
> >> n => a. Can you imagine automatic corrections in that case? Especially
> >> for boolean A/N in Excel or Access?! (Ano/Ne = Yes/No). I don't knowwhat
> >> are these people paid for. :-(
> >> I instruct people either do delete the "a n" couple from dictionary or
> >> not to use automatic corrections at all...
>
> >> "Allen Browne" <AllenBro...@SeeSig.Invalid> pÃ*Å¡e v diskusnÃ*m pøÃ*spìvku
> >>news:(E-Mail Removed)...
> >>> There's no problem setting the RecordsetType in English (in form design
> >>> view.)
>
> >>> Internally the value is stored as a Byte, so if there is a problem with
> >>> setting it in your language, you may be able to set it programmatically.
>
> >>> With Form1 open in design view, press Ctrl+G to open the Immediate
> >>> window, and enter something like this:
> >>> Â* Â*Forms("Form1").RecordsetType = CByte(2)
>
> >>> Substitute the name of your form for Form1, and for 2 one of these:
> >>> Â* Â*0 Â* Â* Â* Â*Dynaset
> >>> Â* Â*1 Â* Â* Â* Â*Dynaset (Inconsistent Updates)
> >>> Â* Â*2 Â* Â* Â* Â*Snapshot
>
> >>> "VladimÃ*r Cvajniga" <nos...@thank.you> wrote in message
> >>>news:(E-Mail Removed)...
> >>>> Does EN (US) version of Access have the same bug? See
> >>>>http://groups.google.co.uk/group/mic...s/browse_threa....
>
> >>>> It's A2002 form/query RecordsetType property that I can't change in
> >>>> design view.- Hide quoted text -
>
> - Show quoted text -