After writting the select statement below using the word Distinct the error Object doesn't support this property or method started appearing. I did a check by removing the data connection to this query and the error did not occur, how can I resolve this?
this is the select statement -
SELECT DISTINCT
-
H_DUTY_PER.H_DUTY_PER_ISST,
-
H_DUTY_PER.H_DUTY_PER_EXPT,
-
H_PER.H_PER_ISST,
-
H_PER.H_PER_EXPT,
-
INS_CERT.INS_CERT_ISST,
-
INS_CERT.INS_CERT_EXPT,
-
MOB_ADV.MOB_ADV_ISST,
-
MOB_ADV.MOB_ADV_EXPT,
-
RD_WORTH.RD_WORTH_ISST,
-
RD_WORTH.RD_WORTH_EXPT,
-
VEH_DESCRIPTION.VEHICLE_NO,
-
VEH_DESCRIPTION.ENGINE_NO,
-
VEH_DESCRIPTION.CHASIS_NO,
-
VEH_LIC.VEH_LIC_ISST,
-
VEH_LIC.VEH_LIC_EXPT,
-
VEH_TYPE.VEHICLE_TYPE
-
FROM
-
H_DUTY_PER ,
-
H_PER, INS_CERT,
-
MOB_ADV,
-
RD_WORTH,
-
VEH_DESCRIPTION,
-
VEH_LIC, VEH_TYPE
-
WHERE
-
VEH_DESCRIPTION.VEHICLE_ID=VEH_TYPE.VEHICLE_ID And VEH_DESCRIPTION.VEHICLE_NO=VEH_LIC.VEHICLE_NO AND VEH_DESCRIPTION.VEHICLE_NO=H_DUTY_PER.VEHICLE_NO AND VEH_DESCRIPTION.VEHICLE_NO=H_PER.VEHICLE_NO AND VEH_DESCRIPTION.VEHICLE_NO=INS_CERT.VEHICLE_NO AND VEH_DESCRIPTION.VEHICLE_NO=MOB_ADV.VEHICLE_NO AND VEH_DESCRIPTION.VEHICLE_NO=RD_WORTH.VEHICLE_NO;
-
and this is how i did the join using visual basic to the Access Database -
DVehQry.DatabaseName = App.Path & "\VEHICLE_TRACKER.mdb"
-
DVehQry.RecordSource = "VEH_QRY"
-
then to the various text box that would display the data in the field of the Db, i used this code -
Text1(3).DataField = "VEHICLE_TYPE"
-
Text1(6).DataField = "VEHICLE_NO"
-
Text1(4).DataField = "ENGINE_NO"
-
Text1(5).DataField = "CHASIS_NO"
-
Text2(0).DataField = "VEH_LIC_ISST"
-
Text2(1).DataField = "VEH_LIC_EXPT"
-
Text2(2).DataField = "H_PER_ISST"
-
Text2(3).DataField = "H_PER_EXPT"
-
Text2(4).DataField = "RD_WORTH_ISST"
-
Text2(5).DataField = "RD_WORTH_EXPT"
-
Text2(6).DataField = "INS_CERT_ISST"
-
Text2(7).DataField = "INS_CERT_EXPT"
-
Text2(8).DataField = "MOB_ADV_ISST"
-
Text2(9).DataField = "MOB_ADV_EXPT"
-
Text2(10).DataField = "H_DUTY_PER_ISST"
-
Text2(11).DataField = "H_DUTY_PER_EXPT"
-
.
Please how do i resolve this issue
0 964 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Kyle Goetz |
last post by:
hey, i'm new to mySQL...this meaning that i have tried ~10000 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it)...
|
by: Jim |
last post by:
I'm working on my first .net project using c#. I've been using
activex controls embedded in a web page and wanted to do the same in
..net. My approach has been to create a windows control library...
|
by: banz |
last post by:
Hello
I have a problem to resolve: I wrote a Perlscript which caches data from a
server (local on my machine) I would like to have a other connection to a
remote server but I don't know how to...
|
by: Ryan Ritten |
last post by:
Hey,
I just started working at this new company and they gave me a simple
database project to start with. yet I am starting to look like an
idiot cause I can't even seem to connect to the MS...
|
by: iwdu15 |
last post by:
hey, i was wondering if 1) anyone could tell me whats wrong with my code, i
did a little fixing to the msdn version fo this, or 2) how to make a simple
program that will connect and listen for...
|
by: perjorgen |
last post by:
Hi,
My asp.net can't connect to any sql database when running 1.1
I can connect to databases if I make a windows application and if if I run
asp.net 2.0
Other computers have no problem...
|
by: d3vkit |
last post by:
Okay so I am at a loss here. I have a website that I've previously had no trouble connecting to the mysql DB on. I have an include to a connect file with the relevant connection info, and it was...
|
by: Mikael Arhelger |
last post by:
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the...
|
by: dfarney |
last post by:
So I've created a Windows based application in C# that uses data from our databases on a service provider (crystaltech). The application has been deployed and has been working great on all our...
|
by: DKn |
last post by:
Hello All,
I am doing one C#.Net(2.0) Windows application having treeview control, with some tree nodes like "Logical disk, Memory, CPU, CDROM drive, etc.."
On treeview After select event, on...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |