Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-09-2019, 07:08 PM   #1
Zet
Newly Registered User
 
Join Date: Sep 2019
Posts: 1
Thanks: 3
Thanked 0 Times in 0 Posts
Zet is on a distinguished road
Forms

Hello guys,
I'm having trouble with creating a combo box and textbox in a mainform that will filter the datasheet in the subform datasheet using "Name, Year, Semester" fields. I have found some for combobox but they are still kinda advanced and not readable for me sometimes.





P.S. I'm pretty desperate since I have a subject's final project due tomorrow that's to create a database with Microsoft access. I do know some programming but I have no idea how to make things work in MS ACCESS. It is comparatively difficult since I'm using it in a virtualbox installed on Mac so I'm not so used to using Ctrl + Keys. It'd be much appreciated to follow somewhere easy because all I found are advanced or "how to create and design a form" stuffs. I'd like to learn VBA for forms in a short time.

Zet is offline   Reply With Quote
Old 09-09-2019, 07:35 PM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,082 Times in 2,037 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Forms

I'll just say good luck, I don't think someone here will make your project for you, so show what you have and where you've the problem.
Learning VBA in a short time, forget it, it take years if you don't have any experience with other programming languages.
If you need to finish the project tomorrow, how long did you've had to complete the project?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-09-2019, 08:07 PM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,307
Thanks: 534
Thanked 937 Times in 888 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Forms

This might get you started with VBA,

https://www.niftyaccess.com/vba-beginner/



Sent from my Pixel 3a using Tapatalk

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Zet (09-09-2019)
Old 09-09-2019, 08:12 PM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,307
Thanks: 534
Thanked 937 Times in 888 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Forms

Here's a bit on filtering:-

https://www.niftyaccess.com/easily-apply-filters/



Sent from my Pixel 3a using Tapatalk
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Zet (09-09-2019)
Old 09-09-2019, 08:17 PM   #5
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,307
Thanks: 534
Thanked 937 Times in 888 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Forms

This assumes you have the basics down pat, so might be a bit advanced for you just now:-

https://www.niftyaccess.com/sql-stat...for-beginners/

Sent from my Pixel 3a using Tapatalk

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Zet (09-09-2019)
Reply

Tags
combo box , combobox , forms , textbox , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
When i open saved info on forms, show it on forms again? trizzytt General 5 10-06-2017 01:52 PM
Best Practice: How to Ensure Forms Dependent on Other Forms are Refreshed whdyck Forms 2 11-21-2012 06:53 AM
Required fields in forms and their sub forms. (Suppress warnings?) JGalletta Forms 7 03-29-2012 11:13 AM
Help with Forms List Box Double Click and Passing Info among forms dj_mix Forms 1 04-11-2008 04:34 AM
Open Pop-Up Forms Based On Criteria in Main Forms BlueFraggle Forms 3 07-25-2007 09:29 AM




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


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

Featured Forum post


Sponsored Links


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