Recent content by andymac

Bob, thanks so much for all your help! It works!!! Fantastic stuff, thank you!! Andrew

Apologies for making a mountain out of the proverbial molehill! All I want is - on Monday morning, to open the "Monday" form. As I enter each 3 digit ID number followed by a CR/tab, it ticks the 'monday' box of that child's record on the details form, and returns the curser to the combo box for...

Here's my latest attempt. Still creating new records. Probably followed your advice wrong! https://www.dropbox.com/s/f88yw992ii74giv/DB3.accdb Apologies!

Ah I see what it's doing now at the bottom of the table. Not really what I'm after, as I want the "Monday" tick to appear beside the same of the person who's ID I type in.

Bob, Yes i agree the entity structures aren't the best, it was a database which evolved and was created under time pressure, i would like to rewrite it some day if i get a chance! As for now, I just need it to work :) You said records are now being added to details table? Strange, in mine when...

Tried that, this now happening: https://www.dropbox.com/s/g3hu70tyodu8753/DB2.accdb Thanks, Andrew

Ah yes. So now getting this: https://www.dropbox.com/s/6fr42ob1nehxj0e/Screen%20Shot%202014-06-16%20at%2012.57.06.png When I debug: https://www.dropbox.com/s/yskcz2xxck3j5pz/Screen%20Shot%202014-06-16%20at%2012.56.20.png

https://www.dropbox.com/s/eqk4c18axq1ia0f/DB.accdb It's the "Monday" form I've been working on. If I can get it to work, then I can duplicate and the necessary code for the other days. Thanks A

Great - think I'm finally getting somewhere! So now when I enter a three digit child number, it jumps to the correct record, and moves the cursor back to the combo box, but still doesn't tick the "present" box? Not sure what I'm doing wrong. I can upload a copy of the DB if that would help...

Thanks for this, That sounds like what I need. Unfortunately I've no idea how to do this! Any ideas or as to where I could find this? Andy

Thanks for your reply. Yes, you assume correctly. However its Tab Stop is already set to no. Once the number is entered, you tab once to jump to the "present" tick box (which is checked and the record saved through Got_Focus [see attached picture of code in original post]) then you tab again...

Greetings all. I'm revising a database I made last year, but want to simplify a couple of things! Without boring you with too many details - it's a registration database and the form I'm fixing is the "daily sign-in" form (it's for registering children at a conference over number of days)...

Hello, I'm using a barcode scanner to enter ID numbers into a combo box on a form.. I've got it to do this much - scan the barcode, and then the form loads the relevant record. Great - now I want, that when a barcode is scanned, it makes the next field the 'live' field (the one with the cursor...

Sorry for delay - brilliant - works like a charm!! Thanks a mill - any thoughts on my other thread? Head's wrecked with it lol!

Ok, I'm keen to make it work with best practice incase something goes wrong! Here's a link to my database: https://www.dropbox.com/s/x17q79ulidpynee/SummerFire.accdb The form in question is "Saturday Registration" (there will be one made for each day) The DB is flat file (everything is in...