Need Help with Cascading Combo Boxes Please

[othmanyg]

Hello, as I'm not that good at VB codes, I really need your help in solving my cascading combo box issue.

- In my third Combo box named (Subject 2) whenever I select the item I get an error message and I could not fix the code.

- Another issue with the first combo box (Subject) that even though the item is listed, I get the (On Not in List) code activated asking to repeat the same entry, for example English is already there but it keeps asking to add it.

- Just last thing, I would like to be able to show a specific item by clicking the comments filed when I search for a keyword in that field, then print only that item.

my Database is attached, and I appreciate your support good people!

Thanks,

 

[dkinley]

I haven't taken a look at your database because I am short on time, but this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=155389

Has a wonderful cascading demo attached to it and might resolve many of your issues. If not, post back and we can see what can be done.

-dK

 

[othmanyg]

thanks Mr. dkinley for the very useful example which is almost what I want but this will require me to start creating the DB from the scratch and change all the structure, can you kindly help me to FIX mine?

Good day,

 

[dkinley]

hehehe ... I understand your frustration, I've been right there with you .. actually I am with you on a project I have been fooling around with.

I copied that to give you a head start, sort of a 'stare and compare' to help you figure out what is wrong with yours (if it is applicable). You don't have to start yours from scratch, just copy and apply the appropriate parts.

That being said, I am not blowing you off by any means, but it is the weekend here and I've a few projects to kick out and the weekend to attend to. I just know that I won't be in a better position to review and tinker and wanted to give you something because the weekends can be a little slow around here.

-dK

 

[othmanyg]

you are absolutely right it is frustrating so anyone up there can help Please?? Enjoy your weekend Mr. dkinley.

Thanks,

 

[dkinley]

Repaired ...

1 - There was a quotation issue for your SQL string.

2 - Found this error when you wanted to add a new record. Selected "No" to the "Limit to List" option in the combo box properties. On your main form it this property has no relevance because you are filtering records through the SQL.

3 - Added code so if you double-click the comments it opens up the other form.

As a side note, if this database is going to grow, I would highly recommend normalizing your database. Here is a link:

http://www.databasedev.co.uk/database_normalization_process.html

It is pretty detailed and full of gobeldigook so you may need to read it a few times. You can do searches on database normalization (on this site or the WWW) and get tons of information.

Here are some other links to help you on your way that has some great tutorials and such:

http://www.techonthenet.com/access/index.php
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://www.functionx.com/vbaccess/

Good luck!
-dK

 

[othmanyg]

Mr. dkinley, it works perfect I do appreciate your efforts and time to solve my issue. I also found those links very useful and informative.

God bless you and your knowledge

Good day and thanks again,

 

[dkinley]

You betcha!

By the way, Mr. Kinley is my father =]

Oh yes ... if you run into any more stumps again ... post on a Monday - hehe

Good luck!

-dK

 

[othmanyg]

Hello Good people, I'm in dire need for the help to finish up my Database. Two things are needed here

1. I need to be able to add new items through (Add New Item) command button in the main form and whenever the item is already there in the combo box named "Subject" then I can jump to the next combo named "Subject 1" same thing then if the item in Subject 1 is already there I move to Subject 2 combo box. Note that (Subject 1) and (Subject 2) combo boxes values depend on the (Subject) combo box. However, if the item is not listed then I need the Not In the list message appear asking me if I want to add or not. I really could not get it to work somehow.

2. I need to be able to print ONLY that specific item (in a report format) whenever I double click on the comments field to filter an item.

Please refer to my attached database that was thankfully fixed by dkinley.

Your help is very much appreicated as I already got frustrated.

Good day all

 

[dkinley]

hey hey ... What you are requesting is a bit beyond my knowledge because I design my databases differently.

Anyone?

-dK

 

[othmanyg]

That's ok dkinley, wow beyond your knowledge , I don't think so because they are straight cascading combo boxes, but anyways I appreciate your usual quick responses, anybody out there who can help???? Pls

Thanks,

 

[dkinley]

Well ,,, beyond my knowledge in the scope that you have alot of SQL which I know just enough to be dangerous with. =]

-dK