Search results

Doc I believe I am the better for reading your advice. I guess there are things that I have experienced that has help lead me to my way of thinking. I need to change my thinking. Thank You

Galaxiom Now you are not only attacking me you have added Minty to your list simply because her opinion agrees with mine. By reading the remarks of other people it would appear that some totally agree with me, some agree with reservation or agree up to the point where I use the word never...

I can't make head nor tails with this. Is it possible to post a cut down version of what you have. Convert to the oldest version that you can. Like 2003 or 2007. What do you actually mean by "Read". This could mean more than one thing.

Auto Numbers. Written by someone at UA. What they are NOT Row (record) sequence numbers. An "order of entry into the table" number A "gapless" series of numbers. Editable numbers. A series of (necessarily) always increasing numbers (see note 1 , below). Intended to be viewed/used by end...

I am trying to get across the idea that the AutoNumber has but one purpose. That is to identify a record. That is its job and nothing more. The harm it can do is confusion. User says hey what is this number for. Then they may try to use it for some purpose. There is not much more I can say...

FuzMic the OP has asked a question that would tend to make one think that his experience is limited. To answer his question one should take that into account. One way of doing that is to propose a solution that is not ambiguous. By saying things like always use an Auto Number or hide the PK...

Open your properties box. Make sure the Form has the focus. Look under the All Tab.

Wayne Welcome to the forum. When you have a problem just start a new thread and ask away. Good luck.

Only to the point that if it can't be seen then it is unlikely to be used for something like an Invoice Number, Employee Number etc

I did not intend my statements to be read in the manner you are reading them. This is the fault of my poor English, not something you did. Hiding the key has nothing to do with the overall design of the table. What I was trying to say in general terms was that writing a statement is simpler...

You have a Filter. I think you need to get rid of that. I can't read much of 2010 as I run 2003 and 2007. I am limited. Give this a try but do a back up first.

Is there a question that goes along with that.

Paul Read the next post of mine. You have surprised me. I would have thought that you would have seen a vast array of databases and that you would have seen where a novice has run into troubles with their work. I was wrong wasn't I.

Hi Button. A good response. Thanks. My rule is dogmatic, I will give you that. However if you looked again I do say "I" not "YOU MUST" I am giving an example of what I do. As always if you want to do it differently then that is your business not mine. I have seen examples where using a...

bonegrin Welcome to the forum.

You are confusing me. You can read a new record but not an old one is that correct?

Joe Welcome to the Forum and best wishes. Hope you have a good memory. If not we can help.

My simple reply is. absolutely no reason to show them.

Would it not be best to fix what you have, which may fix a lot of your problems, before moving on to something else. For me to answer your question I would have to do what I am asking you to do. That is fix all those little problems like Relationships. How do you feel about that idea.

The chances are indeed miniscule. But it is still possible. Just for the fun of it I wrote a Procedure where it is not possible to duplicate or miss a number. It works under my testing which was a couple of loops requesting a number over a long period. I remember that I ran it over night but I...