Search results

  1. H

    Slow Forms, LockFile NOT GRANTED, CreateFile SHARING VIOLATION

    I did make those changes on our server but I haven't had a chance to reboot it yet. According to KB Article 150384 it looks like a reboot is required to make this change take affect.
  2. H

    Slow Forms, LockFile NOT GRANTED, CreateFile SHARING VIOLATION

    Yes I do. We're using mostly Access 2007 here with the latest updates installed. I did find the same settings on 2007 and that's how we have it on all our machines.
  3. H

    Slow Forms, LockFile NOT GRANTED, CreateFile SHARING VIOLATION

    We have a timeclock application shared out on our network. The backend is a 2002/2003 .mdb file stored on our file server with very liberal permissions set on the share. If more than one user has a bound form open then bound forms take 5 to 15 seconds to open for all users. Also, if one user...
  4. H

    Change Textbox Color through "subclassing"?

    OK, great. I'll check that out. All our machines do have 2000 or newer.
  5. H

    Change Textbox Color through "subclassing"?

    Not much. I don't think that's what I want since some of our computers are still using older versions of Access.
  6. H

    Change Textbox Color through "subclassing"?

    Is there a simple way to have the background color change on a textbox when the user enters it and change back to default when he exits it? The only solutions I've come up with so far mean that I have to call a sub or function on_enter and on_exit, or else use a form timer. Is there some way I...
  7. H

    Close an access database from another program

    Thanks. I think I'll go the "from within" route but I believe I'll use UDP with a Winsock Control. This allows me to accomplish it without any timers and without the network activity involved in checking the shared backend for a boolean record value.
  8. H

    Close an access database from another program

    I'm working on building a system that will allow me to close a user's database. We have too much trouble with users leaving databases open overnight. 1) Does anyone have a suggestion how to do this or a method they have tried that worked or didn't work? 2) Would it be possible for me to design...
  9. H

    Multiple Entries for one machine in the .ldb file

    I don't mean to be an idiot but that's clearly not the answer I was looking for. There is some data stored locally such as user settings and for some reason over time the files do increase in size. Some of the users are savvy enough to build tables, queries and reports so that likely has...
  10. H

    Multiple Entries for one machine in the .ldb file

    I'm getting multiple entries for one computer in my .ldb file. The best guess I've come up with so far is that this occurs when a machine/user runs compact and repair on it's frontend file while others are using the database. The only way to resolve this problem is to have everyone get out of...
  11. H

    Problem with Shelling to ftp

    Looks like I found the problem. First, as a work-around, I'm now writing a batch file that cd's to the correct directory then runs the ftp string and excludes the formerly necessary quotes around the paths. This brought up a new problem. A percent in the password started causing something...
  12. H

    Problem with Shelling to ftp

    I'm trying to shell using ShellWait and then ftp some files using MoveIt Freely ftps. This all works fine until I add stuff to the end to send the results of the ftp to a text file. At that point the black screen just flashes momentarily. I'm bringing up the shell string in a message box and...
  13. H

    Show header and footer on Continuous Subform

    Your right. Sorry about that. Here's the properties for the subform.
  14. H

    Show header and footer on Continuous Subform

    I guess I should also mention that the subform does not relate to the main form. The main form is not bound to anything. Can't see how that would make any difference.
  15. H

    Show header and footer on Continuous Subform

    Here's the requested screenshots. The black "header" on top is on the main form, not the subform. I've had to resort to it for the time being since my headers and footers aren't working. Let me know if any other screenshots might be helpful. I noticed that it looks like my screenshots got...
  16. H

    Show header and footer on Continuous Subform

    That sample works and it brings to mind an issue that could be causing this problem. I'm still using an old file format for the backend and the frontent. Not sure whether it's 2000 or 2003 and not sure how to check. My application needs to be compatible with older versions of Access. I wonder if...
  17. H

    Show header and footer on Continuous Subform

    By granny, I wish I knew. I've changed their colors and placed controls on them and they still don't show up. No error message. Have ran compact and repair on the db frequently and there are no problems. It's a fairly small db with only 1 forms/subforms, 6 linked tables, several modules, and 1...
  18. H

    Show header and footer on Continuous Subform

    I don't mean to be a jerk but I won't be able to post it here without a lot of modification. It has too much proprietary code and a variety of other things that make it quite complicated.
  19. H

    Show header and footer on Continuous Subform

    I understand that you can't show headers and footers on datasheet view subforms but I have a subform that is a continuous form and no matter what I try I still can't get it to show the header or footer. I'm using Access 2007 by the way and I think I have the latest service packs installed...
  20. H

    Group field doesn't print when text is the same

    That's exactly what it was. Not sure how that property got set to that value unless "yes" is default in some cases. Wow, I should have posted sooner. Been pulling my hair out for a quite a while on this one.
Back
Top Bottom