User Forms - getting them to talk to Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hello Again,

As some of you already know, I have been working on a quote module for
my company. After extensive gnashing of teeth, and pulling of hair as I
fought with several coding problems, I have completely ditched the first
try, and I am now on round two.

I realized most of my problems were stemming from my trying to prevent
my users from being able to unintentionally mess things up, while
keeping the whole thing friendly to those that are not friendly with
computers.
Through all my research, it finally dawned on me that I need to be
using a series of user forms.

User forms seem easy enough, and so far making it look like I want
isn't a problem at all. Figuring out how to get it to put the
information into Excel the way I want has been. This leads me to the
first two questions in what is likely to be a long series of questions
in the future.

1. What code do I use to sequentially have the user go through the
user forms in the order I want them to.

And

2. I have a list of client names with their corresponding contact
information in a combo box, so my users are picking the client they
want to quote from the drop down list. Because we frequently quote new
clients, I wanted a way to give them an option to add a new client. No
problem. I found the code to add them to the list, and it works!
Hurray
The question is, how do I expand the row source to reflect the new
addition/s, and how do I keep the users from adding duplicate clients.

Any advice will be helpful.

Thanks in advance to everyone who reads or posts to this tread.
Amber :)


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30012
View this thread: http://www.excelforum.com/showthread.php?threadid=505875

.

Relevant Pages

  • Re: Posted before didnt get a response- populating dropdown 2 sou
    ... When preparing a quote you would typically build a form based on the Quote ... Any Client information you wish to appear on the Quote form can then ... Anything in the taxexempt table is really JUST jobs ... setting the Row Source of cboJob. ...
    (microsoft.public.access.forms)
  • Re: Web Design Term Help Needed
    ... > "The acceptance of a commission by the client is based on the client ... how is the standard and quality definbed? ... > original quote will be invoiced for. ...
    (uk.legal)
  • Re: Posted before didnt get a response- populating dropdown 2 sou
    ... When preparing a quote you would typically build a form based on the Quote ... Any Client information you wish to appear on the Quote form can ... jobs in the quote form will show up in the dropdown for the quotes form- ... can build your combo box row source from the table, ...
    (microsoft.public.access.forms)
  • Re: Oracle Spatial?
    ... Just remove the "nospam." ... with one of my client as a Technical Manager.The client would like to ... Technical Gurus to join my team.If you are in USA and interested for a ... <end quote> ...
    (comp.databases.oracle.server)
  • Re: VB Project cost estimation
    ... > In the past all my paid VB programming has been billed on an hourly basis. ... > Now a client wants me to quote a figure for an entire project and I am not ... the client is happy and you are happy. ... Don't be afraid to walk away. ...
    (microsoft.public.vb.general.discussion)