Search results for query: *

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

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

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

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

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

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

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

Hi Everyone, I have a PC running XP PRO and Windows 2003. On the PC there are three Profiles, Administration, Guest, and USER1. When I look at the Profiles of the three accounts, the first two are a little over one Meg in size. However, the third account (the most used) is over 23 Meg. Can...

We are running Windows Server 2003, Terminal Server, for about 25 employees. Currently, if there is no activity on a workstaion the user is kicked out and must log back in. Unfortunately, this setting is about 10 minutes and we would like it to be 30 minutes of inactivity. In addition, the...

Hi Everyone, I am attaching to an old FoxPro database using ODBC. I need to select all the records in the lname field that begin with a *. I am having some trouble here since the * is default for wildcard in Access. Can anyone tell me how to select all records in the lname field that begin...

Hello everyone. I have a list of employees in a table called tblReport. In this table I have four fields. Id autonumber Name text StartDate date/time TermDate date/time I have a second table called tblBillableMonth which has two fields Id autonumber DateID date/time The DateID contains a...

Hi Everyone, I have a form that has several command buttons that when selected act as a filter. The problem I have is if there are no records for the select button I need a way to pop up a message saying No Records Found. This is how the code looks behind each button: Private Sub...

Hi everyone, I have a main form (frmMaster) that opens and then opens a hidden form (frmCalculations)that holds a bunch of calculations. On frmMaster I have a command button that opens anther form (frmHourandSalary), which takes data from the main form, populates some fields on the newly opened...

Hi everyone, I have an option group with two options (With Health Care and Without Health Care) I also have an option group with three options, if a person has Health Care they could be one of the three (Single, Parent and Child, or Parent and Spouse) I am trying to use a multiple IIF statment...

Hi everyone, I am trying to do something similar to thread702-940780, but keep getting an error. I have a form that has an option group with 6 options. What I want the form to do on open is show all records. If one of the 6 options is selected, then filter the records for that specific...

Hi everyone, I have an Access application that sends email via a command button on a form. This works fine. What I am wondering is if there are commands in access to format the text being sent to outlook for Bold, Font Size, etc. In the code below, I would be bolding and resizing the headings...

Hi everyone, I have an Access 2003 database that provided a button on a form that sends email to a list of recipients. This works okay. The next step is to have the code update a YES/NO filed in a table after the email is sent. This is what does not work. In the code below. I receive the...

Hi everyone, I have a question that we simply cannot seem to get a straight answer too. We are a small company (25 employees) and are using a new service from FrontBridge to handle our spam. We also journal our email in-house on our server. What we want to do is journal our email to two...

Hi all, I have a function that creates a file and saves it. The file is FDF format used to import data to a PDF form. Currently the file is created, notepad opens to view the file, and then I can manually exit the FDF file. Then I must go to the saved FDF file and double click it to open and...