Search results for query: *

Okay, I admit in advance I am well out of practice. But this is driving me mad. I want to check for a valid date on my webform. It can be US or UK/European formats so I'm adding .CultureInvariantValues = True. But whatever gibberish I type in the textbox is accepted as valid. What on earth...

I know the basic question has been asked many times but I think not quite from this perspective. I have always used a decent mishmash of the tools I know. A bit of Dreamweaver for the ability to preview my CSS and HTML. ASP.NET C# SQL where necessary - tested in the Visual Studio environment...

There must be a freeware plugin out there. But if not. Anyone devloped a work timer for MS Word? Open a doc, prompt to start clock and for which account. I am not going PCLaw on this! Any suggestions welcome.

Hi all how can I connect one router to another? No hub, switch or cabling is going to do this job. My original thread outlines the situation. http://www.tek-tips.com/viewthread.cfm?qid=1532000&page=1 Okay, I have a limited choice of wifi access for my dessktop. 1. A Prolink Wn 2100 Usb...

Hi all. First off I'm in Cambodia. I am limited to the choices of hardware available to me. But yes I can get my hands on the basic brands of wireless cards. Here's the situation. I am using a a desktop. I have a near direct line of sight to a friend's wireless router some 120 metres away...

Hi, If I add a new form to a project- no problems: My.Forms...will list all the forms available BUT If I add an existing form (you know rght clck add etc) to a project the form is not visible in the My.Forms collection Now I reckon there's an assembly reference somewhere but I really am...

Hi Guy's, How do I insert generated values as a set and using not using a loop or cursor? THere was a work around in 2000 but I've been out of the loop for a while and now I'm catching up on 2005 and can't seem to get it working. Let me illustrate. I select a name from a table and insert it...

I am trying to trap an conversion error arising from running the following update against 'myField' which is a decimal. However, rather than continue into my trap the transaction breaks and returns the standard error message Server: Msg 8114, Level 16, State 5, Line 1 Error...

Lo there I'm trying to utilise a global variable via a dynamic property butI'm not sure where it sits in the workflow. i.e. I have an Excel connection > Transformation > DbConnetion_Destination This is exactly what you would expect from a DTS package saved from the wizard But, How do I...

Hi How do I go about converting a US date in a CSV into a UK date on DTS into SQL Server? I've had a play with transformations but it doesn't seem to like them in the slightest Should I go with my instinct and "massage" the dates initially as varchar in an intermidiary table first?

I'm trying, successfully in most cases, to extract data from systems dependent on a system DSN. Oddly if I use a simple query file and run this through excel I have no problems at all. However, when wrapping the query into an application using the following very innocuous code I often have a...

When I run .NET Setup on my new machine it kicks of ATI catalyst install in Spanish!?! Now I know Catalyst relies on the framework but I've found nothing on this particular problem Ok I've got to clear either a Reg or some sort of MSI entry but Where and How? Can this be a unique post? I'd...

Hi I'm having to pull tables out of an Access db. I'm using late binding because it has to work across multiple versions. Early binding everything is happy However, when I use late binding the statement apAccess.DoCmd.TransferText acExportDelim, , "exp", "C:\myfile.txt", True Throws error...

I'm in the bind that every search I have to do is embedded within a string. Therefore I cannot use 'IN' against a subquery list of values. For example my target field contains the equivalent of: 'Slow Blue car with red trim' My table of search values contain 'Red' 'Blue' 'Green' as long as...

..and no matter how hard I search I can't find out if it is a bug or if I have to add it. Help Please Thanx

How do I stop returning multiple resultsets? I need to use selects to populate some parameters Select @Brand = brand from BTable -- Don't return this and then I want to return the single resultset Select Name from NameTable Where name = @Brand -- Just return this Cheers Folks

How do I pull out a value for the required - NOT selected Item in a listbox - I'm actually trying to pull out all the unchechecked Items and use their ValueMember values. There has to be a nicer method than this: MyListbox.SetSelected(indexValue, True) Debug.WriteLine(MyListbox.SelectedValue)...

Below is the bare bones of the Sproc I'm working with. Not only is there some nasty string parsing in there but the declared parameters are not helping the speed side of things either. Can this be split in two? Say a UDF or calling Sproc that will pass the name, strength and pack parameters to...

A quick 'opinions' question. Returning between 2 and 50 records from a dataset to a SQL table. What is the prefered methodolgy: a for...each loop repeatedly calling a stored procedure and passing a record at a time or utilise some of the bulk insert methods. Like to know your opinions guys.

If you've had to do this you will know exactly what I'm talking about! If anybody has experience of parsing the mess that are free entered preparation-form-dose strings or has developed solid methodolgies or (fingers crossed) some sort of tool I would really appreciate any insights that you may...