Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 115
Search took 0.01 seconds.
Search: Posts Made By: seananderson
Forum: SQL Server 2000 December 3rd, 2007, 05:34 AM
Replies: 0
Views: 551
Posted By seananderson
UPDATE from another table?

Could someone give a simple query example for updating one table from another.

The following is the query that's come from Access version of our database. As you should be able to tell, the...
Forum: SQL Server 2000 November 30th, 2007, 07:31 AM
Replies: 5
Views: 3,680
Posted By seananderson
I tried your workaround and got the following ...

I tried your workaround and got the following

Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries'...
Forum: Access November 30th, 2007, 05:32 AM
Replies: 0
Views: 1,016
Posted By seananderson
Replication with SQL2005

I have a database which houses management information, including the business contacts and appointments diary ... a number of our people regularly work offline and would be interested in knowing how...
Forum: SQL Server 2005 November 29th, 2007, 10:48 AM
Replies: 1
Views: 793
Posted By seananderson
Could you not just create it as a stored...

Could you not just create it as a stored procedure?

CREATE PROCEDURE CORRINEO_QUERY @CM1 VARCHAR(255) AS
... then your query, but replace CM1 with @CM1

How about storing you 54 questions in a...
Forum: SQL Server 2005 November 29th, 2007, 10:17 AM
Replies: 2
Views: 586
Posted By seananderson
Replication to/from Access

Does anyone know hot to replicate SQL 2005 with MS Access?
Forum: Access October 3rd, 2007, 06:35 AM
Replies: 1
Views: 1,879
Posted By seananderson
SELECT from SELECT query?

I have a lot of queries which are along the lines of

SELECT * FROM CUSTOMER WHERE ...

We've added a limitation to the CUSTOMER table (and renamed it to CUSTOMER_MASTER) and now need to do a...
Forum: Pro VB 6 October 2nd, 2007, 03:28 AM
Replies: 3
Views: 881
Posted By seananderson
It does make sense, indeed. Hadn't realised that...

It does make sense, indeed. Hadn't realised that the resource file needed compiling.

No matter which way it gets done, it's gonna be a ball ache - there's literally hundreds of them.

Regards,
...
Forum: VB Components September 28th, 2007, 05:22 AM
Replies: 2
Views: 7,328
Posted By seananderson
I did this in Javascript for a webpage, but I am...

I did this in Javascript for a webpage, but I am sure that you could adapt it fairly easily into VB.


var oOutlook = new ActiveXObject("Outlook.Application");
var oNameSpace =...
Forum: Access September 14th, 2007, 03:27 AM
Replies: 1
Views: 3,850
Posted By seananderson
Network Interruption Error

On a PC woth Vista, where we have an Access 2003 MDE connecting to an MDB located on a server, we're getting the following error:

Your network access was interrupted. To continue, close the...
Forum: SQL Server 2005 September 4th, 2007, 03:29 AM
Replies: 2
Views: 687
Posted By seananderson
I quite agree, but I develop commercial software...

I quite agree, but I develop commercial software and much as I would like, the customers aren't always willing/able (and it well out of my control) to keep up to date with the latest versions of the...
Forum: SQL Server 2005 September 3rd, 2007, 04:39 AM
Replies: 2
Views: 687
Posted By seananderson
Exporting Structure

We're having some fun and games when trying to convert between SQL server versions. Working with both 2000 and 2005 we need to switch data from one version to another ... and back.

We've tried to...
Forum: VB Components August 17th, 2007, 10:46 AM
Replies: 0
Views: 1,337
Posted By seananderson
Load and display ActiveX

I have a set of ActiveX controls, each of which have one user control. The details of the files will be held in a (configurable) text file ... would appreciate details of how my form can read from...
Forum: Pro VB 6 August 17th, 2007, 05:58 AM
Replies: 3
Views: 881
Posted By seananderson
Customised Labels & Text (poss Language?)

I would like to add the functionality where a client can customise the wording that's used on my forms, to encompass differences in terminology.

For example; you would refer to pages in a book as...
Forum: SQL Language August 13th, 2007, 05:19 AM
Replies: 2
Views: 1,182
Posted By seananderson
I couldn't see a proper way of masking the data. ...

I couldn't see a proper way of masking the data.

Have a play with something like this...



CREATE FUNCTION fn_ADD_THOUSAND_SEPARATOR (@input_value NUMERIC) RETURNS VARCHAR(75) AS

BEGIN
Forum: SQL Language August 13th, 2007, 04:50 AM
Replies: 0
Views: 1,091
Posted By seananderson
A really good report writer....?

I am looking to find a really good, user-friendly report writing application to link into an SQL relational database, for my clients to use. They have a series of reports that are provided within my...
Forum: VB.NET 2002/2003 Basics August 13th, 2007, 04:46 AM
Replies: 0
Views: 934
Posted By seananderson
Charting ActiveX Control

Can anyone recommend a good quality charting control?

It needs to be easy to use (programatically) and produce a high quality output ... the kind of result that is similar to what the CEO would...
Forum: Reporting Services August 3rd, 2007, 07:45 AM
Replies: 0
Views: 962
Posted By seananderson
Getting Started?

Could someone point me in the right direction of a website that has a decent (beginners guide) to getting started with this?

I'll worry about more complex matters later, just need the basic...
Forum: SQL Server 2000 August 3rd, 2007, 07:43 AM
Replies: 1
Views: 608
Posted By seananderson
Statistics?

Does anyone know how we can obtain usage statictics from SQL?

We have a client who would like to see some performance statistics which include stuff like number of updates and frequency of use....
Forum: Classic ASP Basics July 19th, 2007, 08:04 AM
Replies: 3
Views: 1,331
Posted By seananderson
The commented line of code in the global.asa is a...

The commented line of code in the global.asa is a little misleading then (Runs when a user's session times out or quits your application) as it implies it will run.

I guess that I will have to...
Forum: Classic ASP Basics July 19th, 2007, 06:40 AM
Replies: 3
Views: 1,331
Posted By seananderson
Session_OnEnd Question....

I have added a simple stored procedure into the Session_OnEnd of my global.asa ... which doesn't seem to be run when the webpage is closed.

I have run the SQL Profiler and the query isn't being...
Forum: Windows Server July 19th, 2007, 05:29 AM
Replies: 4
Views: 1,765
Posted By seananderson
That implies that I would be better off...

That implies that I would be better off following:

-- Set up a new PC with Windows 2003 server as a domain controller
-- Creating everyone's accounts on that
-- Switch desktop PC's to the new...
Forum: Windows Server July 17th, 2007, 06:11 AM
Replies: 4
Views: 1,765
Posted By seananderson
Creating a Domain

Our present network system is a simple 'Workgroup' environment (15-20 workstation PC's and a Windows 2003 Server) and we're looking to switch to a proper domain environment.

Can we alter the...
Forum: SQL Server 2005 July 13th, 2007, 08:39 AM
Replies: 2
Views: 1,102
Posted By seananderson
Update to add identity & primary key

I have a load of tables with an ID column that needs to be updated to an identity and primary key. Reading around, the following suggestion doesn't seem to work. Could someone advise...

ALTER...
Forum: SQL Server 2000 June 28th, 2007, 05:48 AM
Replies: 1
Views: 773
Posted By seananderson
Adding an Order to Table

Is there a way to get the record number as part of a SQL query?


SELECT * FROM EMPLOYEE ORDER BY SURNAME

RECNO FORENAME SURNAME
----- -------- --------
1 John Smith
2 ...
Forum: ASP.NET 1.0 and 1.1 Basics June 19th, 2007, 09:10 AM
Replies: 2
Views: 953
Posted By seananderson
... I am getting the same problem when executing...

... I am getting the same problem when executing a simple update query from Access VBA and am also struggling to locate the solution. In my code, the query is executed direct (and not parameterized)....
Showing results 1 to 25 of 115

 


All times are GMT -4. The time now is 08:15 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.