Hi, i have a table with a few check box fields in but they dont save and i
have to choose the check box option for each field every time i open the
database, any clues please?
Also the rows and column heights wont save to what i put them at.
Thanks

Did you choose check-box in table design?
Vlado
"Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
> Hi, i have a table with a few check box fields in but they dont save and i
> have to choose the check box option for each field every time i open the
> database, any clues please?
> Also the rows and column heights wont save to what i put them at.
> Thanks

Hi
Yes, sorry, its the table i am working with, i am not using a form for this.
Thanks

"VladimÃ*r Cvajniga" wrote:

> Did you choose check-box in table design?
> Vlado
> "Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
> > Hi, i have a table with a few check box fields in but they dont save and i
> > have to choose the check box option for each field every time i open the
> > database, any clues please?
> > Also the rows and column heights wont save to what i put them at.
> > Thanks
>
>

You shouldn't be working directly in the table. You can use autoform to
create a quick form. If you have a single table and wish to work directly
in the table, a spreadsheet would be a good choice.
When you say the check box fields don't save, do you mean that you create a
record and check the box in some yes/no fields, but when you go back to that
same record those fields are no longer checked? Or do you mean that you
want the default for the yes/no fields to be Yes?

"Angel_1" <(E-Mail Removed)> wrote in message
news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
> Hi
> Yes, sorry, its the table i am working with, i am not using a form for
> this.
> Thanks
>
> "Vladimír Cvajniga" wrote:
>
>> Did you choose check-box in table design?
>> Vlado
>> "Angel_1" <(E-Mail Removed)> píse v diskusním príspevku
>> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
>> > Hi, i have a table with a few check box fields in but they dont save
>> > and i
>> > have to choose the check box option for each field every time i open
>> > the
>> > database, any clues please?
>> > Also the rows and column heights wont save to what i put them at.
>> > Thanks
>>
>>

Hi
I select check box in the design layout and the field shows the box but when
i come to reopen the database the field shows either a -1 or 0 depending on
if i've checked them. so i have to reselect the check box in the design
layout.

"BruceM" wrote:

> You shouldn't be working directly in the table. You can use autoform to
> create a quick form. If you have a single table and wish to work directly
> in the table, a spreadsheet would be a good choice.
> When you say the check box fields don't save, do you mean that you create a
> record and check the box in some yes/no fields, but when you go back to that
> same record those fields are no longer checked? Or do you mean that you
> want the default for the yes/no fields to be Yes?
>
> "Angel_1" <(E-Mail Removed)> wrote in message
> news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
> > Hi
> > Yes, sorry, its the table i am working with, i am not using a form for
> > this.
> > Thanks
> >
> > "VladimÃ*r Cvajniga" wrote:
> >
> >> Did you choose check-box in table design?
> >> Vlado
> >> "Angel_1" <(E-Mail Removed)> pÃ*se v diskusnÃ*m prÃ*spevku
> >> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
> >> > Hi, i have a table with a few check box fields in but they dont save
> >> > and i
> >> > have to choose the check box option for each field every time i open
> >> > the
> >> > database, any clues please?
> >> > Also the rows and column heights wont save to what i put them at.
> >> > Thanks
> >>
> >>
>
>
>

1) Is this what you mean?
http://img142.imagevenue.com/img.php..._122_439lo.jpg

2) Do you save table after you make changes?

3) Which version of Access do you use? In A97 and A2002 it's OK.

Vlado

"Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
news3A3A306-C5DC-4988-9B2E-(E-Mail Removed)...
> Hi
> I select check box in the design layout and the field shows the box but
> when
> i come to reopen the database the field shows either a -1 or 0 depending
> on
> if i've checked them. so i have to reselect the check box in the design
> layout.
>
> "BruceM" wrote:
>
>> You shouldn't be working directly in the table. You can use autoform to
>> create a quick form. If you have a single table and wish to work
>> directly
>> in the table, a spreadsheet would be a good choice.
>> When you say the check box fields don't save, do you mean that you create
>> a
>> record and check the box in some yes/no fields, but when you go back to
>> that
>> same record those fields are no longer checked? Or do you mean that you
>> want the default for the yes/no fields to be Yes?
>>
>> "Angel_1" <(E-Mail Removed)> wrote in message
>> news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
>> > Hi
>> > Yes, sorry, its the table i am working with, i am not using a form for
>> > this.
>> > Thanks
>> >
>> > "VladimÃ*r Cvajniga" wrote:
>> >
>> >> Did you choose check-box in table design?
>> >> Vlado
>> >> "Angel_1" <(E-Mail Removed)> pÃ*se v diskusnÃ*m
>> >> prÃ*spevku
>> >> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
>> >> > Hi, i have a table with a few check box fields in but they dont save
>> >> > and i
>> >> > have to choose the check box option for each field every time i open
>> >> > the
>> >> > database, any clues please?
>> >> > Also the rows and column heights wont save to what i put them at.
>> >> > Thanks
>> >>
>> >>
>>
>>
>>

Hi
Yes, thats what i mean, i choose Yes / No in Data Type, then i choose Check
Box in Display control, Press Save, Close table, when i reopen it none of the
above has been saved.



"VladimÃ*r Cvajniga" wrote:

> 1) Is this what you mean?
> http://img142.imagevenue.com/img.php..._122_439lo.jpg
>
> 2) Do you save table after you make changes?
>
> 3) Which version of Access do you use? In A97 and A2002 it's OK.
>
> Vlado
>
> "Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
> news3A3A306-C5DC-4988-9B2E-(E-Mail Removed)...
> > Hi
> > I select check box in the design layout and the field shows the box but
> > when
> > i come to reopen the database the field shows either a -1 or 0 depending
> > on
> > if i've checked them. so i have to reselect the check box in the design
> > layout.
> >
> > "BruceM" wrote:
> >
> >> You shouldn't be working directly in the table. You can use autoform to
> >> create a quick form. If you have a single table and wish to work
> >> directly
> >> in the table, a spreadsheet would be a good choice.
> >> When you say the check box fields don't save, do you mean that you create
> >> a
> >> record and check the box in some yes/no fields, but when you go back to
> >> that
> >> same record those fields are no longer checked? Or do you mean that you
> >> want the default for the yes/no fields to be Yes?
> >>
> >> "Angel_1" <(E-Mail Removed)> wrote in message
> >> news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
> >> > Hi
> >> > Yes, sorry, its the table i am working with, i am not using a form for
> >> > this.
> >> > Thanks
> >> >
> >> > "VladimÃ*r Cvajniga" wrote:
> >> >
> >> >> Did you choose check-box in table design?
> >> >> Vlado
> >> >> "Angel_1" <(E-Mail Removed)> pÃ*se v diskusnÃ*m
> >> >> prÃ*spevku
> >> >> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
> >> >> > Hi, i have a table with a few check box fields in but they dont save
> >> >> > and i
> >> >> > have to choose the check box option for each field every time i open
> >> >> > the
> >> >> > database, any clues please?
> >> >> > Also the rows and column heights wont save to what i put them at.
> >> >> > Thanks
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Which version of Access? Anyway, I don't think I'm able to help anymore...
:'-(

Recently I have encountered a bug which is caused by poor translation from
English to Czech, see
"Access 2002: Can't set RecordsetType", originally posted 25 Nov 2006, 20:28
or
http://groups.google.co.uk/group/mic...3fa2b7ea938dac

Vlado

"Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
news:FC1FC9B4-6A21-48F9-BE79-(E-Mail Removed)...
> Hi
> Yes, thats what i mean, i choose Yes / No in Data Type, then i choose
> Check
> Box in Display control, Press Save, Close table, when i reopen it none of
> the
> above has been saved.
>
>
>
> "VladimÃ*r Cvajniga" wrote:
>
>> 1) Is this what you mean?
>> http://img142.imagevenue.com/img.php..._122_439lo.jpg
>>
>> 2) Do you save table after you make changes?
>>
>> 3) Which version of Access do you use? In A97 and A2002 it's OK.
>>
>> Vlado
>>
>> "Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
>> news3A3A306-C5DC-4988-9B2E-(E-Mail Removed)...
>> > Hi
>> > I select check box in the design layout and the field shows the box but
>> > when
>> > i come to reopen the database the field shows either a -1 or 0
>> > depending
>> > on
>> > if i've checked them. so i have to reselect the check box in the design
>> > layout.
>> >
>> > "BruceM" wrote:
>> >
>> >> You shouldn't be working directly in the table. You can use autoform
>> >> to
>> >> create a quick form. If you have a single table and wish to work
>> >> directly
>> >> in the table, a spreadsheet would be a good choice.
>> >> When you say the check box fields don't save, do you mean that you
>> >> create
>> >> a
>> >> record and check the box in some yes/no fields, but when you go back
>> >> to
>> >> that
>> >> same record those fields are no longer checked? Or do you mean that
>> >> you
>> >> want the default for the yes/no fields to be Yes?
>> >>
>> >> "Angel_1" <(E-Mail Removed)> wrote in message
>> >> news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
>> >> > Hi
>> >> > Yes, sorry, its the table i am working with, i am not using a form
>> >> > for
>> >> > this.
>> >> > Thanks
>> >> >
>> >> > "VladimÃ*r Cvajniga" wrote:
>> >> >
>> >> >> Did you choose check-box in table design?
>> >> >> Vlado
>> >> >> "Angel_1" <(E-Mail Removed)> pÃ*se v diskusnÃ*m
>> >> >> prÃ*spevku
>> >> >> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
>> >> >> > Hi, i have a table with a few check box fields in but they dont
>> >> >> > save
>> >> >> > and i
>> >> >> > have to choose the check box option for each field every time i
>> >> >> > open
>> >> >> > the
>> >> >> > database, any clues please?
>> >> >> > Also the rows and column heights wont save to what i put them at.
>> >> >> > Thanks
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>

Hi
I am using Access 2003

"VladimÃ*r Cvajniga" wrote:

> Which version of Access? Anyway, I don't think I'm able to help anymore...
> :'-(
>
> Recently I have encountered a bug which is caused by poor translation from
> English to Czech, see
> "Access 2002: Can't set RecordsetType", originally posted 25 Nov 2006, 20:28
> or
> http://groups.google.co.uk/group/mic...3fa2b7ea938dac
>
> Vlado
>
> "Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
> news:FC1FC9B4-6A21-48F9-BE79-(E-Mail Removed)...
> > Hi
> > Yes, thats what i mean, i choose Yes / No in Data Type, then i choose
> > Check
> > Box in Display control, Press Save, Close table, when i reopen it none of
> > the
> > above has been saved.
> >
> >
> >
> > "VladimÃ*r Cvajniga" wrote:
> >
> >> 1) Is this what you mean?
> >> http://img142.imagevenue.com/img.php..._122_439lo.jpg
> >>
> >> 2) Do you save table after you make changes?
> >>
> >> 3) Which version of Access do you use? In A97 and A2002 it's OK.
> >>
> >> Vlado
> >>
> >> "Angel_1" <(E-Mail Removed)> pÃ*Å¡e v diskusnÃ*m pÅ™Ã*spÄ›vku
> >> news3A3A306-C5DC-4988-9B2E-(E-Mail Removed)...
> >> > Hi
> >> > I select check box in the design layout and the field shows the box but
> >> > when
> >> > i come to reopen the database the field shows either a -1 or 0
> >> > depending
> >> > on
> >> > if i've checked them. so i have to reselect the check box in the design
> >> > layout.
> >> >
> >> > "BruceM" wrote:
> >> >
> >> >> You shouldn't be working directly in the table. You can use autoform
> >> >> to
> >> >> create a quick form. If you have a single table and wish to work
> >> >> directly
> >> >> in the table, a spreadsheet would be a good choice.
> >> >> When you say the check box fields don't save, do you mean that you
> >> >> create
> >> >> a
> >> >> record and check the box in some yes/no fields, but when you go back
> >> >> to
> >> >> that
> >> >> same record those fields are no longer checked? Or do you mean that
> >> >> you
> >> >> want the default for the yes/no fields to be Yes?
> >> >>
> >> >> "Angel_1" <(E-Mail Removed)> wrote in message
> >> >> news:58B99E09-0E69-46F0-81C3-(E-Mail Removed)...
> >> >> > Hi
> >> >> > Yes, sorry, its the table i am working with, i am not using a form
> >> >> > for
> >> >> > this.
> >> >> > Thanks
> >> >> >
> >> >> > "VladimÃ*r Cvajniga" wrote:
> >> >> >
> >> >> >> Did you choose check-box in table design?
> >> >> >> Vlado
> >> >> >> "Angel_1" <(E-Mail Removed)> pÃ*se v diskusnÃ*m
> >> >> >> prÃ*spevku
> >> >> >> news:E34B398D-D7EF-4732-82A3-(E-Mail Removed)...
> >> >> >> > Hi, i have a table with a few check box fields in but they dont
> >> >> >> > save
> >> >> >> > and i
> >> >> >> > have to choose the check box option for each field every time i
> >> >> >> > open
> >> >> >> > the
> >> >> >> > database, any clues please?
> >> >> >> > Also the rows and column heights wont save to what i put them at.
> >> >> >> > Thanks
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
>
>

Angel_1 wrote:
> Hi
> I am using Access 2003

It's not a linked table by any chance is it?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com