Access Query thru ADO.Net

  • Thread starter Thread starter Mathew
  • Start date Start date
M

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?
 
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#];
 
Hi Matthew,

I guess that fields ending with # are missing?

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

Mathew said:
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




.
Click to expand...
Click to expand...
 
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

Mathew said:
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?


.
Click to expand...
Click to expand...


.
Click to expand...
 
so if I switch my variables over to either a
# for numbers and $ for characters every thing
should work just fine?
 
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

Mathew said:
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

Mathew said:
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?


.
Click to expand...


.
Click to expand...
Click to expand...
 
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

Mathew said:
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?


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
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

Mathew said:
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

Mathew said:
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?


.



.
Click to expand...


.
Click to expand...
Click to expand...
 
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

Mathew said:
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?


.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Don't use non alphanumeric characters.

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

Mathew said:
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

Mathew said:
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?


.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
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

Mathew said:
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

$a101280a@phx.gbl...
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?


.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
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

Mathew said:
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

Mathew said:
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

$a101280a@phx.gbl...
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?


.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
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

Mathew said:
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
Click to expand...
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

$a001280a@phx.gbl...
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
Click to expand...
$a101280a@phx.gbl...
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?


.



.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
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

Mathew said:
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

$a001280a@phx.gbl...
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
$a101280a@phx.gbl...
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?


.



.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...

Otis Mukinfus
http://www.otismukinfus.com
 
Back
Top