Go Back   Access World Forums > Access World > The Watercooler

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2019, 01:31 AM   #1
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 579
Thanks: 73
Thanked 61 Times in 61 Posts
vba_php is on a distinguished road
what's your most complex VBA code project?

what is the most complex vba code project you've ever taken on? got any code snippets from the project? I once created an FTP application similar to Filezilla. A lot of the code contains DLL functions and class types.
Attached Files
File Type: zip FTP VBA code.zip (5.3 KB, 8 views)

vba_php is offline   Reply With Quote
Old 11-10-2019, 02:24 AM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,710
Thanks: 105
Thanked 1,511 Times in 1,424 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: what's your most complex VBA code project?

An application that looked up information stored in a database about text based reports in the file system, found them and parsed them. All the work was done in a Class. The parsed data was held in recordsets. Each recordset that was loaded was added to a Collection so it didn't need to be parsed again in the session.

It analysed and stored critical information about the reports in the database for subsequent use.

Another one verified all the links in selected Word files and offered the opportunity to replace the links that couldn't be found. The results were displayed in a fabricated ADO recordst.
Galaxiom is offline   Reply With Quote
Old 11-10-2019, 04:19 AM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,272
Thanks: 115
Thanked 3,081 Times in 2,799 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: what's your most complex VBA code project?

That's a very subjective question and in the end perhaps somewhat meaningless.

Usually its the last major project with new features that I've finished. The final code may often be simple but the process of achieving that can often involve very complex coding.

Some apps I created 10+ years ago that seemed complex at the time now seem simple as I've reused the code and skills elsewhere since. By contrast, several projects I completed as coding challenges in the past few years now baffle me as I've never reused the code elsewhere.

Perhaps a better question would be:
What coding projects are other forum members most proud of?

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

Colin (Mendip Data Systems)
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.


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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-10-2019, 04:19 AM   #4
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 1,007
Thanks: 73
Thanked 52 Times in 45 Posts
MickJav will become famous soon enough
Re: what's your most complex VBA code project?

I built a program back in 2000 called chart tracker Elite which have a number of import/exort moduals

This was what the output looked like
https://www.ukmix.org/showthread.php...=Chart+Tracker


As A Point I'm about to start rebuilding in now I've completed the style manager.
__________________
All open code examples and free projects are only available from:

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


Creating a new project then add styles to it download open code example from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 11-10-2019, 06:02 AM   #5
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 579
Thanks: 73
Thanked 61 Times in 61 Posts
vba_php is on a distinguished road
Re: what's your most complex VBA code project?

Quote:
Originally Posted by isladogs View Post
several projects I completed as coding challenges in the past few years now baffle me as I've never reused the code elsewhere.
is it still true that google holds coding challenges as a way to pick the best candidates to hire?
vba_php is offline   Reply With Quote
Old 11-10-2019, 07:17 AM   #6
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,713
Thanks: 93
Thanked 1,710 Times in 1,583 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: what's your most complex VBA code project?

The most complex project was a tracking system for software security maintenance for the U.S. Navy. We had 30+ users (variable over time), 80+ projects with people assigned to manage multiple projects' server, over 1500 servers (variable as we grew and as servers were replaced), half a dozen different operating systems (if you count LINUX, AIX, OpenBSD UNIX, and the different flavors of Windows Server as different), and about 30-40 new designated patches per month. Patches could be in multiple states (newly announced, pending assignment to an admin, pending system downtime, pending permission of manager, pending arrival of actual patch for particular vendor's system, patch failed to run, temporary waiver, completed, determined non-applicable, ... a total of about 20 statuses overall.) In the end, patches were either applied or not, but the various reasons WHY they were not applied were important to the security staff.

Any person on the project could perform the patch and update the status of that server with respect to a given set of patches. Any OTHER person on the project could query the state of their project to see what still needed to be patched. And we could make a summary report that we could send to the project manager (who was a business type, not a system admin) regarding patch activity.

The DB was able to import info on new servers from spreadsheets and was able to produce spreadsheets to summarize project/server status. We also had a help document in MS Word that, if you clicked the HELP button, would be opened read-only to a specific bookmark related to that form or that function - and you could select bookmarks by topic. We also sent e-mail to project managers when needed, and if necessary, we could encrypt the messages over Outlook.

At any given time, we might have a total of over 500,000 pending or completed actions on record. We archived the oldest closed notices every month but "oldest" was relative to the last closure. We kept records for six months after the last closure for a particular notice and archived those records to a different file for long-term retention.

There were five base tables that had a "W" relationship. I can't draw it here, but I can summarize.

Notices - were applied to individual servers via a junction table.

Users - were assigned to projects via a junction table but they had to have the ADMIN role associated in the user table. Three teams of admins were assigned to Windows; three teams were assigned to UNIX; a few people were assigned to VMWare systems.

Servers - were associated to projects via a junction; were associated with notices via a junction. The latter junction (server/notice) was the big kahuna that grew to well over 500K records.

Everything was normalized to a fare-thee-well and we had some five-way joins in that mix because of the complexity of the relationship.

Since it involves U.S. Navy computer security, two factors apply. First, it is still in use to a lesser degree and is covered by certain regulations regarding publiation, and second, I don't own the code. Therefore, I can describe it in general but cannot publish it. Third, being cognizant of that fact, I didn't take copies home with me.
__________________
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-10-2019, 09:53 AM   #7
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 579
Thanks: 73
Thanked 61 Times in 61 Posts
vba_php is on a distinguished road
Re: what's your most complex VBA code project?

as always Richard, your posts prove to be very insightful. thanks! that was a good read.

vba_php is offline   Reply With Quote
Old 11-10-2019, 10:36 AM   #8
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,272
Thanks: 115
Thanked 3,081 Times in 2,799 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: what's your most complex VBA code project?

Quote:
Originally Posted by vba_php View Post
is it still true that google holds coding challenges as a way to pick the best candidates to hire?
No idea as I've never worked for Google. I set my own challenges when a topic grabs my interest.
Here's one such topic I worked on earlier this year : https://www.access-programmers.co.uk...d.php?t=303974
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
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.


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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-10-2019, 10:49 AM   #9
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 579
Thanks: 73
Thanked 61 Times in 61 Posts
vba_php is on a distinguished road
Re: what's your most complex VBA code project?

Quote:
Originally Posted by isladogs View Post
Here's one such topic I worked on earlier this year : https://www.access-programmers.co.uk...d.php?t=303974
you've got some talent dude! those forms in your app are quite pleasing, in terms of a user interface. I assume you run your own consultancy?

That's a great thread...I'm sure I'll look at that a few times. Lots of good stuff in there. Although, that might be giving away a bit too much information to people who should really pay for advanced programming work. But that's your choice of course.

I see a lot of free information being given away for apps that are used by beginners and non-technical people. for instance, excel and access. there are multiple forums on the web for this too. while there *are* forums for web languages as well, I don't see near as much free help being given for client side of server side languages. and I rarely see anything (like code snippets) advanced posted on forums in the form of web languages.
vba_php is offline   Reply With Quote
Old 11-10-2019, 10:58 AM   #10
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,272
Thanks: 115
Thanked 3,081 Times in 2,799 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: what's your most complex VBA code project?

I give away a lot of complex code. I do indeed have my own company.

There are several reasons why I give away code including:
a) Partly this is pay-back for when I got a lot of help as a beginner some years ago.
b) Other developers may be able to adapt the code for their own innovative projects
b) Sometimes the apps are cut down version of commercial apps and additional sales may occur as a result
c) Also doing so can lead indirectly to unrelated contract work
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
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.


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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-10-2019, 08:15 PM   #11
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,713
Thanks: 93
Thanked 1,710 Times in 1,583 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: what's your most complex VBA code project?

To be clear, I offer time here, limited though it may be, because this site helped me when I was setting up that monster I described earlier. I think of it as "paying it forward."
__________________
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-15-2019, 05:14 AM   #12
scott-atkinson
I'm with the Witch.......
 
scott-atkinson's Avatar
 
Join Date: Aug 2006
Location: West Midlands, (Formally Essex Barrow Boy....)
Posts: 1,597
Thanks: 25
Thanked 29 Times in 26 Posts
scott-atkinson will become famous soon enough
Re: what's your most complex VBA code project?

I have limited Access VBA skills, built a complex database about 12 years ago, it still works Iv'e been told, but havent touched Access since.

Now do a lot of VBA coding in Excel, and the most challenging project I've completed is building a Forecasting Replenishment workbook for multiple Distribution Centres, with lots of forecasting methodologies, and replicate it 13 times for different functions and build in self event management, updating process.

Took me about a month to complete end to end..
__________________
As you slide down the banister of life, may the splinters never point the wrong way.
scott-atkinson is offline   Reply With Quote
Old 11-15-2019, 07:43 AM   #13
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 675
Thanks: 9
Thanked 56 Times in 54 Posts
kevlray will become famous soon enough
Re: what's your most complex VBA code project?

I have never created anything particularly complex, but I did have to look at an Access DB that someone else had created (and no longer with the organization). It was reading Excel files, doing great number of calculations (at one time we discovered some of the calculations were incorrect, former employee?) and exported to Excel creating sheets and graphs on the fly. That took a while to understand the flow.

Last edited by kevlray; 11-15-2019 at 07:43 AM. Reason: typo
kevlray is offline   Reply With Quote
Old 11-15-2019, 08:36 AM   #14
scott-atkinson
I'm with the Witch.......
 
scott-atkinson's Avatar
 
Join Date: Aug 2006
Location: West Midlands, (Formally Essex Barrow Boy....)
Posts: 1,597
Thanks: 25
Thanked 29 Times in 26 Posts
scott-atkinson will become famous soon enough
Re: what's your most complex VBA code project?

Quote:
Originally Posted by kevlray View Post
I have never created anything particularly complex, but I did have to look at an Access DB that someone else had created (and no longer with the organization). It was reading Excel files, doing great number of calculations (at one time we discovered some of the calculations were incorrect, former employee?) and exported to Excel creating sheets and graphs on the fly. That took a while to understand the flow.
I know that feeling, I inherit quite a lot of Excel workbooks where 'people' have created Code, and I have to try and fathom out what the hell they were trying to achieve... Scratches Head repeatedly...
__________________
As you slide down the banister of life, may the splinters never point the wrong way.
scott-atkinson is offline   Reply With Quote
Old 11-15-2019, 08:42 AM   #15
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 579
Thanks: 73
Thanked 61 Times in 61 Posts
vba_php is on a distinguished road
Re: what's your most complex VBA code project?

Quote:
Originally Posted by scott-atkinson View Post
and I have to try and fathom out what the hell they were trying to achieve... Scratches Head repeatedly...
excel is easy for people to start using cuz one can open it up and immediately start typing crap into the cells. this is what a lot of small business people do cuz they need to write stuff down quickly.

vba_php 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
help with complex macro or code KellyADnvr Macros 3 08-09-2012 08:26 AM
Complex "notes" project and i am so lost... simpleton General 7 07-09-2008 12:16 AM
complex(?) code? Matizo Modules & VBA 6 02-01-2007 11:37 AM
Complex Example Code in MS Help Files mamandeno The Watercooler 8 01-31-2007 11:57 PM
complex code for a form Jade Modules & VBA 1 06-27-2001 07:37 PM




All times are GMT -8. The time now is 12:07 AM.


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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World