Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2018, 03:42 AM   #1
bkhawaja
Newly Registered User
 
Join Date: Nov 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
bkhawaja is on a distinguished road
How to enter query parameter value through vba

In attached file I want to enter query parameter automatically through vba. can you please help me out.
Attached Files
File Type: accdb SAMPLE.accdb (576.0 KB, 8 views)

bkhawaja is offline   Reply With Quote
Old 11-10-2018, 06:07 AM   #2
theDBguy
Newly Registered User
 
theDBguy's Avatar
 
Join Date: Oct 2018
Posts: 110
Thanks: 1
Thanked 16 Times in 15 Posts
theDBguy is on a distinguished road
Re: How to enter query parameter value through vba

Hi,

Take a look at this function for an example.

Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
MickJav (11-10-2018)
Old 11-10-2018, 06:25 AM   #3
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 554
Thanks: 24
Thanked 5 Times in 5 Posts
MickJav is on a distinguished road
Re: How to enter query parameter value through vba

Another link for my access toolbar lol

__________________
After 20 years working with access i have no more hair to give.
MickJav is offline   Reply With Quote
Reply

Tags
query parameter passing

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove enter parameter value in query lsingh165 Queries 1 01-28-2013 06:18 AM
Enter Parameter Value despite no Parameter in query reklaw Queries 5 09-15-2011 10:34 AM
'Enter Parameter Value' in Update Query hammer6 Queries 5 09-11-2009 01:52 AM
Enter Parameter Value problem in query uldis Queries 4 08-29-2008 02:22 AM
Query help - Enter Parameter Value piet123 Queries 2 05-25-2004 12:49 AM




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


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