Search results for query: *

Simple data setup ... each record is a sales lead. Each record includes a result column - sold or unsold. Simple example might look like ... Lead Result 6/1/10 Open 6/2/10 Sold 6/3/10 Sold 6/4/10 Unsold I would like a "report" result like this ... CountOfLead...

I want to duplicate a record in the same table - all the data except the key field, of course. The append query is easy enough. For example, here I am duplicating record #2 in my test table called zzTblJunk: INSERT INTO zzTblJunk ( Field1, Field2, Field3 ) SELECT zzTblJunk.Field1...

Hello Amazingly Smart People, I did a search and found the answer to my question. However, the answer is excessively slow. I'm wondering if you know a better way. Need: To delete records from TblA when the key value of the records does not appear in several related tables. Solution: DELETE *...

This seems like it should be simple, but for some reason it's not (for me) ... Table1: RecID Client 1 A 2 B 3 C Table2: RecID Client 1 D 2 A 3 E As you can see Client A appears in both tables, but the other clients do not. How do I query the Client value...

Let's say I have a simple sales order table like ... SaleID Agent SaleDate 1 A1 7/6/07 2 B2 7/25/07 3 A1 8/12/07 4 C3 8/14/07 5 C3 9/6/07 6 A1 9/10/07 And I want to count each agent's sales within the quarter by month. This...

Thanks again to Remou for the response to dragging and dropping an Outlook email into a memo field. Now ... what about a pdf file? I've tried dropping it onto all field types (I think all). Nothing occurs that would indicate a codable event has taken place. Why do this? We currently "attach"...

I may need professional help for this, but thought I'd start here ... In our Access database we make notes of client activity. Some of that activity involves receiving email from and sending email to clients. We use Outlook. I want to save these emails and allow the user to link to them from...

Simplified version of the challenge ... Clients table has a single field - ClientID Policies table has 3 fields - PolicyID, ClientID, ProductID Clients has a one to many relationship with Policies based on ClientID, obviously. I want a list of ClientIDs from Clients where a record does not...

Hello, Last week I posted a problem and was advised to do better error trapping. I've done that, so here is the problem again... I've been using code for an Outlook object - which I found through this forum - for years with no problems. However all my users had full versions of Access on...

Hello, I've been using code for an Outlook object - which I found through this forum - for years with no problems. However all my users had full versions of Access on their machines. Now they have only runtime versions of Access. And the function creates a runtime error. Note: I and 2 other...

Hi, The ActiveDocument.PrintOut command in the sub below generates an error. What is the easiest way to print a Word doc from within Access (VBA) that involves no merging? Just need to print the doc. Thanks! Public Sub PrintWordDoc(ByVal strDocPathAndName As String) On Error GoTo...

Using Form.Dirty I can tell if the current form record has been edited and not yet saved. I cannot find a similar property for a control on the form. I'm trapping the Escape key with KeyPreview events and want to be able to tell if the user is editing the current control when they press...

Frustrating problem. I'm using Access 2002, so you know. Table includes a field with date/times in it. For example ... 6/18/05 4:32:55 PM 6/19/05 5:17:12 PM etc. When I query this field with the Between...And operator as criteria, the last date of the operator does NOT capture records with...

On a form, by setting KeyPreview to Yes and using the KeyUp, KeyDown or KeyPress events, I can trap a user who presses the Escape key. I do this so a user cannot avoid the form validations by pressing Escape when the record is dirty. I prompt for their intentions and either wipe out the entry...

I'm technically oriented but new with html and frontpage. This is for my company Intranet. Anybody know how to setup a hyperlink so when one of my staff clicks it, it launches a new e-mail in Outlook AND attaches a specific file to the e-mail. The purpose is to easily send a consumer report...

I have a combo box on a form based on an inner join query, as follows: cboFindProspect.RowSource = SELECT tblProspects.ProspectID, SalesAttemptID FROM tblProspects INNER JOIN tblSalesAttempts ON tblProspects.ProspectID=tblSalesAttempts.ProspectID; tblProspects is the one side and...

Hi, In Access 2000, running on Windows 2K, the following code in the BeforeUpdate field of a combo box prevents the update when the condition is met and then restores the original value in the box ... If Not IsNull(Me.cboProduct.OldValue) Then strMsg = "SORRY - THAT'S NOT ALLOWED!"...

I'm creating text in code and feeding it to text boxes on forms. For example, taking name and address fields and creating an address block in one text box on a form. To get line feeds I use the vbCr, but it shows up as boxes (character indicators) in the text box instead of executing the...

What I consider "normal" behavior is when data is typed into a field on a form or a selection is made in a combo box, pressing the Escape key once will Undo the typing or the selection. For most fields on my form the Escape key does just that. But there are several fields on the form...

Hi, I'm generating a vacation report for each of my employees to be e-mailed to them in house. The code is below. The recordset is rendered invalid by the OutputTo command. (I originally thought it was the call to the e-mail function, but it's not.) Becuase the report is different for each...