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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Click on List box and move to that record in the form



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 02:29 AM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Click on List box and move to that record in the form

I have a single form which will be used for users to clock in and out. On the
form I have a list box showing the completed clock-in's and another list box
with incomplete clock-in's. I would like to have the user be able to select
their name from the incomplete clock-in and have their record load so they
can clock out. I've tried to find the solution, but can't quite find it.

Thank you,
  #2  
Old June 1st, 2010, 03:59 AM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Click on List box and move to that record in the form

"Kelly" wrote in message
news
I have a single form which will be used for users to clock in and out. On
the
form I have a list box showing the completed clock-in's and another list
box
with incomplete clock-in's. I would like to have the user be able to
select
their name from the incomplete clock-in and have their record load so they
can clock out. I've tried to find the solution, but can't quite find it.


The following link is to a sample database that looks up a record from the
Northwind sample database:

http://accessmvp.com/Arvin/Combo.zip

This actually demonstrates a Drill Down technique, but you merely need to
use the second list box to accomplish what you which.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


  #3  
Old June 1st, 2010, 11:29 PM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Click on List box and move to that record in the form

HI, Thank you that worked and put the record information from the list box
into the form field.
I now have another problem with the form and the list boxes. Lets say I have
2 or more records in the list box. After clicking the first user information
from the list box and it places it in the form fields and I then click
clock-out, it places the username into the completed list box. It also clears
the form feilds lik it should.

If I pick on a second entry or a third, the first entry stays in the form
fields and doesn't clear the initial entry info. that was first clicked.
Also, when I click the first entry to "clock-out" it will place it in the
completed list box "OK", but when I click the second entry or click the
clock-out button, it doesn;t add a new record to the 2nd list box, it just
addes more time to the current record. I need it to add unique records
everytime I click the clock-out button. I also need to be able to click from
the first list box (Clocked in user).
To summarize; If I have (1) record only, it works fine. If I have another
record of the same name or different name. It only uses the first record
entry, although the time does modify.

Thank you,

"Kelly" wrote:

I have a single form which will be used for users to clock in and out. On the
form I have a list box showing the completed clock-in's and another list box
with incomplete clock-in's. I would like to have the user be able to select
their name from the incomplete clock-in and have their record load so they
can clock out. I've tried to find the solution, but can't quite find it.

Thank you,

 




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 06:24 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.