Search results

Just so anyone that looks knows...I figured out a solution...although it may be a workaround...I won't be the judge;) I included the following two lines of code into the gotFocus event of both combos on the subform and on all navigation buttons. Me.OrgNameCombo.Requery Me.OrgNameCombo =...

Hi all, This is kind of a two parter... Explanation: I have an unbound combo box (organization) that's rowsource is a query where another combo (contact) on the form supplies a parameter. The query works correctly. Problem 1: I would like to display the first value from the combo's list. I...

Thats if you are assuming that armageddon is a destruction event and not more of a "restructuring" event. I am not overly religious about this, I just think that doomsday scenarios are overplayed.

Consider this....maybe the climatic change is a shift in how we live...maybe we are going back to the dark ages...I see any "armageddon" as a change, not an end.

I know its been a while since the last post, but I just wanted to say thanks for those who had input here. I would also like to note that thanks to the many kind people here and around the net, that my first real dB is becoming a success. It is mostly normalized and I have learned a lot...

I lived in SC for a while and the locals were the same way!! Even in Columbus OH where it snows a little bit every year, if there is 3-4 inches on the ground, they close down all the roads and you can get a ticket for driving, even if your are like me and have studded snow tires because when it...

Anybody seeing snow this week? We are getting pounded. Already have almost a foot and possible 2 feet by tommorow morning. Love that lake effect snow off of Lake Erie (one of the Great Lakes in the US).

Thanks very much. John sorry I hadn't looked at that link, I am going to save that for future reference. Pbaldy thanks for the info, that worked nicely, I didn't even think to try that. Again thanks very much. KMB:)

Pbaldy, I used requerys in the after update event for the combos and I used one in the on current for the form. I made the criteria for Type in the query for the Category combobox as: the Combobox for the Type. KMB

This article isn't specific enough. Thanks very much though. KMB

Hi everybody. Thanks for previous help. I have a new issue that may have an easy fix or it may not...I haven't found it here or on the net. Anyways, the basic idea is that I have 3 cascading combos on a form (Category Type, Category, and Subcategory). When I pick a Type, the correct...

Well....I think I finally may have figured it out. It seems to be working how I want it to now. :) Thanks

Bob, I appreciate your help, but I have tried to strip down my file as much as I can and it is still about 1.2 Mb. If there is another possibility, please let me know. Thanks

Bob, I am using 2003. Thanks. kmb

Hello, I have been searching the net and the forum for a few days trying to come up with an elegant solution. I have figured out, by reading and experimenting with others' ideas on how to make a subform with for a junction table. Thanks Pat Hartman for the example for venues and customers...

I've never had to wait...I am in the US on the East Coast..:o

The last reply works perfectly...thanks very much:D

thanks, I will read up on the website george suggested. for clarity, there is only one category table where the PK in that table is referenced by two different FKs in the org table and ditto for subcategories. Thanks for the ID advice in the cat type table. The reason I started this thread...

Hi all, I don't have a specific problem, I am just trying to improve and learn. That said, I am attaching the relationships diagram for my current dB. I know that I haven't been that great at a consistent naming pattern, but I am wondering if anyone wanted to comment on the design or...

Ok...thanks