Search results

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.

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.

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

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

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

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

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.

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

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

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

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

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

Your right. Sorry about that. Here's the properties for the 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.

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

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

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

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.

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

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.