Recent content by jlcford

  1. J

    Email from Access 2007 & and set [from] in VB code

    Thanks jlcford
  2. J

    Email from Access 2007 & and set [from] in VB code

    Is there anyway to change to a group mailbox from the default mailbox when using Microsoft Exchange Server to send batch emails from Access 2007 using VB code. I can't find a reference to [From] that works anywhere in a line of code like below: DoCmd.SendObject acSendReport, "MyReportName"...
  3. J

    Microsoft Outlook sending email in Access 2007 with selection of "From"

    I have an Access 2007 database that I send mutiple batch emails from. The users that send these emails sign on with an Outlook exchange server with their personal email account which is their default account and also another group mailbox account. I would like to be able to send the emails...
  4. J

    Merging Tables

    I am working with a database that I was given, not one I design so I totally agree with your criticism about the normalization issues. The 1st table is made from a query I wrote to sum the costs of repairs on jobs that only have the concatenated key which is made up of 4 fields. A bit...
  5. J

    Merging Tables

    I have two tables that I need to merge into one table. One table has the following fields: My first table is a Select Distinct table from my second table id (autonumber primary key), Bill_No, Equip_Int, Equip_Nbr, Repair_Dt, Repair_Order_No, SumOfAmt_Billed My second table unfortunately...
  6. J

    Listbox with Select Distinct Record to be Expand on a Field on New Form

    I currently have a listbox with multiple records that are listed as "Select Distinct". I would like to enable a double click event on a particular Distinct record in the listbox and open a second form which displays all the records that are combined in the "Select Distinct" record. To complicate...
  7. J

    Using DSum in Query

    Thx - It worked. jlcford
  8. J

    Using DSum in Query

    When I do that it prompts me to enter the individual Record_Order_No. I don't want an individual record count, I want a new table or query output of all the records sums as my output. Thats were I am running into the problem. jlcford
  9. J

    Using DSum in Query

    I have a Query with 2 fields. The first field has Record_Order_No with multiple identical entries. The field is text data. The second field has the Cost of each Record_Order_No which is currency data. I want to be able to sum each Record_Order_No costs and output it to another table or Ouery...
See more
Back
Top Bottom