Search results for query: *

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.

Hi Guys, i'm looking for some help in my access 2003 vba. It seems that if I put break points (the red circle at the beginning of the line) in my code in order to debug something, they don't appear to break the code. When I reach where a break point should happen in the access form, I don't...

No NTDomainUserName is a function in a module that gives what the Active Directory login name is. This is what I was checking for in the "tblUserlist" table. I did note your Criteria code, but I presumed I could remove that and just tell it to use NTDomainUserName instead. Didn't realise the...

It's a front end with the forms and queries, and a back end on a network drive with the tables in it. The problem i'm having is i'm guessing the record set code above checks to see if the user is listed in the table, but I don't know what to do with it. I've not used recordsets in my db's yet...

Admin won't be a problem as there's no db security set so all use the same user, I think that's how it works. I've got a function to give their network login, and that's what i'll be adding the table. If I have problems where I can't get in, I will just open the backend MDB file and remove the...

Easyit, They will use the shared lock file on the network for a brief spell while it checks the relevent table to see if they already exist, but they won't be using anything creating locks in my main tables, and it should only be for a brief spell til it closes the database down for them, so I...