Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wickerman

    How to play a song?

    http://www.codeproject.com/cs/media/soundplayer.asp IMLTHO, the WMP9 API sucks... Last I checked, there was no native .NET/managed API; you have to make do with the auto-generated AxInterop wrapper. Also, WMP9 has become so web-centric (and, consequently, state-free) as to make it relatively...
  2. wickerman

    # stored procedure with return value

    Maybe you need to set the direction of your parameters before you execute the sproc. In this Windows Form example, Form1 contains button1, textBox1, sqlConnection1, and sqlCommand1. The sproc used in this example is really basic: create procedure dbo.nw_CountProductsInACategory(...
  3. wickerman

    Opening an MDI child in the parent window

    It's pretty easy... In this instance, a menu creates a new instance of formMDIChild as myChildForm. Standard disclaimers apply... ;-) private void menuOpenChild_Click(object sender, System.EventArgs e) { //declare and instantiate myChildForm as a new //instance of...
  4. wickerman

    Can't select an Access 97 query that uses a VBA expression

    I'm trying to build a CR 8.5 report using the Report Wizard; my data source is an Access 97 MDB; the "table" I'm trying to select is a query that uses a VBA expression to generate one of my output fields. The expression works as follows: I have parent records that I'm reporting on...
  5. wickerman

    Assign ADO-recordset to form's RecordSource

    At first I thought that Francescina's post looked pretty promising, except for one thing: there is no "Name" property for an ADO recordset... I'm trying to create an unbound report (Acc97) which will point to an ADO recordset for it's RecordSource; I'm doing this because it is...
  6. wickerman

    Using Month text vs. Month number

    How many rows do you have in your crosstab? If you haven't exceeded your maximum already, you could add an expression for a Row Heading which results in a numeric value.<br><br>Assuming table name is tblMyTable, field is named MyDate, and MyDate's format is a valid Date/Time format; insert a...
  7. wickerman

    ActiveX component can't create object. (Access Wizards)

    Here's another MS Knowledge Base site to check out; it's a full checklist of things to troubleshoot when this error comes up...&nbsp;&nbsp;The entire article covers problems with OLE automation, which sounds more like the issue <b>nufather</b> is having rather than the DCOM issues which raise...
  8. wickerman

    charts in reports

    Have you set the RowSource property properly? Under your <br>&quot;Data&quot; properties, here are the values I've got in a report<br>which uses an MS Graph object (I've omitted properties w/o <br>settings):<br><br><FONT FACE=monospace><br>OLE...

Part and Inventory Search

Back
Top