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

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?

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.

What are the errors?

Do you know which macro is causing the errors?

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?

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.

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.

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

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.

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....

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.