Recent content by Griff389

Thanks for the replies guys. :)

Hi all, I want to get a cert installed on our firewall so that when people browse to it from the local lan, Ie doesn't keep complaing there's a problem with the certificate. So I'm looking at installing a CA on our Active Directory and issuing it a Self Signed Cert. (At least that's what I...

Sorry for the late reply. Thanks for that. I'll take a look and see if I can make something from that. A user just wants a list of all the files that contain the text he's looking for, so hopefully this will do the trick. :) Cheers

In excel 2003 there is a "file search" option that lets me search of text in multiple documents and then shows me a list of which documents contain the search term. Is there a way to export the list of documents that the search returns. Or maybe an alternative? Thanks Carl

Thanks RivetHead. I used DoCmd.SetWarnings (False) DoCmd.RunSQL "DELETE * FROM TblUsersLoggedIn Where Username='" & NTDomainUserName & "';" DoCmd.SetWarnings (True) for the delete and works fine. Much appreciated. :)

That works great. Cheers for the quick help. Don't suppost you know the best way to add the username into the table when they open the db, and then delete the row when they click my button to close it do you ;) I'm guessing a SQL statement will be easiest. Select Into, and Delete from perhaps?

I'd like to restrict users from opening a database more than once, by adding there network login name to a one column table (TblUsersLoggedIN) when they open the database. Then if they try to open it again without closing it down, on another computer for example, it will first check to see if...

ignore the last comment about uri formats, my mistake on that one, but the rest is still a mystery :)

We have an Office sharepoint 2007 server that has it's data in a remote sql 2005 server. I don't have any sites in it other than what is created by default (i.e. the admin site, and a portal site). I've created a full backup to a share on a windows 2003 server using the central admin page, and...

Thanks for the link. That didn't work either. Looks like i'm going to import the forms into my old working copy along with any code I have changed, and see if that works.

everything that is referenced is fine. (cheers for the help by the way :) )

The error trapping is set to "Break on Unhandled Errors" Yes compiling seems ok, and i've 'compact and repaired' it a few times. Not sure on any references missing. It definately seems to be something in the Database. I tried it with a different database (an old copy of the one i'm working...

I still get both message boxes firing instead of breaking. Private Sub Command17_Click() Stop * MsgBox "test", vbOKOnly * MsgBox "test2", vbOKOnly End Sub (The * indicates the breakpoints)

Incidently, this is on Vista, but I'm sure that's not the issue as I get the same results when test it on an XP Virtual machine too.

It works fine. I just tested by adding a new button to the form, adding these two lines of code: MsgBox "test", vbOKOnly MsgBox "test2", vbOKOnly and putting a break point on each line. When I clicked the button it just ran both message boxes, despite their being the two break points too.