Search results

Hi This all sounds greek to me. I am just a beginner wanting to walk with big shoes.... Appreciate if you can please make the changes in my sample database and email it to me. That will be extremely helpful for me to understand this more.

Thank you for your quick reply. I would like to take the data from the search result and load it to a table LOG_Details via the Form.

Hi I tried this, the problem is that after it feeds the information into the main form, it sits in memory, It changes all the existing records to have the same emp details.

Hi Gemma I tried all the what you asked me to try and it does not work. Attached is my sample database. The form name is Summary.... Can you please check this and let me know what wrong I am doing for this not to work....

Thank you very much, but this does not work. Please help

I changed the enter key properties to the new line. But it does not work Pl help me

I did make it to new line, but it does not work.

Thanks as I am new to this, appreciate if you can please make the changes and email me the attachment. Thanks

Can you please give me the exact VB script for this. I have a popup memo field and when I hit the enter key it closes the popup form and returns to the main form. I would like the following: - when I hit the enter key it should go to the next row and not close the form. Currently on load...

Hi Can someone please show me how to pass multiple values from the search result form to another form. I have attached a sample access Database. I would like to pass multiple values from one form to another form. Attached is the sample EmpSearch_Frm hold the search results - I want to pass...

I am trying to use the button for two things. 1) if there is an attachment in the data table (attachment) email the attachment and a report from the reports section for a particular record And 2) when there is no attachment, then it should email only the report. I hope I explained it well

Sorry I tried all but it does not work.

the search control is all unbound

Can you please explain where do I add the full pard of the folder in my script. Please help.. Please open my db script and tell me where to add the folder name...

Hi gina When the search string is empty, the pop msg box does not appear. Nothing happens. I would like the msg box pop up when the result is null

I would like a Message box to pop up when a users search for information on any of the fields and if no records are found, this message box should pop up. "No records found". I have written this but it does not work....

OOPS!!! here is the attachment

Thank you very much for helping me. When I run this I get an error message as below: Runtime error-2147024894 Cannot find the file. Verify the path and file name are correct .Subject = "Availability Lot for " & Me.AVLOGID & " At " & Me.[Date] .HTMLBody = "Some text here"...

I have created a multiple field search screen. The script is attached. I would like to add a MSG Box "No records found" when the user types in information in any field where no records are available. Just cannot get this working. Can you please check my VB script and let me know what is...

The email button does the below operations 1. it takes the attachment from the data field (attachment) and moves it to a FOLDER that gets emailed. 2. It also takes the report from the report list and moves it to a folder that also gets emailed. The problem with this script is when there is no...