Search results

thanks a lot Isla & Gasman ;);););)

dear Gasman, no it is not working please see the screen shot

Dear isla, complie error is showing. method and data member not found what to do?

hi, i need automatically input date into separate column based on combobox selection. like , i select option "ASKED"= column "ReqDate" will fill up by present date. if i select opiton "Sent"= column "SentDate"will fill up by present date. ----------- please see the attachment for ref. thanks.

Thanks, Colin. You have done well but I thought there would be some easy process. it was not my original db. In my original DB the existing query is far more complex. it has some left join and some other complicacy. So I am afraid it would be more complicated when I will do more query over...

Thanks for Reply! can you please work on my database. I can't understand. I have given what I need into the PNG and also given the present condition of my database. please see my post at the beginning. thanks

Hello Dear, Thanks for Reply. Actually, i didn't ask for searching by the word "Done". I want to see single TAG's date wise last update. so according to that, I need to search for the latest date for individual TAG. so finally it will show me the last updated Date for a single ID with Status...

hello there, I am facing a problem while using query option. I need to get a result based on the latest date it will show me the job status. the product id came from a different table. Here the access sample database is attached. I need the result shown in the image but the result is not coming...

Could not understand ur instance. please make it simple

hi, i have a Form which contains some objects like Combobox, subform and Option Button Frame. i have written some code for this object. now these objects are working for data entry now i need the same object for data searching. please see the image attached.

sorry boss i m not satisfied with ur reply. And i cant remove my look up if i wanna relate two tables. So please show an easy example.

hello dear, i have some combobox which shows the column shown into the subform. i can filter the subform using the comboxes. now i need to build an instant report based on the current filtering. i can filter more or less. but i need the current position of the subform into a report. please see...

hello there, i have two data tables, one is depending on the other. now i need to delete the main table row depending on the subtable row if it is null. please see my attachment. :banghead::banghead:

i know about the cascading but there is a problem with that. the comboboxes are dependent on one to another. the second one is dependent on the first one. but i need no dependencey. i need randomly selected column, the current data shows into the subform it will also show into the combobox. i...

the database is very simple. it contains a table now i want to filter the next columns according to the subform shows the values for each column u can see my db attachment.

hi, i have got a problem about filtering my subfom. i need a filtering system using combo box. the whole data of the table will be shown into the subform. and each combobox will populate each column of the subform table. i have given two attachments for instance. here the first combobox...

hello, i have a table contains 5/6 column. now i need to filter the table on a form randomly. suppose i have 6 different combo box for 6 column. Now on the sub form the control shows the whole table. i this case i have clicked the 3rd combo box, then it will show the whole column in its list...

Hi Jhb, u have done awesome. thanks for the help. i need something more like, i need to increase the data of my table in that case the text box will be fixed within four or three number and by clicking change button the rows will show accordingly.

Hi Gizmo, :p hm.... i got u let me explain clearly. First of all i have a table which contains three fields like ID, FruitName, Person name. This is my database. Now i need a form which contains some textbox/level/Command Button which are arranged in two different group. each time while i...

hi, i have a table that contains two field one is Fruit Name and another is Person name. i have attach the .accedb file. i need a form that shows the Field value randomly and while i click on the same ID value it will show green color or disappear. and every time when i clicked on the change...