Search results

I have added a button on my form that looks in a specific fields and allows the user to search my form. Problem is when the find/replace pop-up window no long has the focus, it changes the "Look in" option to Main Menu. I would like to close the form once it has lost focus. Anyone know how to do...

I have a pop-up that is linked to a table. I have a button on the form to find a record, then I have a button to delete the record. the find works perfectly. The delete button is where I am having problems. The code is: Private Sub cmdDeleteTicker_Click() On Error GoTo...

I have searched everywhere on the net for the answer to my question and I found a post on this forum: Sending a report by mail. But even in the post there was no solution. I would like to send a report that I have created in access 2003 in an e-mail not as an attachment, but in the body. I...

I have search the threads and came accross thread: Update ListBox from CheckBox But that did not help me. Here is my problem: I am trying to unload a combo box. I have five items in my combo box. When it get to item number three it throws error 6013: Unable to remove item. '3' not found...

I am trying to do something new in my query to make it run faster and I hope simpler. I am first: Deleting out the data from my temp table: CurrentDb.Execute "DELETE * FROM tblTemp_SG" Second I am appending records based off of a qry into my table that I just sweeped. strSQL = "SELECT...

I have created a query and in the criteria I entered a function name: =GetDate. The code for get date is as follows: Function GetDate() Dim dtedteEntered As Date Dim checking As String dtedteEntered = Forms!frmMain.PeriodStartDate.Value GetDate = "#" & dtedteEntered & "#" End Function When I...