Help to get an data entry form done

[AhmedEG14]

Hello guys,

I'm Ahmed and I'm new to your forum and I hope that I can learn about the Access world that i have just dived in and I found it's a very big world and also interesting.

I would like to get some help from you guys to get a data entry form done in the way I would like to see. my request is how can I create a form that well be updated by only pressing some buttons. like I will press a certain button that will lead me to the next choices buttons and so on till choices are done so the form will be filled. this instead of using a combo boxes or text boxes so it will be very simple and user friendly.

I have added a photo to explain more what I'm trying to say.

 

[theDBguy]

Hi Ahmed. Welcome to AWF! I don't see a photo. Try zipping it up first before attaching.

 

[AhmedEG14]

It's attached now as a zip file my friend. it's a flow chart can show you what i actually mean by sequence choices.

Regards

 

[vba_php]

how can I create a form that well be updated by only pressing some buttons. like I will press a certain button that will lead me to the next choices buttons and so on till choices are done so the form will be filled. this instead of using a combo boxes or text boxes so it will be very simple and user friendly.

using a button for EVERY field that needs data entered is not user friendly my friend. every database system I've ever worked with, when allowing users to enter data into the database, gives them a form with input elements such as combos and textboxes and lets them go at it and reign free until all required data is entered. then of course, and only then, will you (maybe) see a button that says "save/enter record".

 

[AhmedEG14]

using a button for EVERY field that needs data entered is not user friendly my friend. every database system I've ever worked with, when allowing users to enter data into the database, gives them a form with input elements such as combos and textboxes and lets them go at it and reign free until all required data is entered. then of course, and only then, will you (maybe) see a button that says "save/enter record".

yes mate you are right it's easy to use a drop and combo boxes to enter data but in my case I would like to use just a touch screen to let the user enter the data fast and easy. and to be honest with you i find this as a challenge and I'm looking forward to know how it's done.

cheers mate.

 

[vba_php]

yes mate you are right it's easy to use a drop and combo boxes to enter data but in my case I would like to use just a touch screen to let the user enter the data fast and easy. and to be honest with you i find this as a challenge and I'm looking forward to know how it's done.

cheers mate.

well i don't even know if you can use a touch screen with access, can you? have you looked that up? I would assume you can if the online eSign companies and stuff allow you to write ur signature on employment documents. i just got back from wal mart and bought a win 10 machine and it also has touch screen capability but I won't know how it works with access until i strip all the crap off of it and install my ide's and apps. but that aside, what r u developing? a point of sales system? all POS's nowadays I believe r u using touchscreens, whether they be by IBM, or using iPADs or whatever. every sales person is touching a screen and pushing buttons.

until you or someone else tells me that an access app can be used via touching the screen, I won't even look at ur file. so can u answer that for me?

 

[isladogs]

Yes you can use Access on a touch screen with or without an on screen keyboard
In fact most of the time I'm on the forum I'm using a Windows touchscreen tablet with A2010 which I use for creating and testing apps
However, to make an app work well on a touchscreen, you need larger buttons and a simple interface with space between the different controls.
See this link for a kiosk style Access Patient Login app specifically designed for use on a touchscreen
https://www.access-programmers.co.uk/forums/showthread.php?t=302159

And another one...this time designed to be highly locked down
https://www.access-programmers.co.uk/forums/showthread.php?t=300831

 

[vba_php]

so Colin, are you saying that putting something together in 2007, which is what I have, will work fine for this dude? did you create those apps by just adjusting the size of the built in access controls it comes with, or did you use an external or 3rd party library with customized controls? I did not download your apps and look at ur vba references.

 

[isladogs]

The 2 apps in my links also work perfectly well on a standard PC/laptop.
ALL my apps are created solely in Access and, in general they are designed to be touchscreen compatible.
No third party controls - no ActiveX controls (except for occasional use of AX slider & web browser controls in some apps).

I use A2010 for developing but I see no issue in principle with developing in A2007 for a touchscreen.
However unless you can test on that type of device you won't know how effective it is in practice.

 

[vba_php]

However unless you can test on that type of device you won't know how effective it is in practice.

which is why Ahmed here needs to make a form and put a button on it to see if he can play around with it via his fingers, correct?

 

[isladogs]

My suggestion was that Ahmed looks at the two links I provided.
I think he's happy to do it himself but just wanted some advice
There's nothing special in terms of design or code other than that they were designed primarily for touchscreen use