IceBower
Last Activity: Sep 19 '08, 12:41 PM
Joined: Dec 27 '07
Location:
-
If your trying to do what i think you are then the .Update should sufice. There shouldnt be any need to enter 'Edit Mode' -
Isecretl, sorry about the late reply. If you replace 'important' with 'inbox' then this code shoudl work.
As for stopping it replicating the messages, the best way to do this would be to create a record set in VB and hard code the query aswell, that way you could check if the table already contains another similar email.
If you need help writing this code then just let me know...Leave a comment:
-
I think i get what your after...
Try an SQL like this:
...Code:INSERT INTO knowledge_tbl ( Field Name ) SELECT inbox.Contents FROM inbox WHERE ((Important.subject)="what your filtering by")
Leave a comment:
-
Have you tried using the link table wizard instead? (select outlook as the file type.) Link your outlook inbox to the application that way then you can set up queries and coding to get the data you require.Leave a comment:
-
I think this should work:
Code:TextBox.Text = Left(TextBox.Text, (Len(TextBox.Text) - 4))
Leave a comment:
-
Alkeshnayak,
If they are using bound fields (which this sounds like they are). Wouldnt this risk deleting the data from the first record ratehr then creating a new one?...Leave a comment:
-
Thanks mike, that seems to make sense and should work without to much effort.
Debasisdas, I would usually agree. I always keep the front end of my work seprate from the datasheets (and i tend to opt for Access over excel aswell). unfortunatly this is an existing projest that i have been asked to work on so my options are more limited.
Thanks both for your helpfull comments!
Bower...Leave a comment:
-
Is this possible?
I have an excel sheet distributed to mulitple people accross the country. If I want to update the VBA code behind their copys is there anyway of doing it via distributing another excel sheet to change it remotly? I do not want to have to collect in all the copys and each one varies slightly on the data it contains so i cant simply send out a replacement... -
you shouldnt need to use any VB to do this, you can set up a rule (tools>rules and alerts) to do this for you.
hope this helps
Bower...Leave a comment:
-
This could do with tidyign up a bit but it seems to do the job!
...Code:Dim oOutlook As Outlook.Application Dim oNs As Outlook.NameSpace Dim oFldr As Outlook.MAPIFolder Dim oAttachments As Outlook.Attachments Dim oAttachment As Outlook.Attachment Dim iMsgCount As Integer Dim oMessage As Outlook.MailItem Dim iCtr As Long, iAttachCnt As Long Dim sFileNames
Leave a comment:
-
What im ideally looking for is some Access code that will allow me to detach the files from emails (linking them using the table mentioned) and save them to a local drive....Leave a comment:
-
Access & Outlook
Hi all,
Im creating a database which has a table linked to an email account. so far i can only get the table to show wether or not an email has an attachment but i cant find away of opening/importing them.
Anyone know how? -
Hi,
Thanks for that but iv just found a way of doing it before i checked the board again.
[code=vb]
Shell "rundll32.e xe C:\WINDOWS\syst em32\shimgvw.dl l,ImageView_Ful lscreen " & FILE NAME
[/code]
Thanks anyway!...Leave a comment:
-
Minion,
The problem i am having is that i am trying to do this through Access VBA code. Something like the ShellEx command would do but i am unsure how i can specify a program... Any ideas?...Leave a comment:
-
Opening Tiff Files in Sepecific Program ~ Urgernt Help Needed!!!
I need the code to open a TIF file in the Microsoft picture and fax viewer without setting this program as the default program for TIF files.
Does anyone know this?
No activity results to display
Leave a comment: