Buttons

[Lizelle Schoerie]

Good day.

Hope any one can help me. I am designing a program to use on the farm. It is very important to simplify your data basis due to the fact that we are working with illiterate people. I want to create a data basis where I use picture buttons that they can click on and that button will then write the information into a table from which I can then create a query to extract the rest of the data.

For example an image of the driver. If he clicks on himself the program will write his name and surname into the table. Then he can click on his sprayer and tractor and it will write the information in die table as for the weather conditions, farm name and block.

Is something like this possible??



Lizelle

[ranman256]

save any clip art to your pc you needed (google, etc)
edit the image in Paint, and save as BMP (24 bit bitmap)
shrink it so its about 28x28 (icon size)

put a button on the form,
in the button property, format tab, click the property row for PICTURE,
click the ellipsis button on the far right of the property
choose an icon given or use your custom icon by clicking BROWSE,
choose your image. (be sure to set the file type to BMP)

[Lizelle Schoerie]

How do you program that button to write the information assigned to that button into the required field of a specific table?

[ranman256]

either macros or vb. (you can do a LOT with macros and not know programming)

you should lookup these items in an Access book. They are fundamentals of the app.

[June7]

Start with a review of https://support.office.com/en-us/art...0-DAB7C75CBE0C

For one method, form is bound to table and focus is on existing record or the New Record row. Then code writes data directly to field.

So if button has a tractor image, code in the button Click event to set field value. VBA example:

Me!Equipment = "tractor"

Another approach on an UNBOUND form would write records to tables using INSERT sql actions.

Regardless, having buttons for each piece of equipment and each driver and other inputs will mean a LOT of buttons. Have to modify the form every time a driver quits or is hired.

An alternative might be to have tables for each data entity with images in attachment field. Have forms bound to these 'lookup' tables with images displayed in Image control. User clicks record and code saves data to a data table. It's using an entire form like a combo or list box because images can't display in combo or list box lists.