Search results

So much for the peace huh? I just placed a new thread on the Reports forum. Basically what I need to know is what do I have to do to convert the ID values back to full descriptive values in a report. If you get the chance please look at my post the Reports forum. Thanks.

Hi all, I have just normalized my database. In my main table "TBL_Main" I have a column "CategoryID" which gets it's information via a form combo box. The combo box looks at another table "TBL_Categories" which has fields "CategoryID" & "CategoryName". So for example, the first record in...

Cheers John, It should mean I leave you in peace for at least a couple of days! :)

OMG! I've just done it! Now I feel like a real idiot, such a simple process and yet I never knew it could be done like that. As I said, I've always just dropped existing fields into my forms and then manipulated the field to what I've wanted. I really must thank you for not treating me like a...

Thanks John, I'll have a play. Is Combo Wizard in Access 2007 exactly the same? As I've never use the wizard! I've always just added existing fields. Thanks for laying it out step by step. Dave.

here's the upload. please keep in mind that i was testing what i've learnt before i apply it to my actual database. Good job too I think. Thanks so much. :banghead:

Okay, Will do so shortly. Cheers

Hi all, Okay, so I've normalized my database to the best of my ability. I've dissected the sample upload that was edited to show me how it should be. I've just attempted a test form to see how my new layout works. For some reason, I can't get my form to display the value but store it's ID back...

Hi John, Okay, no problem, thanks for all of your help on this. Much appreciated.

Hi John, I've been looking at normalisation. I think I'm getting the basics so I'm going to start refining the DB. Can I ask? I've looked at what you did to the sample I uploaded. Am I correct in understanding that when you set the RowSource for the "Country" field on the form, the query has a...

Thanks once again John, You're very helpful.

Hi all, I'm currently re-vamping an existing database. What I'd like to know is how to enable a combo box so that I can make and display multiple selections on a form. I have a table called colours which just contains 2 fields "ID" & "Colours". The way the database was previously set up I had a...

Thanks John, You didn't have to take time out to do that, but I really appreciate it. Thank you. I'll have a look at it thoroughly and see if I can apply the theory I've been reading into it's breakdown. You're a Champ!

Thanks John, I'm sorry, I'm really struggling with this. Maybe it is the Excel mindset. I understand what you have mentioned above, what I don't understand is how the information then comes together via it's relationships. Surely sooner or later you end up with one table that has all the info...

Just reading the link now, the Steve Litt additional reading is good. So in essence, would I be correct in saying each table should only have a ID (primary) and one other field? Most of my tables (not all) are like that. But I have one "main" table that my form uses as it's RecordSource for my...

Awesome! That works a treat. Thank you so very much for solving that. I was just about to start another thread about linking two forms, but I'll look at the normalization bit first as that could possibly change things. I've tried reading about normalization before but the things I read were...

Hi, I have attached the database as requested. I hope the upload is successful. please read the label i have placed on the form for an explanation of what I would like to happen. Please feel free to comment on anything you notice that may be incorrect. Keep in mind I have deleted quite a few...

Thank you, will do it very shortly.

Hi, I was just looking at making a copy, deleting the unrelated objects and then upload. Where do I upload to? Thanks.

Thanks so much both of you. Yes, the Country field in the CW Countries table is text. I will try the examples you have given me, and see what happens. I've tried so many different ways and nothing has worked. All I ever achieve is #Error. If I can't get it working, I might upload just the...