Виконано

Generate Sequence String

Generate Sequence String

Seeking a sequence incrementing/generating model for an Access 2000 Application.

The sequence is an Order Number (string) and provides an informational meaning for my

client. Here is an example 03-2006-001S. The 03 represents the month. 2006 is the year,

001 represents the first 'S-type' order in the month of March 2006 and S represents the order

type. There are 3 types of orders: Services (S), Goods (G) and Consulting(C).

Therefore, one of the difficulties is that the sequence begins at 001 at the start of

the month and there are separate numbers for the order types. Some examples:

03-2006-001S

03-2006-001G

03-2006-001C

03-2006-002S

03-2006-002G

03-2006-002C

The order number (OrderNumber) is kept in an orders table (tblOrders).

The autoincrementing PK index in that table is called OrderID. For our purposes

assume there are three other fields: OrderDate (defaults to current Date), OrderCode (S,G,C

referenced above - actually another related table has these values in a numeric form S=1,

G=2, C=3) and customerName.

I am using a custom form wizard to lead the end-user through the data entry process. The

first page of the wizard collects/sets the OrderID, the OrderCode and the CustomerName. This

basically saves the record. The order number is created on the on-click event of the "Next"

button of the wizard so that the Order Number is displayed on the second page of the

entry wizard.

Unfortunately, I don't understand how to generate [url removed, login to view] datepart function and Format function

e.g. Format$(001,"000") can be used for part of the string, but it appears that I

will need additonal fields and logic to solve this puzzle.

Your ability to work on this immediately will impact selection process.

## Deliverables

1) working prototype example of generator in Access 2000.

2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Access 2000

Навички: Техніка, Microsoft Access, MySQL, PHP, Архітектура ПЗ, Тестування ПЗ

Деталі: types of data entry fields, to string, string the, string i, string 2, prototype part 3, prototype engineering for hire, prototype date, php data entry form example, model services agreement, meaning of data entry work, logic wizard, legal consulting services agreement, lead selection, lead it consulting, lead generating services, it lead generator, it consulting agreement, how to string, hire lead generator

Про роботодавця:
( 316 відгуки(-ів) ) United States

ID Проекту: #3358050

Доручено:

GeluExvW

See private message.

$85 USD за 2 дні(-в)
(151 відгуків(-и))
6.3

13 фрілансерів(-и) у середньому готові виконати цю роботу за $92

javaoraclepro

See private message.

$126.65 USD за 2 дні(-в)
(167 відгуків(и))
7.5
GetReal

See private message.

$85 USD за 2 дні(-в)
(312 відгуків(и))
7.3
pShankar2

See private message.

$85 USD за 2 дні(-в)
(409 відгуків(и))
7.1
Premshanks

See private message.

$85 USD за 2 дні(-в)
(350 відгуків(и))
6.5
eescalantesl

See private message.

$85 USD за 2 дні(-в)
(84 відгуків(и))
5.9
sondravw

See private message.

$85 USD за 2 дні(-в)
(11 відгуків(и))
4.6
hawkswayvw

See private message.

$140.25 USD за 2 дні(-в)
(12 відгуків(и))
4.5
foundationsvw

See private message.

$85 USD за 2 дні(-в)
(25 відгуків(и))
4.1
coolfella

See private message.

$85 USD за 2 дні(-в)
(15 відгуків(и))
2.9
arsSQL

See private message.

$85 USD за 2 дні(-в)
(9 відгуків(и))
2.7
vw1641023vw

See private message.

$85 USD за 2 дні(-в)
(0 відгуків(и))
0.0
talhamajeed

See private message.

$85 USD за 2 дні(-в)
(0 відгуків(и))
0.0
AndrewHook

See private message.

$85 USD за 2 дні(-в)
(0 відгуків(и))
0.0