Search results for query: *

PHV, Thank you so much. That worked like a charm. Dom

In the following code, I want to insert a line break where the & chr34 showes at the end of a line, however it is not working. Is there another way to force the text to display in multiple lines? Thanks for your help, Dom With ppPres While Not rs.EOF With...

I am using Access 03 and Outlook 03 on our network. What I am doing is linking the outlook SENT and RECEIVED data in Outlook with Access so I can count the number of emails Sent and Received. I can do this for one user and all works fine. The result is two tables with the SENT and RECEIVED...

PHV, You are fantastic. I have been playing with this for over 2 hours and you solved it in 2 minutes. Your suggested code works perfectly. Thanks so much.

PVH, Thanks for the quick reply. I used your suggestion and it is closer but still missing the mark. Here is the new result using your suggested code: To CountOfSender Name Expr1 Bennett 2 10/10/2006 Bennett 3 10/11/2006 Heess 1 10/11/2006 Heess 1 10/9/2006...

Hi everyone, I have an application where I link to Outlook from Access. The purpose of the database is to count how many Sent and Received Emails each person receives per week. The following code results in the output in the first table below and I need to have the output show as it is in...

Paul, Thanks for the reply. We have never had more than one user utilizing the software. I will do as you suggested to see if the manufacture has a way to do what I need done. Thanks again, Dom

Hi everyone, I have a bit of a strange request for help. The small company I work for has a single user license for a software package. We have this software loaded on a Windows XP Pro machine. Currently, when a user logs in remotely to this XP machine they can run the software and...

Duane. Thank you so much for the quick reply. This is a nice piece of code that I can use over and over again. Again, Thanks. Dom

I managed to use the code from D. Hookom on thread 703-896152, but am wondering if anyone knows what the function Get quarter may look like. I suspect he created a function that interprets the GetQtrStart and End dates but am not sure of how to recreate one. Private Sub lboDates_AfterUpdate()...

Thanks, I will check out Redemption.

Remou, I wanted to post back with my findings and the working code. The problem turned out to be that if I had no eCC or eBCC entry in my table it sent a NULL to the DoCmd.SendObject line of code and Access did not like that. If I put an entry into those fields, the code worked fine. I...

Thans for the reply Remou. No, the table has MyReportName, no punctuation at all. The problem is this line of code displays MyReportName correctily when I step through the code: strSQL = "SELECT * FROM EmailTable WHERE eReport = "MyReportName" However, the next line of code displays the...

Hi All, I am trying to do something similar to post thread705-1137518. My problem is the sName returns "MyReportName" but the strSQL returns 'MyReportName'". Therefore, I receive an error that it cannot find MyReportName due to the punctuation. How do I make the strSQL statment retuen...

PHV, Hi PHV, you have bailed me out once again. Your suggested code did the trick. Thank you so much for the reply and for being such a valuable resource. Dom

All, I found the offending code and it had nothing to do with the code I posted earlier. The code causing the problem is on the ON OPEN event of my main form. What I need is the spreadsheet date and time so I can display it on the main form. That way the users know the data is accurate as of...

CautionMP, Thanks for the reply. Yes, the user needs to see the spreadsheet before export and import to Access. I am not familiar with the Global Excel object variable; however, I am going to research that now. Thanks again for the information. Dom

Hi All, I am having a problem with an Excel to Access import (2003). I have a form with two command buttons. The first button when clicked opens the Excel spreadsheet for viewing before it is sent to an Access table. The second command button, deletes all the records in the Access table and...

ddiamond, Thanks for the quick accurate reply. That did it. Dom

Hi everyone, I have a question about command Shell. I have a command button on an Access 2003 form. The code on the on click event works but Excel does not open maximized. I only get a excel icon on the toolbar showing Excel is open. When I click the toolbar icon, the correct Excel file is...