Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Drawing a circle on a form

How do I draw a circle on a form using code?

I Tried this:
Me.Circle (200, 200), 100, 0
But just get error method not found
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock
Avatar of Kimputer
Kimputer

Easiest way to control this, is probably insert a picture instead (as the form doesn't have anything similar, other solutions draws on Windows, not the form perse)
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

You might want to take a look at this LinkedIn post
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Derek Brown
Derek Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks Gustav. Well spotted I asked this question 4 years ago and solved most of it myself. Ended up not using it and forgot all about it.

Kimputer, what do you mean draw on windows?

Dale Link to Linked In does not work for me.
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Kimputer
Kimputer

There are some Windows API solution, but they're quite ugly, and draw on Windows itself, not on the form. If you move the form, the circle stays there. Here's on example: https://social.msdn.microsoft.com/Forums/en-US/8c39712f-fb49-4ef6-9fd2-245b79bb6c67/using-gdi-in-excel-vba?forum=isvvba
Avatar of Derek Brown
Derek Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks to you both
Avatar of Derek Brown
Derek Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

I do hope points have been allocated this time please confirm and let me know how points were distributed. I have no idea why EE has changed what was a simple easy system for this new one, which is weird.
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

You are welcome!
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo