Recent content by dannydanny

Thanks for the reply. I guess we should make the effort to properly shutdown the servers next time then... Cheers, Danny

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 tried the macro recorder and had a look at the code, but if I just go to Edit -> settings to look at the external link info, the macro records nothing because I really haven`t executed/issued any commands. I just need the link info...... Anyway, i played around with VBA, its the...

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 all, Thanks for the replies. I don`t think my BIOS has a temp reading, but I am starting the computer from a cold boot, literally. The computer never crashes/freezes, during normal Windows use, only during bootup. But nowadays, it can`t even get past the Windows disk check sequence. I...

Hi Daniel, Thanks for the tip! It was exactly what I was looking for! Cheers, 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, How about this to reset the combo to the first item: cmbType.value = cmbType.itemdata(0) I`m not sure if this would work on Access 2000, but it works for me on Access 97. Or if you want to clear the value: cmbType.value = NULL I guess you would put these lines after your requery line...

Hi, Thanks for the reply Ken, it was exactly was I was after! Cheers, Danny

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 all, Thanks again for all your responses and insights. My code now works like a charm. Cheers CC for that explanation about how VBA handles parameters, I definitely learnt something today! Thanks again, Danny

Here is my exact code. In the form with a test button: Dim tst As New testmodule1 Private Sub CommandButton0_Click() tst.showformname (Me) End Sub And here is my test module: Public Sub showformname(frm As Form) MsgBox (frm.Name) End Sub Thanks CajunCenturion, I...

Hi all, Thanks very much for your replies. pdldavis: I will definitely look into using tags...its something I`ve never touched but I`ve read that they can be useful. JeremyNYC and CajunCenturion: I tried a test based on JeremyNYC`s example, and the object that keeps failing is in the form...