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.

...Thanks for your help Dom Public Function SendReport(sName As String) As Boolean Dim rs As DAO.Recordset Dim strSQL As String strSQL = "SELECT * FROM EmailTable WHERE eReport = '" & sName & "'" Set rs = CurrentDb.OpenRecordset(strSQL) If rs.EOF Then 'no record for that report Set rs =...

...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 (strSQL) as 'MyReportName'" I would have expected the...

..."MyReportName" Thanks Dom Public Function SendReport(sName As String) As Boolean Dim rs As DAO.Recordset Dim strSQL As String strSQL = "SELECT * FROM EmailTable WHERE eReport = '" & sName & "'" Set rs = CurrentDb.OpenRecordset(strSQL) If rs.EOF Then 'no record for that report Set rs...

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

...End Sub Private Sub cmdImportRecords_Click() On Error GoTo Err_cmdImportRecords_Click Dim strDelete As String strDelete = "DELETE WebPAS.*, * FROM WebPAS" DoCmd.RunSQL strDelete Call ImportExcelToAccess Exit_cmdImportRecords_Click: Exit Sub Err_cmdImportRecords_Click...

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