subdatasheet to none not working

K

Keith G Hicks

I ahve a tiny little Access 2000 project that I worked on years ago for
someone and he recently asked me to make a couple of minor changes. I
noticed that the tables still have subdatasheet set to Auto and I went to
change them to None but they won't stay. When I save the tables and go back
to design they still say Auto. Any ideas?

Thanks,

Keith
 
K

Keith G Hicks

Well never mind. I used code I had to chagne them all at once. That worked.
But I'm still wondering why I was unable to chagne them manually. Weird.
 
J

John W. Vinson

Keith,

I have noticed it won't stay set to [NONE] unless you turn off Track
Autoname Correct.

.... which should be routinely turned off in all databases, since it has richly
earned the nicname "Name Autocorrupt".
 
K

Keith G Hicks

That did it. Thank you. I created this thing so long ago that it was before
I got in the habit of correcting all those little things that MS tossed in
to goof us all up. :)

Gina Whipp said:
Keith,

I have noticed it won't stay set to [NONE] unless you turn off Track
Autoname Correct.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Keith G Hicks said:
I ahve a tiny little Access 2000 project that I worked on years ago for
someone and he recently asked me to make a couple of minor changes. I
noticed that the tables still have subdatasheet set to Auto and I went to
change them to None but they won't stay. When I save the tables and go
back to design they still say Auto. Any ideas?

Thanks,

Keith
 
G

Gina Whipp

Keith,

Glad to help...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Keith G Hicks said:
That did it. Thank you. I created this thing so long ago that it was
before I got in the habit of correcting all those little things that MS
tossed in to goof us all up. :)

Gina Whipp said:
Keith,

I have noticed it won't stay set to [NONE] unless you turn off Track
Autoname Correct.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

Keith G Hicks said:
I ahve a tiny little Access 2000 project that I worked on years ago for
someone and he recently asked me to make a couple of minor changes. I
noticed that the tables still have subdatasheet set to Auto and I went to
change them to None but they won't stay. When I save the tables and go
back to design they still say Auto. Any ideas?

Thanks,

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top