Need help finding VB code

Hi all,

I have a database that has a column for quantity of product sold and the total price of the item (this number comes from the quantity*retail price for an individual item). The running total I have instead multiplies the total price with the quantity again. This is something I would like to change. When I click on Database Tools -> Visual Basic, all I see is the project in the project explorer window but with no modules under it. When I right click on the project, the "view code" option is grayed out. Any idea how I'm supposed to make the changes I need?

thank you.
clloccAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jerry_JusticeCommented:
Why do you think VB code is doing this calculation?

What populates your database?  Where does this running total appear?  On a report?  Reports have functions that do not need VB code.
0
omgangIT ManagerCommented:
Is there not a + sign next to the project to allow you to expand the tree?  What is the file extension of the project?  *.mdb, *.mde, *.accdb, *.accde ?

OM Gang
0
clloccAuthor Commented:
Jerry_Justice:
Where can I manipulate these functions?

And no, the tree cannot be expanded. It's a *.mdb file.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

omgangIT ManagerCommented:
I believe Jerry_Justice is on the correct track then as it seems your project has no VBA code in it either in Access Class objects (forms, reports, etc.) or code modules.  If it did, you'd see the objects and be able to view/modify them.

Do you see the database window when you open the project?  I.e., do you see  forms, reports, queries, tables?  Or does the project open to a main form/switchboard?

OM Gang
0
Bill PrewCommented:
Is your report going against a table, or a query for it's data source?

~bp
0
clloccAuthor Commented:
OK, I was assuming it would be VBA.  Basically, there is an exe that is connected to an mdb file.  When I open the mdb file, I can see the tables that make up the database.  But I am unsure where to edit the function of the exe file which incorrectly sums up the total sales.  

Let me rephrase my initial question:
Is there an easy way to edit the code in the .exe thats connected to the .mdb file so we can correct this seemingly simple math calculation?

Thanks.
0
clloccAuthor Commented:
Is your report going against a table, or a query for it's data source?

~bp

the .mdb contains tables which organizes the data.  However, the actual data comes from csv files which we import into the mdb, via the exe that is attached to the .mdb

Once the csv data is imported into the mdb tables (again via exe) then the data is compiled into a specific fixed width format which is then sent to a 3rd party for processing.  

The problem we have is that when the data is compiled, there is a new record that is created which includes an incorrectly calculated sum total of sales.  I'm hoping to find a way to make a simple math adjustment to whatever component (either exe or mdb) that is totaling sales so the correct sum total sales value appears in the fixed width file that is generated by this whole process.
0
omgangIT ManagerCommented:
Sounds like you're dealing with a compiled application (exe - e.g. VB6 or ???) with an Access backend.  If you don't have the uncompiled source code I'm not sure you'll be able to make any changes.

OM Gang
0
clloccAuthor Commented:
Is there anyway to decompile the exe to retrieve the source code?  I'm assuming there isn't since no one has mentioned it...
0
Jerry_JusticeCommented:
Where can I manipulate these functions?

And no, the tree cannot be expanded. It's a *.mdb file.
...............
It depends.

You still haven't answered where the data comes from and how you are viewing these "totals".

You see, the question is:  Are these totals part of the data, or simply totals calculated "on the fly".

If you are viewing these totals in a report, then the report could very well be calculating these at run-time.

From the way you describe this, it sounds like a report.   Can you open the report?  If so, look at the report or group "footer".  There is probably a calculated field somewhere in there.  Look at "Properties" and it might have something like =Sum(Amount * Qty) in the ControlSource property.  You can edit this if you know what you are looking for.

But do make a copy of your report before you start messing with it.  If you are not familiar with programming in Access, you can get in trouble pretty quickly.
0
Jerry_JusticeCommented:
I should have waited before that lengthy comment.

Yup, it sounds like your data manipulation program is creating the wrong totals.  Probably a VB program.  Look around for a VB project.  Search for files ending with ".vbp"
0
clloccAuthor Commented:
by: Jerry_Justice Posted on 2013-09-30 at 15:45:08ID: 39534343

I should have waited before that lengthy comment.

Yup, it sounds like your data manipulation program is creating the wrong totals.  Probably a VB program.  Look around for a VB project.  Search for files ending with ".vbp"

Thanks for the clarification.  I am unable to find a .vbp file, seems like there is only a .exe and .mdb in the same directory.  

Would that indicate to you that the .exe is coded in something other than VB?
0
omgangIT ManagerCommented:
Thanks for the clarification.  I am unable to find a .vbp file, seems like there is only a .exe and .mdb in the same directory.

Would that indicate to you that the .exe is coded in something other than VB?

It only indicates you don't have, or don't know where to find, the original, uncompiled, source code files.

OM Gang
0
Jerry_JusticeCommented:
Possibly dumb question: Does whoever you are sending these fixed length files to really need a total record at the bottom?

Can you write a quick program to modify the total record?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
clloccAuthor Commented:
Possibly dumb question: Does whoever you are sending these fixed length files to really need a total record at the bottom?

Can you write a quick program to modify the total record?

Yes the total record is required.  That is a good work around solution, I'll probably look into that, it seems that is the best route to go.
0
clloccAuthor Commented:
Thanks for the help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.