Access Query thru ADO.Net

[Mathew]

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data Form
Wizzard) not all my fields are there. Can someone explan
why that is and how I can fix that?

 

[Miha Markic]

Hi Matthew,

How does your query look like?

 

[Mathew]

Hi Miha

I don't know if this will help or not but, here is the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate, tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice, tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] = tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];

 

[Miha Markic]

Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate, tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice, tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] = tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];

-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com




.

 

[Otis Mukinfus]

Hi Matthew,

I guess that fields ending with # are missing?

I'd guess you're correct, Miha.


Otis Mukinfus
http://www.otismukinfus.com

 

[Mathew]

so basically if I switch all my variables over to either
a # for numbers or $ for text I should be just fine?

-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate, tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice, tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] = tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];

-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data Form
Wizzard) not all my fields are there. Can someone explan
why that is and how I can fix that?


.

.

 

[Mathew]

so if I switch my variables over to either a
# for numbers and $ for characters every thing
should work just fine?

 

[Miha Markic]

Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to either
a # for numbers or $ for text I should be just fine?

-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate, tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice, tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] = tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.

.

 

[Mathew]

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?

-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to either
a # for numbers or $ for text I should be just fine?

-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate, tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice, tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] = tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now (),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.



.

.

 

[Miha Markic]

Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?

-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now (),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data
Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.



.

.

 

[Mathew]

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my column
names when I go through ADO.Net? That is the problem I am
having. I can see most of my columns but, not all of them.

Mathew

-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?

-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now (),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS ACCESS.
where I look at my fields from my query (in Data
Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.



.



.

.

 

[Miha Markic]

Don't use non alphanumeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my column
names when I go through ADO.Net? That is the problem I am
having. I can see most of my columns but, not all of them.

Mathew

-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?


-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to
either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN
tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now
(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

I am trying to access a query I wrote in MS
ACCESS.
where I look at my fields from my query (in Data
Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.



.



.

.

 

[Mathew]

Miha

What do I do now with my date, currency, number
columns? Plus I have a AutoNumber column. All of these
columns have data in them and changing them over to a
TEXT field will have a major impact on them.

Mathew

-----Original Message-----
Don't use non alphanumeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my column
names when I go through ADO.Net? That is the problem I am
having. I can see most of my columns but, not all of them.

Mathew

-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?


-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to
either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but, here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason, tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN
tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now
(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

[email protected]...
I am trying to access a query I wrote in MS
ACCESS.
where I look at my fields from my query (in Data
Form
Wizzard) not all my fields are there. Can someone
explan
why that is and how I can fix that?


.



.



.



.

.

 

[Miha Markic]

Hi Matthew,

Perhaps you misunderstood me.
You have to change only column *name*, not type.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

What do I do now with my date, currency, number
columns? Plus I have a AutoNumber column. All of these
columns have data in them and changing them over to a
TEXT field will have a major impact on them.

Mathew

-----Original Message-----
Don't use non alphanumeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my column
names when I go through ADO.Net? That is the problem I am
having. I can see most of my columns but, not all of them.

Mathew
-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special
character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?


-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric
characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to
either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

Hi Miha

I don't know if this will help or not but,
here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason,
tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN
tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now
(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

[email protected]...
I am trying to access a query I wrote in MS
ACCESS.
where I look at my fields from my query (in
Data
Form
Wizzard) not all my fields are there. Can
someone
explan
why that is and how I can fix that?


.



.



.



.

.

 

[Mathew]

HI Miha

Thank You!! I have worked with relational databases for
about 10 years now however, this is the first time I have
gone through ADO. Normally you can define the same column
name in multiple tables. But what I have seen here you
must have unique column names in each table so you can
see each field individually.

Again Thank you for your help

Mathew

-----Original Message-----
Hi Matthew,

Perhaps you misunderstood me.
You have to change only column *name*, not type.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

What do I do now with my date, currency, number
columns? Plus I have a AutoNumber column. All of these
columns have data in them and changing them over to a
TEXT field will have a major impact on them.

Mathew

-----Original Message-----
Don't use non alphanumeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my column
names when I go through ADO.Net? That is the

problem I
am

having. I can see most of my columns but, not all of them.

Mathew
-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special
character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to look
like this: #inglsk, $strAbc #curDollars?


-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric
characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to
either
a # for numbers or $ for text I should be just fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

[email protected]...
Hi Miha

I don't know if this will help or not but,
here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason,
tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN
tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now
(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

news:030c01c3c994$e4128e70

[email protected]...
I am trying to access a query I wrote in MS
ACCESS.
where I look at my fields from my query (in
Data
Form
Wizzard) not all my fields are there. Can
someone
explan
why that is and how I can fix that?


.



.



.



.



.

.

 

[Otis Mukinfus]

Mather,

What Miha is trying to tell you, and you're still misunderstanding him
is that you should use plain English, Spanish or your preferred
language column names.

Foe example you could have two tables that have a relation ship:

Table one:
Column 1:
Name: City, Type: VarWChar, Length: 50
Column 2:
Name: State, Type VarWChar, Length: 2 Related to Column 1 in Table
two
Column 3:
Name: Population, Type int, Length: 4

Table two:
Column 1:
Name: State, Type: VarWchar, Length: 2 (Primary key)
Column 2:
Name: StateSmanLike, Type: VarWChar, Length: 50

Both tables can contain the column name State.

Miha is saying to you "Don't use any characters that are not in
(abcdefghijklmnopqrstuvwxyz or ABCDEFGHIJKLMNOPQRSTUVWXYZ). In other
words use only alpha characters in your column names and don't use
spaces in them. The ADO.NET system does not like other characters,
and frankly, neither will any other programmer trying to read your
column names or code.

You can continue to use Autonumber columns in your tables if you need
them.

HI Miha

Thank You!! I have worked with relational databases for
about 10 years now however, this is the first time I have
gone through ADO. Normally you can define the same column
name in multiple tables. But what I have seen here you
must have unique column names in each table so you can
see each field individually.

Again Thank you for your help

Mathew

-----Original Message-----
Hi Matthew,

Perhaps you misunderstood me.
You have to change only column *name*, not type.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

What do I do now with my date, currency, number
columns? Plus I have a AutoNumber column. All of these
columns have data in them and changing them over to a
TEXT field will have a major impact on them.

Mathew
-----Original Message-----
Don't use non alphanumeric characters.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

Ok...I think I got my question almost answered.

Tell me how I can make sure I can look at all my
column
names when I go through ADO.Net? That is the problem I
am
having. I can see most of my columns but, not all of
them.

Mathew
-----Original Message-----
Hi Mathew,

What about inglsk, strAbc and curDollars.
Those are not variables, they are column names.
And as such they don't need some sort of special
character to determine
their type.
The type is set to column.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

Miha

So how should my variables be set up in ACCESS so
VB.NET will look at each field?

Right now I got them set up like this: inglsk# or
strAbc, or curDollars. Should I reset them up to
look
like this: #inglsk, $strAbc #curDollars?


-----Original Message-----
Hi Mathew,

You really shouldn't use non alfa or numeric
characters.

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

so basically if I switch all my variables over to
either
a # for numbers or $ for text I should be just
fine?


-----Original Message-----
Hi Matthew,

I guess that fields ending with # are missing?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

[email protected]...
Hi Miha

I don't know if this will help or not but,
here is
the
SQR (from ACCESS).

SELECT tblCattleHistoryTable.[inglsk#],
tblCattleSoldTable.dtmDate,
tblCattleHistoryTable.strFYR,
tblCattleHistoryTable.[ingtag#],
tblCattleHistoryTable.dtmdate,
tblCattleHistoryTable.strbreed,
tblCattleHistoryTable.strColor,
tblCattleHistoryTable.intLbs,
tblCattleHistoryTable.strAge,
tblCattleHistoryTable.strSex,
tblCattleHistoryTable.curPrice,
tblCattleHistoryTable.strWhom,
tblCattleHistoryTable.dtmBredDate,
tblCattleHistoryTable.dtmCastrateDate,
tblCattleHistoryTable.dtmDateDied,
tblCattleHistoryTable.strReason,
tblCattleSoldTable.
[ingLsk#], tblCattleSoldTable.intLbs,
tblCattleSoldTable.curPrice,
tblCattleSoldTable.strWhom,
tblCattleSoldTable.ysnWithCalf
FROM tblCattleHistoryTable LEFT JOIN
tblCattleSoldTable
ON tblCattleHistoryTable.[inglsk#] =
tblCattleSoldTable.
[ingLsk#]
WHERE (((tblCattleSoldTable.dtmDate) Is
Null)) OR
(((tblCattleHistoryTable.strFYR)=Format(Now
(),'yyyy')))
ORDER BY tblCattleHistoryTable.[inglsk#];



-----Original Message-----
Hi Matthew,

How does your query look like?

--
Miha Markic - RightHand .NET consulting &
development
miha at rthand com
www.rhand.com

message
[email protected]...
I am trying to access a query I wrote in MS
ACCESS.
where I look at my fields from my query (in
Data
Form
Wizzard) not all my fields are there. Can
someone
explan
why that is and how I can fix that?


.



.



.



.



.

.

Otis Mukinfus
http://www.otismukinfus.com