Search results for query: *

Seen a lot of threads on this but have figured out the cause of my problem, just not sure how to resolve it! A single Windows 2000 server is able to browse the network fine..... until someone dials into it's local RAS server. The remote machine has no problems when remoting. After this happens...

I have an ASP.NET app on a test server. On a page I have a datagrid with a column of values formatted to {0:c}. The figures in this column look like £xx.xx as expected (pound sign as I'm in the UK). However when I run the same pages on my Live server the values are formatted with a $ sign...

I have 3 SQL tables. "Documents", "Departments" and a link tables to provide a one to many relationship (A single document can be viewed by many departments). I have made a form that allows the addition of Documents whilst selecting the relevant department(s). For the administrator I'd like to...

I have a table with the following fields; TranID, Date, Type, Account, Amount. I pull a list of Accounts (Companies) with: SELECT Distinct Account FROM Table I've also got a Stored procedure: CREATE PROCEDURE Procedure @supplier varchar(3), @type varchar(2), @datefrom varchar(8), @dateto...

I have a simple select statement: SELECT Date, Time, Order, Part, Price FROM Mytable ORDER BY Date DESC, Time DESC The table contains deliveries made to our stores. This may return rows with the same part number for different dates and times. I only wish to return the latest transaction for...

I currently havea hotkey set up i an excel document, the contents of which is: Dim retval retval = Shell("c:\program files\adobe\acrobat 4.0\reader\acrord32 \\server\orders\" + ActiveSheet.Range(ActiveWindow.RangeSelection.Address) + ".pdf", vbNormalFocus) This works fine...

Incoming mail works fine to my main exchange server. For a reason i won't go into I have several people's mailboxes on another exchange server. They are able to send emails fine, but not recieve. I assume I need to do something to tell the main exchange server to forward mail to the other if...

All, i wish to limit internal mail (prevent local idiots from sending 4MB movies to each other) BUT allow decent size emails to be sent externally. I've tried and tried but don't think there is a way to accomplish this. Can anyone confirm this, or have any ideas as to how it could be...

I'm using a security system from RSA called secureid. To support windows 98 clients the server must use post dial terminal based authenticaton. The other method available (EAP client) works fine on the same server with Windows XP VPN clients dialing in. I don't think that Windows XP clients...

I know how to make connections to databases, but how to I get a connection to the current DB? Essentially I want to run a query from the press of a button, then do some other stuff (mail something to email address that come out of the query). Any help/ code snips much appreciated!

I have a simple Access MDB that is only ever administered by one person. Other users have the data appear via the local intranet using ASP.NET. Although this works fine, whenever a user views the web page, the server creates a lockfile in the same location as the MDB. This seems to stay there...

When I use explorer to open a folder it takes ages to show the contents. If, however I click on a menu (tools for example) it all kicks into life and displays the folder and file list immeadiately. A similar problem exists whilst browsing internet sites, the page won't appear until I click a...

I have an FTP server running in IIS 5. I have virtual folders pointing to local folders on the server, they work fine. I want to be able to provide access to a single file in another folder and show it as being in the root on the FTP, but I don't want the user to see the entire contents of...

Is there any way to edit the format of a datetime field to produce an output similar to my formula below: totext(datepart("ww",{SHIPLINES.SHPMT_DATE})) + "/" + totext(datepart("yyyy", {SHIPLINES.SHPMT_DATE})) I'm unable to use this field in selection criteria or...

I used to have a document detailing what asp pages to amend to do this. Essentially I need the user to click on the project and immeadiately display the task summary, as oppose to prompting the user to select a view. My ASP is very limited indeed so if anyone still has the document I'd love to...

I have a single page report working fine, showing a single item and it's details of an order. I want crystal to produce a separate page for each item depending on the quantity required of that item. Each page will be the same except for the serial number, which I wish to be something like...