Search results

Can I fix this Chris or anybody is it possible to fix this problem?

Found the Problem Its the Application.Quit that hangs it up or similar commands that do the same thing. I tried the MsgBox Option and it worked perfectly even when the form was not the active window on my screen but it was messing up the other way even if the form was the active window. Now I...

Code Option Compare Database Private Sub Form_Timer() ' IDLEMINUTES determines how much idle time to wait for before ' running the IdleTimeDetected subroutine. Const IDLEMINUTES = 5 Static PrevControlName As String Static PrevFormName As String...

Update I am using the code verbatim but I am using the one without the message box so it would close right away. I did not populate the interval at first so that's why it didn't execute. Now the application hangs. I have tried everything from Applicataion.Quit to DoCmd.Quit with and without...

Link Here is the link Here is the link I used.

The problem Hi, Well I launch the database. Click on the form to select a position and I go into my entry form. I just sit there for minutes on end and it never closes. Code is verbatim the microsoft site suggested by ghudson. I am running 2003 Access.

I read the dialogue between ghudson and bikeman77. I decided to follow the route that microsoft suggested which was to use a macro to execute the form. Problem is I don't think it launch the form because it went past five minutes and didn't shut the datbase down. The way my database works is...

I found some code to delete those import tables from the Microsoft site. I think if I put it in a Macro I can run anytime I click on it. I need it run automatically eveytime before I exit the database. Anyway to do this?

Glad Glad we could be there for you. I will be testing this some more. Has some potential.

It should work for only the users who are idle This should only kill sessions which are idle correct. Say 4 are in there and 2 haven't worked on it in 30 minutes time. Then it would kill only those two sessions correct?

It works Actually put what you susggested in the Timer Procedure. Shouldn't that work the same instead of the old code in the link. Everything else including the Autoexec is the same as what was in link as well. This should work as well without adding anything including the zero assignment to...

I tried this and it didn't work I have a startup search form and a editing/entry form. I did not touch the db for 30 minutes which was my time. It still did not close.

Can someone help me I have not hear back from Ken. Can someone else help me. I need to know how to do commas in the validation rule as mentioned before.

Actually Ken, Actually its words but what if I need to seperate by commas. Thanks for the help.

Its String Its String.

Question about validation rules. I have a user who has set up a validation rule to allow certain values to be entered. Something like if the value equals 4 or equals 5 then it would accept it. Now she would like the validation be set so they can put both 4 and 5 in together. How can this be done?

When I am on my entry form and use the scroll wheel on my mouse to scroll down the form it scrolls through all my records. I do not want this happen especially if other users are the using the db. They could be making changes and do this and accidentally edit someone elses record!! :eek: I...

Found the culprit Doc man, The problem was that there was an error that XP was detecting when opening the word documents using the 2003 Word applications. Some kind of data integrity error Type 4. I had to open the documents using open and repair option and save the documents and everyhting...

Response Not really, All have tables all use virtually the same code to open the word documents. And even when I went into the 2003 application it was referencing the right libraries. Now I did this in 2000 and they are using 2003 to open it up. That's the only difference I can see. Strange to...

Hmm Strange thing is I have 4 other documents when you click on the button that work just fine.