Recent content by mcw21j

  1. M

    Not-able-to-print puzzle

    That's very possible The_Doc_Man. The "bigger" PC wherein the issue emerged, was configured by our IT department. The old, "smaller" PC was also configured by IT but 5 years ago. With problems of security breaches, especially at a state-run office like mine, i imagine IT installed a lot of other...
  2. M

    Not-able-to-print puzzle

    Hello everyone. Just wanted to update this post and thank you all again for the advice. Unfortunately, none of it worked to save my original database design. I had to take the nuclear option and break up the database. I was able to isolate the problem to be subreports. The underlying queries...
  3. M

    Not-able-to-print puzzle

    Thanks isladogs! Yes, you are correct. And I will edit the code and give that a try.
  4. M

    Not-able-to-print puzzle

    I went with the MaxLocksPerFile-using-VBA suggestion in the On Load event of the initial window the user sees. DBEngine.SetOption dbMaxLocksPerFile, 15000 The code compiles fine but i'm not sure if it actually changes the MaxLocksPerFile setting. Still get the same errors when trying to...
  5. M

    Not-able-to-print puzzle

    Thanks again for these suggestions. I am considering doing a redesign as a worst-case fix. I am still hopeful that I can find some tweak that will get this to work (I need IT Admin rights to do registry tweaks). I am just so puzzled because it prints correctly on 2 other lower-powered machines...
  6. M

    Not-able-to-print puzzle

    Thanks to all who replied so far. Great suggestions! I will need to look through these links in detail and run some tests. Will update when i've succeeded (or gotten tired of banging my head against the wall).
  7. M

    Not-able-to-print puzzle

    Hello, I have a local (C:\desktop) Access database which uses an ODBC connection for numerous queries/subreports which ultimately get pulled into a single overall main report. I am able to consistently print preview the main report. However, when I attempt to print (either to PDF or to...
  8. M

    dcount to find duplicates with ' (or ANY character)

    Thanks to both of you gentlemen. I am able to confirm that the replace function was successfully applied to my situation.
  9. M

    dcount to find duplicates with ' (or ANY character)

    I can swear I tried something like this before but I suppose my code is more sloppy. Thanks so much, theDBGuy :) Initial testing proves promising.
  10. M

    dcount to find duplicates with ' (or ANY character)

    Thanks so much arnelgp. It looks like that solved the single apostrophe problem but now the same problem occurs with quotes. I was worried that other characters might cause the same issue. The ideal code would allow for any text character i can type on a keyboard...$#~`{[};":, etc, etc. Thank you!
  11. M

    dcount to find duplicates with ' (or ANY character)

    Hello, I am using the following to search for duplicate text strings in a before update event on a form. I just want to allow the user to be aware of the duplicate value...these values do not have to be unique. The user needs to be able to save duplicate values if they want. Private Sub...
  12. M

    newly added values in combo box

    here ya go. there is OnNotInList code also which was from the first iteration of this database.
  13. M

    newly added values in combo box

    thanks again! yes, i did look at that link and implemented some of what i could understand. i was not able to get the fields to auto populate as follows: 1-new value typed in cbo, 2-new value auto populating in popup data entry form, 3-new value auto populating in original cbo, 4-OnChange event...
  14. M

    newly added values in combo box

    thanks for the link. i have tried the OnNotInList event to update the combo box but it only updates 1 field. since my combo box has the OnChange event attached to it which updates a corresponding textbox, i could not use OnNotInList....unless there is a way to do this with OnNotInList...i just...
  15. M

    newly added values in combo box

    Hello, I've searched all over for an answer to this to no avail...there MUST be a way to do this. I have a combo box that pulls account name data from tblAcctInfo. the combo box has an OnChange event which updates a textbox, txtAcctAddr. when i have a new account that i would like to be listed...
Top Bottom