Search results

DocMan, I printed out your suggestions as a checklist and went back through the code, also looked at the links, but I had already implemented all of them. Right now I'm looking at rewriting it to export to text files and use bcp to import them to sql. (Time is also an issue. 3 hours...

Perhaps I should have said I'm looking for things outside the common ones that might help me figure out what is wrong. For example, is there anything in Performance Monitor I should look at? Is there any way to find out what resource is the problem? (I'm not seeing anything in Memory...

Moving data to a SQL database to make it accessible to more users. (growth issues). As I said, I actually have two different situations, very different situations. The other is a business app where the problem seems to be a form with 42+ subforms (Calendar app) which has been rewritten several...

I have two different situation where I have not been able to solve the Error 3035 "System Resource" exceeded problem. I've looked for memory leaks, set the MaxRecordLocks to 1 million as suggested elsewhere, and tried various rewrites, all to no avail. The latest is a routine that moves data...

following code has a few things stripped out to make it simpler. FileIsClosed() just looks to see if the lock file has gone away. the FileIsClosed() call was recently added. It did not solve anything. Private Sub UpdateDatabase()...

>> How long do you have to wait? << Varies. I have had it take 10 trys over 10-20 minutes, and I've had it work a minute later. Though I've never know an immediate retry (5-10 seconds) to work. And I've gone for weeks and never seen the error. Then seen it multiple times in a day...

It's fairly simple. The database checks the version, if a newer one is available it uses the SHELL command to start another App and uses Application.quit to shut itself down. The second App asks the user what they want to do. The first app will have completed it's shut down by the time they...

First, you misread my post. I am copying a new version, with updates, of the front end. As for the backend, there are a lot of reasons to link to different backends. Most common one is training purposes. The second is to look at archived data "What was in this file at the end of last year?"...

Did you ever find a solution to this problem? I get the same error "sometimes" for no apparent reason with a version handler that I have used for years to copy a new version of the front end from a server to the users workstations. Never have found a solution.

You have Texto694 in the code and TextBox694 in your reply. Which is it? Is the line "Option Explicit" at the top of the code file? (You should always turn it on as it will prevent hours of frustration with typos.)

What you're trying won't work. There is a post that shows up in the list of "similar threads" that sounds like what you need. Re: Continuous subform - control to display image / icon based on another field (AC20007) It's marked "solved". I would use hyperlinks. Otherwise you have to...

You need sql something like this: SELECT Customer.Name FROM Customer WHERE (((Customer.TimeCreated) Between #4/1/2015# And #7/1/2015#)) GROUP BY Customer.Name; Or in the query design view for the Date line set the "Total" line to WHERE and uncheck the SHOW box. And if you do not change the...

Kicking myself, don't know why I didn't try that. Old code gave me blinders I guess. Did have to handle the OpenArgs in the Load Event instead of Open. What's nice is I added the code and none of the other calls had to change.

Are you trying to do this in the query design view? In Code? In a report? Are you getting an error? Also "Date" is a reserved word. It should never be used as the name of a field. Try changing it to something like dtmMyDateField.

As there is not enough information to really tell what's going on, try wrapping the value in Nz() Nz(Me.Texto694.Value,0)

It is opened "Hidden". then we set the value of the Title and an unbound text control. then we select the report object, which makes the report visible, but the unbound control is shown empty, as it does not get repainted when we the value is set after it is opened. Then the report is printed...

I use the following code in many place to open and print a log. I would like to let the User preview the report, then decide if they want to print the log, which seems easy, but the Preview view that shows always show a blank "LogText" control. If bolErrorsFound Then strReport =...

That did the trick. I found numerous posts various forums that indicate _GotFocus is buggy. I don't use it much, and have always used MouseUp for drag and drop stuff.

Here's the sample database. It has a few minor differences from the original post, as I've tried a lot of things, and left some stuff in that gives me visual hints that I'm hitting the lines I intend to hit.

I've placed the break point in several spots. Same results every time. All of the code "works". None of the code "works". No errors, no warnings. It's only with a new record. The field is a part of a multi-field primary key. I can duplicate the problem in a clean database with one table...