Search results for query: *

Thanks a lot, i was swaping. Thanks a lot for helping so quickly.

A small problem with this is when the CouponStartDate stated and ended between the daterange i have specfied it not pulling that. For Example: If the date range is CouponStartDate <= 01-JAN-2003 and CouponEndDate >= 31-Jan-2003. It is pulling all the records that were active between that frame...

That works for only up to 3 records, but in this case if the user want to get 5 records, it varies, it won't be same number of records all the time. sometimes user may need 10 records, if i write a query for 3 or 5 records then its not going to work for 10 records. This query is a record source...

Not Parenthesis problem, i have corrected that when i got syntax error, its just giving me result for one record, if give records with comma sepearation its not giving result

I have tried SELECT tblCycleFeedBackData.* FROM tblCycleFeedBackData WHERE (((tblCycleFeedBackData.[Record #]) In [Enter All Record Numbers separated by commas])); still not working also i tried SELECT tblCycleFeedBackData.* FROM tblCycleFeedBackData WHERE (((tblCycleFeedBackData.[Record #])...

Thank you so much for your quick response. In that case i can specify records if i want from 10 to 100. But in this case i need to get perticular records like 11,19,65,54 etc. How to do that?

I have wriiten a parameter query like below SELECT tblCycleFeedBackData.* FROM tblCycleFeedBackData WHERE (((tblCycleFeedBackData.[Record #])=[Enter Record Number])); This will populate a message saying "Enter Record Number" and displays that result. But this one only do this for 1 record...

I got the answer too. We can set the Recordset type property of the Query to Snapshot then it won't allow the user to edit it.

I got the answer too. We can set the Recordset type property of the Query to Snapshot then it won't allow the user to edit it.

I have a table from which i want to show some feilds as query result. It is just a simple query. select No, ID, Name from tbl; But when i do this the resultant records can be edited by user, but i don't want the user to edit it. Is it possible to do that?

I have a table from which i want to show some feilds as query result. It is just a simple query. select No, ID, Name from tbl; But when i do this the resultant records can be edited by user, but i don't want the user to edit it. Is it possible to do that?

I have a table with values like Amount Value ------ ----- 3000 0 25000 13 75000 38 1254000 75 3,000,00.00 95 3,000,00.01 100 I want to add the "Value =0" to the table if my Total is <= 3000 If the Total <=75000 then Value=38 How to write a query...

Thats a good example, but i don't know how many fields will be each time when it opens. Because the fields will vary like one time there can be 10 fields but next time there can be 50. So how to fix it with specific field number.

Yep, its worked out for me. Thanks and a star for you

I have a field in which the data is like 3.16- And its not importing that data. How to solve it

How to fix the Column width in MSHFlex grid?

yep, i took text, Thanks a lot.

But in table the field size is Long integer, still its taking only upto 9 char.

Is there any way to change that field size to 12. Or if you could suggest me which other control will work good for this, that will be great.

Hi, How many charecters can be kept in a Textbox. Its allowing me only 9 charecters, but i need to enter 12. How to fix it. I am using this textbox on access forms.