Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-09-2019, 02:51 PM   #1
Beta Member
 
Join Date: Feb 2019
Location: USA
Posts: 3
Default Programming Project

I am attempting to do a project relating to Real Estate Investing on my computer that will help me to make calculations relating to different Real Estate Properties. I have a program that was written in Excel years ago by someone else that relates to it, but it no longer works and I personally think that something like this could be accomplished in something Microsoft Access using VBA or perhaps in a language like Visual Basic.



I am wondering as to what you guys think might be my best bet for doing this. Should I do it in Access and use VBA or is there a better way that I can do this. I want to make this as user friendly as I can so that all the correct information related to a particular property is entered into the program, stored in something like a database and and will return the correct values and information. The idea behind it is for me to take a property address and it's correlating information, enter that into the program, store it and have it perform calculations relating to that property and then return that information back to me so that I can see at a glance if a particular piece of property is going to be worth the investment and how it compares to others.



There is 1 professional software program out on the market that relates to this, but it is expensive to buy. I have Office 365 (with Access) on my computer and I have Visual Studio 2017 on my computer. I however don't know as to what would be the best way to go with this kind of project.
__________________

__________________
rdonovan1 is offline   Reply With Quote
Old 02-10-2019, 05:33 AM   #2
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,265
Default Re: Programming Project

Based on what you described, what you want could be accomplished in either Excel or VBA.

What is your level of VBA or Access knowledge? I would go with the one you are most knowledgeable/comfortable with and proceed from there.
__________________

__________________
strollin is offline   Reply With Quote
Old 02-10-2019, 08:01 AM   #3
Beta Member
 
Join Date: Feb 2019
Location: USA
Posts: 3
Default Re: Programming Project

Quote:
Originally Posted by strollin View Post
Based on what you described, what you want could be accomplished in either Excel or VBA.

What is your level of VBA or Access knowledge? I would go with the one you are most knowledgeable/comfortable with and proceed from there.

My level of knowledge relating Excel and Access probably about intermediary. I have never done any programming with VBA in the past. My programming experience has been with languages like QBasic, C, and C++.



I've played with those languages years ago, but it has admittedly been a very long time. The original program that I am trying to copy was written by someone else in Excel and did use some VBA, but the program is old and does allow for one to save the details as a record like Access would.



I've been looking at taking what they did and putting it into Access as that would allow the data to be saved a s record for future use (if needed).
__________________
rdonovan1 is offline   Reply With Quote
Old 02-10-2019, 05:01 PM   #4
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,265
Default Re: Programming Project

Excel can act as a DB, the columns are the fields and each row in the spreadsheet is equivalent to a row in the DB. It shouldn't be difficult to add the ability to save the data to the existing VBA. You could even add the ability to save and retrieve the data to an Access DB from the existing VBA.
__________________
strollin is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 07:01 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0