Search results for query: *

Oh, right. I'll give that a try then. Thanks for your help. Stephen.

I had actually tried that, but it kept giving me undesirable results (i.e. 900 / 1000 = 0.9, when I need 0). I think I may have found what I am after though. One of my colleagues just pointed out the '0,' format string that can be applied in the ToString method of a numeric Type. I'll see how...

Hi all. Can anyone tell me how, using VB.NET, to format an SQL Server Money datatype to display the value in 1000s? So that 678900 would be 679 and 98 would be 0 etc. Thank you. Stephen.

Hi all. When I am debugging an application that has quite a long running process (i.e. a large data extract process), and I stop debugging the application before the process is finished, the process keeps on running, despite me having ended the debugging session. The only way I can stop this...

The type for the problematic fields is nvarchar. I would have imagined that this would be the same in the DataSet which is filled from an Sql DataAdapter.

I didn't realise that I'd have to manually alter the text Encoding, but I have a feeling that it is probably the latter as the characters show up just fine in the VS.NET debugger, but not in the text document. I've just had a flick through the MSDN docs and have found the Encoding Class. Is this...

Thank you for your help. It is very much appreciated. I did check the users guide and it contains a little too much information to read right through it, and I couldn't locate the desired information by index or search, so I thought I'd look elsewhere for a point in the right direction. The...

Hi all. I am extracting information from an MSSQL DB and using VB to manipulate it and output it to text. The problem is that what should appear as 'Gebrüder' is output as 'Gebr?der'. Any ideas on what could cause this? Thanks. Stephen.

Hi all. I am new to Crystal Reports (we have purchased CR XI Developer) and have been asked to produce a PDF document that firstly contains a cover page detailing the contents of the PDF document, then follows a heavily formatted directory style report that is split into 2 columns (information...

Good thinking. I'll give that a go.

OK. I'll take a look into that. The only concern I have is that I can not predict how long the number will be. I imagine that there will be a way to account for this in the format string though. I'll let you know how I get on.

Is there any way that you know of that would allow me to apply that to the physical field? I have tried entering "@@@" to the format for a field of length 3, but Access still trims the data as I enter it.

Hi all. If I have a telephone number like '01623...', how can I efficiently format it to look like '(01) 623...'? I would like to this to be simple and quick, so I would like to avoid hacking the string up with Substring etc, if possible. Thank you in advance. Stephen.

That would achieve the same end result, but I would like to be able to enter the entire string (including the trailing whitespace) in the database without Access trimming off the end white space chars.

Hi all. I would like to store a single whitespace at the end of a value in Access so that when I fetch it using VB, I get something like 'value '. How can I achieve this? Thank you in advance. Stephen.

It was the static IP in the end. We set these up on the problematic machines and restarted everything and it all seems to work fine. Thanks for your help. Stephen.

Yeah, all of the settings appear to be ok. Localhost also responds correctly when run locally. However, we have just looked into problems with the IP/DNS and have found that those with static IPs are able to respond to HTTP requests just fine over the network, so we will look further into that...

Hi all. We have recently installed a Windows 2003 Server as a domain controller (we have moved from a work group) and have found that we are no longer able to access eachothers development machines via HTTP (We can get to them accross the network though). Previously, for testing purposes, we...

OK. I could really do with some help here as now I've found that the dataset won't even fill. If I have just a basic Table which I drag onto the DataSet schema designer from the server explorer and then try to fill the dataset from the same table, it won't fill. the dataAdapter.Fill method...

Hi all. I have the following DataSet: <xs:element name="Structure" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="INF_COMP"> <xs:complexType> <xs:sequence> <xs:element name="PK" type="xs:int" /> <xs:element...