Search results for query: *

I am not over familiar with VBA, but recently I was tasked with pulling data from our SQL database into an Excel spreadsheet. I managed this fairly easily, but what I really want to do is to execute a SQL stored procedure, and be able to pass parameters into it. Executing the stored proc works...

I have a VB.Net app which has an embedded COM Adobe Acrobat reader control within it. It works fine on XP, and Win7 32 bit, but falls over with a "Class not registered" error on Win7 x64 Has anyone else encountered this, and knows a workaround?. I was wondering if there was an x64 Adobe Reader...

Hi All I have a windows form with an Adobe 8.0 browser control on it. (Adobe Acrobat 8.0 Browser Control Type Library). Its simple to use, and you can use the loadfile method to open up your pdf. All I want to do is to rotate the PDF clockwise through 90 degrees automatically, after each PDF...

Here is a puzzle that has baffled me for years. In concept it is quite simple, but despite many attempts at coding, I have always failed to reach an optimum solution. Quite simply the puzzle is one of linear nesting, ie the best cut of a series of parts from a list of bars. 2 things are...

This isnt a problem as such, more a desire for a more elegant solution to a problem. I have a Rich Text Box, and Im able to strip the contents and store it in a SQL Table, as an Image Field. This is the code I use to do this.. 'My Class for SQL->.Net Binary Type Translations Dim o As New...

We had a thread a few months back, where someone wanted a clickable Map. Rick came up with a cracking solution for that by using a gradient background image onto which the mouse click was transposed to work out where the click was made. I have always wanted however to figure out how it was...

I have a CR, which is a landscape report. I populate it with data, pass it to a viewer which I dont show to the user, and instead export directly to a PDF file. The output always appears portrait. Does anyone any ideas how I force it to be landscape. The code below is the New Event of my...

Im sure Im missing something obvious here. I worked with Foxpro for many years and the controls had events such as Load and Init, where Load fired before the form was available but Init fired once the form was instantiated. This event was available for every control on the form, if so desired...

Ok...heres the scanario. I have a crystal viewer form, and all my reports are loaded, dataset applied etc and preview displayed. There are 2 ways to print the report. 1) viewer.printreport (shows print dialog box) 2) report.PrintToPrinter(1, True, 0, 0) (goes direct to printer) Now..here is my...

Having seen many questions about the datagrid, especially relating to column styles. After all every grid you design realistically needs some design touches adding and the MS Datagrid is not the easiest control in the world to work with on this front. Because of this, and partly as an exercise...

I have noticed that a Datacombo dropdown event occurs before any keydown/press, mouse down/up and click events. How then do you determine whether a user has pressed ENTER in the combo, or mouse clicked the drop down part of the combo. So far I have made all of my combos mainly keyboard...

Im looking to implemement a PDF viewer in my .NET app. What 3rd party control if any, can anyone reccommend. I only want to view the PDF, I dont want to mark it up or amend it, but I would like some programmatic control over which page is to be currently viewed. I dont need to create the PDF, I...

Simple question I hope, with a simple answer. Im using V6, just as its the only version of VFP I have. Whereas in V7 and upwards you can do the following *--Crystal Reports Export Options LOCAL oExp as CRAXDRT.ExportOptions Could anyone tell me what is the equivalent code in V6.0? I know it...

I have a Fox Imagelist, and I have lost the original icons. How do I get them out and save them back as Icons or Bitmaps. I am certain I did this before using .NET, but my mind is at a complete blank as to how I did it. Any pointers greatly appreciated Sweep ...if it works dont mess with it

I have a standard form with a CR9 viewer on it, docked to fill the form. All works well, report loads and displays, now all I want to do is to press the ENTER key, and for the report to print (I also want to trap other key events too!). However none of the viewers key press events seem to fire...

This is a hopeful punt, that someone out there also uses C1 Grids, and can offer me a little help I understand how the SelectedRows collection works, and I have my grid working with Windows shift,ctrl click type functionality, and I can get back the selected rows as a datarow collection quite...

How is it possible to switch between paper sizes. Im trying to programatically select the paper size from a printer which has A3 and A4 sizes in I know its something to do with the System.Drawing.Printers namespace, but Im struggling to figure out how it all fits together. It has been a long...

Im either missing the plot, or missing something obvious Im sure of it. I have a form named frmViewer, which is simply a form with a Crystal Viewer on it, and a few other controls. What I want to do is to pass the report to my viewer. This I can do as follows Dim orep As New CrystalReport1...

I have a very simple fox app, which is used to generate bar codes. It consists of one form only. The form has ShowWindow set to 2 (Top Level Form). When the exit button is clicked the application closes ok, but quite often leaves itself in the Task List. It also uses an ActiveX control for the...

Hi all.. I have a delete command button in a datagrid. I can successfully bind the delete button to the "onclick" event, but would like to use a VBScript confirmation in the form of a MessageBox - Ok to Delete Yes/No. I can use the Javascript confirm command successfully, but am unsure if...