Printable View
:afrog: I am trying to tie an actual form in Microsoft Outlook with another form in my visual basic program. I dont really know much about visual basic and I dont know what properties in the object browser to select inorder to tell the program what i am trying to do. I dont know if this properly explains my problem.
thanks will apreciate any responces :confused:
please ignore the silly faces
thanks
welcome to the Forums.
Why do you need to use 2 forms? Couldnt you just get the info out of Outlook directly to populate your VB6 form or is there
some other reason?
Quote:
Originally Posted by RobDog888
Thanks,
I am using the foms to create electronic forms in outlook to replace the paper forms around the office, the only catch is that each time the forms are sent back from the employees to the boss, the boss needs a copy of the form in a database in Microsoft Acess. I need to learn how to use the macros in Outlook to create this. Thanks
Quote:
Originally Posted by RobDog888
Acutally reading your comment again, I dont really know how to do that using the object borwser, i cant figure out what objects are in the outlook library, or how the whole thing works. I am reading a begineers book now. I am really bad at VB right now. I will apreciate any help and suggestions
anyone, i am desperate, i need some kind of lead. I am a begineer.
Did you Publically publish your forms to the Exchange db?
Custom Outlook Forms need VB Script behind the form to populate any combos or other controls and to do validations etc.
How is the data getting in to the forms? Manually typing it in or selecting from combos, etc.
Quote:
Originally Posted by RobDog888
The data is getting to the forms through manual typing and then it is sent off to other people. I need the form to populate an acess database, so therefore i need to know how to populate the acess database and the macro form? i dont really know what to do , i am a begineer, and have been in the books for a whole day trying to learn to program! What do you think that I should do? :confused:
Modify the OL form to connect to the database and store the info.... then you don't need to worry about one form reading another....
Tg
do u know how to modify the form so that it could connect to a database?Quote:
Originally Posted by techgnome
thanks
does any one know how to do this? Anyone. I could really use some help on this project.Quote:
Originally Posted by tejiri
Thanks
I used ta could..... about 10 years or so ago.... today not so much. Basically you'll need to open the form in design mode and from there modify the code behind it - it's much like working a macro in Excel - using VBA.
I wish I could be more help, but it's been too long since I've done anything like that. I do remember though, that the form will need to be published to the Exchange mail server forms library in order to ensure everyone gets it.
Tg
Does u remember what the visual basic objects names for Microsoft office forms are called? or in what library they are located. I understand that I have to alter the macro; the problem is that I can’t find the object library for outlook forms. I wonder if there is another way to tackle this problemQuote:
Originally Posted by techgnome
does anyone know how to do this, I am just looking for some sample code, and then I can go from there?
Thanks any responce would be apreciated. I really need this.
Either way, you are creating an Outlook Object of what kind? MailItem, ContactItem, AppointmentItem, etc.
If you do want to write from the form then you need to write out the VB Script and event behind the form. Whats the form like?
it is a Mail Item. I am trying to call up to the textboxes on the Outlook Form. so that i could map them to a particular cell in an access table. the form is attached.Quote:
Originally Posted by RobDog888
Thanks
The real problem is that i cannot find the text box and drop box objects ect. that are in an oulook customized form. I am stumped . :sick:Quote:
Originally Posted by tejiri
If it is a MailItem with custom property items then you dont need to deal with the form in order to populate the data into/out of Access.
Which way is the data flow going to be? One way, from where to where or both ways?
i know this looks bad, but it is the first time that hav ever tried to program, could someone give me some suggestions as to how to access the textbox in my specialized Outlook form. Here is the little code that i have written, dont even know if it is coherent, but I could use some help.Wrote this as a macro. THe code simply ignores my form -Engineering, and does not look for the "Namer" field to change, i wonder what i am doing wrong. I just need a way to acess the fields in my form so that i can map them to access.
Public Sub gettext()
Dim oMail As MailItem
Dim strspname As String
Set oMail = CreateItem(olMailItem)
Dim form As FormDescription
Set form = oMail.FormDescription
strspname = InputBox("Please Enter Your Name")
Debug.Print strspname
NewMC = "IPM.Note.Engineering"
Set CurFolder = Application.ActiveExplorer.CurrentFolder
For I = 1 To CurFolder.Items.Count
Set CurItem = CurFolder.Items.Item(I)
If CurItem.MessageClass = NewMC Then
CurItem.UserProperties.Find("Namer") = strspname
CurItem.Save
End If
Next
MsgBox strspname
End Sub
Thanks for your response RobDog888Quote:
Originally Posted by RobDog888
ok, this is how it works. I a creating a form that would be put on the public server and could be accessed by anyone. Once the form is completed, the user pushes a button- " Send" and it is automatically sent to the supervisor. Once the supervisor aproves of the form. He pushes another button- "Keep", and it is automatically loaded into Access.
The dataflow is going to be in one direction. From Outlook-to- Access.
Ok, easier. You would only need to retireve the "Keep" MailItems that are in a certail folder, correct? You could create a
function in Outlook to "push" a copy of the data to an access table. If the records already exist then they would be overwritten
or possible even deleted and then just all would be added. Depends on how you need to represent items in Access.
[QUOTE=RobDog888]Ok, easier. You would only need to retireve the "Keep" MailItems that are in a certail folder, correct? You could create a
function in Outlook to "push" a copy of the data to an access table. If the records already exist then they would be overwritten
or possible even deleted and then just all would be added. Depends on how you need to represent items in Access.[/QUOTE
That makes sence. Yes all the "Keep" MailItems would be in a certain folder. The question is how do i make a function to push a copy of the data to an acess table, if i dont understand how the outlook object model relates to personalized forms? that is my problem really. i dont know what objects or methods to use.
Its all the same as regular Outlook Object except for the addition of your custom UserProperties that store your custom data.
You would want this to be invoked from a menu item click or something as real-time would not be advisable.
So you could click "Push to Access" or some other relevant caption for your menu item. Then the code would iterate through the
folder filtering just the items with the "Keep" userproperty value. You would need to write the ADO code to connect to your Access
DB and then the iteration begins.
Should sound about right for the logic?
Should sound about right for the logic?[/color][/QUOTE]
yes the logic sounds right, but when you say menu item click, does that mean that i would write a code, that would add something to the outlook menu, which would launch the macro?
I am also confused when you say that the objects are still the same, because i tried to write a test form with only one text box, and ran a small macro i wrote. It did not respond to the form.
Sorry for so many questions, but I really am a begineer.
thanks again.
No problem. :) I dont write much Outlook Forms because I dont like their limitations and awkwardness or programmability.
The menu item would be added by writting an Outlook Add-In. This will also help if you need to distribute this to other systems. This is
going to take some effort and time but we can get there.
Are you familiar with ADO and databases?
no not really, but i guess that i could read up on it. Why?Quote:
Originally Posted by RobDog888
Because you are also going to need to develop your Access db since you are going to be using it as the receiving source
for your "Keep" form data.
Sure. Thanks for the suggestions, I would be reading up on this(ADO databases) next week and try to piece some code together, if i get stuck, i'll probably post my problems here. I think that for the " send " part of my program, i dont really need any programming, but for the "keep" part, i would need to write the ADODB part. well here goes.
Give me some time today and I will see what I can write up as an example of the technologies you will need at
least for the outlook part.
We have a good ADO tutorial in the DB forum. Its in one of the stickies at the top of the forum. ;)
I'll make sure I check out the ADO tutorial.
Thanks :D
Hey i have been trying to work with ADO and add-ins, right now I am trying to learn how to write a .exe file. Were you able to write up any examples?Quote:
Originally Posted by RobDog888
Thanks