Search results for query: *

Hi, I have 2 Dell PowerEdge 2600 servers, both running Windows2k Server. One weekend, our office building was scheduled for power maintance which meant no power for about 6 hours (only on the weekend). So we planned to shutdown the servers on Friday night and start them up again on Monday...

Hi, I have an Excel Workbook A which has links to another Excel Workbook B. Usually I would go to Edit -> Link Settings to find information about the path / location of the source workbook B, but how can I find and/or change this information using VBA?? Thanks for any info in advance, Danny

Hi, I know about the docmd.outputTo code to export a table to an Excel file. However I would like to export multiple tables to a single Excel file, with each table represented on different Excel Worksheets. Is this possible in Access 97? I suspect it might take some complex VBA coding in...

Hi, Maybe I should be asking this in the Windows 2000 forum, but one of my users can not boot up his computer. Even though he can shutdown the computer normally, on bootup Windows does a hard disk consistency check. About 5 seconds into the check, the screen goes black and the computer does...

Hi, I have just installed Office 2000 SP3 on most of our office computers. We use some Excel files with macros in them. Before i applied the SP3 update, Excel used to ask us if we wanted to Enable or Disable macros before opening the file. But after the SP3 update, Excel just opens the...

Hi, I have run an SQL query in Access97. I want to add another blank column into the query results so that I can do a UNION query using this table and another table which has an extra column. Is this possible with a SQL query statement? Thanks for any info. Danny

Hi, I have about 5 forms which have code that is about 90% identical to each other. (Code to hide textboxes, save a record, delete a record etc.) I would like to create a separate class module to centralize this code so any changes I make, I only have to make to the class module and I don`t...

Hi, I have a form with a subform. I would like to write code in both forms to execute/trigger procedures in each other i.e. have the subform trigger a procedure in the parent form and have the parent form trigger a procedure in the subform. How would I code this...

Hi, I have a continous form with many records. I can create a macro to page down whenever a button is clicked, but I would like to write the VBA code equivalent of the Page Down macro. Could anyone please give me some tips? After I created the Macro, I tried: DoCmd.RunMacro (PageDown)...

Hi, One of my users has found that recently any attachment he views within the Lotus Notes (v5.0.8) email program gets registered in the Start, Documents list. So now that list only contains "ghost" references to files he only viewed within Notes, and not opened within Word, Excel...

Hi, When designing my subform, I have a button which makes a field on the subform unlocked for editing by the user. If I view my subform, this button works ok. But when I insert the subform into my main (parent) form, the button on longer works. I get an error message...something like...

Hi, OS: W2K Pro SP3. I have a Canon digital camera. I plugged it in to the USB port of my computer and installed the drivers of a CD when prompted by Windows. But the software used to interface the data in the camera can not detect the camera, even thought Device managers says the camera is...

Hi, Software: W2k Pro SP3, Office 2000 SP3. Printer: HP Laserjet 4050 with latest drivers. I have an Excel workbook which consists of 10 sheets which are a combination of landscape and portrait orientations. If I were to print each sheet separately, they would each fit on one page. However...

Hi, I`m have just done a fresh install of Windows 2000 on my IBM NetVista M41. After installation, I went to Device Manager, and there were 3 items with the question mark and a yellow circle next to them. I inserted the CD I got from IBM with all the drivers required for my machine, and...

Hi, Win2k Server SP3. BackUpExec v8.6 (both Japanese versions) Dell PowerEdge 2600 with internal SCSI LTO drive. We recently installed a new server. Everything from the hardware to the software is brand new. But recently the server crashes a couple of times a week. It only crashes during...

Hi, Software: Win2k Server SP3, Backup Exec 8.6 Our brand new Dell PowerEdge2600 has been crashing recently (once every 2 weeks). I notice that it crashes during a backup using Backup Exec v8.6. The backup device we use is a SCSI internal LTO drive. This drive is on a different channel to...

Hi, We just moved our users from a NT4 domain into AD. (W2k Pro Sp3, Office 2000 SP3). Since then, when I open an Excel file with macros, the usual prompt that asks me if I want to open the file with the macros active or disabled does not appear. Then when I try to manually run the macro, I...

Hi, Our server is running W2k Server SP3. I wanted to run a disk check on our data drive, 146GB, RAID 5. But Windows says I have to schedule it at the next boot up. So could anyone tell me approxiamately how long it will take (with both options to repair bad sectors checked)? Because I...

Hi, We are all using W2k Pro SP3, and are in an AD domain. Recently I migrated all our computers from an NT4 domain into the AD one. Before migration, usre only had to type their password when loggin on as the username field was filled already with the previous logon username. After...

Hi, We are about to return a server to a leasing company. Of course I will format all drives, and break the RAID 5 that is setup across all HDDs, but is this enough to prevent someone with good knowledge to re-construct the data on the disks? I have heard of people being able to recover all...