Increment number based on list box

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Net Admin (NetAdmin_at_discussions.microsoft.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 05:21:04 -0800

Hello. I'm creating a bid database for a company to track their sales
efforts. What I'm trying to do is automatically generate a proposal number
based on the region selected from a list box in a form. So the list box has
the options North, South, East, and West. The following text box is where I
want the proposal number to auto-gen. So if somebody chooses North, I would
want that text box to show a number of 07050001 and keep incrementing from
there to 07050002, 07050003, and so on. I must be writing my VB functions
wrong because I can't accomplish this! Can somebody throw an idea or
suggestion at me to get this done? Is there a macro that can accomplish this
maybe? Thank you for the help.

Relevant Pages

  • RE: Formula and Table Joining in a Query
    ... "KARL DEWEY" wrote: ... Correct/Incorrect for each sale in the sales data table. ... I tried to accomplish this by adding a column called Label to the second ...
    (microsoft.public.access.queries)
  • Using/Display Text as Measure
    ... Is it possible to have text in the "measures" area of the pivot table? ... their sales totals for the month in the measures section. ... dimenstion of this data) on the same chart. ... Is there anyway to accomplish this, if not I will not be able to use ...
    (microsoft.public.sqlserver.olap)
  • setting up spreadsheet
    ... using excel for sales contact log. ... I apologize, not sure how to even ask what i'm trying to ... accomplish. ...
    (microsoft.public.excel.misc)