Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-13-2019, 01:58 AM   #1
supraman
Newly Registered User
 
Join Date: Jun 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
supraman is on a distinguished road
i want VBA to display values greater than given number

HI,

Please help me to solve the problem, i tried to create 2 text box from ActiveX control, where first box will search given text value for me from the range, and i want to put a certain no to my 2nd text box which required to concatenate with the first text boxes value and will display me the data equal or greater than the value provide in the 2nd box.

example:-

In Sheet1, D column is having my data like - "Gold (5),Gold (20),Gold (15), Silver (10),Silver (15)" etc. all numeric values are in ().
in first text box i put the criteria for filter =textbox1.value & "*" for related search Now can any one help me what to do or how to code the second box so that if i put "10" in the second box along with the first box value as "Gold" it display data for >=Gold (10) from D column.

Its Urgent, in case any question please call me on 7618788845

supraman is offline   Reply With Quote
Old 06-13-2019, 04:04 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,090
Thanks: 476
Thanked 893 Times in 848 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: i want VBA to display values greater than given number

Is this an Excel question?

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
Old 06-13-2019, 05:28 AM   #3
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,672
Thanks: 398
Thanked 637 Times in 618 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: i want VBA to display values greater than given number

You do realise that Gold (5) is greater than Gold (10) in your check?

Code:
? "Gold(5)" > "Gold(10)"
True

__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Reply

Tags
vba access 2010 excel

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How Filter greater number in a Form adnanali166 Macros 1 04-08-2017 03:14 AM
[SOLVED] Criteria in query is greater than or equal to 15% but it gave values less than 15%!y? nofeara Queries 5 11-24-2013 09:53 PM
Divide by all values greater than a string of 0 length clintonmadden Excel 3 08-13-2010 01:46 AM
how to display when percent greater than 100% barlee Reports 9 10-21-2009 11:54 AM
Report results for dates greater than a parameter date don't display. Lura Reports 2 08-25-2000 12:03 PM




All times are GMT -8. The time now is 07:04 PM.


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