Search results for query: *

Hi, I have a SQL Server 2000 database with my hosters, and I've set up a SQL server registration in Enterprise manager under a group. When I access this registration, I can log into my database remotely cos the profile on Enterprise Manager holds my username and password. So far so good. But...

Hi, I'm bring back some username records and I want to order them alphabetically but I always want the record containing the word "General" to come last. In Oracle it's easy: SELECT...FROM...WHERE... ORDER BY DECODE(my_field,"General","ZZZZZ",my_field) Does...

I'm using DW to create a page comprised of * A header table, right across the page * 3 columns of content below this * A footer, right across the page The columns are not the same length - i.e. don't contain the same amount of text, so under one or two of them there will be white space. Which...

A customer has requested that he wants the facility on his website to download report outputs into Excel format on his local machine (as well as viewing reports on screen of course). I have no real idea how to do this, or even if it can be done. I'm using SQL Server 2000 via an ASP.NET...

I'm trying to update a field from a form using parameters but it will not accept single quotes. It just cuts off the text, so "Bill's Record" would just be updated as "Bill". The solution on all the web pages I've seen, i.e. replacing the single quotes with two single quotes...

I'm new to ASP.NET and I am so hating it. :| Is it true that you can't use HTML forms any more in an ASP.NET page? All I want is a simple search box that resubmits to the page by way of a button (which calls some javascript). First off, I tried to include an HTML form but nested forms aren't...

Hi, A bit of advice, if possible... Not having IIS (I have XP Home which I don't want to upgrade to PRO) I was considering creating a dev environment consisting of SQL*Server and ASP.NET through Cassini web server (ASP.NET only). I wondered if anyone had any views on this, along the lines of...

Hi, I've search high and low for the answer to this, but... All I want is the final report footer to print at the bottom of the final page. The unchangeable (?) default seems to be just to print wherever the report ends? Is there a way of doing this? I hope so, I give a demo of the...

I was going to give it a rest with the questions, but this problem really bites the bag. I have a simple form on which is a button. Press the button and it loads a value into one of the fields using a VB sub. Which is great, except it uses INVISIBLE text. It looks like it hasn't worked, but...

Having a bad day today. I have a form button that does "create form filter". I created a button then to "apply form filter", which is available from the button "wizard". But seeing as choosing "create form filter" disables all buttons, how can I use the...

Hi, I have a simple form that contains a sub-form. I have a button "delete" that will reference a VB sub, which will perform checks and then, if appropriate, delete the relevant record, be it from the main form or the subform. The "delete" sub needs therefore to know...

Hi, never having used Access before I've possibly unwisely agreed to write an Access 2000 invoice system for a customer within 2 weeks! :o All's going OK, except one thing - if I attempt to enter a record that contains erroneous data, the database rules force an error message (as expected). But...