Search results for query: *

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

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

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

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

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

I have a database and would like the users to only login once. I have a module to get the user name already, and it is referenced as NTDomainUserName. I'd like my startup form to look into my "tblUserlist" table which has only one field called "Username", and see if the username exists already...

I've got a script which runs when a user switches off their machine that checks the value in the registry key 'HKLM\Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\AUState' and if it's a 5, adds it into an ini file. This is the current state of a windows 'automatic update' at...

I have a line of code which i'd like to run whenever a user prints one of my reports. Can someone help me out on where best to add the code. I thought perhaps one of the On Print sections, but the code runs even if you just open the report to have a look at it. Thanks Griff

We are using Outlook 2003 with Exchange 5.5. When I create a new user account and have them log in and use Outlook the first time. it kicks off the profile wizard and asks them (or me) to create their profile. To where I tell it to use exchange, give it the user name and then everything is...

I have a form with customer details such as customer code, address details, tel number etc. We also use a SQL database as our main system and i'd like my Access database to lookup the address from the SQL table where the customer code are the same. I've done a search but can't find anything on...

In my form i've got a control which simply joins two name fields together to display the full name. The code I have is: =[First Name]+" "+[Surname] This works fine in the form, but when I try it in the report (with the same fields), it comes back with #error. I've tried changing the + for &...

Hi all, Does anyone know of any way to stop users from using the 'Disconnect' option and thus making them logoff? I've hunted around but can't find anything on this. Regards Griff

I've got a form with two controls in particular called txtProduct and txtDescription. I have a separate tblProducts table which holds the products and descriptions. When a user types in a prodcut code in the txtProduct box how can I get it to put the corresponding description from the table in...

Hi guys and gals. I've got a database front end on each users local drive, with the tables on a network drive. When the user loads the database it loads the splash screen ok as it's local, but when they click the 'OK' button to load frmReturnsReport, it sometimes takes up to 10 seconds to...

I've got a form with a cotinuous form as a subform. I've got an e-mail button which creates an e-mail based on details from the form. How can I go about adding in the details of the subform into my e-mail. Obviously it would only contain records relevant to the main form. The code for my...

I have a form with about 6 tabs in it. The "Items" tab has a sub form with a continuos form it which one department enters a list of items to be repaired. (Data goes into an "items" table) Another department uses a "Parts Used" tab to enter a list of parts used in the repair. (Data goes into a...

I've got a subform which is a continuous form displayed in my main form. The subform contains fields [RetrunNo], [ItemNo] plus a few more insignificant fields. The link field is [ReturnNo]. So far this works fine. I want to add a second form to display information based on which record is...

I'm using Barts Modular boot disk to boot our new machines onto the network so I can then ghost an image on to them. This was working finr all day yesterday, however now when I use it I get to the login password section, and after entering my password i am presented with: "Error 5. Access...

I've had a search and came up with nothing, so here goes. We have a few users that have an alternate recipient set up in their mailboxes to send copies of mail to custom recipients (home address). Recently we set up a new install of exchange 5.5 on a w2k server under the same site, and moved...

Can anyone help me. I have a folder containing approx 8 sub folders, with a total of about 1000 excel files. I need to open each one, replace some forumlas, and then save and close them. What i've done previously is copy all those files into one folder, and then run the code below to modify...