Search results

Thanks for your reply. Please let me know how to do this - not from standalone DB, but from the linked DB itself. I do not want to close the database after calling this function. thanks for your help.

I wish to automate a function (Function Name: Daily_Activities_Snapshot) - everyday at 5.00 PM. Please let me know whether I can use the form timer event for this. If yes, please let me have an example. If not, please let me know how to do this. Thanks for your help.

Thank you very much, it works well.

Thanks for the reply. Can you please provide me a sample? Thanks.

Is there a way to paste a access query result in the outlook message body?. I do not want to attach the query result in the email. Thanks for your help.

Thank you.

Thanks for the reply. My question is, how do I move those numbers to the access query criteria? Thanks

Sorry if this is a very basic question. I have around 3000 numbers in an excel sheet. I need use those numbers in a query (Field Name: Package_Qty), the data type is text. I need to add these numbers with " ". Please let me know what is the easiest way to do this. Someone told me to...

Thank you, I will try that

Thank you.

Thank you. No, this listbox is unbound until the cmdSearch is clicked. Thanks again.

Hi, I have a table imported from excel, in which both First and Last names are in upper cases. Is there a way to change the First names into proper case?. Thank you.

Thank you. I do not have the permission for that; I have a txtSearch, a srListbox and rsltForm. I enter the Employee id in the txtSearch and click cmdSearch. The srListbox displays the result. When I click srListbox, that is set as the recordsouce for the rsltForm. If the search result...

I tried none, simple, multi - but all of them select both records - since both records have same values.

I have a list box bound to a query. If the list box retrieves two records, I am not able to select only one of them. If I click, it gets both records selected ( highlighted ). Is there any way I can select only one record? Thank you.

Thank you, I will think in that way.

I have field in my form and the entry is required. The data type is date. I need to keep the date type as date. My problem is if the date is not available, the user has to enter "Nor Available". Is there any way I can achieve this? What are the other option available to me? The reason is...

Thank you very much. This is what I have been looking for. Thanks again.

When I changed the memo field from plain text to Rich Text, I got the below divs and slashes. Is there any way to get rid of them? <div>GC in process - EB1.</div> <div> </div> I had only "GC in process - EB1" in plain text. Thank you.

No, two combo and one list box. No subform