Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Modify code written by another coder

Posted on 2014-10-21
Medium Priority
Last Modified: 2014-10-21
The Coder Wrote this project For Tracking Roofing Bids
I am trying to add functionality to do track all kinds of bids eg; Kitchen remodle, New Fence bids etc
I have added a combobox where a user can enter these bids titles eg;Kitchen remodle, New Fence bids etc
I have ran into an issue when trying to save these new titles the problem is this:
I need to reset the udt's add company when a new title is saved. There is a function Add_Company that does this.
For instance:
Roofing Bids
Has 3 companies names and info in a udt
When a different cbo title(new fence or ?) is made then the company name and info should not be to the list of roofers
I think the RoofingCompany udt need to be emptied. How can this be done ?
Question by:isnoend2001
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 49

Expert Comment

by:Martin Liss
ID: 40395689
You either attached the wrong project or it is missing a form or module because there is no Add_Company function or RoofingCompany in the project.
LVL 49

Expert Comment

by:Martin Liss
ID: 40395707
Looking at an older version of your project I see that RoofingCompany is an array. Do you want to empty the whole array? If so then you can simply do ReDim RoofCompany(0) which will leave you with one, blank, array member.

Here's an article that may help.

Author Comment

ID: 40395879
Thanks martinLiss
whoops uploaded the wrong project
I guess that is what needs to be done. what i have ran into:
Project has 3 roofing companies with all their data.
ABC Roofing
John Doe Roofing
Bills Roofing
I add a new Bid Type say Bathroom remodle with a new company(Joes Bathrooms) and click save or add
I am ending up with:
ABC Roofing
John Doe Roofing
Bills Roofing
Joes Bathrooms this should not be include with roofing Bids
So if its a new Bid Type added to the cbo
This will fix it
ReDim RoofCompany(0)
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 40395913
I have added a new variable
if mbNewBidType then 'new bid type added to cboBids
ReDim RoofCompany(0)
end if
Think this will solve the issue ?
LVL 49

Accepted Solution

Martin Liss earned 2000 total points
ID: 40395948
I can't really tell because I don't know your project well enough, but doing ReDim RoofCompany(0) will wipe out everything in RoofCompany, so if that's what you want to have happen then you should do it.

Author Closing Comment

ID: 40395957
Thanks MartinLiss I will try it, if it does not work i will remove all the ocx's and post the project in a new question

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question