Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Kretzer

  1. Kretzer

    Stand Alone Access Application

    Hi, the only way I can think of is using a runtime Version of Access. That means you would have to buy a runtime Development kit which is not quite cheap. I don't know exactly how much it would cost but you can probably try ebay and have a look there. As I understand - compiled as a runtime...
  2. Kretzer

    relating to several axes of an diagram with vba

    Hi, found the answer! Refering to the secondary Y-Axes works like this: Me.DiagramName.axes(2, 2).maximumscale = value Maybe someone else needes this answer aswell ;-) Martin
  3. Kretzer

    relating to several axes of an diagram with vba

    Hi, my problem was nearly solves with this Thread:thread703-538743 Now I know that I can set the maximumsclae of the Y-Aches of an Diagram by using: Me.Ranking_VOFI.axes(2).maximumscale = 10 So what i now need to know is. How to reference a second Y-Axes. The Diagram in my report owns...
  4. Kretzer

    opening an excel sheet from Access

    Hi, i'm trying to open an access workbook and want to jump to an special sheet inside that workbook. rs is a DAO.recordset and delivers the relative path of the xls file. lst_Auswahl is a list box where an id is selecte. This ID is similar to the name of the sheet which shall be opened. I try...
  5. Kretzer

    Controling Notes via VBA?

    Hi, I found the solution it is as that simple... Instead using maildoc.from "emailadress" you simply have to use maildoc.principal "emailadress" That's it. Thank you anyway. Martin
  6. Kretzer

    Controling Notes via VBA?

    Alright, I think I still don't get it right. Once more the situation here: There is an Access DB. Approxiamately 5 people will work with this Database. A Function of this DB is to send emails. What I can do so far is send emails, attach files and so on BUT: the when the receipient ansers...
  7. Kretzer

    Controling Notes via VBA?

    Hi Pascal, thanky for your efforts. Unluckily i do not hav any experiences in programming Notes. My aim is to realise this email thing from Access via VBA. So it would help me a lot more if you would have any kind of code example for me. Yesterday I tried a lot and was quite frustrated. I...
  8. Kretzer

    Controling Notes via VBA?

    Hi, concerning Lotus Notes 5. What is working so far: We can create emails out of MS Access and send them using Lotus Notes, attach attachments and so on. What is not working : We would like to change the email address of the sender. So we want to create an extra email postbox for maybe 5...
  9. Kretzer

    IE6 and popup windows

    Hi, are there any known issues concerning IE6 and popupwindows? The thing is that my onclick event will be processed in a non popup window but won't be processed in a popup window.. The code example: 1) the click event <form action=""> <input name="Update" type="button" id="Update"...
  10. Kretzer

    No Connection to Access

    Hi, solved my own problem. It works fine here like this: strdb = "Data Source=" & server.mappath("user.mdb") set conn =server.CreateObject("Adodb.connection") strconn = "Provider=Microsoft.jet.oledb.4.0;" & strdb conn.open strconn Martin
  11. Kretzer

    No Connection to Access

    Hi, I asume that this will be a mistake quite easy to solve for some of you. My piece of code looks like this: strconn ="Driver={Microsoft Access Driver (*.mdb)};Dbq=\\Otdesbwelhttp\clc-mod\cop\cop-test\user.mdb;Uid=Admin;Pwd=;" set conn = server.createobject("adodb.connection") conn.open...
  12. Kretzer

    design questions concerning a manual cross table

    Hi, i have to do a manual cross table. I understood the logic behind it. My question now is belonging to the design. I do have several groups. The details are switched off and the only thing you see are the summary fields of the group. Thats how I get my numbers. The thing is that sometimes 2...
  13. Kretzer

    implode.dll - missing

    After installin CR again everything works fine. But to answer your questions: I did not find the file on my hard disk ans there was absolutely nobody I knew with CR installed. So I think this was a quick solution... Thank you nevertheless.. Martin
  14. Kretzer

    implode.dll - missing

    Hi, after starting my computer again - Crystal Reports 8.5 is missing the &quot;implode.dll&quot; and can't open the view which is needed for the report. Do I have to install CR again? Martin
  15. Kretzer

    Access data refresh error

    Hi cord, in the database menu there is a point called &quot;check database everytime&quot; or soomething like that (I do not have Crystal installed here so I can't look it up for you). The thing is that if this point is checked. Crystal really checks the database everytime you repaint the...

Part and Inventory Search

Back
Top