Change field value with macros

[Guest]

I need someone to help me.
I created table with one field named “Num†as data type “Number†(Long
Integer, Decimal Places=0). In this field I put a number like 1234 as a
first record. Also I created a form with Text Box and Command Button.
With this button I want:
1.To take value from first record
2.To add 1 to the value (1234+1) and to record new value (1235) in new record
3.To delete first record (I want to keep only one record)
4.To put value of first record (previews new record) automatically in Text
Box.

 

[Jeff Boyce]

If there will only be one record, would you be able to simply increment the
value in place by one?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

In this field I want to generate following numbers which I’ll use for records
in separate forms and reports. As Example: I have separate “Invoice†and
“Credit†data tables, forms and reports in one project, but they haven't
relations among themselves. I need first “NumInvoice†to be 1234, second –
to be 1235 and if I create Credit record, the “NumCredit†to be 1236,
followed by NumInvoice = 1237 and etc.

 

[Jeff Boyce]

I believe I understand the need to increment, but I was asking why you would
need to add a new record at all. Could you simply change the record you
already have?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/