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 TouchToneTommy 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. EricDraven

    EXCEL: Vlookup on Calender Linked Cell

    Hi all I have a spreadsheet with a Calender object which returns a selected date via the linked cell property. I then need to use this selected date to perform a vlookup on a second spreadsheet. I know the vlookup code is correct as when I manually type the date into the linked cell, the lookup...
  2. EricDraven

    Convert quick report to pdf

    I know of one from Gnostice which does the job particularly well. http://www.gnostice.com/QuickReportExport.asp "Now you see that evil will always triumph, because good is dumb" - Dark Helmet
  3. EricDraven

    QuickReports - Missing Something?

    Theres very little actual code involved, the power of QuickReports comes from the components themselves and the report layout. You only really need a few lines of code to open your dataset and then to call the quickreport. Depending on which version of Delphi you are using, in your Delphi...
  4. EricDraven

    QuickReports - Missing Something?

    Looking at the information that you have provided, I would say that yes it is possible to do this as one QuickReport as both documents will use the same layout albeit with different data. Essentially, what you want is a Quickreport with two QRBands and one QRGroup. Of the two bands, one should...
  5. EricDraven

    QuickReports - Missing Something?

    The simple answer is to just place a QRDBText into your Detailband and assign it to your query and give it the expected field name (much in the same way as a DBEdit box works). That should at the very least place the first record in your query onto your report. Depending on how complex your...
  6. EricDraven

    Why can't I display a form in the Form.Create?

    Your getting that error because the second form hasnt been created yet and your already trying to show it. Try using your main forms OnShow event to show your senond form. If you show it modally (Your second form that is), it should pop up before your main form which wont appear until you close...
  7. EricDraven

    Creating a Print Preview facility for an app

    I dont use any complex printing in any of my software, just statistical and legal documents with the odd jpeg or gif in them, so I create all of my documentation in HTML format and then display it on screen using a HTML viewing component. I can then either print whats on screen or send it to...
  8. EricDraven

    Enable a locked form?

    It depends on exactly how you have coded your procedure. If you are running a simple loop then you can have a cancel variable which is set when you click the cancel button. When you hit the end of a loop cycle, call Application.ProcessMessages and then check on the state of your variable. If...
  9. EricDraven

    Findkey Problems

    Personally, I do use the Advantage database and I use EditKey instead of FindKey. The problem with Advantage is that it is particularly sensitive to field types. If your field is a string, then you need tp search using a string, it wont do the work for you. Try adapting the following code and...
  10. EricDraven

    "External exception C0000006" occurs & don't know why

    Is your DLL releaing its memory correctly? Ive had a similar problem in the past which was memory related. Well ain't this place a geographical oddity. Two weeks from everywhere!
  11. EricDraven

    Creating Forms in DLL file

    This is indeed possible. I dont have the time available to replicate the code (in fatc I dont have the code on my current work machine) but if you take a look here :- http://www.programmers.net/mirrors/DSP/newl/d20/f043_001.htm and download the [b]mdidll.zip[b] file, it contains an example of...
  12. EricDraven

    Random Character Generator

    Check out the Random function in the delphi help and couple that with an Array and you should get what you want. Both have pretty good examples to get you going with this as its not something thats particularly complicated to achieve. Gar!!! I watched Dodgeball and now I think I be a pirate me...
  13. EricDraven

    Removing form close icon

    You can disable the 'X' using the following code/component but unfortunately it doesnt "hide" the icon, merely disables it. Still, it may give you a starting point to work from. unit UNoCloseForm; interface uses Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs...
  14. EricDraven

    Cannot get MDI working if not in main form..

    The MDI form has to be the main form of the application. A childform can be any form you like but the MDI parent has to be the main form. The only thing you can do is "fudge" your way around it by simulating the behaviour of the MDI forms using other components, i.e. Panels etc. "How about the...
  15. EricDraven

    email quick reports

    If you use the Gnostice component, it will correctly extract your report as it is on screen into HTML format. From memory the only thing you lose is any shading on your document. As notlimah says above, using the command posted above results in a very messy and nonsensical report when converted...
  16. EricDraven

    email quick reports

    In short, not easily. The problem is, you could in theory save the Quickreport document that your program has generated and attach it to your email. Doing this however means that the recipient will need a program which supports QuickReports to be able to view the document. Short of rewriting...
  17. EricDraven

    Some questions about TToolbar

    Steve, I believe you want an Outlook bar to do this. Try downloading the JEDI VCL tools, theres one in there and its a good set of tools to have at your disposal. http://jvcl.sourceforge.net "Mr Flibble says: Game Over, boys!"
  18. EricDraven

    difference between date n times

    Look under the delphi help for DecodeDateTime. Using this command you will be able to get a solution. "Mr Flibble says: Game Over, boys!"
  19. EricDraven

    how to simulate dbnavigator??

    For each buttons OnClick event, enter the specific code. For example, if you are using a table which is hooked upto a DBGrid via a Datasource, you do something along the lines of :- Table1.Next; //Go Forward One Record Table1.Prior; //Go Back back one record Table1.First; //Go to the first...
  20. EricDraven

    Execute a Query to MSSQL

    A bit vague, why not try this link. There should be a tutorial or two here to help you get started. http://delphi.about.com/od/database/ "Mr Flibble says: Game Over, boys!"

Part and Inventory Search

Back
Top