Search results

  1. T

    Outlook Email from MS Access, a new one.

    Thank you very much for your time. This code would not compile for me. Darn.
  2. T

    Outlook Email from MS Access, a new one.

    Thank you very much for your help. This code compiles, but I get a smilar error. In the same location (this time the Set MyMail = MyOutlook.CreateItem(olMailItem) line). The error is... Run-time Error 424 Object Required. Shoot, I will keep searching, thank you!
  3. T

    Outlook Email from MS Access, a new one.

    I have the reference... "Microsoft Outlook 11.0 Object Library" selected. Before I selected this reference, the two objected I "dimed" gave an error. The other references I have are... Visual Basic For Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DAO 3.6 Object...
  4. T

    Outlook Email from MS Access, a new one.

    :) Sorry, I have a new question for the MS Access open up an Outlook E-Mail experts. So I decided to start a new thread. I have an MS Access database, that in the past opened up and created a new Outlook e-mail message just fine. All of a sudden it quit working. I believe it was the move...
  5. T

    Adobe - Bound Object - OLE Server Error

    I did Search this forum before posting. I wanted to make sure to not add anything new. There was little regarding this error, and nothing specific to Adobe that was answered in the past. I have also searched the internet (via Google) and on the Microsoft site. Anything that was close to a...
  6. T

    Adobe - Bound Object - OLE Server Error

    Thank you for your help. I have searched the internet and tried a few different things. I went to my Control Panel and Repaired my Office 2003 (which required me to restart my machine). I also ran the "Detect and Repair" option under the Adobe Acrobat Reader "Help" menu. I then disabled my...
  7. T

    Adobe - Bound Object - OLE Server Error

    I have the strangest error. I have used a OLE Bound Object, so I could create a link to some .PDF files. Everything works great, and I was ready to roll it out to the users (boy will they be excited), when I noticed a silly error I could not get rid of. After closing the .PDF file (which...
  8. T

    Strange ODBC error

    I am getting a very strange ODBC error, when connecting to a SQL database. There already was an MS Access DB, connected correctly to a SQL back-end. I copied this database, removed the ODBC links, then re-linked to the new SQL database correctly (or was done in the past). I could see the data...
  9. T

    New Page Issue in Crystal .Net

    Never mind everyone, you can even delete both threads. I forgot to set the variable (x) in a forumula field that counts when the details section is printed. I did this on both the 8.5 and XI versions, but forgot on the .Net version. Now I have this added to the .Net version it works perfectly.
  10. T

    New Page Issue in Crystal .Net

    I am having difficulting duplicating a function from Crystal 8.5 and Crystal XI (works in both versions) in the .Net Crystal environment. The functionality forces a new page after the Group Footer is printed the last time. In Crystal 8.5 and Crystal XI the following code works just fine...
  11. T

    Third Party Control - Kodak Image Viewer

    All the users having the problem are on 2000. But some of the users on 2000 are also able to use the control correctly. All the XP users are able to use the control correctly. Very bizzare issue, thank you for your time.
  12. T

    Third Party Control - Kodak Image Viewer

    I have a database that was built by some users, long before I came to my current job location (oh yes, one of those fun issues), and have run into an error that is involving a 3rd party tool, and is tough to duplicate. There is an ocx control named "Kodak Image Thumbnail control" the path is...
  13. T

    Code too large for procedure

    MS Access is all we have to go with. It has a SQL back-end. If worse comes to worse, and I cannot find the answers to my questions above, I will have to limit the fields the users search against. The tables are normalized as much as possible. It is a very simple structure. 1 main table...
  14. T

    Code too large for procedure

    I have never broken my code up into various code modules before. I know this is a very quick way to write repeatitive code. But if someone can give an example of the following, I believe I can figure it out.... Take a value from a text box on a form (in my case multiple text boxes). Pass...
  15. T

    Code too large for procedure

    The users wanted to search against MANY fields, on a form and 6 subforms. (about 100 fields in total). So I am going through and building a WHERE STRING based on what is entered in the many fields. I did not realize this was even possible. If I cannot find a work around, I will have to limit...
  16. T

    Code too large for procedure

    I have a large search form, in which I am building a query in the code. I went to compile the code, and was suprised to receive the error "Code too long for procedure". I had no idea there was a limit, but now I know. So, I believe I will have to break this code up into chunks, stored on at...
  17. T

    Zoom function

    I have taken great advantage over coding in the "Zoom function" when a user double clicks on a large text box, so data entry is easier (for memo fields and such). On the double click event, I add the following code: SendKeys "{+F2}", True Works great. Only problem is, one user discovered if...
  18. T

    List Box Text Selection

    You are correct. The users just wanted a list box originally, so they could see a few columns of information for each row (and yes this can be added to a drop down combo box as well). The users liked the look of the list box, so I was just trying to find a way to make it work. If nothing else...
  19. T

    List Box Text Selection

    A few weeks ago I had a post in which I asked how a user could type in the text value of a list of selections in a list box, and arrive to that selection. Such as if they type in "A" then "B", it goes to "Abby" rather than "Aaron" then "Ben". It was answered that this was not possible in MS...
  20. T

    Goto specific record in recordset

    Never mind, I found the code in another database, I asked prematurely. Sorry for the post, feel free to delete if you want. If you would prefer I post the code instead, let me know. Thank you, T.J.
Back
Top Bottom