Recent content by ck01

I've got a contact manager application that will be split and the backend will run on a server. I would like to take it to the next step where users can download their current appointments and upload any changes. It would be nice if they could do all of this from the field by logging into our...

OK, I see what you are saying. Still, for this example I am using bound keys.

I'm not sure of Darkat's goal, but on my form both the city and state/province are BOUND controls. If his form is for data entry, he would definately want theset bebound controls.

it works and it does what he wants

I might be able to help you, but I need a lot more clarification.

Well, I was going to upload an example, but this should be just as good and you should be able to follow the code with no problem. Please note that I use a function and two subs. One sub is for the afterupdate event and the other is for the beforeupdate event. You will still need a table...

Here is your solution. Look through the code and adjust your form accordingly. Basically, you will need to add a textbox named firstname, lastname and emailname. The control source for the emailname textbox must be the hyperlink type. Private Sub EmailName_AfterUpdate() ' If you just type...

I have a solution for you. I'll post an example tomorrow. The way you should do this is have the user type in a zip code. If the zip code is in your list, have it grab the city and state information to fill in the form. If the zip isn't in the list, you want a message box asking the user if...

I understand. If you don't mind, I would like to try the solution that you offered and if I have problems upload the database to show you. I hope you will still be around to take a look. Thanks

BY the way, if you have an example database, I would ove to see it.

That's great but.... I'll have to give this a try at home tonight. If I have a problem, I hooe you will still be around to help out. ALso, I will definately upload the database for sharing when it is complete. Thanks again!

Can someone please upload a sample database that demonstrates how to handle price breaks in a table. This could be what I am looking to do with a tiered commission structure that my company uses. Thanks!

I'm working on a contact manager/sales manager database for a company where commission plans are tiered based on the gross margin generated from the sale. The company also has two types of commission plans available to the sales rep (Straight commission & Commission + Base). Here is an example...