Encerrado

VB application

Lookup data from an existing Access database, add new data, store into a new database. Create an exportfile from the new database

## Deliverables

Existing database [url removed, login to view] contains fields:

Fieldname: ean, Type: text, length: 13

Fieldname: titel, Type: text, length: 70

Fieldname: prijs, Type: currency

New database must contain following fields:

Fieldname: ean, Type: text, length: 13

Fieldname: titel, Type: text, length: 70

Fieldname: Calprijs, Type: currency

Fieldname: NieuwePrijs, Type Currency

Fieldname: Aantal, Type: number length 5

Fieldname: Serienaam, Type: text, length 20

Fieldname: Export, True/False (default false)

Fieldname: Credit, True/false (default false)

Screens

Main screen containing four buttons:

1 Start serie (Go to "start serie" screen)

2 Export report (Go to "export" screen)

3 Systeem (go to "syteem" screen)

4 Afsluiten (exit program)

Systeem screen:

Enter/change a path for the existing database ([url removed, login to view])

Enter/change a path for the new database

Enter/change a path for the export file

Enter a factor for calculating price (default 0,25)

Start serie screen

Enter a new name for a series (press start to go to input screen) or select a name from list to continue that serie (doubleclick goes to input screen)

Button: Start

Button: Hoofdmenu Return to main screen

Input screen

Display name of series

5 fields

EAN, Titel, Prijs, Nieuwe Prijs, Aantal

EAN (13 digit number) is entered by keyboard (press enter to start lookup) or barcode scanner (automatically gives CR after barcode, satrt lookup) Display and lookup in ISBNData and display fields Titel (display) and Prijs (multiply by factor entered in system screen, display the outcome)

Nieuwe prijs: enter manually (currency)

Aantal: enter manually (number, no decimals)

For each serienaam an EAN can only occur once. If the same EAN is scanned again in the same series display saved record from new database Nieuwe prijs and Aantal can be altered.

Cursor should start in field EAN then go to Nieuweprijs then to Aantal

Pressing Tab & enter should make cursor go to next field. All fields must be filled before pressing "Opslaan" If a field is empty when pressing "opslaan"return cursor to first empty field.

Button: "Opslaan". Saves all fields to new database (including serienaam, prijs should be saved as the calculated price not the price from the original database). Go to blanc input screen to continue with next title

Buttun: "Wissen". Discard all input. Go to blanc input screen

Button: "Hoofdmenu" If all fields are not empty Display message "Druk eerst op Opslaan of Wissen" press "OK" to return to filled input screen. If all fields are empty pressing this button close input screen and return to main screen.

Export screen

Diplay a list:

Serienaam, Totaal, Export, Credit

Serienaam is the name of the series from the new database

Totaal is the Sum per series of ((CalPrijs-NieuwePrijs)*aantal) for all records in the series

Export True or false If Button export was pressed for this series set to true (default false)

Credit: True or false manually set to true (default false)

Button: "Exporteren"

Select a series by clicking on it, Press button "Exporteren". Create a file containing EAN, Titel, CalPrijs, NieuwePrijs, Aantal, Totaal ((Calprijs-Nieuweprijs)*aantal)

Save file to location entered in systemscreen. Name should be serienaam and type is .csv Message when file is created "Bestand <name> is gemaakt" Press "ok" to return to Export screen.

Button: "Hoofdmenu" Return to main screen

Perhaps Export and credit fields should be in a seperate database together with serienaam as relation to the other database

Habilidades: Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic, Área de trabalho do Windows

Ver mais: return path, data pressing, doubleclick, path scanner, scanner access database, visual basic access application, application store visual basic, barcode scanner access, visual basic currency, data input create report, 2008 barcode scanner, access export mdb, visual currency, barcode system visual basic, change existing access database, keyboard barcode input, visual basic barcode scanner, csv create save, barcode scanner input database, file system scanner, record lookup, text file mdb, record default input, access database change existing field, add data existing access database

Acerca do Empregador:
( 0 comentários ) Netherlands

ID do Projeto: #3042893

43 freelancers estão ofertando em média $291 para este trabalho

fastudiovw

See private message.

$34 USD in 14 dias
(733 Comentários)
7.5
pShankar2

See private message.

$170 USD in 14 dias
(409 Comentários)
7.1
weng0000

See private message.

$51 USD in 14 dias
(788 Comentários)
7.0
hwanghendra

See private message.

$106.25 USD in 14 dias
(460 Comentários)
6.9
canlevw

See private message.

$4250 USD in 14 dias
(56 Comentários)
6.8
shuvrapintu

See private message.

$127.5 USD in 14 dias
(121 Comentários)
6.6
suthernsoftware

See private message.

$133.45 USD in 14 dias
(62 Comentários)
6.6
gkalish

See private message.

$255 USD in 14 dias
(255 Comentários)
6.3
zeesoft

See private message.

$242.25 USD in 14 dias
(198 Comentários)
6.0
DivineSolutions

See private message.

$1020 USD in 14 dias
(57 Comentários)
5.8
jkmcoders

See private message.

$343.4 USD in 14 dias
(13 Comentários)
5.8
mrrcomputers

See private message.

$722.5 USD in 14 dias
(43 Comentários)
5.6
mdsoftsl

See private message.

$148.75 USD in 14 dias
(12 Comentários)
5.0
vw6947279vw

See private message.

$327.25 USD in 14 dias
(20 Comentários)
5.0
pmferreira

See private message.

$102 USD in 14 dias
(51 Comentários)
5.0
seventhsensesl

See private message.

$120.7 USD in 14 dias
(74 Comentários)
5.0
friend12vw

See private message.

$254.15 USD in 14 dias
(13 Comentários)
4.5
farooqgill

See private message.

$255 USD in 14 dias
(15 Comentários)
4.6
jtabordasl

See private message.

$21.25 USD in 14 dias
(44 Comentários)
4.3
jvavadiya

See private message.

$68 USD in 14 dias
(19 Comentários)
4.1