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...
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...
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...
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?
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...
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
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...
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...
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
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
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 !
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.