The project for which I needed to "Push" Access Data to Word is now gone. But in my research I did learn how to do it, and it might be of some use to you.
Word MVP Cindy Meister posted the VBA Code below, which did work for me:
Dim oWord as Object
Dim oDoc as Object
Set oWord =...
Hi Duane,
Thanks for the reply.
I have found a video by Steve Bishop that goes into the "Bookmark" process to push data to a WORD Document. So, that seems to be quite helpful, too.
Thanks again,
Ron
First, let me thank this Forum for tremendous help you have given an Access newbie over the past few years. You have helped me solve many Access problems involved with the non-profit Food Pantry where I volunteer, and I very much appreciate the help.
I currently have a need to get Access to...
Thanks for the info., but unfortunately this article fails to discuss the difficulties of doing Compact the Repair on a SPLIT database. So, it doesn't really do me very much good.
I am running a split Access 2007 database(a BE desktop server and two FE laptops) at a non-profit food pantry. I have posted several questions here over the past few months about this database running quite slowly, but have up to now had little success at fixing the speed problem.
I have...
Yes, each of the two Laptops have their own copy of the Front End Database. Of course, only one Laptop was used in splitting the Database. The resulting Front End Database was copied to the other Laptop. That other Laptop's Front End Database seemed to utilize the Back-End Database with no...
I assume that, based on the scenario I outlined, no one has any ideas about what is going on.
Could someone tell me if this might be a memory issue with the Desktop (acting as a server) computer? For example, if one of the two users out of two logs out of the Front End Database, then does...
You guys have heard this scenario before. I am running a split Access 2007 Database at a non-profit Food Pantry. There are 2 Laptops running the Front End Database part connected by wired Ethernet to a Desktop running the Background Database Part.
We have recently simplified the Ethernet...
Well, thanks again, Duane, for offering help on this.
It turns out that my problem was a study in "don't put too much store in Microsoft Access Error Messages".
Once I got all the network parameters correct (static IP Addresses, etc.) the supposed problem with the BE Database "being...
Hi Duane,
Thanks for your reply.
I'm not totally sure of the answer to your first question. I'll be down there tomorrow and make sure that all users DO have Read, Wright, and Delete permissions for that folder. I would assume they do, since this has never before been a problem before, and...
I am running a split Access (2007) database at a non-profit. It consists of two Laptops with a copy of the FE database, that are connected by wired Ethernet to a Desktop with the BE Database. All three computers are running Windows 10. That means that both Laptops are simultaneously accessing...
Thank you very much for the references. I'll take a look.
Wayne, what I meant was that I know exactly which VBA code the Access Application will jump to and run at a certain time. By jumping into the VBA Editor, I can go to that exact Code point in that specific module. It would be nice to...
I am attempting to learn to debug VBA code in Access. I believe I understand the use of the Immediate Window and the Local Window. I understand the use of the Debug.Print command.
Would someone please explain to me how to get Access into Break Mode in order to step through and execute the VBA...
Hi Duane,
I stand corrected! I guess I wasn't a very good student before. I went back and created your suggested outer join query more carefully, and it worked. Previously I just looked at case numbers in both tables and checked to see if one table had a case# that did not exist in the...
Duane,
Thanks again for your reply.
I did create such a query. The desired Relationship link between these two tables is a number called "case #", and the query shows that, in fact, there are no case #'s in the "many" table that are not found in the "one" table.
The actual error I get is...
Hi Again Duane,
I took your advice today and tried to put the Relationships in manually.
I was surprised to see that Access wouldn't let me.
I got an error message that said that it could not establish a one-to-many relationship of one table to another, because there were entries in the...
Hi Duane,
Thank you for your reply.
I have considered just putting the relationships back, but it would be a huge task. There are probably 25 Tables and 75 Relationships in the Databaae.
I am running a fairly complex Access 2007 multi-user Database (a .accdb Database)at a non-profit Food Pantry. A while back we split that database into backend and frontend parts. However, the split did not seem to go as expected. We did end up with forms, queries, etc. in the frontend, but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.