Computer Learning Zone CLZ Access Excel Word Windows

Only a fool fights in a burning house.

-Klingon Proverb
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > General
General Discussion Forum


Back to General Discussion Forum
 

Advent Of Code 2022 Pinned    Upload Images   Link  
Alex Hedley 
3 months ago
Anyone planning on doing AoC this year?
Alex Hedley
3 months ago
Could be a new video type like TechHelp or FastTip
Alex Hedley
2 months ago
Day1 was fun, anyone else completed it?
Adam Schwanz
2 months ago
Yep just finished it with VBA. Not sure if I cheated though, I pasted the value list into a table, maybe I was supposed to import that part with code.
Adam Schwanz
2 months ago
What language did you use Alex?
Alex Hedley
2 months ago
Oh fab, I think that's fair, that's just the util stuff.

Prob would be worth having a procedure to import data from a text file as each day you get a different input and you can test on the sample one then the actual.

You got it up on GitHub?

I picked C# again.
Adam Schwanz
2 months ago
Nope, I'll make a GitHub tonight for this and see how many I do lol
Alex Hedley
2 months ago
I'd love to see it,
Also don't forget to use VCS so I can easily see the code.
Adam Schwanz
2 months ago
I don't know what I'm doing but I think I shared it LOL.

SPOILER ALERT, vba solutions HERE
Adam Schwanz
2 months ago
I'll need to go back and look at the videos I think you made about GitHub for how I'm supposed to do it LOL.
Alex Hedley
2 months ago
Do you have the plug-in in Access?
Adam Schwanz
2 months ago
Probably not, havent really ever used GitHub.
Alex Hedley
2 months ago
No, the VCS access add-in.

See videos.
Adam Schwanz
2 months ago
I'll check them out tonight and fix it. Thanks
Adam Schwanz
2 months ago
I haven't watched yet, but I found out how to clean it up a little bit I think, uploaded vba Day 2 part1/2. Really easy day, I even coded more than I had to I think. See how many days VBA can last.
Adam Schwanz
2 months ago
Kevin Scott either of you doing it?
Kevin Robertson
2 months ago
No, at least not at the moment.
Alex Hedley
2 months ago
🤘📰✂️
Scott Axton
2 months ago
Not me.  In case you haven't noticed I've been MIA quite a bit lately.
Slammed at work.  The Monday, Tuesday and Wednesday of last week we logged almost 500 phone calls. Our busy  time of the year!
Life is good though - just busy.
Adam Schwanz
2 months ago
Alex did you do day3?
I have a lot of lines that have no matching characters if split in the middle

One of my lines is
LTmnZTgMmbWWGWZQZb
There is no matching letters on the left 9 to the right 9

Am I missing something?
Adam Schwanz
2 months ago
I don't want to talk about it LOL. There is a Z. I'm just blind
Alex Hedley
2 months ago
Did you brute force it?
Adam Schwanz
2 months ago
Yea, I was actually having some trouble with this one getting it to match characters correctly, it was picking and choosing where it wanted to match. I had about a page worth of code trying to get super technical with it, then dumbed it down to the most basic possible and it worked lol. Swear that didn't work the first time ;). Uploaded D3P1 working on P2 now.
Alex Hedley
2 months ago
🧝 Day 4 was fun, and Part 2 was a quick addition.
Adam Schwanz
2 months ago
I think this is it for VBA boys LOL.
Adam Schwanz
2 months ago
Alex any ideas?
Alex Hedley
2 months ago
Did you try a Stack to push and pop from?


Dim stack as Object
Set stack = CreateObject("System.Collections.Stack") 'Create Stack

stack.Push "Hello"
stack.Push "There"
stack.Push "Mr"
stack.Push "Smith"

peekAtTopOfStack = stack.Peek()
doesContain = stack.Contains("htrh") 'Result: False
doesContain = stack.Contains("Hello") 'Result: True
    
'Get item from the top of the stack (LIFO)
topStack = stack.Pop()  'Result: "Smith"

'Clear the Stack
stack.Clear

Set stack = Nothing
Adam Schwanz
2 months ago
No I did not, I didn't know there was a stack object. I was trying to brute force code it with pages of code lol. I'll try something like that. Thanks
Alex Hedley
2 months ago
Break it down into simple problems first.
How to I add items to a stack, how do I move from one to another.
Work on parsing the commands, how would you then call that against your collection object.
Alex Hedley
2 months ago
Day 6 - 🧝☎️
Adam Schwanz
2 months ago
Yea did day 6.

Part 2 i did with reallly ugly code though lol.

Coming back to day 5 when I have some free time.
Alex Hedley
2 months ago
Day 6 - Part 2 was one input change for me, which was lucky, or well thought ahead, who knows.
Alex Hedley
2 months ago
Day 7 - Fun stackoverflow
Alex Hedley
2 months ago
Day 8 - 🌲
Alex Hedley
2 months ago
Day 9 - 🌉
Adam Schwanz
2 months ago
I'm falling behind getting busy at work lol. I'm almost done with day 7, day 8 looks interesting, still need to go back to that stack too lol.

This thread is now closed. If you wish to comment, start a NEW discussion, below.
 


Back to General Discussion Forum Comments
 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to General Discussion Forum
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/3/2023 10:53:09 PM.