Home

auto click in acces

%3CLINGO-SUB%20id%3D%22lingo-sub-899112%22%20slang%3D%22en-US%22%3Eauto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899112%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20trying%20to%20create%20an%20auto%20click%20in%20acces.%3CBR%20%2F%3EThe%20autoclick%20is%20for%20in%20a%20form.%20The%20date%20of%20today%20is%20already%20automatically%20entered%20in%20the%20form.%20But%20I%20want%20to%20eliminate%20as%20many%20handlings%20as%20possible.%20So%20I%20want%20to%20create%20a%20from%20in%20which%20I%20scan%20a%20barcode%20with%20auto%20enter%20(with%20auto%20enter%20I%20mean%20that%20after%20scanning%20the%20barcode%20acces%20wil%20automatically%20select%20the%20next%20box%20in%20the%20form).%20In%20this%20next%20box%20the%20date%20of%20today%20is%20autofilled.%20But%20I%20want%20acces%20to%20automaticcaly%20continue%20to%20the%20next%20box%20and%20skip%20editing%20options%20in%20the%20date%20box%20without%20the%20user%20having%20to%20pres%20enter.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20hope%20anyone%20has%20a%20solution%20for%20this.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EDimitri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-899112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899261%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%26nbsp%3BIn%20the%20After%20Update%20event%20of%20the%20textbox%20that%20%22recieves%22%20the%20barcode%20scanning%20you%20can%20do%20whatever%20you%20want...%3C%2FP%3E%3CP%3EJust%20configure%20your%20barcode%20scanner%20to%20append%20an%20%22Enter%22%20after%20the%20scanning%20and%20via%20control%20the%20other%20controls.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899688%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%20Well%20that%20is%20one%20way.%26nbsp%3B%20However%2C%20if%20you%20want%20to%20see%20what%20character%20your%20barcode%20DOES%20append%20then%20use%20the%20_Keypress%20event%20of%20the%20field.%26nbsp%3B%20Then%20take%20a%20look%20at%20what%20the%20value%20of%20the%20KeyAscii%20parameter%20of%20this%20event%20is.%26nbsp%3B%20In%20one%20of%20my%20implementations%2C%20for%20example%20the%20result%20was%209%20(tab%20key)%20and%20I%20was%20then%20able%20to%20put%20an%20If%20clause%20in%20to%20test%20for%20that%20and%20then%20do%20what%20I%20wanted.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901396%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F96686%22%20target%3D%22_blank%22%3E%40Maria%20Barnes%3C%2FA%3Ethank%20you%20for%20your%20reply!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20sorry%20for%20the%20bad%20explanation%20of%20my%20question%2C%20please%20allow%20me%20to%20elaborate.%20So%20I%20am%20trying%20to%20create%20the%20following%20form%20in%20Acces%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20869px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F136029i468FA7D066E0B3AC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22acces%20box%20registration.JPG%22%20title%3D%22acces%20box%20registration.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAs%20you%20can%20see%20I%20am%20trying%20to%20create%20a%20form%20in%20which%20the%20delivery%20date%2C%20box%20numbers%20and%20an%20order%20number%20are%20registered.%20My%20problem%20is%2C%20that%20the%20registration%20process%20has%20to%20be%20very%20efficient.%20So%20I%20want%20the%20following%20to%20happen%20when%20I%20open%20the%20form%3A%20I%20want%20today's%20date%20to%20be%20auto%20filled%20and%20I%20want%20the%20cursor%20to%20immediately%20start%20in%20the%20box%20number%20textbox.%20So%20that%20when%20a%20worker%20opens%20the%20form%2C%20he%20can%20start%20scanning%20boxes%20right%20away.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIf%20you%20have%20a%20solution%20to%20make%20this%20happen%20that%20would%20be%20really%20great!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDimitri%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901439%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3EThank%20you%20for%20your%20reply%2C%20that%20is%20a%20perfect%20solution%2C%20I%20now%20made%20the%20form%20in%20such%20a%20way%20that%20I%20scan%20the%20order%20number%20at%20the%20end.%20The%20barcode%20of%20the%20order%20number%20has%20an%20auto%20enter%2C%20so%20after%20scanning%20the%20order%20number%20a%20new%20empty%20form%20will%20appear.%20That%20is%20perfect!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20maybe%20also%20have%20a%20solution%20for%20the%20following%3A%20I%20want%20to%20create%20the%20form%20in%20such%20a%20way%20that%20the%20date%20is%20auto%20filled%20and%20the%20cursor%20skips%20the%20date%20when%20opening%20the%20form.%20The%20form%20Will%20then%20look%20as%20follows%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20869px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F136032iBC3FA2F06B52E6C5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22acces%20box%20registration.JPG%22%20title%3D%22acces%20box%20registration.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20want%20the%20following%20to%20happen%20when%20I%20open%20the%20form%3A%20I%20want%20today's%20date%20to%20be%20auto%20filled%20and%20I%20want%20the%20cursor%20to%20immediately%20start%20in%20the%20box%20number%20textbox.%20So%20that%20when%20a%20worker%20opens%20the%20form%2C%20he%20can%20start%20scanning%20boxes%20right%20away%2C%20without%20having%20to%20do%20anything%20with%20the%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you%20have%20any%20ideas%20on%20how%20to%20fix%20this.%20Thanks%20a%20lot%20for%20your%20help%20already!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDimitri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901664%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901664%22%20slang%3D%22en-US%22%3EJust%20set%20Default%20for%20the%20Datefield%20to%20Date%3CBR%20%2F%3Eand%20your%20Barcode%20%22order%20number%22%20to%20have%20Focus...%3CBR%20%2F%3EProbably%20use%20the%20OnCurrent%20Event%3CBR%20%2F%3EPrivate%20Sub%20Form_Current()%3CBR%20%2F%3EMe.OrderNumber.SetFocus%3CBR%20%2F%3EEnd%20Sub%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902096%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902096%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%20Actually%20you%20do%20not%20need%20code%20to%20set%20the%20barcode%20to%20have%20the%20focus.%26nbsp%3B%20Just%20set%20the%20Tab%20Index%20to%200%20for%20that%20field.%26nbsp%3B%20The%20date%20field%20could%20even%20be%20one%20that%20you%20set%20Tab%20Stop%20to%20No%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902202%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F96686%22%20target%3D%22_blank%22%3E%40Maria%20Barnes%3C%2FA%3Ethanks%20again%20for%20your%20reply!%20Could%20you%20maybe%20explain%20how%20I%20can%20set%20the%20tab%20index%20to%200%20for%20the%20date%20field%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902210%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3Ethanks%20a%20lot%20for%20your%20reply!%20I%20am%20actually%20a%20beginner%20with%20Acces%20and%20I%20am%20having%20a%20hard%20time%20understanding%20what%20you%20mean.%20I%20tried%20looking%20up%20your%20suggestion%20and%20found%20out%20a%20few%20things%20that%20helped%20me%20understand%20what%20you%20are%20trying%20to%20say%2C%20but%20I%20still%20dont%20understand%20the%20most%20of%20it.%20I%20am%20sorry%20for%20having%20to%20ask%2C%20but%20could%20you%20please%20explain%20a%20little%20bit%20more%20what%20you%20mean%20so%20that%20I%20understand%20it%20and%20can%20try%20to%20build%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902325%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%20The%20Tab%20Index%20and%20Tab%20Stop%20properties%20can%20be%20set%20by%20right%20clicking%20on%20the%20field%20(in%20form%20design%20view)%20and%20selecting%20Properties%2C%20then%20going%20to%20the%20Other%20tab.%26nbsp%3B%20A%20good%20right%20up%20on%20these%20fields%20is%20available%20at%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSet-the-tab-order-for-controls-2B37E49B-52D1-4F03-AE33-9E6D9C103C99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSet-the-tab-order-for-controls-2B37E49B-52D1-4F03-AE33-9E6D9C103C99%3C%2FA%3E%3C%2FFONT%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902428%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20click%20in%20acces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902428%22%20slang%3D%22en-US%22%3Eperfect%2C%20thank%20you%20Maria!%3C%2FLINGO-BODY%3E
Dimitri1220
Occasional Contributor

Hi everyone,


I am trying to create an auto click in acces.
The autoclick is for in a form. The date of today is already automatically entered in the form. But I want to eliminate as many handlings as possible. So I want to create a from in which I scan a barcode with auto enter (with auto enter I mean that after scanning the barcode acces wil automatically select the next box in the form). In this next box the date of today is autofilled. But I want acces to automaticcaly continue to the next box and skip editing options in the date box without the user having to pres enter.


I hope anyone has a solution for this.


Thanks in advance!


Kind regards,
Dimitri

10 Replies

@Dimitri1220 In the After Update event of the textbox that "recieves" the barcode scanning you can do whatever you want...

Just configure your barcode scanner to append an "Enter" after the scanning and via control the other controls.

@Dimitri1220 Well that is one way.  However, if you want to see what character your barcode DOES append then use the _Keypress event of the field.  Then take a look at what the value of the KeyAscii parameter of this event is.  In one of my implementations, for example the result was 9 (tab key) and I was then able to put an If clause in to test for that and then do what I wanted.

@Maria Barnesthank you for your reply!

 

I am sorry for the bad explanation of my question, please allow me to elaborate. So I am trying to create the following form in Acces:

 

acces box registration.JPG

 


As you can see I am trying to create a form in which the delivery date, box numbers and an order number are registered. My problem is, that the registration process has to be very efficient. So I want the following to happen when I open the form: I want today's date to be auto filled and I want the cursor to immediately start in the box number textbox. So that when a worker opens the form, he can start scanning boxes right away.


If you have a solution to make this happen that would be really great!


Kind regards,


Dimitri

 

@tsgiannisThank you for your reply, that is a perfect solution, I now made the form in such a way that I scan the order number at the end. The barcode of the order number has an auto enter, so after scanning the order number a new empty form will appear. That is perfect! 

 

Do you maybe also have a solution for the following: I want to create the form in such a way that the date is auto filled and the cursor skips the date when opening the form. The form Will then look as follows:

 

acces box registration.JPG

 

 

So I want the following to happen when I open the form: I want today's date to be auto filled and I want the cursor to immediately start in the box number textbox. So that when a worker opens the form, he can start scanning boxes right away, without having to do anything with the date.

 

Please let me know if you have any ideas on how to fix this. Thanks a lot for your help already!

 

Kind regards,

 

Dimitri

Just set Default for the Datefield to Date
and your Barcode "order number" to have Focus...
Probably use the OnCurrent Event
Private Sub Form_Current()
Me.OrderNumber.SetFocus
End Sub

@Dimitri1220 Actually you do not need code to set the barcode to have the focus.  Just set the Tab Index to 0 for that field.  The date field could even be one that you set Tab Stop to No for.

@Maria Barnesthanks again for your reply! Could you maybe explain how I can set the tab index to 0 for the date field?

@tsgiannisthanks a lot for your reply! I am actually a beginner with Acces and I am having a hard time understanding what you mean. I tried looking up your suggestion and found out a few things that helped me understand what you are trying to say, but I still dont understand the most of it. I am sorry for having to ask, but could you please explain a little bit more what you mean so that I understand it and can try to build it?

@Dimitri1220 The Tab Index and Tab Stop properties can be set by right clicking on the field (in form design view) and selecting Properties, then going to the Other tab.  A good right up on these fields is available at https://support.office.com/en-us/article/Set-the-tab-order-for-controls-2B37E49B-52D1-4F03-AE33-9E6D... 

perfect, thank you Maria!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies