Search results for query: *

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

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?

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.

Hi, I have a question about the Combo Boxes. I have created a form that has 7 combo boxes. The user may select one of the option from two combo's or some times from 5 combo's or sometimes all 7 combos. Based on the selection criteria when the user clicks a button the query result should come...

Hi all I need a small help in my Query. I am running a query that brings results from 3 tables. Eg: For ProductID 1 there are more details in the other two tables. So, when i run this query i am getting the ProductID 1 around 200 times. I want to show the total of Products by counting the...

hi I have two combo boxes in my form. When the user selects in first combo box the second combo should have the corresponding values. Eg: First combo has 4 value list 1.Type 2.Channel 3.Status 4.Group Second combo should show all the types that are available when user selects &quot;Type&quot; in...

Hi, I have a problem with a small database that i have created. I do need to run a query to retreive the information from three tables(data will be imported into the tables through .txt file). Those tables are tblCoupon: CouponId,CouponVersion(as PK) tblCommunication ...

Hi, I need to write a query that retrieves records from table based on the date range that i specify. eg: My table will have a CouponStartDate and CouponEndDate. When i specify the date range i need to get all the Coupons that were active during that period. I have tried this query like this...

Hi, I have created a Report in Ms-Access Database. I need to change the back color for every alternate record. eg: ProductId ProductDescription DateDalivered These are the three fields in a record, when i run a report the first recordset of the three field should have red color and the...