Search results for query: *

Hi all, I'm trying to run a Macro in Excel 2000 at startup. I ca't see that there is a command line to do this, Microsoft seemed to have removed it from Office 97. My basic plan is to convert a number of XLS spreadsheets into a CSV text files, but need to remove and change some of the data first.

Sorry about the subject line but I can't think of how to describe my problem. My DataBase table contains a field for the date and time, ie 2004-03-06 21:34:12. I want to group by the date only, ei 2004-03-06. I'm using perl to select the data which is then displayed on a web site. I have the...

An error occurred while processing a B2D command.^` Drive: ReadFMTable() CreateFile failed (e:\10.201.5.10\B2D001278.bkf). Error=2 Anyone else seen this before and have an idea on how to fix the problem. Veritas support just say that it's an error that occurs, not very helpful.

Is it possible to Query the results of a Query?

Let's start of with the code : my $cur = $dbh->prepare("SELECT Device_Name FROM tbl_admin_systems"); $cur->execute(); my $menudata = $cur->fetchall_arrayref(); my $q = CGI->new; my $action = "/cgi-bin/serverstatus.pl?"; my $menu_value = $q->url_param('ServerList'); my...

How do I get the real value and not the arrayref into my menu list from this source data? my $cur = $dbh->prepare("SELECT Device_Name FROM tbl_admin_systems"); $cur->execute(); my $menu = $cur->fetchall_arrayref(); my $q = CGI->new; print $q->header; print...

I'm trying to form a refresh on a page but can't seem to get it function. Using the following code :- my $q = CGI->new: print $q->header; print $q-start_html('Live Status Report', -head=>meta({-http_equiv=>'Refresh'}));

I'll try and explain the best I can on this one. I have a MySQL table (tbl_disk_space) that I want to populate :- Device_Name Drive Size Used Free server1 C server1 D server2 C 10 1 9 server2 D 5 4 1 My data source is split into the $drive...

Running a mail script on a windows web server and get the following error :- Net::SMTP: Bad protocol 'tcp' at mailer.pl line 13. The script runs fine from the command line but not in the browser. Line 13 contains, $smtp = Net::SMTP->new('(smtp server in here)', Hello => '(Customers...

I'm trying to gather host information on a number of Windows Boxes. The information source is "ipconfig /all". I want to populate a MySQL DataBase with the following information :- Host Name . . . . . . . . . . . . : servername Ethernet adapter Local Area Connection: (Only the section...

Backup Exec 8.6, Windows 2000 and Stand alone tape drives. I need to check that each server has had the tape loaded prior to starting the backup job. Is this possible to do?

I have a query that selects a number of records, I only require the first record. Is there a way of getting the data from the queries first record into a variable so that I can populate an other table with the resulting data. This is all being done via a form that hopefully will be populated...

I want to do a lookup on a field that contains the same data multiple times, ie 100,100,100,101,101,101,102,102,102 I want to consolidate the data so I only see the unique data when I do a lookup, ie 100,101,102 Is this possible to do on a form?

I would like to generate an auto number on a field, the number need's to start at 100 and increase by 1 for every new record created. I'm not to sure on how I would go about doing this or if there is a way of modifing the autonumber properties to achieve this result.

I have a form that inputs data into a single table, one of the fields needs to be unique. I need to check after the field has been updated on the form that it is unique and produce an error message if it is not. Is this possible at all?

Not sure if I'm being stupid or not but here goes. I have a query that holds a number of records, I want to hold the first record in a variable so that I can populate a form with the data. What's the best way of doing this?

Got this code, but getting an error when I call the Function within a form. Run-Time error `3075`: Syntax error (missing operator) in query expression `Customer = John Smith`. The code stop's at : Set RS = DB.OpenRecordset(sSQL) I've been looking at it for most of the morning and can't see...

I'm creating a database that will contain IP addresses, firstly is there a way of masking the entry ie 192.168.1.254, I've tried ###.###.###.### but I need some zero's which doesn't help. Secondly I need to get the last section of the IP address, x.x.x.254, is there a way of doing this. Thanks...

I'll try and explain the best I can. Table_1 as the field "Customer" Table_2 as the field "Customer" I would like to enter data into Tabel_1 using a Form. I would like to firstly lookup from Table_2 an entry for "Customer" but would also like to update Table_2 if...

I'm new to VBA and I'm creating a Database in Access 2000. I need to create a number of records automaticly, does anyone have any ideas on how I can do this. The set-up is :- Two tables, one that will be manually populated with a number range, ie START = 0, FINISH = 99. The code then needs to...