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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: Appollo14
  • Content: Threads
  • Order by date
  1. Appollo14

    Maxicode/UPS barcode

    Hi, has anyone had any experience with adding the Maxicode/UPS barcode to a crystal report? I need to generate the barcode at runtime and am really struggling to find a font for it so any help would be appreciated. Thanks, Noel.
  2. Appollo14

    problem with logon to report db

    Hi, I have an sql app which connects to the db's via odbc. I have a report within the app that i can run fine on the development pc but when i move to another pc i get the LOGON FAILED message. What am i doing wrong? here is the code that calls the report and applies the logon details...
  3. Appollo14

    Pass Database name as Stored Procedure Parameter

    Hi, I need to be able to set the database name used within a stored procedure by passing a parameter at run time. I know how to pass a parameter normally but I seem to be a bit stuck on this one. Here is an illustration of how i thought it would work. create procedure [dbo].[sp_Lock] @dbExt...
  4. Appollo14

    Datagridview refresh problem

    Hi Guys, I've been playing around with this for hours and seem to be getting nowhere fast! I have 2 forms (both with datagridviews). User clicks on form one and gets form two containing details for the row they clicked on and the ability to edit those details. When the user makes changes in...
  5. Appollo14

    Get ID of new record.

    Hi, I'm writing a vb.net (2003) app that links to an SQL db. On a form I have added a button that allows the user to insert data into a table. Once the item has been added i need to retrieve the new db ID and do an insert onto another table. How do i return the value of the new id so that i can...
  6. Appollo14

    Zoom in to picture box

    Hi all, I have a picture box displaying an image and I have a context menu with a zoom option. When i put the two together i get a picture box that allows you to zoom into the image. The problem that i have is that it only zooms intio one point. I want to be able to set the focus of the zoom to...
  7. Appollo14

    Detect the format of image in picture box.

    Hi all, I've got a picture box on a form that displays an image and i want to know the file format of the image (stored in the db as Long Binary). Any ideas how to detect this? Thanks, Noel.
  8. Appollo14

    Cannot access a disposed object...

    named "PrintPreviewDialog". Hi All, I feel like a right royal pain at the minute but I've tried looking every where to reolve the above problem. The error occurs after i've loaded a form that contains a picture box done a print preview closed the preview, moved to the next record and...
  9. Appollo14

    Printing JPG to scale

    Hi, I'm using vb.net 2003 and I have a form that uses a picture box to display an image. I have put a context menu on the picture box allowing the user to print the image, however on trying it I ended up with an image the size of a postage stamp in the corner of an A4 sheet. Could any one...
  10. Appollo14

    A daft question about datasets

    Hi, I'm new to programming and after messing with access an awful lot i've decided to have a go at vb.net so please excuse me if this is a bit basic. I've written a small app that stores contact details and images (stored in the db) associated with those contacts. I've got one form in...
  11. Appollo14

    Insery image to picture box from dataset

    Hi I'm a novice to programming and I'm trying to learn VB.Net and would appreciate a little help. I'm working on a small project that has a contact database (Access) containing names, address's and a picture as an OLE Image. I can get all of the text objects on my form with out a problem...
  12. Appollo14

    Array parameter in a stored procedure

    Hi, I've created a report (Crystal V8)based on an SQL stored procedure and when i'm working with single parameter values it works really well. The problem comes when i try to implement the parameters as an array of values. I've looked on the net and can find documents that explain how to do...
  13. Appollo14

    Sum of Total does not add up

    Hi, I'm having problems with a report where the total for a field does not add up correctly! The report pulls up the records correctly, does not supress any records but the value in the SUM field is incorrect to the lines on the report. If i drop the report into excel and sum the column i get...
  14. Appollo14

    Export to ASCII file.

    Hi all, I'm having problems exporting V8.01 reports to Ascii format. I've tried exporting directly into a text file and i get extra lines added, i've gone thro word and saved as text and i get extra spaces at the end of the lines and extra linefeeds at the end of the file. I've tried paginated...
  15. Appollo14

    Create a parameter from a parameter

    Hi, i've created a report based on a table. The table stores 3 main components. PeriodId YearId MiscInfo what I'm doing is passing in the PeriodId from a parameter. I would then like to be able to select all data from table which has a periodid <= parameter AND the yearid the same as the...
  16. Appollo14

    ApplyFilter on a tabbed form

    Hi all, I have a problem getting a form that uses tabs to display data. The form is called from a command button on another form that is displaying summary information of records in a table. The form should open and display the relevant record based on the id of the record that is selected. The...
  17. Appollo14

    Problems with date query

    Hi, I'm getting some strange results with a date query that i'm using. Sometimes it will display the correct results sometimes not. At times i have to use a months date range just to get anything at all to display. The query i'm using is; stLinkCriteriaMain = WHERE & " [tbJob].[OrderDate] >=...
  18. Appollo14

    Form Size

    Hi all, Just a quickie. Is there a way to set a form size so that the form can not be resized by the user. I have some forms that i want to lock at full screen and some that i dont. Regards, Noel.
  19. Appollo14

    Copy record and linked data

    Hi, I need to be able to copy a record in a table (which i can do) and also copy a related record in another table. This needs to be based on the current form and a form that is displayed on command. For ease of use this needs to be done from a button. Any help appreciated. Noel.
  20. Appollo14

    How can i find a time difference

    Hello all, I have two text fields which i convert to to a time. These times give me a delivery time and an actual delivery time. In my report i want to count all jobs where the actual delivery time is more than 30minutes greater than the delivery time. How can i do this. The original text goes...

Part and Inventory Search

Back
Top