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

$10-30 USD

Cerrado

Publicado

hace alrededor de 6 años

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 16855339

Información sobre el proyecto

25 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

25 freelancers están ofertando un promedio de $28 USD por este trabajo

@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 en 0 día

4,9

(247 comentarios)

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 en 0 día

5,0

(104 comentarios)

6,5

@WebInfoSolutions

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

$35 USD en 1 día

4,9

(40 comentarios)

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 en 1 día

4,7

(75 comentarios)

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 en 1 día

5,0

(70 comentarios)

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 en 1 día

4,9

(72 comentarios)

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 en 1 día

5,0

(12 comentarios)

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 en 2 días

4,9

(13 comentarios)

4,0

@jplepere

use # for date

$25 USD en 1 día

4,4

(1 comentario)

2,3

@MeghaGFreelancer

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

$55 USD en 1 día

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 10 días

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

0,0

@danielcpowell

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

$83 USD en 1 día

0,0

(0 comentarios)

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 en 0 día