Search results for query: *

Hi All. I'm pretty new to cursors...in fact I'm a newbie with them. I think I need to run a cursor for the following exercise. If now please advise, otherwise, could some clever person build one for me? I have a table with rows of data, where one column is identified as "AddOmitFlag". If the...

Does anyone know how to do this? I have an access report, with two specific groups (Possession & Resourcetype). For each group footer, I have a total value which is all good and well. In the PAGE FOOTER section though, the user has asked me to display all the running totals together for each...

Hi All I have a report with a column returning values 0 & 1 (Where a task is complete or not). I have set an expression to return "NO" or "YES" accordingly. Now, in my report footer I would like a field that only counts the number of 1's. If my report shows 6 columns and only 2 have a "1"...

Hi All I have a Stored Procedure sourcing an SQL 2000 database. The SQL Query analyser runs the SP fine (including any parameters I pass in). the paramters are: @Year INT, @Period INT, @GroupOG VarChar(50) @Analyser VarChar(25) Now, when I bind my Crystal Report (v 9.0) to this stored...

Access version 97 Crystal Version 9 What I have is an Access database that generates a report for a procurement order. What is needed is for an email to be generated (that bit is working fine) and for the procurement report to be attached as a PDF file to the email. Now, I have the report both...

Hi All I have the following code calling a recordset from an SQL DB. I'm getting an error telling me the Object Variable is not set...and it's late...and my head is spinning [sadeyes] Can anyone check my code and see what I'm missing on my oRS! Set conn = New ADODB.Connection strConnect =...

Can anyone tell me the difference between Report_Activate & Report_Open? Thanks Tudor birklea ~©¿©~ <>< Dim objJedi as Jedi.Knight Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

Hi All, I have the Crystal Viewer object in a VB project (crviewer9.dll) When a user launches a Crystal Report, the report is "fixed" to a specific printer. I've looked at the properties of the object but can't find where to include the facility to setup a printer in the Veiwer so the user can...

Yikes...I'm having problems! I have a Listview (listview1) on a form. I have a command button which when clicked will loop through the ocontents of the listview, and write each line in turn to a text file. My issue is that I enter my FOR LOOP fine, but I can't seem to make the loop jump to the...

Hi Folks I've written myself a Web Browser with status bar which has three panels does anyone know how I can insert a progress bar in one of the panels which will load and display the progress of a website as it loads? Also, does anyone have a clue how I can change the text in panel("Status")...

Hi, I have an ASP page linked to an SQLServer 2000 DB On my page are two drop down boxes: Company & Site. At the moment I'm using ADO to populate each DropDwon from a recordset. What I want is to dynamically change DropDown No 2 to show only the sites relating to the selected Company in...

Hi Folks Using CR 8.5, I've created 8 reports which link to an SQL DB. Teh users are running a Web applicaiotn I have developed. What I would like to do is distribute the reports via the web so that the users can just click a link on the web site, and run the report (including parameter prompt...

Hi Folks Does anyone have any javascript that I can use in my ASP page? Basically if I enter a value "1000000" or "-1000000", I have a Javascript update function which determines if the number is positive or negative and returns either 1000000 or (1000000) Now what I want to do is insert the...

Hi All I have created two list boxes. From code found on the internet, I have manage to manipulate the values in List1 and transfer the selected values into List2. What I need to do now is run a report based on the the captured values in List2...and that's why I need some assistance. How do I...

Hi Folks How do I refresh a DropDown box on an ASP page? I have three <SELECT> drop downs: <COMPANY> <SITE> <TRADING OUTLET> At the moment, each <SELECT> is populated form a recordset e.g. "SELECT * FROM tblCompany ORDER BY CompanyName" The tables are linked i.e. tblSite contains the FK...

Right, firstly I have a field in my SQL Server2000 table called "Commit" Now I want to retrieve all the record sin the tabel and display them in a TABLE on an ASP form. For each rst value in the row, is a column for the "Commit" value (currently varChar storing "Yes" or "No" - but let me know...

Hi I am creating a page to allow "Edit Details" When the page opens, I retrieve the record details from the table...one of which is an ID reference called SiteID When the page loads, it displays the Site Details in a <SELECT> combo box (There are 6 sites to choose from) Everything is working...

I have an ASP page with several input text boxes (Typically holding numerical values) At the end of the form I have two SUBMIT buttons: <form method="POST" action="AddPhasedBudget.asp" name="form1"> Blah Blah Blah <INPUT FILES HERE> <input name="save" type="submit" value="Save Record">...

Hi Folks I have a page which the user enters sales figures in INPUT boxes on a form. When he's completed all the enteries, he clicks a button called "SAVE RECORD" and the entries are written to the database. My issue is that when the user clicks <RETURN> or <ENTER> on the keyboard, the "SAVE...

Yikes! In my AccessDB, I am interrogating an Oracle Database to retrieve data into a dump table. Set dbFC = New ADODB.Connection dbFC.Provider = "MSDAORA" dbFC.Open "MyServer", "MyUser", "MyPassword" I've removed the actual specifcs to protect the innocent ::-) Now, when I quite the DB, I...