If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
field no show
The following query does not show the ID field. This is imperative because
data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
#2
|
|||
|
|||
field no show
That's strange. Maybe it's hidden? Try this:
SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout, member_time.id as TheID FROM member_time WHERE member_time.date = #4/16/2010# ; If that doesn't work, try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout FROM member_time ORDER BY member_time.id desc ; -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
#3
|
|||
|
|||
field no show
I suspect that it is hidden. How do you unhide a field. I have check the
property sheet of the table and see nothing. Thanks. The queries you shared showed all fields except the id and TheId fields. "Jerry Whittle" wrote: That's strange. Maybe it's hidden? Try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout, member_time.id as TheID FROM member_time WHERE member_time.date = #4/16/2010# ; If that doesn't work, try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout FROM member_time ORDER BY member_time.id desc ; -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
#4
|
|||
|
|||
field no show
In datasheet view, select FORMAT: Unhide columns.
In Access 2007, you will have to find the equivalent in the Ribbon. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County seeker wrote: I suspect that it is hidden. How do you unhide a field. I have check the property sheet of the table and see nothing. Thanks. The queries you shared showed all fields except the id and TheId fields. "Jerry Whittle" wrote: That's strange. Maybe it's hidden? Try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout, member_time.id as TheID FROM member_time WHERE member_time.date = #4/16/2010# ; If that doesn't work, try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout FROM member_time ORDER BY member_time.id desc ; -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
#5
|
|||
|
|||
field no show
Seeker -
Is there a column title for the ID field and no data, or is the column title not even showing? Did you try putting square brackets around the ID field name (e.g. member_time.[id])? Is this in a query def or in code? If it is in code, copy/paste it into a query (SQL View), and see if that shows it. It it is in code, can you post the code? -- Daryl S "seeker" wrote: The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
#6
|
|||
|
|||
field no show
I just tested things and hiding the column in the table doesn't seem to make
a difference. As you ran other queries, I don't think that's it either. You can try opening the table and the query in datasheet view. Right click on them and you should see an option for unhiding fields. See if its not checked. Also try this to see if the missing column shows up with the wildcard: SELECT * FROM member_time ; Are you seeing any data or columns that you don't expect? Could you be using lookup fields in that table? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: I suspect that it is hidden. How do you unhide a field. I have check the property sheet of the table and see nothing. Thanks. The queries you shared showed all fields except the id and TheId fields. "Jerry Whittle" wrote: That's strange. Maybe it's hidden? Try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout, member_time.id as TheID FROM member_time WHERE member_time.date = #4/16/2010# ; If that doesn't work, try this: SELECT member_time.id, member_time.date, member_time.timein, member_time.timeout FROM member_time ORDER BY member_time.id desc ; -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id, member_time.date, member_time.timein, member_time.timeout from member_time where member_time.date = #4/16/2010# This is written in a access database. Thanks |
Thread Tools | |
Display Modes | |
|
|