I installed Small Business Server 2003 in April 2005 in one of our client's machine. This machine is: Processor: Intel(R) Pentium(R) 4 CPU 2.40GHz Frequency: 2.4 GHz Amount of RAM: 512 MB and 40 GB in Hard Disk. They have 10 users in their Network and Exchange server was not implemented ath the beggining...

I have two open workbooks; Book1 and Book2 Book2 has a lookup table on sheet1 I want to run code from book1 that will pick up a value from cell A1 and then lookup from sheet1 in book2 that value and return into B1 what is in column 2 The code I have tried is [B1] = Application.VLookup(Range("A1"...

I need to download about 50 or so items from our Sharepoint site. There has to be a better way to download them in bulk without the use of 3rd party utilities or one-by-one. The server is using a remote SQL server for all data on this SP server, but I don't see a clear way to do this. Any suggestions...

we're thinking of upgrading from Office 2000 to Office 2007 i have 6 workstations, all w/ Office 2000 Professional. i only need Access on 1 of them (the Vista machine) so i have 2 questions: 1) can i upgrade from Office 2000 Professional to Office 2007 Standard? 2) what will i have to do to get my...

I'm working on an Database created by a former co-worker which links data from a dbase 5.0 database with Access 2000. The dbase data needs to be deleted from within Access and my former managed to accomplish this in Access 97 using a delete query but with the upgrade to 2000 it now fails. The error...

I have a project with a setup After the setup is done i need to copy a file from the location of the setup file to the installed directory. Does anyone know how to retreive the path from where the setup was run. Eample: setup.msi in on d:\myprogram\setup.msi and installs to c:\program files\mycompany...

Is it possible to recover contacts from a users profile that has since left the company? Situation: A user left several months ago. User is out of the system and mailbox deleted. The user used cached outlook 2000 on his PC. We now need to get to contacts that the user had. Is it possible to get them...

Hi experts, I am running a module that used to creat a table for me, and now is creating a problem. I wrote this in access 2000, and havd 2003 now. What is wrong? Function Posting_Types() Dim db As Database Dim tb As TableDef Set db = CurrentDb() ' Deleteing existing Graph Data if it exists For Each...

When I place a Text box on the form, it also has a Lable that is "attached" to the Text box. I want to disassociate the Label from a Text box so they are independent of each other. Also, at some later time, can a RE associate the Label or Labels with this Text Box? Thanks, Tom

Hi, I have a excel which has data like this. Srl No Seat No Ext No 1 HC-1F-24 8888 2 HC-1F-25 8889 3 HC-2F-29 8734 Colum A is the serial No Colum B is the seat no's of the users and colum 3 is the extension 1. What i want is srl no should change autromatically 2. Seat no is a fixed field and that...