Devam Ediyor

495898 enter a number in field on form - and have it fill next

Hello I am attaching a sample microsoft access database.

when you open the database- a form comes up- you will notice the cursor flashing in the second field pre-number-

If you enter a number there - it will fill each record with that number.

If you try to enter a number in the number field- it will reject you- I have found that if i make serial number in tbl2 primary key- it will let me enter number here.

But this is not possible- since serial number has duplicates in real database. ( also only enters same number in all records)

*** it does not matter if you change whole process- just want correct result thank you

what I want:

I want to be able to enter a number into prenumber field and have it populate the next records- UNTILL - I enter another number or exit application.

so it would be like enter 100100 and

pre number number

100100 123

100100 425

100100 511

NOW i change prenumber to 100111

100111 744

100111 748

WITHOUT Changing Prior records- the number changes.

-------------------------

I have only those 2 fields to enter into - because - the other fields in form [serialNumber] and [Code] - are already populated before user gets to this form in data entry process.

----------------------

I need this in next 12 hours- if you can do it - let me know

Beceriler: Her şey Kabul, Veri Girişi, Microsoft Access

Daha fazlasını görün: what is a data entry form in a database, what does data entry do, n is a number, microsoft number, microsoft access data entry form, it field, data entry form in access, data enters, access form data entry, access database data entry form, to make a application form, in process access, serial number change, next next, access form record, flashing code, result number, data enter pre, primary key, application form data entry, serial data access, database data entry form, data entry application form, access database entry form, serial entry

İşveren Hakkında:
( 49 değerlendirme ) indianappolis, United States

Proje NO: #2241813

Seçilen:

frehmanpk

Immediately in this sitting.

0 gün içinde 15$ USD
(27 Değerlendirme)
4.6