One more quick question if you don't mind? As I only have to input 2 charactors is there a way to format the column to automatically jump to the next cell as soon as i input the 2nd charactor?? That would save time and as i'm doing readouts and inputs I wont forget to hit tab/return. "Dave" wrote: You're welcome. Thanks for the feedback. Dave.

... managed code for CPU-intensive functions and procedures that feature complex ....Server.SqlUserDefinedAggregate( Microsoft.SqlServer.Server.Format.UserDefined, //use clr serialization to ... version of the aggregate product function in SQL. You will need ... have the logarithm and exponential functions. They are not standards, but...your situation is with a quick test on the sign() of...

... Application.ActivePrinter = str End Sub Function GetFullNetworkPrinterName(strNetworkPrinterName As String) As ... 100 strTempPrinterName = strNetworkPrinterName & " on Ne" & Format(i, "00") & ":" On Error Resume ... to the original printer End Function -- Regards Ron de Bruin http... multiple print icons on the Quick Acces toolbar, each pointing to...

..." wrote: Hi, Thanks for the quick reply, thats exactly what I needed ... do the conversion using the Ucase function: Field Name: [SomeTextField] Update To: ... do by just entering '>' into the format of each field in the ...my tables that I export as quickly and easily as possible. The import...> exported text file retains the formatting and doesnt return to mixed case...

Hi, Thanks for the quick reply, thats exactly what I needed and since...to do the conversion using the Ucase function: Field Name: [SomeTextField] Update To: UCase([... do by just entering '>' into the format of each field in the ...in my tables that I export as quickly and easily as possible. The import ...> exported text file retains the formatting and doesnt return to mixed case....

... the conversion using the Ucase function: Field Name: [SomeTextField] Update To...by just entering '>' into the format of each field in the...what is the point of having formatting if it isnt really...formatting the data but the way it is displayed? Anyway, I...tables that I export as quickly and easily as possible. The...exported text file retains the formatting and doesnt return to mixed...

...data and manipulate/query it quickly. Usually only one person is...a need/want for this functionality again. We can show you...you want SQL Server to format it for you. But only...t appear to be a "Format" function in Transact-SQL (like...XL), so that I can format my numbers any way I...do you need to apply formatting to numbers inside the database...

...store data and manipulate/query it quickly. Usually only one person is in... a need/want for this functionality again. We can show you how... you want SQL Server to format it for you. But only ...'t appear to be a "Format" function in Transact-SQL (like ... do you need to apply formatting to numbers inside the database?... you want SQL Server to format it for you. But only ...

... and advice; making recommendations when out-of-the-box functionality can be used to minimize the customization and coding to ..., XML technologies for integration purposes. - Must be able to quickly understand the overall business strategy, to analyze the business .... - Must have an excellent understanding of the various data formats and data transformation processes and procedures. Experience: - ...

... and advice; making recommendations when out-of-the-box functionality can be used to minimize the customization and coding to ..., XML technologies for integration purposes. - Must be able to quickly understand the overall business strategy, to analyze the business .... - Must have an excellent understanding of the various data formats and data transformation processes and procedures. Experience: - ...