Recent content by iamchemist

I would strongly agree! I HATE the new format. I find it difficult to navigate. Like where is the "General Access Discussion" forum?

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

Duane, I do apologize for writing back to you and calling you "Wayne". It really was a typo. Ron

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