Search results for query: *

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

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

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.

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.

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.

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

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.

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

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

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

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