Auto "Tab" after X seconds

[Teuntja123]

Hi all,

I've got a question about a form I made for my colleagues.

To give you some context, people need to manually enter some basic info, after that they should manually hit "TAB" on the keyboard / or put the cursor on the next empty field, so the cursor will be on this next empty field. Then they need to measure something with an external device and send this data (via bluetooth) to the computer.
The thing is, people sometimes forget the manually hit "TAB" or move the cursor so when they transfer data from the device to the computer, the data won't be put in the next empty field, but in the current ..
Is there an option for this certain cell in the form, that after they filled something in, it will auto TAB after eg. 5 seconds?

I hope I made my problem clear to you..

Kind Regards, Teun

 

[sneuberg]

Is there anyway you can get the external device to send the tab?

If not you could set a timer in the On Change event of the text box that gets the external input. Like

Me.TimerInterval = 5000

That's 5000 milliseconds and then in the timer event of the form put

Me.NextTextBox.SetFocus
Me.TimerInterval = 0

I suggest setting the focus to the field you want it to go to as I have in this code rather than using SendKeys to send a tab. They say it's not good to use SendKeys.

You can see this work in the attached database.

 

[smig]

how exactly do you send the data from the externa device to Access ?

 

[Teuntja123]

Thanks Sneuberg, that was exactly what I meant !