I encountered this problem for the first time today while trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet, even
though the box is checked. I've already done some trouble shooting,
making sure the box is checked, making sure that the columns aren't
hidden.
Also, I went to the toolbar menu, under tools and then options, and
checked the box to display all columns. (That should make ALL the
columns appear in data sheet as if you did a SELECT * statement from
the table, shouldn't it?) I also double checked the SQL view, and the
necessary select statements for the new columns I want are there as a
result of my adding columns through the design grid.
Has anybody run into this before and fixed it? If so, thanks in
advance if you can give me a clue.
Mike 4 2096
Hi, Mike.
trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet
Since this is linked table, since the time you created the link, has anything
changed in the information saved in the link, such as path and file name,
permissions, table structure, et cetera? If you change anything on the back
end, drop the link and recreate it so that the changes will be reflected in the
linked table information in your Access database application.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Mike" <mg******@gmail.comwrote in message
news:11**********************@a3g2000cwd.googlegro ups.com...
>I encountered this problem for the first time today while trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet, even
though the box is checked. I've already done some trouble shooting,
making sure the box is checked, making sure that the columns aren't
hidden.
Also, I went to the toolbar menu, under tools and then options, and
checked the box to display all columns. (That should make ALL the
columns appear in data sheet as if you did a SELECT * statement from
the table, shouldn't it?) I also double checked the SQL view, and the
necessary select statements for the new columns I want are there as a
result of my adding columns through the design grid.
Has anybody run into this before and fixed it? If so, thanks in
advance if you can give me a clue.
Mike
Are you suing a form/subform to view the linked DBASE table?
If you are, adding the items to the query will not make them show up on
the subform, they have to be added to the form also.
Just a thought....
Ron
This one's solved. I thought I troubleshot all the possible causes,
but I'm kind of embarrassed. I didn't look close enough in the data
sheet view. I didn't expect the new columns to show up in the same
place until I went to the data sheet and drug them to where I wanted
them, but they were there, all along. I just needed to look closer.
'69 Camaro wrote:
Hi, Mike.
trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet
Since this is linked table, since the time you created the link, has anything
changed in the information saved in the link, such as path and file name,
permissions, table structure, et cetera? If you change anything on the back
end, drop the link and recreate it so that the changes will be reflected in the
linked table information in your Access database application.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Mike" <mg******@gmail.comwrote in message
news:11**********************@a3g2000cwd.googlegro ups.com...
I encountered this problem for the first time today while trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet, even
though the box is checked. I've already done some trouble shooting,
making sure the box is checked, making sure that the columns aren't
hidden.
Also, I went to the toolbar menu, under tools and then options, and
checked the box to display all columns. (That should make ALL the
columns appear in data sheet as if you did a SELECT * statement from
the table, shouldn't it?) I also double checked the SQL view, and the
necessary select statements for the new columns I want are there as a
result of my adding columns through the design grid.
Has anybody run into this before and fixed it? If so, thanks in
advance if you can give me a clue.
Mike
Hi, Mike.
This one's solved.
Excellent.
I thought I troubleshot all the possible causes,
but I'm kind of embarrassed.
.. . .
I just needed to look closer.
Don't be embarrassed. Folks reading this thread may have the same problem
later, and you can be sure they will look closer, too, because some things are
easy to miss the first time.
Have a Happy New Year!
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Mike" <mg******@gmail.comwrote in message
news:11*********************@a3g2000cwd.googlegrou ps.com...
This one's solved. I thought I troubleshot all the possible causes,
but I'm kind of embarrassed. I didn't look close enough in the data
sheet view. I didn't expect the new columns to show up in the same
place until I went to the data sheet and drug them to where I wanted
them, but they were there, all along. I just needed to look closer.
'69 Camaro wrote:
>Hi, Mike.
trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet
Since this is linked table, since the time you created the link, has anything changed in the information saved in the link, such as path and file name, permissions, table structure, et cetera? If you change anything on the back end, drop the link and recreate it so that the changes will be reflected in the linked table information in your Access database application.
HTH. Gunny
See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Mike" <mg******@gmail.comwrote in message news:11**********************@a3g2000cwd.googlegr oups.com...
>I encountered this problem for the first time today while trying to add
some columns to a query from a linked DBASEIII file. The new columns
that I added on the design grid do not show up on the data sheet, even
though the box is checked. I've already done some trouble shooting,
making sure the box is checked, making sure that the columns aren't
hidden.
Also, I went to the toolbar menu, under tools and then options, and
checked the box to display all columns. (That should make ALL the
columns appear in data sheet as if you did a SELECT * statement from
the table, shouldn't it?) I also double checked the SQL view, and the
necessary select statements for the new columns I want are there as a
result of my adding columns through the design grid.
Has anybody run into this before and fixed it? If so, thanks in
advance if you can give me a clue.
Mike This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Diego TERCERO |
last post by:
Hi...
I'm working on a tool for editing text resources for a family of software
product my company produces.
These text resources are found in a SQL Server database, in a table called...
|
by: pmud |
last post by:
Hi,
I have 2 questions:
1. I have an editable data grid with 21 columns. I need to edit only 2
cloumns in this data grid. But when the grid is displayed in Edit mode, all
the columns show long...
|
by: kevin_giles78 |
last post by:
hello everyone.
There may be a better way to do what I want but please bear with me as
I need a simple explanation of how to do something with a data grid.
I have a grid showing a status in a...
|
by: Gary Blakely |
last post by:
I'm giving this post another try - it can't be too difficult for
everyone....
In the program below, the web page has dataGrid1. the only thing that has
been done to it at design time is to...
|
by: NowItsWhatever |
last post by:
In query DESIGN view, how do I automatically "fit" the columns in the
table/field grid to the lengths of the table and field names (including any
functions applied to the fields). I am not talking...
|
by: srinivas |
last post by:
Hi,
I have binded a dataset to a gridview control at run time.
I'm fetching 5 columns from the database.
But while displaying it on the screen i want to show only 3 columns.
I tried with...
|
by: bappelsin |
last post by:
Hello,
I have a problem with the datagridview. I have a view with around 25
different columns. To make life easier for the users I have implemented
a popup dialog where the user can select which...
|
by: fh217 |
last post by:
Hi
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it...
|
by: methexandude |
last post by:
Hi,
I have recently started developing ASP.net applications using VB.net.
Well, I created this huge query to retrieve data from SQL Server and create a pivot table, which means I'm creating columns...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
| |