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 derfloh 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. billyhs

    Syntax error in FROM clause

    Thank you both for your help. I have got it working now.
  2. billyhs

    Syntax error in FROM clause

    Dear experts, I'm using VB6 and Access database for my development. Currently, I'm having a problem with SQL syntax. VB6 gave me an error message saying "Syntax error in FROM clause" which I have been trying to fix but had no luck so far. Here is the code portion which contains the SQL...
  3. billyhs

    Problem with ADODB RecordSet & Crystal Viewer

    Hello again Dave, never mind my previous post. I have finally been able to show my report correctly by way of using the ttx file. Thanks for all your help.
  4. billyhs

    Problem with ADODB RecordSet & Crystal Viewer

    Hello Dave, I have tried using the two lines you suggested, but Crystal Report is still showing all records. Do I have to set anything in the report designer so that it will read from my recordset ? Or any other suggestion that you might have ? Thanks very much. Billy.
  5. billyhs

    Problem with ADODB RecordSet & Crystal Viewer

    Thank you for your answer, Dave. I don't have my development system right infront of me at this moment, but I will definitely try your suggestions once I am back at my office on Monday. To answer your question, the CRViewer1 has always returned all records. It never worked correctly before. Billy.
  6. billyhs

    Problem with ADODB RecordSet & Crystal Viewer

    Dear Experts, I'm having a problem with Crystal Report Viewer CRViewer1 not showing right amount of records speficied in my ADODB Recordset. The viewer instead is always displaying all records from my database. I had proven using the VB6 debugger that the recordset recordcount contained right...
  7. billyhs

    From pixels to Row and Columns

    Thank you CDavis for your code sample. I have tried to combine everyone's suggestions and been able to come up with a solution which works for me. Billy.
  8. billyhs

    From pixels to Row and Columns

    Thank you all for answering my question. I have tried Mike' suggestion, however the menu showed up at the pointer location which could be anywhere on the label control. What I really want is to display that menu at a fixed position which is somewhere on the left edge of my label. In any case...
  9. billyhs

    From pixels to Row and Columns

    Hello everyone, does anybody know how to convert from X,Y pixels location to Row and Column, in a Form ? I have a situation where I want to put up a shortcut menu at the location of my label control. The label has Left and Top positions in pixels, but the popup menu takes Row and Col positions...
  10. billyhs

    disappearing modeless form

    Thank you all for your help. Now I know what happened and fixed that problem. Thanks to Bill (wgcs) for giving details in code.
  11. billyhs

    disappearing modeless form

    Hi all, I'm new in programming Visual FoxPro, and am using version 8. At the moment I'm encountering the following problem which I can't solve, I have a top-level form that has one command button named btnMaintain to open another form using createobject function. When I clicked on that button...

Part and Inventory Search

Back
Top