Search results

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

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

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

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

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

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

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

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

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.

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!

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

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

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

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

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

well, to update... i couldn't get the multi-level nested subreports to show the way i wanted. instead, i added a parameter value to the underlying queries, which created a dummy record in the resulting query. the record had no other data except for the dummy parameter value. since the...

Thanks Dan! I went with the hiding labels option. It works great with 1 level of nested subreport but I have 2 nested levels (subrpt_3, nested in subrpt_2; and then subrpt_2 is nested in subrpt_1). This is the code that works where subrpt_3 is contained within subrpt_2 (this is the on load...

This was an option i was playing with at the end of the day yesterday. i've used this method before (placing a text box behind a subreport which would display when the subreport has no data) but i assumed that there would be something more elegant. my method seems so "fudgy". i mean, i guess it...

good day, good people! i have a main report with several subreports. Some subreports have other nested subreports. all of the reports and subreports are based on queries. when a query returns no values, i would still like for the reports and subreports to display in print preview. (currently...

i went the dual checkbox route and it worked! thanks so much. the user sees only the [Print] box that selects the check to print. i attached an update query to the command button that opens the report. the update query updates the [Printed] value to true if ([Print] = true). each time the user...