Recent content by Swemebegur

hi Rainlover If you think I was rude it was because I found your statements arrogant as well as inaccurate. You did not write "I think this is wrong", you wrote "This is wrong". And you implied that I was not using a naming convention, apparently because it was not the one you happen to...

Please RainLover, your statement is nonsense. There is nothing wrong in using natural keys. Using surrogate keys is just your opinion, nothing more. But I do not want to get into that stale old debate, which has been thrashed to death over the years. And I happen to use a different naming...

That is probably the reason. In your original post you wrote that it was an autonumber, which is a long integer, and the format I gave applies to these. But why on earth are you copying the autonumber to "txtTrans" instead of just using the autonumber itself? Swemebegur

Hi KLouise I have been playing around with the copying problem, and here is a .mdb showing how it might be done HTH Swemebegur

I do not understand why you lose the formatting when you close and open the form. This does not happen when I try it. Have you put the 0000000 in the text box, as boblarson pointed out? Can you show us the property sheet for CallID?

Hi again KLouise I see now what you want to do. One way would be to use an append query to create the category records. This would select records from the book/category table with the old book's id as their foreign key, then append these to the same table but with the new book's id. I have...

Hi Maffhob Simply format the text box as 0000000. HTH Swemebegur

Hi KLouise I must admit I am still not convinced. Can you show us your table structure? Swemebegur

Hi davewong911 Glad to be of help. In your second question, you write "or use a combo box". I would have thought that this would be the preferred way to display the data on a form. Or are you thinking of a combo box with a field list as its row source? It would be much better to use a table...

Hi KLouise Why are you wanting to copy all the details of a book (or whatever) into a new record? Is it because you have a separate record for each instance of a book? Might it not be simpler to have one record for the book with a quantity field? Swemebegur

Hi davewong911 On the BookingsTBL, put a unique index on the combination of Teacher ID and Lesson ID. BTW - it is not a good idea to have spaces in field names - you will have to enclose the field names in square bracket all the time. HTH Swemebegur

Hi Thorlim I've been thinking about your problem over the weekend, and feel that, if you just want to link the family members for reporting purposes, a separate link table may be overkill. It will certainly involve more complex programming. It would be simpler to add a parent field ("parent"...

The simplest way would be to have a separate form which the administrator (you?) would use to link the associated visitors. It would also be possible to let the visitor(s) make the link but this would need to be carefully designed. BTW, are you sure that visitors would be willing to enter all...

This would depend very much on your form design. Both person records would need to be created before the link record could be created. How much data will the visitors be inputting? Swemebegur

One way would be to create a table linking two records in the Person table: Person Id 1 - FK (eg the grandmother) Person Id 2 - FK (eg the grandson) Link Type ("grandmother") Inverse Link Type ("grandson") The prime key would be the two person ids. This would enable you to...