Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. iamchemist

    Sad

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

    Push To WORD?

    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 =...
  3. iamchemist

    Push To WORD?

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

    Push To WORD?

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

    Compact and Repair Split Database?

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

    Compact and Repair Split Database?

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

    Access Slow Down??

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

    Access Slow Down??

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

    Access Slow Down??

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

    Windows 10 Security/Access Issue

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

    Windows 10 Security/Access Issue

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

    Windows 10 Security/Access Issue

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

    Getting Into Break Mode?

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

    Getting Into Break Mode?

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

    Getting Into Break Mode?

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

    Strange Database Split

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

    Strange Database Split

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

    Strange Database Split

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

    Strange Database Split

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

    Strange Database Split

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

Part and Inventory Search

Back
Top