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 Wanet Telecoms Ltd 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: RTorrance
  • Content: Threads
  • Order by date
  1. RTorrance

    Problem opening 8.5 report in ver 10

    Hello, I just recently installed Crystal Reports version 10. We used version 8.5 in the past. I tried to open a report that was created in 8.5 and it opened fine but when running the report I got an error. 'The database file has changed. Proceeding to fix up the report!' Click 'OK' and it...
  2. RTorrance

    Process won't end

    Hello, I have an exe that was working fine. I made a little change so that the FoxPro screen won't show in the background and now something strange is happening. I run the exe and it runs fine. In task manager there are the forms under the applications tab and the exe name in the processes...
  3. RTorrance

    Passing parameters to Crystal Reports

    Hello, I am using VB .Net 2003 with Crystal Reports 8.5 and SQL Server 2000. I am trying to pass a datetime parameter to my report. The report seems to ignore the datatime parameter but no other parameter. Any help would be appreciated. Thanks Rachael
  4. RTorrance

    DateTime parameters from VB .NET

    Hello I am using CR8.5 with SQL Server 2000 and VB .Net 2003. I have a report that takes 3 parameters, two of which are datetime fields in the database. The report seems to ignore the new values of these two parameters when run from vb. The other parameter works fine. Any help would be...
  5. RTorrance

    Guidance with Crystal 8.5

    Hello, I am very new to Crystal Reports and have the task of rewriting a reporting program that is currently on a FoxPro database. We are in the process of upgrading to SQL Server 2000. My problem is that I dont' know where to start with Crystal Reports. I have one table that I need to...
  6. RTorrance

    Crystal Reports Tutorials

    Hello, I have just started looking at Crystal Reports 8.5 and I have quite a detailed report to write with data coming from a SQL Server 2000 database into Visual Basic .NET. I was just wondering if any of you can give me a good first place to look for tutorials on where to start but get in to...
  7. RTorrance

    Application Exception on StartUp

    Hello All, I developed an application that links to a SQLServer database located on a seperate server. I also put together a setup program for my app. Setup program installs fine everytime. The application works fine on all machines...as long as I am logged in as administrator. We have many...
  8. RTorrance

    Datatable.Select()/Datarow.Find()

    Hello, I am having trouble searching a table in a database on a field that is indexed but not the primary key. It always says that the value I am searching for is not found. I have tried using the Datatable.Select() method as well as the Datarow.find method. I need to search my table for a...
  9. RTorrance

    MDI Forms - Opening child

    Hello, I am having a problem with opening a second child form in my MDI Parent. I have 3 forms, one being a parent and 2 children. I open the first child from a menu and then from this form i want to open the second child and close the first child. I have tried numerous ways and looked...
  10. RTorrance

    [ODBC Microsoft Access Driver] Index not found

    I have an Excel spreadsheet that has a query init that links to an Access Database. When I go to edit the query I get this error: [ODBC Microsoft Access Driver] Index not found. I'm not sure if this error has to do with ODBC drivers or possibly an index on a table. All of the indexes seem to...
  11. RTorrance

    OLE Objects

    Hi I have a table with about 450 records that each have a picture or a word doc in a ole object field. The table is getting quite large (1gb) and I would like to know if there is a way to change the ole object field so that it is like a hyperlink to the doc or of any other ways that I can...
  12. RTorrance

    Changing a number to an autonumber field

    Hello, Does anyone know of an easier way to change a number field to an autonumber field than recreating the whole table and importing all records to the new table. Any help would be appreciated. Thanks.
  13. RTorrance

    Time Calculation

    Hello, I have a table that has a time field and I need to delete 4 hours from that time. Is this possible? Everything I have tried sebtracts 4 minutes. Thank You for any help
  14. RTorrance

    Hex Code

    Hello, I am trying to send some hex code to a com printer port. This is the code: set printer to name \\computername\printername ??? '<STX>1 0<ETX>' set printer to The second line needs to be in hex and I can't figure out how. I have tried: ??? '0x020x310x300x03' ??? '\x02\x31\x30\x03' If...
  15. RTorrance

    Windows 2000 and VFP6.0

    I have kind of a weird situation. I have a user who is running Win2000 originally with no services packs. (Now has service pack 3) When this user tried to run my application, it would run fine until it was about to display a report, then would close the whole application. This only happened on...
  16. RTorrance

    Objects cannot be assigned to arrays

    Hello, I am having a problem calling a report that worked fine until this morning. In the command:valid there is some code to find the total number of pages of the report. On the line : Report Form frmForm To File (m.lcfile) NoConsole it gives me an error saying objects cannot be assigned to...
  17. RTorrance

    Report Page Number

    Hello I thought that there was a thread on this topic already but couldn't find it. Is there a was to show pagenum of totalpages on a report? Thanks
  18. RTorrance

    Objects cannot be assigned to arrays

    I'm getting this error when I call my report in screen. I have used an array to collect data and then put it in a temp table from there. I have looked at the table and it seems fine. When I comment out this line everything works smoothly. I don't understand why this error would be called on...
  19. RTorrance

    Input

    I was just wondering if there was something like a VB inputbox in VFP. If so could you please let me know the syntax. ThankYou.
  20. RTorrance

    Multidimensional Arrays

    In the application I am developing I have come across a part where I would require using a 4D array. I really don't like this idea as it gets a little hard to manage. If anyone has anyways of getting around this please let me know.

Part and Inventory Search

Back
Top