Search results

darbid: Thanks so much for the response. I was wondering how to publish a report to word via vba code. It translates well when I do it manually. This report would not look good via excel. how do you add a report to the body of an e-mail in code? I was hoping this code would do that: 'Copy...

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

No, please. I really appriciated both. With yours I could see what I was doing wrong in my code. Thanks again.

Thanks all for the help!! missinglinq: that worked perfectly!!! Thanks.

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

Do a google search for linking fields and VBA or Access

This worked perfectly. Thank you for the second set of eyes.

You are right, Thanks.

Bilbo's way is simpler! Which is always best.

I see what you are talking about now. I am trying that.

I thought max just returned the highest number of the records. Like it would return 120. I thought that sum was the key word that would return the sum of the values. No?

ACCOUNTING_METHOD is in the query that is in the from statement. I am using a specific search string of "o" in that query. Since it should all be the same value in that column I didn't want to include it again in my second query. Can you please help me understand why it is needed?

I am having a similar problem. My post is on the site too. But mine isn't with forms. For yours you can make a sub form that when it opens, it's source would be the query from the continuous form. That hard part is pulling the data from the record that you are on. You could do that if...

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

Probably because Rich is right. ;)

Hi Brian, Yup that would have worked, but I wanted to use it one multiple boxes and didn't want to hard code it. Thanks so much for the help! Thanks, Bre

Talked with my friend and now it works... Here is the code: Function GetDate() As Date Dim dtedteEntered As Date dtedteEntered = Forms!frmMain.PeriodStartDate.Value GetDate = dtedteEntered End Function I missed defining the return veriable....:rolleyes:

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