Recent content by kanga202

yeah... i was wondering whats the best thing to put it under??

Nah doesn’t work… putting any of the staff IDs in just brings up the first and last name for staff number 23… which is nether @ the beginning or end of the table(if that makes a difference) better than nothing though, anyway ill have a look through the other info in your post and see if...

Hay Dave thanks so much What is it with the combo box fanatics on these forums ;) I can’t use combo boxes... every employ has to enter there name individually... but thanks :) @ ssteinke, err event???? i'm new here... actualy i'm just kinda fingering this out as i go so lol...

Thanks heaps for that, yep i got rid of the spaces and the last quotation mark, but ill go though and standisise the names thanks for that but its still not working... well @ least i'm getting the first name and last name to come up but it doset not seem to have anything to do with the staff id...

Ok I’m coding a form, heres what I have done so far Me.FN LN =DLookUp("[First Name] & ' ' & [Last Name]","tblStaffID", "Staff ID=" & Me.Staff ID") I have a txt box to imput the Staff ID number in to and I want it to return the first and last name in to another txt box Am I close??? What am I...

i'm looking to create a similer thing, although not quite so complicated as yet.... did this ever go anywhere??? did anyone get this done??

Yes that’s so close to what I need, the only thing is it cant be a combo box, it needs to be a straight text box that they can enter there ID in, I cant make it easy to enter data in for other people How do I make the same thing, but not a combo box? Thanks heaps for the help

Haya all, I’m new to access and I’m trying to create a database for my boss, but am a bit stuck, it’s a Bundy clock system in access, I have the tables set up (I think), and what I’m stuck on is building a form where, when I put in the employs ID and press enter there name appears underneath...