MS Access/VB/MS Word Help
Hello Gurus,
I haev a situation at work and need your help...my job depends on this....I am not a developer yet i have been assigned a "Small" task.
We currently have a Glossary Database (MS Access). it has around 1000 Acronyms/words and their definitions.
Then there is this VB application that allows a user to pick a word document to scan for words that match the ones in the glossary database. The applicaiton creates a list of all the matching words and allows the user to select the desired words and upon click of the "Generate deifinitions" button, the application displays the definitons for teh selected words. The user can copy it and paste it in the word document under the glossary section.
We have added some Macros (Dropdowns with some values) to our word document and this application has stopped working.
How can we fix this issue? the person that actually developed this application is no longer working for teh company and it is now on my plate.
Any help/advice is truly appreciated. I am in deep crap. Please help!! please !!
Thanks,
Ravsmog
Re: MS Access/VB/MS Word Help
Welcome to the forums :wave:
Quote:
Originally Posted by
Ravsmog
We have added some Macros (Dropdowns with some values) to our word document and this application has stopped working.
1. Who added the macros?
2. What do the macros do? Why are they necessary?
3. What happens if you take the macros out?
4. What does "stopped working" mean? Are you getting errors now?
Re: MS Access/VB/MS Word Help
Hi Hack,
Thanks for replying. here are the answers to your questions
1. Who added the macros?
Another employer that is no longer working for the company
2. What do the macros do? Why are they necessary?
Macros lets the user select from a whole bunch of downstream applications. We have roughly 8 systems (hence, 8 dropdowns) that have impacts on like 50 downstream applications (which are the dropdown values). I forgot to mention that we also added tables to the document.
3. What happens if you take the macros out?
The application works fine without the Macros and tables
4. What does "stopped working" mean? Are you getting errors now?
The application hangs up, and even if we get it to working, yes, we get errors.
Re: MS Access/VB/MS Word Help
What are the errors?
Do you know which macro is causing the errors?
Re: MS Access/VB/MS Word Help
No, we do not know what is causing the application to freeze. I think it is MS Access Forms interface, not sure if its VB or VBA code....I am assuming they are pretty similar.....
We are assuming that its the macros that is causing the application to freeze...
we get this error " There may have been an error evaluating the function, event, or macro."
we want to create a new application (Build from scratch) to replace this....could you please help me with the code?
Re: MS Access/VB/MS Word Help
Quote:
Originally Posted by
Ravsmog
No, we do not know what is causing the application to freeze. I think it is MS Access Forms interface, not sure if its VB or VBA code....I am assuming they are pretty similar.....
In the same way that a bicycle is pretty similiar to a motorcylce. Both have two wheels...both will get you where you are going...both use handle bars. The major difference is that one has a lot more to it, has more power, and does many similiar things in different ways. Knowing one does not necessarily mean knowing the other. (Also, there are different versions of VB and the difference between VB6 and VB.NET are monumental)
Quote:
Originally Posted by Ravsmog
We are assuming that its the macros that is causing the application to freeze...
Why is this an assumption? Did you not say in a previous post that if you remove the macros the application works fine?
Quote:
Originally Posted by Ravsmog
we get this error " There may have been an error evaluating the function, event, or macro."
You need to find the exact line of code that is causing this error.
Quote:
Originally Posted by Ravsmog
we want to create a new application (Build from scratch) to replace this....could you please help me with the code?
Help yes...write for you no. You also said that you are not a developer, so who will be writing this new application?
When you have a specific programming question with code that you have written, please feel free to post it.
But, lets get this resolved first.
Re: MS Access/VB/MS Word Help
Quote:
Originally Posted by
Hack
Why is this an assumption? Did you not say in a previous post that if you remove the macros the application works fine?
Yes, it does...but since i have no clue about programming, i am not sure...what is causing the application to freeze, because sometimes we get an error.
Quote:
Originally Posted by
Hack
so who will be writing this new application?
Apparently me....they have given me a week....they say that it is simple Access forms and macros....and I should be able to do it.....
Quote:
Originally Posted by
Hack
When you have a specific programming question with code that you have written, please feel free to post it.
But, lets get this resolved first.
Ok, will do, thanks Hack.
1 Attachment(s)
Re: MS Access/VB/MS Word Help
I have attached a screen shot of the application....the "Create Glossary" section
Displays something like this:
CFA
Chartered Financial Analyst
PMP
Project Management Professional
Thanks,
Ravsmog
Re: MS Access/VB/MS Word Help
Quote:
Originally Posted by
Ravsmog
i have no clue about programming
Quote:
Originally Posted by
Ravsmog
they have given me a week....they say that it is simple Access forms and macros....and I should be able to do it
A week! :eek2:
"They" don't know anything about programming do "they"? Lotsa luck...you are gonna need it.
I don't know what you are trying to tell us with the screen shot.
Re: MS Access/VB/MS Word Help
They do know about IT...but they are trying to save money by not going to the IT division.....they received an estimate of $10,000...so its on me to solve this puzzle....
Re: MS Access/VB/MS Word Help
Like I said, you need to find out exactly what is causing the error. The easiest way to do that is to comment out all of the error trapping, run the app, let it blow up, and then at least the cause will become apparent. Once that is known, we can start looking at fixing it.