Search results for query: *

Hi, I'm trying to write a stored procedure where one of the string parameters passed is 'evaluated' to be used within a query in that procedure. Giving a simplified example may be clearer. I have a table which has one of it's fields contain a 'code' from 1 to 99. I want the sp to return all...

Hi, I have a mail server running vanilla exim (debian woody). The connection to the outside world is via an ADSL connection. Mail is brought into the server b using fetchmail. Outgoing mail is via our ISP's mail relay (BT). Had forwarding for some users using the standard ".forward&quot...

Hi, I'm looking for recommendations for installing hotfixes for 2000 pro workstations but while a regular user is logged on. Basically, I'm looking after about 60 2000 pro workstations in an NT4 server environment (so no active directory). Also, no SMS server. Rather than run around all 60...

Hi, I'm looking for a method (outlook xp) to automatically create contacts (in a personal folder) from incoming emails. I know that by manually copying a single email from an email folder into a contacts folder will create a contact (with the email body in the notes field) but creating a rule...

Hi, I'm running a network of Windows 2000 workstations on an NT server based network. I'm about to migrate user profiles from one server on the domain - PDC - to another - a BDC. The process I used for some test accounts were as follows. Example account: j.blo profile path...

Hi, I've a 5.5 installation hosting 3 domains. Originally we had one - with an MX record pointing to our mail relay which in turn forwarded it onto the exchange box. Relaying problems were covered by the usual accepted method of setting routing restrictions and the domain itself was set up...

Hi, I have a form with a calendar control - on selecting a date it opens two other forms. One form - "Pledges_Date" - uses a query as a control source, with a filter being passed from the mail form. The second form - "Pledges_Date_New_Rep" - uses the selected date passed...

Hi, I'm looking for some assistence with designing a data entry/modification form. I have a database with a simplified design similar to the following: Two tables: ########################## STAFF: ID Name ########################## ########################## SALE: ID SALE_date...

Hi, I wonder if I can pick a few brains...? I'm writing an access db (form based entry) to capture work against days. For example, a supervisor will pick a day and add work totals for particular memebers of staff. I started writing this as a database where for each staff member record, there...

Hi, Bit of an odd one here... We are running a single subnet network using DHCP to allocate public IP addresses to all machines (except for a few static servers etc). As an aside, we inherited the public IP address installation. Call it 111.111.111.0 (255.255.255.128). This came with an ISP...

Bit of an odd one here.... We are running a single subnet network using DHCP to allocate public IP addresses to all machines (except for a few static servers etc). As an aside, we inherited the public IP address installation. Call it 111.111.111.0 (255.255.255.128). This came with an ISP...

Hi, I'm running 5.5 SAles and Marketing hosted on an MS SQLserver7 backend. I'm trying to import contact data via the import/export wizard and all seems to be going as expected. However, there are some details we store in the contsupp table (subscription details (date, number etc) on a...

Hi, I'm configuring an Exchange 5.5 server for backups with ArcServeIT 6.61's Exchange Agent. I'm really looking for people's views on whether to use bricks level backups or just the information store as a whole? Bricks is great for pulling off individual emails but I would think it'll take a...

Hi, I'm using OpenArgs to pass the selected date from a form with a calendar control to use in the query of the next opened form. I've tested that the parameter has been passed correctly with the debugger. The code in this second form recieving the paramater is: Private Sub Form_Open(Cancel...

Hi, I'm having trouble with controlling the data displayed in a simple subform grid from a calander control in the main form. The subform is a grid simply displaying the contents of a query: name, date and amount. I would like to use a calander control in the main form to filter the grid for...

Hi, Currently, all user profiles are set in the user manager to user directories on the PDC. Similarly, they each have a private 'P:' drive mapped to a share on the PDC. Eg: on the profiles tab: #################################################### User Profile Path...

Hi, I'm planning to replace our PDC - it's getting old and flakey - with a new Dell server. However, I am planning to keep the machine's name so exsting shares, mappings etc can be kept. I'm going to the use the MS recommended method - promote the BDC. Remove the old demoted PDC (let's call it...

Hi, I've a large number of w2k pro workstations running on a domain controlled by an NT4sp6 PDC. I want to get the machines syncing their clocks together, but without a w2k PDC, the w32time service doesn't work. The option that seems best is to use NT4 server's w32time (NTP) and set up the...

Hi, I've a large number of w2k pro workstations running on a domain controlled by an NT4sp6 PDC. I want to get the machines syncing their clocks together, but without a w2k PDC, the w32time service doesn't work. The option that seems best is to use NT4 server's w32time (NTP) and set up the...

Hi, We're looking at migrating parts of the UK and US offices to OpenOffice or StarOffice. Some of the existing office documents we have will not work - specifically excel documents heavy with macros and pivot tables but these power users can keep MS office installations. However, a few of...