Sub Form controls (1 Viewer)

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
In our MsAccess 2003 database we want to use the form = Investment_Transactions_Main = to allow the continuous entries of (Buying & Selling) transaction.

My problem is that when I choose a = Stock Name = or Symbol Stock = the corresponding data for the chosen equity is not grouped in the sub form and I can not enter new records.

Your assistance is appreciated.

Thank you
Mary Jane
 

Attachments

  • Sub_Data_Entry_Form_2003.mdb
    1.1 MB · Views: 68

June7

AWF VIP
Local time
Today, 06:25
Joined
Mar 9, 2014
Messages
5,423
First, advise you not use special characters such as #, $, / in names. Use Num or No for #, just drop the $, use _ instead of /.

If you want to enter data into record with those two comboboxes, they should be in the Detail section. Really shouldn't save Stock_Name or Symbol_Stock or Symbol_Stock_Y, just Investmentl_ID.

If those controls are for input of filter criteria then they should be UNBOUND.

And what do you mean by 'grouped'? Forms do not group records. You can sort and filter. Reports can group records.
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:25
Joined
May 7, 2009
Messages
19,169
add a Sort Order to your subform 's recordsource.
 

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
Thank you for your suggestions, of not using the symbols you advised us of. Our problem is that these characters have been used for over 10 years and to change them is very difficult, BUT we will not be using these characters in the future.

===

Please advise us as to how we can use the chosen Stock Name or Stock Code to group the equities in the Sub Form?

Where should the combo boxes be so that we can use them to group the equities together for editing?

Your assistance is appreciated.

Nicole
 

Attachments

  • Sub_Data_Entry_Form_B.mdb
    664 KB · Views: 63

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:25
Joined
May 7, 2009
Messages
19,169
here. view the code on the AfterUpdate event of those combos on the main form.
 

Attachments

  • Sub_Data_Entry_Form_B.zip
    120.4 KB · Views: 65

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
Thank you for your assistance and what you have supplied us with works.
Could you please look at the attached RTF document for some changes that our Volunteers would like to have, if you could do them for us.

If you happen to be in Cebu, one of our staff is going there soon and could bring you a bottle of Canadian Maple Syrup.

I/We do appreciate your assistance.
Nicole
 

Attachments

  • Sub_Data_Entry_Form_B.mdb
    756 KB · Views: 70

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
I am sorry but the RTF file was not uploaded
 

Attachments

  • Sub_Data_Entry_Form_B_Adjustments.docx
    13.1 KB · Views: 77

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:25
Joined
May 7, 2009
Messages
19,169
what do you mean by Group? summarized?
Create new record does not work
done.
Up and Down scroll bar does not work on the Sub Form
done, but you must be inside the subform. use Up, Down arrow keys.
Up and Down scroll bar does not work on the Main Form
done. use the Up, down Image.
How can we have a comma added to the numeric stock quantity
Where does the “NZ” go in case there is no quantity for = Shares Bought = Shares Sold = in the Shares Currently Owned
see the controls Format Property.
 

Attachments

  • Sub_Data_Entry_Form_B.zip
    98.3 KB · Views: 63

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
Thank you for your assistance.
===
Create new record (my code) does not work
We purchase a new Equity for example, Arnelgp, how do we enter the purchase details?
===
Thank you for fixing
Up and Down scroll bar does not work on the Sub Form
Up and Down scroll bar does not work on the Main Form
===
How can we have a comma added to the numeric stock quantity?
Our Volunteer group manager would like to see the
= Shares Bought Total = Shares Sold Total= and Shares Currently Owned Total= values for each equity group with a comma separator ie; 2,345.
===
“NZ”
In some cases there is no quantity in the field Shares Sold #, therefore I thought we had to have =NZ = in the totaling code
===
I/We do appreciate your assistance.
Nicole
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:25
Joined
May 7, 2009
Messages
19,169
sorry my access is complaining when adding code to the new form i made. there is incompatibility issue. i only have a2016 x64. your db is created in earlier ver.
 

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
Hello and thank you for your note.

One of our machines has Office 2017, should I try and convert the file for you?

Thank you.
Mary Jane
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:25
Joined
May 7, 2009
Messages
19,169

access2010

Registered User.
Local time
Today, 07:25
Joined
Dec 26, 2009
Messages
1,019
All of the later versions of the MsAccess software programs we have, find that the file that you have been helping us with is buggy and we will start anew.

Paul
 

Users who are viewing this thread

Top Bottom