employee ID into text box, need to show all ID's that have ck in on same form

[jfire]

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need
to show all employee's on the same form as they check in. I have done query's
subforms showing the ID but will only refresh if I close the form then reopen.
This is on a single PC. Using Access 2007 <I'm at a loss>
I have;
Employee_Info Table
Date_Time_IN Query,
Date_Time_IN Table,
Date_Time_OUT Table

 

[PieterLinden via AccessMonster.com]

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need
to show all employee's on the same form as they check in. I have done query's
subforms showing the ID but will only refresh if I close the form then reopen.
This is on a single PC. Using Access 2007 <I'm at a loss>
I have;
Employee_Info Table
Date_Time_IN Query,
Date_Time_IN Table,
Date_Time_OUT Table

Sounds like you need to requery the subform.

Me!Subform1.Form.Requery

 

[jfire]

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need

[quoted text clipped - 6 lines]

Date_Time_IN Table,
Date_Time_OUT Table

Sounds like you need to requery the subform.

Me!Subform1.Form.Requery

Tks PieterLinden
I have tried that, but it dosen't update the Subform while it is still open.
That is what I am trying to do.
I could send you what I have so far if you want to take a look at it your
self. Tks

 

[KARL DEWEY]

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

 

[jfire via AccessMonster.com]

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need

[quoted text clipped - 8 lines]

.

Karl the DB is not on a server at this time only on a single PC. I could
send you a zip copy of what I have, if so I could past a email address you
could contact me and I could send it to you. Sorry that's all I can do right
now.
John Firestone

 

[John W. Vinson]

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need

[quoted text clipped - 8 lines]

.

Karl the DB is not on a server at this time only on a single PC. I could
send you a zip copy of what I have, if so I could past a email address you
could contact me and I could send it to you. Sorry that's all I can do right
now.
John Firestone

Karl isn't talking about the client/server database product SQL/Server - he's
talking about the query within Access.

SQL (Structured Query Language) is the name of a language used by many
database programs - Access, SQL/Server, Oracle, DB/2, FoxPro, on and on. Every
query has a SQL view; in fact the query grid is simply a tool to build SQL,
and some people skip it entirely, just using the SQL window.

Open your query.

Select View from the menu.

Choose SQL from the dropdown.

Copy and paste the text that you will see, and Karl or one of the rest of us
will be able to help.

 

[KARL DEWEY]

I do not do e-mails or web sites. Read John's post or re-read mine.
--
Build a little, test a little.

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need

[quoted text clipped - 8 lines]

.

Karl the DB is not on a server at this time only on a single PC. I could
send you a zip copy of what I have, if so I could past a email address you
could contact me and I could send it to you. Sorry that's all I can do right
now.
John Firestone

--



.

 

[jfire via AccessMonster.com]

[quoted text clipped - 9 lines]

now.
John Firestone

Karl isn't talking about the client/server database product SQL/Server - he's
talking about the query within Access.

SQL (Structured Query Language) is the name of a language used by many
database programs - Access, SQL/Server, Oracle, DB/2, FoxPro, on and on. Every
query has a SQL view; in fact the query grid is simply a tool to build SQL,
and some people skip it entirely, just using the SQL window.

Open your query.

Select View from the menu.

Choose SQL from the dropdown.

Copy and paste the text that you will see, and Karl or one of the rest of us
will be able to help.

SELECT Date_Time_In.AT_Number, Resident_Info.L_Name, Resident_Info.F_Name,
Resident_Info.Unit_Number, Date_Time_In.[Date+Time_In]
FROM Resident_Info INNER JOIN Date_Time_In ON Resident_Info.At_Number =
Date_Time_In.AT_Number
ORDER BY Date_Time_In.[Date+Time_In] DESC;

 

[jfire via AccessMonster.com]

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need

[quoted text clipped - 8 lines]

.

SELECT Date_Time_In.AT_Number, Resident_Info.L_Name, Resident_Info.F_Name,
Resident_Info.Unit_Number, Date_Time_In.[Date+Time_In]
FROM Resident_Info INNER JOIN Date_Time_In ON Resident_Info.At_Number =
Date_Time_In.AT_Number
ORDER BY Date_Time_In.[Date+Time_In] DESC;