• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

set focus back to a textbox and display count of listbox

hello,
am sure when you open this database - will wonder what-
wanted a way to enter multiple serial numbers
question:
with this database is there a way when you enter a serial number- the focus goes back to let you enter again and again- have not been successfull
other thing- is there a way to display count of listbox items above it?thank you
1database.mdb
0
davetough
Asked:
davetough
  • 4
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Here you go Dave:

mx
1database-MX01.zip
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Moved code in Keydown to AfterUpdate.
Removed code in On exit - moved that line to end of new AfterUpdate code.
Added Count text box.

mx
0
 
davetoughAuthor Commented:
Great Job- thanks
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome ...

mx
0
 
davetoughAuthor Commented:
DatabaseMX- now I notice this database is leaving the numbers in the listbox after I hit the add button- do you have idea how I can stop that? or should I just open another question if i have to?
thank you-
0
 
davetoughAuthor Commented:
sorry am not sure how it happened  with those numbers in rowsource- I think my mistake
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Upload your version with my changes

mx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now