473,327 Members | 2,069 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Combining multiple tools into one Master tool

doma23
107 100+
Hi everyone,

For the simplicity, let's assume we have a multinational company with different businesses:
1) selling food
2) manufacturing toys
3) growing oranges


Idea was to build the one Access tool per business, all together three tools, which would be accessed independently.
After finishing the Food.mdb tool, I realized that I would actually need an access to all three tools from one place (one form).
So I've built one Master form frmMaster inside MasterDBA (previously called Food.mdb), with the different business blocks and buttons on the form.

Structure of frmMaster:
cmdFood_EnterData - opens frmEnterData
cmdFood_Charts - opens frmCharts

cmdToys_EnterData - not linked
cmdToys_Charts - not linked

cmdOranges_EnterData - not linked
cmdOranges_Charts - not linked


As the tools will be now combined, I need to change all the Forms, Queries, Tables and Sub Routine names in the modules.
I've started with forms, changing frmEnterData to frmFood_EnterData, and frmCharts to frmFood_Charts.
I've used search&replace function in the VBA editor to correct the code.
But now I need to to the same for each called subroutine, queries and tables, because the future tools Toys and Oranges will for sure be using some of the same sub routine and other names.

My question is - is there a better way to solve this?

For example, is it possible somehow to put all the code, tables and queries from Foods tool into one collection, so when entering the frmFood_EnterData only this collection would be called.
And when entering Toys and Orange forms their specific collections would be called, and would operate seperately from each other.

And if I would need to combine data from couple of collections, for example for Total Revenues of all the businesses, I would just call different collection instance.

For example this would be much easier if possible:
cFood.tblData("Revenues")+cToys.tblData("Revenues" )+cOranges.tblData("Revenues")

instead of renaming everything and then calling like this:
tblFood_Data("Revenues")+tblToys_Data("Revenues")+ tblOranges_Data("Revenues").

Any help is greatly appreciated.
Jan 17 '13 #1
3 1144
zmbd
5,501 Expert Mod 4TB
Instead of co-opting your food.mdb I would build a seperate db that links to the other three.

I do this for several reports I run in the lab I work for; wherein each departement has their own database and I simply link into their backends with my "master" to pull the information. I don't have to mess with anything in the departement level databases which keeps my older staff happy!

You didn't mention which version of Access you are using (v2003?); however, you can link to the backends in a few different ways but the easiest will be with the get external data from the file menu which will allow you to link into the live databases and go from there.
Jan 17 '13 #2
zmbd
5,501 Expert Mod 4TB
I just remembered this: http://bytes.com/topic/access/insigh...ontrols-string

If you have to merge all threee the db into the one then the afor should be helpfull too!
Jan 17 '13 #3
doma23
107 100+
Ok, thank you! I will think about what to implement.
Jan 21 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: perplexed | last post by:
Is there a way to combine the values of multiple form items such as two textboxes and one radio button for insertion into one MYSQL database field?
0
by: glenn | last post by:
I'm really scratching my head over this one. I'm working with CSV data exported from Excel, which explains why it's a mess to begin with. Within a table (or via any other means someone might be...
0
by: Bob C. | last post by:
I am considering combining one large Access db and several small Access db's into a single SQL Server 2000 db. The small db's serve separate but related functions in our operation, and they all...
3
by: alwayswinter | last post by:
I currently have a form where a user can enter results from a genetic test. I also have a pool of summaries that would correspond to different results that a user would enter into the form. I...
2
by: Will | last post by:
I have a table, tblManinstructions with fields Code & InstructionID, one Code can have many InstructionID. I also have tblinstructions (fields instructionID & instruction). What I want to do is...
2
by: hp3k | last post by:
Hi, I'm a newbie to VB .Net and am unable to locate an example of combine two different font types (Arial and Wingdings 3) in a display (text) string. Does anyone have an example of combining...
5
by: André | last post by:
Hi, I am using this code to prevent multi click asp.net 2.0 c#, System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("SetValue();"); sb.Append("if...
3
by: Odawg | last post by:
Hello All Database (Access) Guru's, I am a novice when it comes to databases and I know enough to get simple information for my needs. With that said, I was given an opportunity for improvement...
0
by: nike111 | last post by:
hi frendz, can anyone say me how do we club different tools like Jedit, jabref, jproject with help of java...??? any tutorials can also be provided.? thnx in advance nikhil
6
by: Jeremy Goodman | last post by:
Access 2007; Merging records containing multivalue drop down lists. I have a database showing legislation information divided by State/territory. The database needs to be able to show the info...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.