View Code? Open in Web Editor
NEW
Membership register & gym card tracking built with MSAccess
License: GNU General Public License v3.0
VBA 17.07%
FreeBasic 82.93%
jvk_jasenrekisteri's Introduction
๐ Hi, Iโm @peltsippi
๐ญ Mechanical engineer focusing on software development stuff
Been building embedded test devices and various projects
๐ Iโm interested in various things
๐ฑ Iโm currently learning TDD/Project Management etc
๐๏ธ Iโm looking to collaborate on: feel free to ask
๐ซ You can email me [email protected]
jvk_jasenrekisteri's People
Contributors
Watchers
jvk_jasenrekisteri's Issues
If payments are done but no extensions to card then this report will indicate need to extend the card
Just to make sure that board can decide when void representation rights
What is best way to do this?
Add current date to start date instead of 0.0.000
Now it shows only surname and it makes using this much harder!
One another way to check if everything is ok
Some issues with morning cards and updating the dates etc ?!?
Could this be enforced from the card price list?!
There is functionality for changing databasefile if everything is ok during startup. So that functionality works. But now we just need need to do that before things fail in first startup from new location
Pop out combobox when got focus
Just to be sure everything is ok
More clear like that! Now ui is bit awkward did something change or what...
Query pulls all dates, not max dates? Investigate further!
Backup and restore from backup, how to hande this stuff?!?
Just so people know how to stitch this up
Inserting one by one is harder than preparing a CSV or similar.
Card number must be there.
One needs to open and close the combobox to make it valid. Should be fixed
Values come from table and no altering them and end of discussion thats it.
This is now hard-coded but there is no reason to have it like that
nice to have at some point
First: make bulldog photo disappear when admin mode is on. Get rid of the rectangle.
And use disabled buttons instead of hidden buttons!
Just to make things more clear etc...
If there is charge already 1,5 years to the future the new card type will just extend that and card gets 12+ months extra time.
If starting date is changed manually, card charge is shown incorrectly. (Would there be another workaround for this)
It would help when deciding if it is time to slow down with marketing and gym will not get too crowded
Also a graph, active cards on each day and trends and similar?
Not urgent at all atm.
After forms are calculated price cannot be updated manually
Some texts are not shown with smaller resoutions or similar.
Actual data insertion etc is (hopefully) relatively safe. But how to make sure there are no issues?!?
Fix it somehow.
And additional: how to make sure changes are done to the register asap?
Qty around 500-1000 and real values 60-70 or similar
Form not recalculated if begin date is changed
Should pop up after ok is pressed. What about when should the card extension be stored to table? Should this screen have ok/cancel possibility still if something goes wrong or extension cannot be done?
White background, add date range of the printout to the report
Kertakortti gets +2y with every charge, could be one decade additional per year....
Grouped by payment type so it is easier to sort and group stuff.
Should use already available dateselectors for start and end dates