Search results

  1. E

    CDO email troubleshooting

    Thanks--I get that, but these elderly ladies who do well to have one email address aren't likely to.
  2. E

    CDO email troubleshooting

    A valid sending email setting isn't the problem--the reply-to address is. I can send using the gmail account or the webhost account and all is happy, so long as the reply-to address isn't gmail, hotmail, etc.
  3. E

    CDO email troubleshooting

    DB for organization of 150 members (whose name and email address were entered on their member screen). I set up an email form that allowed the user (just 4 or 5 officers use it) to put a check in a Send Email box for the members to whom she wished to send an email. The vba code makes use of...
  4. E

    Attach an existing file to an email

    ridders, thanks for the test db--I took a look at it but it doesn't help me figure out if it is possible to attach a file from a ftp folder. June, I agree about the CDO. This db already has a cdo routine that works, so if I can figure out the ftp thing I can adapt it.
  5. E

    Attach an existing file to an email

    I know how to set up a macro that opens an email in which I can fill in the intended recipient's email address and edit the message body and which attaches an Access report as a pdf. I would like to be able to set up the same email (probably need to do it in vba) but attach an existing pdf that...
  6. E

    CDO failure

    ridders, I assumed that is the case. However, when the email settings match the settings in the working Outlook, I am not sure what to do next.
  7. E

    CDO failure

    I have now sent your tester to the user with the problem. I cannot test from here, as I have no similar problem with my own isp. Hope this will give us some clues! Thank you.
  8. E

    CDO failure

    I have a db that has been running several years with a cdo email module. The main user of this part of the program uses comcast isp @nc.rr.com. No problems for at least 3 years. Two weeks ago she began having email problems. With tech help she changed from smtp port 25 to port 587 and added...
  9. E

    How to troubleshoot cdo email

    My CDO mail routine has been working great for several years. The user fills in from and to addresses, subject and body, then before hitting Send button, must choose their own credentials from a table (where they have previously entered username, pw, outgoing smtp, port, etc.). This...
  10. E

    ODBC fail to connect error

    Vlad, your deployment solution is nice, but in this instance it isn't the answer. My solution has been to open a large popup upon opening, which notifies the user that a newer version is available to be downloaded from our ftp site (which they can manage, since that is the way they got the thing...
  11. E

    ODBC fail to connect error

    My db's be is an odbc mysql db. I have added a login password to the program and wish to force users to download the new version from our ftp site. The autoexec macro calls a vba openprog module, in which the odbc connection string is set up and then opened with the following: Set MyODBCdb =...
  12. E

    Encryption

    Not sure this question belongs here. I need to figure out a way to encrypt email account passwords in a db where all data is held in be odbc mysql tables. Is there a way? I can show asterisks in the data input field, but it goes into the table unencrypted.
  13. E

    Force text box requery

    Is there a way to trigger requery of a dlookup text box value when a popup has changed the underlying table value? I have a similar situation when form A displays a couple of dcount text values. A button on form A opens Form B where underlying data may be changed. In that instance I have...
  14. E

    Crosstab alternate row color

    Is there any way to use an alternate row color in a crosstab report? It ignores my alternate color choice. Sorry--I recreated the report with the wizard and it is now working!
  15. E

    Corrupted db

    The_Doc_Man I thank you. This morning when they opened I found out another user had begun using the db from another computer via a shortcut. Anyway, I have now put a copy of the FE on each computer. I (with your help) assume I have the problem solved.
  16. E

    Corrupted db

    I need expert opinion as to where to begin troubleshooting. Customer has both FE and BE on a server and runs FE via shortcut on her desktop. Today, out of the blue, it won't open, saying it cannot find the opening screen's form. I connect and look at the FE (by importing it into a new db...
  17. E

    Error 3197 can't update because another user...

    Never mind--it is okay now, not that I totally understand why. When I imported all from the original db, the mysql tables came in with the link through the odbc machine connection. I deleted all tables and imported them again from the oriiginal db. This time they came in with the full mysql...
  18. E

    Error 3197 can't update because another user...

    ...but there isn't another user! My db is written in 2010 where at least mouse wheel works! Data tables are linked MySql tables, all with unique id#'s and timestamps. This is the fourth year this db has been working. After lots of changes and updates, I decided to create a new db and import...
  19. E

    Help! DNS-less connections not working

    For several years my DNS-less connections have been working smoothly. Suddenly they aren't. Tables are all MySQL tables at host server. Nothing has changed there, and nothing has changed in the vba. Dim MyConnectionString As String Dim MyODBCdb As Variant Dim dbs As Database Set dbs =...
  20. E

    Get list of files names on a ftp server

    ashleedawg, I looked at the slick File Transfer app but can't figure out how to adapt it to getting a list of files on the ftp site in question. I understand how to ftp into the site and how to upload files--I am the one who has put the files there in the first place-it only works if I use the...
Back
Top Bottom