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

$10-30 USD

Lezárt

Kiadva ekkor:

majdnem 6 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

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

Projektazonosító: 16855339

A projektről

25 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

25 szabadúszó adott átlagosan $28 USD összegű árajánlatot erre a munkára

@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 0 napon belül

4,9

(247 értékelés)

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 0 napon belül

5,0

(104 értékelés)

6,5

@WebInfoSolutions

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

$35 USD 1 napon belül

4,9

(40 értékelés)

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 1 napon belül

4,7

(75 értékelés)

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 1 napon belül

5,0

(70 értékelés)

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 1 napon belül

4,9

(72 értékelés)

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 1 napon belül

5,0

(12 értékelés)

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 2 napon belül

4,9

(13 értékelés)

4,0

@jplepere

use # for date

$25 USD 1 napon belül

4,4

(1 értékelés)

2,3

@MeghaGFreelancer

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

$55 USD 1 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 10 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

0,0

@danielcpowell

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

$83 USD 1 napon belül

0,0

(0 értékelés)

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 0 napon belül