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: *

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

    How to programmatically turn text into hyperlink

    I am using FP9 and developing a web application. If I have a text field, how can I turn the data in that text field into a hyperlink progammatically using FP code? Thanks. Tony Scarpelli Clinical Engineering Dept. Maine Medical Center Portland, Maine 04102
  2. TonyScarpelli

    How to programmatically turn text into hyperlink

    I am using VS2008 VB.Net and developing a web application. If I have a text field, how can I turn the data in that text field into a hyperlink progammatically using Visual Basic? Thanks. Tony Scarpelli Clinical Engineering Dept. Maine Medical Center Portland, Maine 04102
  3. TonyScarpelli

    How to open a word .doc from web page?

    I am using Visual Basic 2008 and SQL Server 2005. In a web page, my users are going to enter an equipment ID number. The program will search a table and come up with the name of a Word document from the table. For example: Tag #: 12345 | Pm123.doc The program will then display the document...
  4. TonyScarpelli

    IE 6 or 7 won't play music in .PDF file

    I am in the process of creating and testing a web site. One of my links is to a .PDF file that contains music and sounds embedded in it. If I use FireFox the music plays fine, but if I use IE 6 or 7 the music doesn't play. Is there a setting in IE that prevents music from playing? Any ideas...
  5. TonyScarpelli

    FoxPro 9 application generator not working

    I was going through the Walkthrough: Creating Applications with Visual FoxPro. When I got to the build part and built the myapplication.app and tried to run it I get two error messages: File 'e:\myApp\myapplication_app.vcx' does not exist and File not found, or unavailable. It may be in...
  6. TonyScarpelli

    Need help on choosing the least date

    I have two tables, one with equipment information with an ID, and one with dated procedures in it related to the ID of the other table. There are multiple rows (2 to 4) for an ID, and with a date field. I need to choose one of the rows based on the earliest date. I.E. ID Date 1234...
  7. TonyScarpelli

    Where to put _REPORTBUILDER?

    I have a VFP 9 report. I have "SET REPORTBEHAVIOR 90", in my setup .prg, and in my Tools "Report Options" I set "Report Engine Behavior" to "90 (Object Assisted)" In my Main.prg I set _REPORTBUILDER = "", and when I ran the report I was getting an error that it couldn't find "_REPORTBUILDER". I...
  8. TonyScarpelli

    Need FP9 Combobox, to show only one field

    In FoxPro9 I have a combobox on a form. The data comes from a table with two columns, one a description and one a code. The second column is the value I want to use. When I open the list it shows the two columns. However I only want the user to see just the first column, the description, not...
  9. TonyScarpelli

    How to check if a datetime is a datetime?

    I have a character field where the most of the dates are in the format 'Mar 8 2011 12:00AM', however, there are sometimes dates like this: 'April 1, 2009' or '06-2013' or '09/04/2009'. I am trying to check to see if the date is a DATETIME and if it isn't to either skip the record or convert it...
  10. TonyScarpelli

    VFP 9 .exe and runtime files in one directory?

    I am making a FoxPro 9 application. In the old days (fpw 2.6) I could put my .exe and the runtime files on my network in a directory all together. My users could easily get to it and it made it easy updating the .exe by just replacing it. Can I do the same with vfp 9 and it's runtime files...
  11. TonyScarpelli

    SQL Server Select to .dbf not curstor

    I am using VFP 9 SP2. I am using the following to access a SQL Server table: lnErr=SQLEXEC(gnConnHandle, lcStr, "MyResults") The results are going into a cursor. Is there a way to put the results directly into a .dbf file? Thanks. Tony Scarpelli Clinical Engineering Dept. Maine Medical...
  12. TonyScarpelli

    What's minimal install for SS 2005?

    All I want to do is to create a few databases using Visual Studio 2005 or 2008 for Windows Forms and Web Sites. I don't need anything else. What parts of the install do I need? Thanks. Tony Scarpelli Clinical Engineering Dept. Maine Medical Center Portland, Maine 04102
  13. TonyScarpelli

    Can't create SQL 2005 database in VS 2005

    I'm using the developer version of Visual Studio 2005 and SQL Server 2005. I've had SQL 2005 Express installed last year, and since moving up have been regretting putting anything Express on my system. I've never had so much agony trying to get rid of this junk. I'm going through some video...
  14. TonyScarpelli

    Access DB connects but getting weird error

    On a Windows XP SP2 machine and using both Visual Studio 2005 SP1 _and_ 2008 I am getting an error. I am adding a connection to an Access database, using the Server Explorer, and the ".NET Framework Data Provider for OLE DB" and "Microsoft Access Database File". The Test Connection button...
  15. TonyScarpelli

    Crystal Reports and SQL Server access

    My DBA gave me Read Only access with integrated security to one of our SQL Server databases while I have been developing a few reports using Crystal Reports and Visual Basic 2005. We use Windows XP SP2. The reports have been working on my workstation, and I created a deployment project to test...
  16. TonyScarpelli

    VS 2005 and CR XI together

    I've been using CR in Visual Studio 2005 for quite a while. At some point last year I installed CR XI and then Rel 2. I've noticed that on some reports (in the VS 2005 environment), when I go to change something in the report (right clicking somewhere) I get a list of doubles of everything...
  17. TonyScarpelli

    Getting Error when trying to add SQL data source

    In both VS 2005 SP3 and VS 2008 SP 1 I am getting the same error when trying to add a new data source on a new VB project. In Server Explorer I can connect to the database that I want and see the tables there. It's a SQL Server 2005 database that is on our SQL Web server. I can use 'SQL Server...
  18. TonyScarpelli

    Is there a way to stop Autoplay on a USB port?

    I have Windows XP3 Pro SP2. Whenever I connect a USB device to my computer, like a Pocket PC using ActiveSync, Autoplay pops up with a windows Explorer. Is there a way to stop this action from occuring? I know that I can normally shut Autoplay off using a drive letter, but what if the device...
  19. TonyScarpelli

    How to create dataset in VS VB 2005 Dev. Env.

    I have VS 2005 and I program in VB. I am also using Crystal Reports X1 Rel 2 to create reports in the development environment. I'm trying to figure out a way to design the report using a dataset instead of making a connection to SQL Server. I can most of the time get the report designer to use...
  20. TonyScarpelli

    To JOIN or not to JOIN?

    Below are two SELECT statements. Can anyone tell me why a JOIN in the second statement is better/faster or whatever than the first statement? In other words, why use a JOIN? SELECT Pur_head.PurDate, Pur_head.PONum, Pur_head.company as Vendor, Pur_head.ChargeBack, Pur_item.Descrip...

Part and Inventory Search

Back
Top