Search results

I am wanting to sum up all deposits and all withdraws and get a balance. I have been unable to figure this out. Here is my sql statement sql = "SELECT Sum([DepositAmount])-Sum([PaymentAmount]) AS Balance " & _ "FROM(tCTransactions)" & _ "GROUP BY...

I moved this to the sql area. Sorry.

I love this quote regarding conservatives and liberals. Hooks

Thanks a bunch. I really do appreciate all of the help. Im sure ill be back will more questions. Hooks

It sounds to me like you need to split your database. Have a front end(your forms) database and a back end(your tables) database. When you need to update or add different things you just add them to the front end and the tables remain the same. Hope this helps. Hooks

Indeed. I just thought that this would violate the rules of a 3 tier design. guess i was wrong. thanks for all of your help Hooks

Wouldn't you have to know the Primary Key of the customer? me.comboboxCustomerStatus.text = objCustStatus.FindCustomerStatus() The findCustomerStatus would need to know the ID of the customer. Wouldn't this violate the 3 tier design?? Hooks

One more question, a couple of post ago i posted the code for how i am retreiving the customer object and populating the text fields on the form. The problem was populating and finding the customerstatus in a combo box for the selected customer. Now if i add the following code to the...

Cool, so i just make a customer status object in the business tier and make a getCustomersStatus function and call it in the lstCustomers_SelectedIndexChanged event? Makes sense to me. thanks a bunch. Hooks

Nice article. Thanks a bunch. Im going to post a bunch of the code that i am using so that you can see how i am doing things. Im sure there are better and more efficient ways to do this but i seem to understand this method. I figured that there are a thousand ways to do it and i dont have...

Im a little confused. Im going to post a whole lot more info in a few more hours so that you can see what im talking about. I beleive that we are talking about the same thing just in a different language. :) Thanks for the help. I feel like if i can get this then ill be ok with the 3-tier...

Sorry for not being clearer. Im still very new to this and do not know the terms needed to explain to you want i am needing. The middle-tier is what i am wanting. The above is exactly what i am wanting. Im talking about the method to get the data to fill the combos. Should that method be...

So in my example i would use the customer class to populate the listbox. then when user selects a customer i would populate the CustomerStatus with the CustomerStatus class which has a GetCustomerStatus method? Is this correct??? Thanks again, you all are great

lol really funny

Thanks guys, I was just using states as an example. Say i have a customer object that populates a list box. Upon clicking the list box all the other customer fields are displayed. Say i have a CustomerGroup and a CustomerStatus class both of which are combo boxes on the customer form. Do i...

Hey all, I have played around with a 3-tier design for about 1 year and am able to make your basic applications using them. My problem is this. Say that you have a Customer class. I would populate a list box on a form with the customer object and when a user selects a customer all the other...

I had a really hard time getting it to run on my pc but loading the 43mb patch made it work. Apparently anyone using ATI graphic cards couldn't play the game until the patch was applied. I highly recommend the patch. Its gonna take some time getting used to the busy GUI but I believe that I...

Does anyone have and good docuements to pass out to people who want you to design a database for them. Like what are the requirements etc???

Thanks a bunch.

lol me 2 :)