Go Back   Access World Forums > Access World > Introduce Yourself

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-16-2018, 06:27 PM   #1
euphonium01
Newly Registered User
 
euphonium01's Avatar
 
Join Date: Nov 2018
Location: Stockton-on-Tees - UK
Posts: 14
Thanks: 8
Thanked 0 Times in 0 Posts
euphonium01 is on a distinguished road
Thumbs up Hi, new member from the UK

Hi to everyone. I have been creating very simple databases in Access for a number of years, simple enough to need Macros instead of vba code. But, I find vba fascinating, and as I have a lot more time on my hands these days (retired now) I enjoy 'upgrading' my databases using it. But converting Macros to vba doesn't always work, so I'm trying to get my head round it

My reasons for joining the Forum are to ask questions about vba that I have a particular issue with to further expand my understanding of how it works, and who knows, perhaps one day I might be able to answer someone else's problem? I do get a buzz after writing code and find it does what I need But like some others, I can get frustrated after thinking I have the answer only to find "Can't do this", "Not supported the other" etc.

So, if I post a question that seems to most so simple it resembles a total rookie, forgive me cos that's what I am. Paul

euphonium01 is offline   Reply With Quote
Old 11-16-2018, 08:33 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,202
Thanks: 10
Thanked 3,895 Times in 3,838 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Hi, new member from the UK

Welcome aboard!
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
euphonium01 (11-17-2018)
Old 11-16-2018, 09:11 PM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,555
Thanks: 369
Thanked 784 Times in 749 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Hi, new member from the UK

Quote:
Originally Posted by euphonium01 View Post
But converting Macros to vba doesn't always work,
Hi Paul, welcome to AWF.

I have also noticed the Macro Conversion Problem, I think it boils down to a syntax problem when a macro contains a "temp var".. The temp var is treated as an object instead of extracting its default "Value"

I did a video about it here:-

https://youtu.be/QSA8smS8QjA

If you notice any other issues in macro conversation, please let me know, as I'd like to get to the bottom of this...

Sent from my SM-G925F using Tapatalk

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
euphonium01 (11-17-2018)
Old 11-17-2018, 05:22 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,578
Thanks: 62
Thanked 1,203 Times in 1,103 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Hi, new member from the UK

Quote:
I do get a buzz after writing code
A known phenomenon sometimes referred to as an "algorasm."
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
euphonium01 (11-17-2018)
Old 11-17-2018, 06:42 AM   #5
euphonium01
Newly Registered User
 
euphonium01's Avatar
 
Join Date: Nov 2018
Location: Stockton-on-Tees - UK
Posts: 14
Thanks: 8
Thanked 0 Times in 0 Posts
euphonium01 is on a distinguished road
Re: Hi, new member from the UK

Uncle Gizmo: Thank you for the welcome, in just a few hours it's good to link up with helpers, I will watch you video and see if I can incorporate anything (that means if my brain can work out what I'm supposed to do/type lol). I have posted a reply in my Thread, it contains all the code I used... sorry its sooooo long!

The_Doc_Man: Algorasm! that is so funny, I remember when.... no.. I can't remember... it was a long long long time ago haha!
euphonium01 is offline   Reply With Quote
Old 11-17-2018, 07:20 PM   #6
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,578
Thanks: 62
Thanked 1,203 Times in 1,103 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Hi, new member from the UK

One more question: Given your name, do you actually play a euphonium? I played a double-bell euphonium once, but chose to learn trumpet instead. It was easier to carry.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 11-18-2018, 12:23 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,398
Thanks: 92
Thanked 1,826 Times in 1,697 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Hi, new member from the UK

There's also the phenomenon where you think you've cracked some difficult code, celebrate then realise it doesn't work after all....
That's called 'premature algorasm'

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Uncle Gizmo (11-18-2018)
Old 11-19-2018, 05:33 PM   #8
euphonium01
Newly Registered User
 
euphonium01's Avatar
 
Join Date: Nov 2018
Location: Stockton-on-Tees - UK
Posts: 14
Thanks: 8
Thanked 0 Times in 0 Posts
euphonium01 is on a distinguished road
Re: Hi, new member from the UK

Hi The_Doc_Man: Yes, I play a Euphonium, after playing with the most famous band in the world for quite a while, I now play at a lower level but still in the top league so to speak.

Music is me, I laugh with it, dance to it... and cry with it! It truly is the international language.
Paul

euphonium01 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New Member BikerPete Introduce Yourself 3 10-17-2014 03:20 AM
[SOLVED] New member kruj Introduce Yourself 1 08-07-2014 03:40 AM
New Member KDTom Introduce Yourself 0 12-05-2012 10:22 AM
New member Sylviajb Introduce Yourself 0 12-04-2012 10:43 PM
New Member SPCIII Introduce Yourself 0 12-04-2012 12:18 PM




All times are GMT -8. The time now is 06:55 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World