Macro for "GenerateParcels" button.

Creating tables and queries
Post Reply
cjcesconetti
Posts: 1
Joined: Wed Oct 03, 2018 1:52 am

Macro for "GenerateParcels" button.

Post by cjcesconetti »

Hello guys.

I researched here in the forum, but so far I have not found what I'm looking for.
(I apologize for any mistake in English, I'm Brazilian)

I want to set up a payment control system.

In my sales form (SaleForm), I need to add a "GenerateParcels" button to automate this process of posting these parcels in a SubForm, with the following fields:

(SaleSubForm-Parcel)
* Parcel-ID
* Order-ID
* Parcel-No (ex .: 1ofX, 2ofX, 3ofX ...)
* ValueParcel
* ExpirationDate (ex .: 10-25-2018, 11-25-2018 ...)
* PaidOut
* PaymentDate


Can someone help me.

I will be immensely grateful.
OpenOffice 3.1
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Macro for "GenerateParcels" button.

Post by UnklDonald418 »

Here is a macro for copying the contents of one row in a Base table into the next row
Base Copy Field or Clone Record – Example
If that isn't what you are trying to do, then please give us more information about your database tables and their relationships.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply