Find Jobs
Hire Freelancers

Code

$5-10 USD

In Progress
Posted over 22 years ago

$5-10 USD

Paid on delivery
I am looking for some code i am using an adoc1 control to the access database and the query code is below what i am looking for is if no results are found to disply a message box no plans Private Sub BuildSearchSQL() Dim sSQL As String ' We will look the [login to view URL] for building the SQL If [login to view URL] = [login to view URL] - 1 Then ' "All Plans" sSQL = "SELECT * FROM Plans" ElseIf [login to view URL] = 0 Then ' Nothing selected get lost from here Exit Sub ElseIf [login to view URL] = 1 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Fixed')" ElseIf [login to view URL] = 2 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Discount')" ElseIf [login to view URL] = 3 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable')" ElseIf [login to view URL] = 4 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Fixed' OR Type = 'Discount')" ElseIf [login to view URL] = 5 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable' OR Type = 'Discount')" ElseIf [login to view URL] = 6 Then sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable' OR Type = 'Fixed')" ElseIf [login to view URL] = 6 Then ' if u add any thing else in the combo box ' please add the SQL End If ' Now initialise the form and show the form ' this is how one shoulf pas the data to the form ' Also you can define publice variable in the form and pass the ' data with [login to view URL] ' But the approch shown below is more convient and professional [login to view URL] sSQL [login to view URL] [login to view URL] Hope some one can help with this for me. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
Project ID: 2833786

About the project

4 proposals
Remote project
Active 22 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
See private message.
$2 USD in 14 days
5.0 (15 reviews)
2.7
2.7
4 freelancers are bidding on average $6 USD for this job
User Avatar
See private message.
$6.38 USD in 14 days
5.0 (27 reviews)
5.0
5.0
User Avatar
See private message.
$6.80 USD in 14 days
5.0 (38 reviews)
4.1
4.1
User Avatar
See private message.
$8.50 USD in 14 days
5.0 (17 reviews)
3.2
3.2

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
2
Member since Dec 5, 2001

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.