Simple Access Problem: Passing parameter to query from OpenRecordset query call? - 01/05/2018 20:27 EDT

$10-30 USD

Closed

Posted

about 6 years ago

$10-30 USD

Paid on delivery

Hello! I have a very simple problem. I have a button that sets a recordset based on a query. For example: rs = [login to view URL]("qryName") This query has a WHERE clause where I need to specify that the records are from a certain year. This year value is pulled from a control on the form the button is located on. For example: WHERE (Year([login to view URL]))=Year([Main]![NavigationSubform]![txtYear]))) However, I get a run-time error because, to the best of my knowledge you cannot use a control in query that a recordset call is used in. I need help making it so my Query can access the value stored in this control.

Microsoft Access

SQL

Visual Basic for Apps

Project ID: 16855339

About the project

25 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

25 freelancers are bidding on average $28 USD for this job

@VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!

$15 USD in 0 day

4.9

(247 reviews)

7.1

@cgullapalli

HI, I am good at Access VBA, Please share the access file to review and change the code required Looking forward to discuss in the chat. -Chandra

$35 USD in 0 day

5.0

(104 reviews)

6.5

@WebInfoSolutions

I checked it is VBA with Access. Can I check the code?...................................................................

$35 USD in 1 day

4.9

(40 reviews)

6.4

@zu02

i, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Access/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Access/Excel projects. I'll do/make working your current sql/ado module . Thank you for your consideration. Zura

$50 USD in 1 day

4.7

(75 reviews)

6.5

@jonathanpradas

Hello and good day. Yes you can use a WHERE clause when opening a recordset. Feel free to message me and I'll work on your project ASAP.

$30 USD in 1 day

5.0

(70 reviews)

5.9

@alaeddindhahri

Hi, I'm a senior Ms Access and VBA developer. Have you tried to get the clause built inside the query, then you simple run the query with no problem? I can show you how in a minute. Hit me up!

$15 USD in 1 day

4.9

(72 reviews)

5.9

@havit

Yes, we can't use control referenced query on .OpenRecordset because it can't evaluate the value from the control. The only option is create the SQL and open it on live or update query with the real value of the control and call the query by .OpenRecordset.

$25 USD in 1 day

5.0

(12 reviews)

5.6

@prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details

$35 USD in 2 days

4.9

(13 reviews)

4.0

@jplepere

use # for date

$25 USD in 1 day

4.4

(1 review)

2.3

@MeghaGFreelancer

that is problem in code. I can fix it. can u confirm your timeframe ?

$55 USD in 1 day

0.0

(0 reviews)

0.0

@Mohammedafifi80

Hi, i'm read you job description and understand what you need and i can do this job and solve the run time problem with in one day, i have excellent experience in MS Access and recently i'm finished 2 Access Database, i can sent to some example about it.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@BestCode3ver

I’m new to freelancing. I have lots of experience with MS Access and VBA and have built many complex database applications with the combination.

$17 USD in 10 days

0.0

(0 reviews)

0.0

@guypender

Hi there, I'm Guy and I live in Angmering on the south coast of England. I am a software engineer with over 15 years of experience in Microsoft programming languages and applications. I have quite a lot of MS Access experience though I tend to work with SQLSERVER and WPF these days. I'm confident I could solve your issue and would welcome the opportunity to start my journey on Freelancer with you. Kind regards Guy

$15 USD in 1 day

0.0

(0 reviews)

0.0

@danielcpowell

I can turn it around quickly Relevant Skills and Experience I have 15 years programming in access vba

$83 USD in 1 day

0.0

(0 reviews)

0.0

@mansoorhasan

I have a long working experience of using MS-Access. This is a very small task. I hope that someday I will be doing some bigger job for you. As a new Freelancer, I am asking you for the lowest bid.

$14 USD in 0 day