Search results

  1. C

    Easy one: Display value of combo box

    Could someone tell me the syntax for getting the value of column 2 from a combo box into a text field on a form? My main table for storing date has a field called StatusID, which gets its value from tblStatus (SELECT tblStatus.StatusID, tblStatus.Status FROM tblStatus;). The StatusID is stored...
  2. C

    Compile error - Expected variable or procedure, not module

    I’m receiving the following error message in one of my modules/procedures “Compile error - Expected variable or procedure, not module." Here’s the background and code: The module CheckForNulls checks for null values in form fields. The code is in a module because it should be available to all...
  3. C

    Email via Access when environment varies

    Still Need Urgent Help: Email via Access when environment varies Michael, thank you very much for your sample application - it's quite nice! However, my little programme does much the same thing, but behind the scenes, i.e. the To address, CC address, subject, attachment, and message are all...
  4. C

    Email via Access when environment varies

    Can someone please help with this in a hurry - just learned the Big Guy is coming in from the states for a demo of my system and we just discovered big probs with email - critical to the entire programme! The app is supposed to automatically send email (with a report attached) to people...
  5. C

    Cascade or Dependent Combo Box Woes

    If anyone was going to heed my plea for help... nevermind! I just found another post from someone who was having similar problems to me with code we had both been using as an example at http://www.fontstuff.com/access/acctut10.htm. Rich (Leo "The One") provided a sample CascCom demo...
  6. C

    Cascade or Dependent Combo Box Woes

    Hi, Gang. For my life, I can’t get my dependent combo boxes to work, despite looking at downloaded samples and reading every thread here and elsewhere. Could someone take a look and tell me what’s wrong: What needs to happen is this: When the user selects a CauseCategory in one combo box...
  7. C

    How to stop (cancel) adding a new record

    Thanks, Pat. Can you (or anyone else out there) please tell me, if I put Cancel = True in the BeforeUpdate event of the form, what else needs to be done? I have a Cancel button whose OnClick event looks like this: ------------------------ Private Sub cmdCancel_Click() On Error GoTo...
  8. C

    How to stop (cancel) adding a new record

    I can't for my life figure out how to prevent adding a record to a table when the user decides they don't want to add the record, or when they "save" the record but then decide they want to delete it. (Yes, our company has a lot of finicky and confused people.) Problem is, Access automatically...
  9. C

    Two methods for sending email?

    Thanks, however, perhaps I'm not being clear. My question isn't about which system to use, since Outlook is the only email system we use and, perhaps more importantly, I don't even know the what IIS and SMTP are. Rather, I was curious why some people send email using the code...
  10. C

    Two methods for sending email?

    Thank you for that, Kodo. Unfortunately, your recommended method won't work as we don't use an STMP thingy. And besides, the code is WAY beyond my beginner skill level - I don't feel comfortable using code that I don't understand. I, will, however, keep the code handy for when I grow up. :)...
  11. C

    Two methods for sending email?

    We use Outlook for our email. I have been using the DoCmd.SendObject to send emails automatically from Access. However, recently I've seen the following method: Dim myoutlook As Outlook.Application 'create outlook Set myoutlook = CreateObject("Outlook.Application") Set mymsg =...
Back
Top Bottom