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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yobensh

  1. yobensh

    Delete records from ClientDataSet

    Hi all, I'm manipulating a filter on ClientDataSet. Eventually, I need to delete all records shown as the result. I've tried to use ClientDataSet.Delete, but it's deleting the underlying record only. Can anyone help me here? Thanks in advance, Yoav.
  2. yobensh

    Define a certain field as Hyperlink

    Hi Friends, I'm using an Access 2000 db which have a field called "Rem" set as Hyperlink type. I'm also using an ADODC and a simple data grid for showing the records. 1. Is there any way for showing this field on datagrid as hyperlink? 2. Same question for datareport... Hope I was clear enough...
  3. yobensh

    SQL query with same criteria on several fields

    Thanks Golom!!!! Works like a charm :-) have a star, you deserve it!
  4. yobensh

    SQL query with same criteria on several fields

    Hi Golom, Thanks for the information, but...yes, all fields are text fields. Still, after adding the [] brakets to fields names, there is no change with the sql result. My suspicious is that there is some kind of problem with the "OR" statments (when testing this on 1 field only, it works...
  5. yobensh

    SQL query with same criteria on several fields

    oops...noticed i've missed something here..sql statment should be: sSql="SELECT * FROM Data WHERE [CRem1] LIKE '1%' OR [CRem2] LIKE '1%' OR [CRem3] LIKE '1%' OR [CRem4] LIKE '1%' OR [CRem5] LIKE '1%' AND Date >= #28/08/2006 00:00:01# AND Date <= #29/08/2006 23:59:59#"
  6. yobensh

    SQL query with same criteria on several fields

    Hi, I'm trying to understand why this is not working for me.. I'm using Access2000 database and ADO Object to show data over datagrid. What I'm acually trying to do is to filter data according to the SAME criteria but on 5 different fields (some of the fields might contain a null value) named...
  7. yobensh

    Need help with SQL Query.

    If you will look at my code that I posted first, you will see that "day1" and "day2" alreay have the "#" before and after those variables, therefore no need to add it again in the SQL.. I'll try the "IN" thing and will keep you updated with the results. Thanks again to you all! Yoav.
  8. yobensh

    Need help with SQL Query.

    Right....I'm in Israel :-)
  9. yobensh

    Need help with SQL Query.

    Hi John, Unfortunately, I still can't figure out what's wrong.. Here is the result from the debug.print: Line like 'LINE-2%' AND (Side='P.S.' OR Side='C.S.') AND Date BETWEEN (#23/07/2006 00:00:01# AND #26/07/2006 23:59:59#) I suspect it's coming from the clause (Side='P.S.' OR Side='C.S.')...
  10. yobensh

    Run-time error '9' subscript out of range

    Hi, Figured out what caused that error - end user is using a remote printer thus when trying to open the report system is expecting to find a physical printer... Therefore, simple solution is to connect the printer directly to the pc and not by net connection. Thanks for all who tried...
  11. yobensh

    Need help with SQL Query.

    Hi Experts, I'm trying to filter some data using SQL query on Access 2000 db. Thing is that I'm getting run-time error '3001' - "Arguments are of the wrong type, are out of acceptable range, or in conflict with one another" here is what I have so far: Dim cn As New ADODB.Connection Dim rs As...
  12. yobensh

    Fixing MSHFLEXGRID column header for not scrolling

    Hi experts, I'm using MSHFLEXGRID to populate records from Access db usind ADO control. When having a large number of rows, while scrolling down the rows, the header row (or is it column header..? ) is going up with the previous rows and kind of "disappear"... Any idea how can i fix it, so...
  13. yobensh

    Run-time error '9' subscript out of range

    Hi Tracy Thanks for your reply eventhough you don't own a crystal ball...;-) Here is what I got so far - after a deep investigation, it seems that the reason for that error to occour is the "pageset" thing. What I'm trying to do here is to print a report at Landscape Orientation. On users pc...
  14. yobensh

    Run-time error '9' subscript out of range

    Hi Experts! I've made a small application using Access 2000 db, packed it and installed it on my personal pc. For me it works just fine. The problem begins right after the installation on users pc. When they click on any button it's giving them this error: "Run-time error '9' subscript out of...
  15. yobensh

    System files out of date problem

    Thanks vbSun for replying! Thing that I did not mention here is that I'm creating the setup file with WIN-XP...so I guess that's why it works fine when I install it on another machine with WIN-XP. Will it still work for me when trying to install it on matchine with WIN 98?? As I understand...
See more

Part and Inventory Search

Back
Top