Recent content by yobensh

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.

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

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

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

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#"

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

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.

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

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

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

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

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

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

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

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