Page 5 of 5 FirstFirst 12345
Results 61 to 66 of 66
  1. #61
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Remove the code from the report. I have already said that having it there is not logical.

    You have a type mismatch between the Customer TypeID primary and foreign key fields. This is causing the Invoice query to fail. You are saving the PK TypeID (autonumber value) into a TypeID text field in Customers. Since the TypeDesc is just a single letter, make it the PK and eliminate the autonumber PK, table join will not be needed. Fix the TypeID data in Customers table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #62
    Stephanie53 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    246
    I removed it from the report, and it still having issues. The problem I think is stemming from the button at the top where it says to PRINT INVOICE (which is needed here to send to production as they cant access the computers to get the orders created its still being done by these print outs and some of the customers are somewhere that cant receive emails I.E Oil Fields) and in the EMAIL ADDRESS (which is also needed to send to customers that do have email access) See below:
    Click image for larger version. 

Name:	Debug Report3.jpg 
Views:	5 
Size:	127.6 KB 
ID:	12135

  3. #63
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Did you fix the tables relationship?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #64
    Stephanie53 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    246
    yes I fixed the relationship of the customer and customertype showing both as numbers instead of one as text and the other as number (if this is the one your talking about ..not sure what that has to do with this issue as that is the issue i was having at the other post)

  5. #65
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The datatype mismatch contributed to the query failure which meant the report would not run. I also had to change the join type between Customers and CustomerType tables in the query from INNER.

    After those edits the query works and the report opens.

    Don't know what other post you mean that would concern the report not working.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #66
    Stephanie53 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    246
    YES I have it working now! now I will mark this solved AGAIN :-)

Page 5 of 5 FirstFirst 12345
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sending HTML files via Access to Outlook
    By Yann63 in forum Programming
    Replies: 4
    Last Post: 02-13-2014, 05:34 PM
  2. sending data into an email body - outlook
    By webisti in forum Access
    Replies: 6
    Last Post: 02-15-2012, 07:05 AM
  3. Sending Outlook E-mail - Run-time error '429'
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 03-01-2011, 09:30 AM
  4. Replies: 1
    Last Post: 03-09-2006, 01:50 PM
  5. Sending email via Outlook (and Exchange2003) from Access2003
    By Larry Elfenbein in forum Programming
    Replies: 0
    Last Post: 11-15-2005, 09:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums