Search results

Paul I did not answer your question because I felt you asked it just to tickle my Ivories. It added nothing to the conversation at hand.You may feel that I should be able to justify my statement, and indeed I can. But in order to do that I would need to supply a big bunch of code together with a...

DoCmd.RunCommand acCmdSaveRecord Instead of using the DoCmd simply use Me.Dirty = False It would be good if you established the Relationships in the Relationship Window. This displays an overall Blue Print of your design. You could also print that out and pin it to the wall as a...

James Good to hear from you. Welcome to the forum.

Guss I don't know the first thing about GUID, but I have the feeling that I should.

Mate I have no idea so I can't help you with that one. You have me confused with your use of pronouns. Especially "them". So once again I can't help. Perhaps you might like to re write your post. You may have been in a hurry when you wrote this.

MySQL does use Auto Number. I think if you upsize from Access you loose that and have to go back and fix them. What MySQL does not have is Relationships with Referential Integrity. You have to insert the Foreign key manually. Is this correct Glaxiom.

G'day Mate We haven't crossed swords for ages. I did not say it can't go wrong. However when and if it does I wonder what the writer of the Database has done. Or perhaps a simple electrical zap has caused problems. There are other means. True there is. DMax plus one is an example. I did...

I use Auto Number without exception. It is the only thing I know of were I can totally say that it will not be repeated. Never use Auto Number for anything other than a unique identifier. Primary Key. Never allow it to be seen by the end user. Some people disagree. The same people run...

Any questions please let me know. Especially anything to do with the "Not on List" Function.

Almost Queries are for gathering information and sorting it plus other things. The Form get it's data from the query and the Form is what you use for Viewing, Adding, Editing. When you are finished the Database you make a special version that Locks the user out of Tables, Queries and...

The Loins could be much better. At least we now have the Gold Coast to barrack I love watching Ablett when he is in form.

Go and look at a Database that has what you want. Go to design view and look carefully at the Properties for the combo. Especially Column widths and Number of columns. You could also look at the attached demo.

Option Explicit should be used all the time.

I have made worse mistakes, so don't give it a second thought. They say that a man who has never made a mistake has never made any thing.

Paul A UDF is not really what is was chasing. I really want to know why the Code would not work in a Query. Thanks.

After a review of your problem, it would appear that your loins are wrong. There is not enough information to give a qualified answer. Can you post a cut down version of this data base. Leave out things that are not part of the problem.

One would think that an apology would have been made by now. Such is Life.

Welcome Hope you get what you need.

Welcome from me too.

Welcome to the Forum. Looks like we may learn some new ideas.