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