Search results

  1. D

    Compact and Repair Split Database

    Is the cmdCompactTables function called as a button on your "main menu?" or is it automatically executed when the Front End is opened by a user?
  2. D

    Split database, SLOW performance

    I just manually split my Access 2003 database into a backend and frontend per: http://support.microsoft.com/?kbid=304932 Both the Front End and Back End files are on the network server. I go into the network and open the Front end directly from the server. It's taking a good 15 seconds to open...
  3. D

    Access Assigning Outlook Tasks

    I looked into setting up automatic reminders for doing things from Access. I came across this method of assigning tasks from Outlook. I should be able to assign tasks to myself and recipients from this code. However, it activates the Microsoft security warning again. Is there another method to...
  4. D

    Access to Word Automation

    This topic gave great info on going from Access -> Word!!! But how do we create tables, borders, tabbing, etc, and other types of formatting in the Word Document from Access VB? As of right now it's still a very limiting feature as it can just import straight text only. Is there a way to have...
  5. D

    Edit an Item from a ListBox ??

    Is there a way to program this for Access 2003???
  6. D

    Grabbing Table item from Form

    You're absolutely right, it's extremely inefficient since I have to go through the entire table. Luckily my table is only around 1200 entries so the search and matching is instantaneous. I actually am very unfamiliar with Visual Basic and Access so i don't know how to open a recordset on an SQL...
  7. D

    Grabbing Table item from Form

    The count just lets me know that the loop is actually "working" going through checking all the entries. What i'm after is being able to grab all the data from a specific line item entry in the subform table for that specific main form order entry. And i found out that the line items ID of the...
  8. D

    Grabbing Table item from Form

    Thanks for pointing that out. However, now that I finally get it to be able to grab values from the table in the sub form, i'm trying to match the Form number to the Subform Table ID number... and the FindFirst function is giving me this error: "Operation is not supported for this type of...
  9. D

    Grabbing Table item from Form

    Each page on the main form stores information on an order in the sub-form table. So that the main form is tied to the table Item_Line by a Relationship. However, when I try to pull values from VB code, it doesn't give me all the information from this relationship. What's going on? I created...
  10. D

    reading field in a subform using vba

    I was also wondering the same thing. How would you pull or call out every single line or values in a subform from the mainform because when he does strLine2 = rst!product & rst!price Won't this just grab the first line of the value Product & Price? Shouldn't there be some way to go...
  11. D

    Bypassing Access warning messages

    Nothing happens when i use port 587. My smtp server doesn't recognize these ports maybe?
  12. D

    Bypassing Access warning messages

    Now a new problem I started running into was trying to used the CDO to non-company emails such as yahoo, gmail, etc. When I type in a gmail address for auto email i get Run-time Error.... The server rejected one or more recipient addresses. The server response was: 550 5.7.1. Unable to relay...
  13. D

    Bypassing Access warning messages

    Thanks JR! That worked like a charm!
  14. D

    Bypassing Access warning messages

    Late binding seems awesome, I have implemented it and it works, but i don't quite understand from the code how passing parameters into the CDO function would not need the CDO 1.21 library. Can anyone clarify how this modification bypasses needing to actually reference the library? Also, how am...
  15. D

    Referencing Sub Form Items

    I have a shipping form where the user fills out To, From, Address, Tracking #'s, etc. and in it is a sub form that contains a table of all the items ordered and shipped I'm trying to do a message box that pops up if not all items are shipped. ie. items shipped < items ordered Item_Line_sub is...
  16. D

    How to open records in form view

    I'd really like to know how you did this as I want to do the same thing.
  17. D

    Sending Hyperlinks to Email

    No one knows?
  18. D

    Bypassing Access warning messages

    How do you do that?
  19. D

    Access 2003 Email as PDF

    I'm not too familiar with using Reports in Access, so I tried playing around with it but it seems Reports pull up all Form entries in a list or some arbitrarily chosen format in design wizard or whatever format one composes. I don't have any issues going from Forms -> Reports -> PDF (Lebans)...
  20. D

    New Protection Method for VBA - How did they access Outlook MAPI

    It seems like this Security Evader software is referring to the Outlook security prompt when you try to use it to send out emails. There seems to be a general method on these forums of using the CDO 1.21 library to send out emails using the SMTP server and thus avoiding the Outlook security prompt.
Back
Top Bottom