employee ID into text box, need to show all ID's that have ck in o
in [Form]
|
From: KARL DEWEY on 27 May 2010 17:42 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 > > . >
From: jfire via AccessMonster.com on 27 May 2010 19:33 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/Forums.aspx/access-forms/201005/1
From: John W. Vinson on 27 May 2010 21:12 On Thu, 27 May 2010 23:33:35 GMT, "jfire via AccessMonster.com" <u60367(a)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]
From: jfire via AccessMonster.com on 28 May 2010 15:57 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/Forums.aspx/access-forms/201005/1
From: jfire via AccessMonster.com on 28 May 2010 15:58 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
|
Pages: 1 Prev: auto populate text box based on combo box value Next: DateDiff Error |