Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-13-2018, 08:09 PM   #1
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Sub Form controls

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
Attached Files
File Type: mdb Sub_Data_Entry_Form_2003.mdb (1.11 MB, 10 views)

access2010 is offline   Reply With Quote
Old 10-13-2018, 10:49 PM   #2
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 819
Thanks: 0
Thanked 185 Times in 185 Posts
June7 will become famous soon enough
Re: Sub Form controls

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.
__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

Last edited by June7; 10-14-2018 at 12:39 AM.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
access2010 (10-26-2018)
Old 10-13-2018, 11:07 PM   #3
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Sub Form controls

add a Sort Order to your subform 's recordsource.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
vagues0ul (10-19-2018)
Old 10-14-2018, 09:15 PM   #4
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

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
Attached Files
File Type: mdb Sub_Data_Entry_Form_B.mdb (664.0 KB, 5 views)
access2010 is offline   Reply With Quote
Old 10-14-2018, 10:10 PM   #5
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Sub Form controls

here. view the code on the AfterUpdate event of those combos on the main form.
Attached Files
File Type: zip Sub_Data_Entry_Form_B.zip (120.4 KB, 9 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
access2010 (10-26-2018)
Old 10-17-2018, 05:43 PM   #6
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

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
Attached Files
File Type: mdb Sub_Data_Entry_Form_B.mdb (756.0 KB, 3 views)
access2010 is offline   Reply With Quote
Old 10-17-2018, 05:47 PM   #7
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

I am sorry but the RTF file was not uploaded
Attached Files
File Type: docx Sub_Data_Entry_Form_B_Adjustments.docx (13.1 KB, 5 views)

access2010 is offline   Reply With Quote
Old 10-17-2018, 10:26 PM   #8
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Sub Form controls

what do you mean by Group? summarized?
Quote:
Create new record does not work
done.
Quote:
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.
Quote:
Up and Down scroll bar does not work on the Main Form
done. use the Up, down Image.
Quote:
How can we have a comma added to the numeric stock quantity
Quote:
Quote:
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.
Attached Files
File Type: zip Sub_Data_Entry_Form_B.zip (98.3 KB, 5 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
access2010 (10-26-2018)
Old 10-18-2018, 11:38 PM   #9
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

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
access2010 is offline   Reply With Quote
Old 10-19-2018, 05:56 PM   #10
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Sub Form controls

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.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
access2010 (10-26-2018)
Old 10-19-2018, 09:33 PM   #11
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

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
access2010 is offline   Reply With Quote
Old 10-20-2018, 01:53 AM   #12
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Sub Form controls

yes please.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-26-2018, 03:58 PM   #13
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 362
Thanks: 166
Thanked 1 Time in 1 Post
access2010 is on a distinguished road
Re: Sub Form controls

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

access2010 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Control to display in Form or be invisible and other Controls to use space PNGBill Forms 5 05-05-2014 01:49 AM
Question Details form from multiple image controls on main form josephbupe General 1 09-16-2013 09:18 PM
Moved controls to tabbed page, controls not working RCheesley Forms 7 10-05-2009 08:24 AM
Auto Populate Form Controls from Form List Box selection alexk15102 Forms 10 01-06-2009 05:39 AM
Disable all Controls except for New Record Controls on Continuous subform airforceruss Forms 0 02-05-2008 01:21 PM




All times are GMT -8. The time now is 02:30 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World