Im coding a program for a veterans organization. My question is, say I have a combobox and it drops down and list all the "Squadrons", so when I choose my Squadron, I click it and it sends me to another page with all the members in the specific squadron, with the option to delete, keep, and add new members.


Anything will help! Thank you!
Please ask any questions needed.

i must have missed it. what is your question?

How do I link a Excel file to a combo box to where I click it, brings up a editable table.


This post was edited by Pat_Man on Jul 28 2013 06:01pm

i'm not following. you need to be more clear

1) you have a combo box. this much i gather. what language is this? html? java? .net? or is this just a cell inside excel and you're trying to use vba?
2) what do you mean link? are you just trying to open an excel file when someone clicks a combo box? or are you trying to read the data inside the excel and populate it into a form on your program?
3) what does editable table mean? you just want it to open the excel file and let them edit it? or you want to copy this table into your program, then when they make changes, you want to modify the excel file?
4) how is this excel file used? does every user have their own on their own computer? or is there only one file in one computer and all the users just use this one computer?
5) how exactly does your program work right now? what language are you using, what frameworks, etc. are you already opening the file and you're not sure how to write to it? or what?

This post was edited by carteblanche on Jul 28 2013 06:21pm

1)I havent started the program yet, so it can be in any language (No html or java please)
2)Read the data inside the excel and populate it into a form on your program
3)Copy this table into your program, then when they make changes, you want to modify the excel file
4)I was going to compile it into the format, Im making it for a central office, I assume it will be on multiple computers.
5)I havent started it


I'll be completely honest with you I haven't coded in a good while, I've been preoccupied with school, girls, army stuff. I've got a year or so experience im just a little rusty.

so you want any language except html and java? sounds very strange, but you can pick anything you like. c/c++/c#/vb.net/ruby/python/etc. use whatever language(s) you learned for the year. make sure you consider how to deploy your updates.

can you explain the restriction to make it excel? this makes it complicated for no reason imo. especially for a novice, i think a relational db will make your life much simpler.

think about concurrency. what's going to happen if two users are trying to modify the same squadron? if one deletes what happens to the other person? is it locked and he can't see it delete? or should it get deleted from his screen? etc

what exactly are you looking for from us? it sounds like you already have a plan.

I completely forgot about that, Thank you very much!!!