Copy data to a blank field (1 Viewer)

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
We have had no success and would like to start a new empty row
When at the blank Vendor #. we would like to click K_01 and the Vendor # will populate the blank vendor # field
When at the blank Cheque #. we would like to click K_02 and the Cheque # will populate the blank cheque # field
When at the GST calculated field, we would like to click K_03 and the GST $ value will populate the blank GST field

Thank you for any suggestion you have for our Access 2003 Data Base.
Nicole
 

Attachments

  • GST_Calculation.mdb
    428 KB · Views: 55

JHB

Have been here a while
Local time
Today, 10:50
Joined
Jun 17, 2012
Messages
7,732
Where should the Vendor # come from?
 

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
Thank you for your question.
The Vendor number and the Cheque number should come from their above fields.

Thank you,
Linda
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:50
Joined
May 7, 2009
Messages
19,169
Is this what you meant
 

Attachments

  • GST_Calculation.zip
    47.4 KB · Views: 37

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
Thank you for helping us with our data entries.
K_01 works
K_02 works
but K_03 is not coping the calculated date to the field = GST - $

I do appreciate your assistance and the two copyings that you have done which will help us A LOT

If you could assist us on the K_03 copying, we would appreciate it.

Regards
Lisa
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:50
Joined
May 7, 2009
Messages
19,169
Is there any formula for the date, could you show us.
 

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
Hello.
The date for each transaction is entered manually using the date on the Vendor's invoice.

We use a mask for display purposes = dd mmm yyyy

Thank you for your question.

Nicole
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:50
Joined
May 7, 2009
Messages
19,169
so you are talking about the date (above gst - $).
 

Attachments

  • GST_Calculation[1].zip
    44.8 KB · Views: 53

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
Hello and thank you for your assistance.

The date column was changed by us by us to a CATEGORY column and not updated on the form which we had sent to you, sorry!

K_01 = this button works and we would like to copy this fuction to our working form, but I do not know how to copy over your book mark. Can you please advise me?

K_02 and K_03 does mot seem to be working.

Thank you for trying to help our Volunteer group.

Regards,
Lisa
 

Attachments

  • GST_Calculation_02_Feb18.mdb
    516 KB · Views: 51

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:50
Joined
May 7, 2009
Messages
19,169
please try again
 

Attachments

  • GST_Calculation_02_Feb18.zip
    48.6 KB · Views: 52

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
W O W.
Thank you for your assistance and your form works perfectly.

We do appreciate your assistance.

Nicole
 

access2010

Registered User.
Local time
Today, 02:50
Joined
Dec 26, 2009
Messages
1,019
The 3 other volunteers in our office, asked me to thank you for helping us with our data entry.

Thanks again.
Nicole
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:50
Joined
May 7, 2009
Messages
19,169
you are welcome ma'am.
also to the 3 others, i greet them too.
 

Users who are viewing this thread

Top Bottom