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