A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 12:03 AM posted to microsoft.public.access.forms
jfire
external usenet poster
 
Posts: 2
Default employee ID into text box, need to show all ID's that have ck in on same form

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

  #2  
Old May 27th, 2010, 12:10 AM posted to microsoft.public.access.forms
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default employee ID into text box, need to show all ID's that have ck in on same form

jfire wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

  #3  
Old May 27th, 2010, 12:42 AM posted to microsoft.public.access.forms
jfire
external usenet poster
 
Posts: 2
Default employee ID into text box, need to show all ID's that have ck in on same form

PieterLinden wrote:
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

  #4  
Old May 27th, 2010, 10:42 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default employee ID into text box, need to show all ID's that have ck in o

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

--
Build a little, test a little.


"jfire" wrote:

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

.

  #5  
Old May 28th, 2010, 12:33 AM posted to microsoft.public.access.forms
jfire via AccessMonster.com
external usenet poster
 
Posts: 5
Default employee ID into text box, need to show all ID's that have ck in o

KARL DEWEY wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

  #6  
Old May 28th, 2010, 02:12 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default employee ID into text box, need to show all ID's that have ck in o

On Thu, 27 May 2010 23:33:35 GMT, "jfire via AccessMonster.com" u60367@uwe
wrote:

KARL DEWEY wrote:
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.
--

John W. Vinson [MVP]
  #7  
Old May 28th, 2010, 04:55 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default employee ID into text box, need to show all ID's that have ck

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


"jfire via AccessMonster.com" wrote:

KARL DEWEY wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

.

  #8  
Old May 28th, 2010, 08:57 PM posted to microsoft.public.access.forms
jfire via AccessMonster.com
external usenet poster
 
Posts: 5
Default employee ID into text box, need to show all ID's that have ck in o

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

[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;

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

  #9  
Old May 28th, 2010, 08:58 PM posted to microsoft.public.access.forms
jfire via AccessMonster.com
external usenet poster
 
Posts: 5
Default employee ID into text box, need to show all ID's that have ck in o

KARL DEWEY wrote:
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;

--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.