Recent content by Jusenkyo

I wanted this to be an automated process really. Dont want the user to link to the SQL server themselves.

Hello all I have a query that I want to export to an existing excel spreadsheet. The spreadsheet is all formatted and coloured up, and I just want to put in the numbers from this query. I cant do this with docmd.OutputTo - as it only allows you to create a new spreadsheet or overwrite an...

Excellent, thanks hwkranger! Ill take a look at this and let you know if I need more help!

Hello all I have 4 stored procedures that each require a multitude on input parameters. I am feeding these in through a form in VB as follows: cmd.CommandText = "sp1" cmd.CommandType = adCmdStoredProc Set prmNTAddedBy = cmd.CreateParameter("NTAddedBy", adVarChar, adParamInput, 50, Me.Name)...

I have the .NET framework 1.1 installed. And the internet information services thing in administrative tools appears to be running. Is that what you mean?

Hello all About a year ago, I made a few simple ASP.NET pages in dreamweaver to view, edit and delete records from a SQL server database. Im trying to get back into it now, and thought id take a look at the pages again. Ive opened them in DW MX, pressed F12, explorer opens, but it just shows...

It does doesnt it! I wanted to run this code in VB, so the less code the better really... What does (ID MOD 2) do?

Remou - Is this code for 2 seperate queries here? What is recno?

Hello all I want to run a SQL update statement in VB that will loop and update a column in a table with first 1, then 0, then 1, etc... So the table will have: ID Loop 1----1 2----0 3----1 4----0 5----1 Hope that makes sense! Cheers J

Its all good, Gol4's idea worked. Cheers anyways!

Good idea Gol4! Cheers. And TheAceMan1, This is not a problem that can be sorted. The duplicated data arises from our legacy systems that allow contracts to go through various stages of registration in the same table, so I am viewing a complete history of some contracts. Therefore duplicates...

Hello all I have a form with a list of contracts populated by a function. What I want to do is to use conditional formatting (the database is an ADP), to highlight any duplicated contract numbers. Anyone got any idea if this can be done? Cheers J

Hello all In ASP you can display continuous data on a form with alternating colours for the rows... so the first maybe red, then blue, then red, etc... Anyone know of a way to do this in an ADP? Cheers J

Hello all I have a stored procedure which requires an input perameter, Contract_No. I want to run this from VB, and pass in a number from a form. I know how to do this in a normal access query, but the stored procedures dont seem to allow where clauses to input perameters. Any ideas? Cheers J

Hmmm. Im not sure that would be the most efficient way of doing things, as there could be a large number of reports that need to be sent, so i would imagine saving them and sending them would take a long long time! My idea was, in VB, to grab the list of data that is going onto the report into...