Search results

Endre's suggestion will work great. I think that yours is not working because you have is null. That would return only records with nothing in that field if you do not have anything in your form field. Should be is not null.. See if this works.

You can do that as long as a null value in your query will return results. Or you can put alternate criteria in your query for your form on the or line. Does that answer your question?

Maybe I am not understanding what you need. But you can make the subform data source a query and then make the criteria the field on the form. Hit the build button on the criteria line if you don't know how to select the form and field. Hope this helps.

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

Just FYI: DoCmd.RunCommand acCmdSelectRecord tells the app which record to delete, otherwise you are correct and I would need some sort of ID.

Sorry never mind..... I had accidentally set the allow deletions on the form to no.

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 do not have experience with 2007. Best of luck...

I beg your pardon, boblarson is correct.

Use the Nz function. =nz(me.text39/5, 0) if the me.text = 0 then a null value would be the result. with the nz function it will return a 0 in the code I have included.

Please let this as it is a starting point for you: Add up all of the numbers and then do an average based on the row count values that do not equal 0. So..... = a+b+c+d +e dim countit as Integer 'initialize countit countit = 0 'next if the values are not in a table then you will have to...

Yup, that is what I would do. I would do it in the after update of the last total on the screen. But only you know if that makes since.

UGRGGG.. anyway: if me.a <> 0 then countit = countit + 1 then you can do your average based on what countit equals. Hope this helps. It is just the way I would do it.

Sorry hit the wrong button and posted... you can do an if on each of the totals. Acutally it would be easier to do = if me.a <> 0 then

Add up all of the numbers and then do an average based on the row count values that do not equal 0. So..... = a+b+c+d +e next if the values are not in a table then you will have to evalueage each total for 0. do until count > 5 if me.a = 0 then loop

Do you want two different report to print in sequence? Open report1 Open report2 Print report1 Print report2 Is this what you want to do?

Here is an example of code that shows what I was trying to do: Got it from web page: http://www.databasedev.co.uk/send_email.html '----------------------------CODE START---------------------------- Public Sub SendMail() 'Provides the Send Mail automation Dim dbs As DAO.Database Dim...

I am looking at your other post again and I see the .Body = Active Document.Content. If I have two word documents will it know that the one I created is the active document? Do I have to set the focus on it?

I am sorry I am confussed. How do I go to outlook from word using the content of the word document. What does the code look like. Is my code incorrect? Thank you for your time.

I also I found an example saving the report in rich text format and then reopening it, but I don't want to save it. I just want to copy it straight to the e-mail.