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!

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

Search results for query: *

  1. YvonneNina

    Send an Email from Access 2003 Form

    In Access 2000 (Windows) I had a code which enabled me to open an Email Form of Outlook by (double)klicking on the Email Address written in the Access form. It went: Private Sub Email_Adresse_DblClick(Cancel As Integer) On Error Resume Next DoCmd.SendObject acSendNoObject, , acFormatRTF...
  2. YvonneNina

    Auto Increment UniqueIdentifyer MySQL

    I have no timestamp column and I am reviewing the data through a form.
  3. YvonneNina

    Auto Increment UniqueIdentifyer MySQL

    Dear all, I have exported an Access Database into SQL. Apparently no problem. I had a primary key field that autoincremented, which I exported to MySQL. The problem is: when I create new Data with my Access frontend, the record will appear only after closing and reopening the table. Why does the...
  4. YvonneNina

    DoCmd.SendObject acSendNoObject, , ... does not open Outlook

    Thank you for replying, my problem is, the user may wish to send three emails to three different persons via the email field. Outlook will open every time he sends a new email. In the end, he will have sent the three emails and Outlook will be open three times. What I would like is NOT to open...
  5. YvonneNina

    DoCmd.SendObject acSendNoObject, , ... does not open Outlook

    Thank you, Zeroanarchy for your hint. I tried this, in fact it opens outlook, but it opens it as many times as I double klick my field. Is there a way to prevent this?
  6. YvonneNina

    Printing a Specific Report with a Command Button on a Form

    Hi, MattMeat, I am working with the German Version of Access so maybe there will be strange words I use: Create a Macro with the command: 'open report'. In the field 'condition' in the bottom (it should be the fourth and last field), you write: [Field]=[Forms]![Name of form].[Field]. Field must...
  7. YvonneNina

    Start Fax application from Access form?

    Hi, a problem which probably isn't new to you but I didn't find a solution to it. I have a Text Box. On double click, I would like it to open the Fax application (Tobit) and to insert the number in the appropriate Tobit form. How would I do this? Thank you in advance YvonneNina
  8. YvonneNina

    DoCmd.SendObject acSendNoObject, , ... does not open Outlook

    Hi jhall 156 and thank you for replying so quickly. I thought of this too, the problem is, in the Windows Settings, Outlook IS the default mail application, but Tobit is installed as the default fax programm and does have this image messaging application which infact is a mail program too...
  9. YvonneNina

    DoCmd.SendObject acSendNoObject, , ... does not open Outlook

    Hi, maybe someone can help me with this: I have a form with a field. For the double click event I have the following code: DoCmd.SendObject acSendNoObject, , acFormatRTF, Me![Email], , , , , -1, where Email is the field. The problem is, there is a 'Tobit image messaging programm installed on...
  10. YvonneNina

    Filtered Records of a form = Records of a Report?

    Hey, what a hint!!! After using filter by form, the button opens the report, which,in the Event On Open runs the Macro AppyFilter with =Forms![My form].Filter as condition. This is it! I hope my english is understandable. My Access is the German Version. Thanks again for the hint
  11. YvonneNina

    Filtered Records of a form = Records of a Report?

    Hi and thank you, jebry, the problem is, I am doing something wrong, because it does not work. I made a button like you said, clicked on the button in the form based on a query, I opened the report (based on the same query) and I got the unfiltered records. Another help? Thanks in advance
  12. YvonneNina

    Filtered Records of a form = Records of a Report?

    Is it possible to use the filtered records of a form as the records to appear in a Report, and this without saving the filter as query? There are sbout 50 fields in the form and I don't want to go through a query that does forms![My form].[Myfield] for each of the 50 fields. Please help !
  13. YvonneNina

    Use field data as email adress and start Outlook

    Thank you, Lonnie, I have used it for the simple text field. I set the hyperlink on 'no' and used the code also for double-click, with a good reason: simple clicking allows to change the content of the field without using right botton stories. Thank you again. Maybe you can help me on a...
  14. YvonneNina

    Export a report to Word and give the document the record number?

    Status: I use access datas (Name, Adress, Date, ref....) as basis for letters written in Word. I have a button 'new letter' which creates a new record, giving the record a new number. Then it opens a report and exports the report as rft file. Problem: How can I automatically give the document a...
  15. YvonneNina

    Use field data as email adress and start Outlook

    Maybe my English will not be correct, since I am using the German version of Access: Here comes the problem: When I enter an email adress in my text field (defined as hyperlink), clicking on the entry makes the browser start, not outlook. I would have to open the hyperlink property box and set...

Part and Inventory Search

Back
Top