Search results

Hello, When I click on the report without running the onClick command of my button the report does not generate because the query is not there. I am a little confused. Are you saying to check the "record source" of the report to see if there is anything there? This is really frustrating..I...

Same result...:confused: Is this not a practical way of creating a report? I dont see why this should be happening.... Thank you for your help. Tallman

Hello, I have a querydef which a report is based off of. The query is created, the report is opened based off the query and then the query is deleted. I am having an issue when the report is long enough to reach two pages it only displays the first page of the report. I have the report to...

Thank you for the reply VbaINET. For some reason the report started to work the way I needed it to without me doing anything. I guess it was a "GLITCH" Thanks again. Tallman

Hello, I have a query that a report is based off of. The issue is the report is not showing all of the information. It only displays the first page of records. The report should be about eight pages long. Any ideas why this would be?? The code to opent report is: docmd.OpenReport...

Good Afternoon All, I think I have an easy quesiton but cannot seem to figure this one out. I have a mailmerge set up that looks at a "pending" field in a temp table. if the pending field is = "test1" then it grabs a letter1 and saves it to the share drive. The problem is the code loops...

Hello, I am trying to conduct a mailmerge by calling a function. Basically the main table "60_Day_Clientlettertbl" has a "pending_notes" field. Depending on the pending field one of two letters needs to populate. Once the code determines which letter to use it calls a function. This is the...

I just tried your update....no luck. I am getting a "Could not find file "share path name here"" Not sure why this is not working.

Hello, I have a tbl with the following fields: Acct_Num, Mkt_Dt,Cash_Value The table holds every daily ending balance since it was opened. I am trying to run a query to capture the "MAX" mkt_dt so that I have the most recent value as of yesterdays close. When I run a straight...

:pPerfection!:p

Hey Bob, For some reason the "CurrentDb.QueryDefs.Append(qdf.Name)" was throwing an error. I texted it out and it worked fine. I wish I could figure out how to combine two temp tables into one spreadsheet using this method. Thanks again for your help!!!

Nice. I will give this a try!

Thanks BOB....I always try to keep things in the VBA window as opposed to creating queries...not sure why...I guess it keeps it clutter free. Does it take up more space when you create queries as opposed to using recordsets in vba? Thanks!

Hello, Does anyone know how to export certain fields from an access table to an excel spreadsheet? I have a tmp table that I currently transfer into a spreadsheet. The issue is I do not need every field. I only need four of them. I do not want to create another tmp table with only those...

Thanks again darbid. I will try that!

Thanks again Darbid. PLease see below: Public Function SendEMail() Dim db As DAO.Database Dim MyOutlook As Outlook.Application Dim MyMail As Outlook.MailItem Dim StrEmailList As String Dim Subjectline As String Dim BodyFile As String Dim MasterString As String Dim MailList As DAO.Recordset...

Thank you for your response. You are understanding correctly. When an assocaite emails someone directly from outlook 2007 to a recipient with 2003 the emails are fine and the receiving person can read the email. So far every participant with 2003 outlook has not received a "normal" email from a...

Hello, Has anyone heard of this issue before? I have a database .mdb that sends out an email once a click box is selected. The email is sent out from an associate who is using 2007. If someone with office 2003 reads the email the body of the email is completely blank. If someone with office...

Good Afternoon All, I have thankfully aquired the code below from this website http://blogs.techrepublic.com.com/howdoi/?p=119. The code allows me to run this macro in outlook and insert all of the emails in a folder I select into an access table. When the macro runs the outlook folder...

Good Afternoon, I am starting to work on some process improvement for my department and I am looking for some examples/ideas regarding this one form. basically what happens is a request comes in from our clients via outlook to a "department" email address. The associate goes and prints...