Code info

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Good Morning!
I have been working in Access for several years on this
accounting Database.
The is for receivables.
WE get a payment in, I have to go to the invoice table to
mark invoice as paid, then go to the payments table to
record the payment. I have designed into the payments
table an invoice number so what I want to do is only have
to open the payments table and it will mark the invoice
paid in the invoice table. One step rather than two.
I am not sure where I should enter code or if I should use
a macro. Any help would be greatly appreciated.
Thanks!
Wendy
 
I would have a screen for entering payments (if you don't already have one) where all the appropriate data - invoice, amount, check number, etc. - is entered and then have a CommandButton to apply it to the tables. Personally, I'd put code behind the CommandButton but use whichever you're more comfortable with.

----- Wendy wrote: -----

Good Morning!
I have been working in Access for several years on this
accounting Database.
The is for receivables.
WE get a payment in, I have to go to the invoice table to
mark invoice as paid, then go to the payments table to
record the payment. I have designed into the payments
table an invoice number so what I want to do is only have
to open the payments table and it will mark the invoice
paid in the invoice table. One step rather than two.
I am not sure where I should enter code or if I should use
a macro. Any help would be greatly appreciated.
Thanks!
Wendy
 
You need to learn how to write Forms. All users should view & enter data via
forms, not by opening the tables directly. Get a "learning Access" book &
look for "Writing Forms", etc.

HTH,
TC
 
Back
Top