Hi,

I would like to query from you people if its possible to
change back color either row wise or CELL wise in List box.

Also I would like to know any other ways of listing record in forms...

hey all,

I am developing application which has a huge data base.
From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself...

I have column table which has values 1 and 2.
What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records...

Its not working.Please help me with Expression builder

I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added...

Hi,

Please help me with Expression builder for my FOrm.
Weight_likely - back end DB Column
I want an expression, where if Weight_likely is blank then in form 0 should be populated or if...

hi,

in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern.

What might be the reason. Please help me.
...

On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box
Please help me in setting focus to that...

Thanks all...
the error is solved now.

Hi,

I am able to sucessfully delete duplicate records when the number of records are few in number say=50. But the same code is not working when the number of records are many say=500 or more.
...

Hi,
I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName

strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName
rst.Open...

hi,

I would like to delete duplicate rows in MS ACCESS.

Note: There are no PKEY in Database
also the DB allows duplicate records.

Please help

Regards,

we are able to query successfullu from a Column called "ParentUUD" (without space) using query

"SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'"

we have a column whose...