Fields not showing up in columns
in [Tables]
|
Prev: Do I have to set the primary key to include primary key fields?
Next: What to do with 1.5 million records...
From: Charlotte Hinger on 14 Apr 2010 09:10 I have a field titled PageNumber in a table that is not showing up in my columns, although it is checked in the design view and is not hidden. On the form view I have access to this field and it has all the entries, which would indicate that nothing has been accidentally deleted. What's happened, and how can I fix this so the page number column shows up in the table.
From: KARL DEWEY on 14 Apr 2010 11:19 The terms you are using and the way you use them are confusing to me. Access has 'fields' in table. Those fields are displayed in columns. When you say 'I have a field titled PageNumber in a table that is not showing up in my columns,' does that mean that data is not being displayed or that the field is not shown. And where is it not seen - in a report, form, or when the table is viewed in datasheet view? -- Build a little, test a little. "Charlotte Hinger" wrote: > I have a field titled PageNumber in a table that is not showing up in my > columns, although it is checked in the design view and is not hidden. On the > form view I have access to this field and it has all the entries, which would > indicate that nothing has been accidentally deleted. > > What's happened, and how can I fix this so the page number column shows up > in the table.
From: Charlotte Hinger on 20 Apr 2010 22:48 Karl, my apology for being so late in replying. The reply notification did not show up in my email program. Sorry for the lack of clarity. I meant I can't get a field to display in a column. Unhide is checked and the data is there. I can access it the field and the data through the "form" view, but I can't create a column with this field. The data is there in the report view also. "KARL DEWEY" wrote: > The terms you are using and the way you use them are confusing to me. > > Access has 'fields' in table. Those fields are displayed in columns. > > When you say 'I have a field titled PageNumber in a table that is not > showing up in my columns,' does that mean that data is not being displayed or > that the field is not shown. And where is it not seen - in a report, form, > or when the table is viewed in datasheet view? > > -- > Build a little, test a little. > > > "Charlotte Hinger" wrote: > > > I have a field titled PageNumber in a table that is not showing up in my > > columns, although it is checked in the design view and is not hidden. On the > > form view I have access to this field and it has all the entries, which would > > indicate that nothing has been accidentally deleted. > > > > What's happened, and how can I fix this so the page number column shows up > > in the table.
From: John W. Vinson on 24 Apr 2010 19:44
On Tue, 20 Apr 2010 19:48:01 -0700, Charlotte Hinger <CharlotteHinger(a)discussions.microsoft.com> wrote: It's possible that Access is considering PageNumber to be a reserved word. Do you get the same problem if you open the table in design view and change the fieldname to PageNo? Note that the Discussions webpage notification button has been broken for ages, and Microsoft shows no inclination to fix it. >Karl, my apology for being so late in replying. The reply notification did >not show up in my email program. > >Sorry for the lack of clarity. I meant I can't get a field to display in a >column. Unhide is checked and the data is there. I can access it the field >and the data through the "form" view, but I can't create a column with this >field. The data is there in the report view also. > >"KARL DEWEY" wrote: > >> The terms you are using and the way you use them are confusing to me. >> >> Access has 'fields' in table. Those fields are displayed in columns. >> >> When you say 'I have a field titled PageNumber in a table that is not >> showing up in my columns,' does that mean that data is not being displayed or >> that the field is not shown. And where is it not seen - in a report, form, >> or when the table is viewed in datasheet view? >> >> -- >> Build a little, test a little. >> >> >> "Charlotte Hinger" wrote: >> >> > I have a field titled PageNumber in a table that is not showing up in my >> > columns, although it is checked in the design view and is not hidden. On the >> > form view I have access to this field and it has all the entries, which would >> > indicate that nothing has been accidentally deleted. >> > >> > What's happened, and how can I fix this so the page number column shows up >> > in the table. -- John W. Vinson [MVP] |