Search results for query: *

Hi hneal98 on the onclick/ondblclick event of any object in the form. I have a field called CDID (Contact Diary ID), if i dble click it, it opens the Diary note form of that no. As both my subforms were in the same Main form i had to call it independently but relative to the main they are...

Hi Hneal98, sorted. If your interested here is the code: If Me.Parent.Name = "FormA" Then Msgbox "Hello" ElseIf Me.Parent.Name = "FormB" Then Msgbox "Hello World" End If

Hi Hneal98, Sorry, I haven't made myself sufficiently clear. Let me try again.. sorry 3 Forms. Form A, Form B, MySubform "MySubform" has a field called CDID. When dble clicked, it gives msg "Hello". Naturally whatever main form it is embedded into, when I doubleclick that field in the...

Hi, not sure how hard this is to do. Scenari Form A and Form B both with same field CDID If i dbl click FormA CDID i get msgbox "Hello" If I dbl click FormB CDID i get msgbox "Hello" what code would i need in order to get FormA dble click CDID to get msgbox "Hello" but on FormB dble click...

hi Prog! do i put that on the onclick event of my button or the oncurrent event of the subform in question? Thanks for replying regards donna aka freespirit

Hi all I have a main form with 3 subforms. Subform 1 being the biggest form. I have a button on it that refreshes the form data of Subform one, but how do i get it to refresh the form data of subforms 2 & 3. I used the Docmd.repaintobject cmd referring to the forms but i just keep getting an...

Hi anyone and everyone.. I have a simple contacts form, Name, address, telephone no and fax number. I want to click a button that activates XP's built in fax program and for it to automatically include my contacts fax number from my form. Is this possible? At the moment, I successfully send...

Guys yr great.. I have Office 2002 and the full install of Access. I couldn't find Commdlg.dll and the Microsoft Common Dialog Control v6 either in my references Library either. But it doesn't matter cos the code, all though Lengthy, that i pasted above allows me to have 6 Links in a doc each...

Hi all, Desperate times... ive search the other threads and came up with one solution that offered alternative button to open link... but how do i create a button that opens the Folders window dialogue to enable me to select a file then store the path in my field that I can just click and my...

Hi PHV, just out of interest, can that be parametized, to prompt for input to restrict the list to select from? donna

PHV... MARRY ME! WORKS A DREAM.. THANK YOU VERY MUCH! DONNA

im back! i was wrong. It does change the data in my other records if i set the control property of the combo that PHV helped me to create to one of the fields ie CDItemlink1. And, yes Aceman, but it change it to active. Still black text.. now what?.. gettin all excited then donna:-(

hold the phone...using PHV's code and it showing the display of the hyperlink, i changed the unbound combo to recordsource CDItemLink1 one and it still shows all CDItemLinks1 to 6 in the list and made the links blue as well!!! Thats good .. thats what i want. They're all active.. ive tested...

Hi PHV, ignore last post. It works in that it lists all my documents from all my CDItemLink fields which is great but does not store it as an active hyperlink. Only the display so I can't click it to take me to my document. As individual combos, it stores as the actual hyperlink. I want the...

Hi PHV, am i creating an unbound combo with the RowsourceType as Table/Query? donna

Hi all... PHV.. thats sounds good will have a go. Omega.. I got errors. Aceman, in answer to your question... the end result ideally, is to see the documents people have linked to each record. As each record has 6 hyperlink fields, Im expecting to see all documents in CDItemLink1Cbo, all the...

Hi Aceman, Well Just the Hyperlink will do. My combos are: CDItemLink1Cbo ControlSource = CDItemLink1 BoundColumn =1 RowSourceType = Table/Query RowSource = SELECT ContactsDiary.CDItemLink1 FROM ContactsDiary WHERE (((ContactsDiary.CDItemLink1)<>" ")); CDItemLink2Cbo...

mmmm.. u guys are great. BRB!

Hi everyone... In a table i have 6 hyperlink fields ItemLinks 1 to 6. On a form I created 6 combos. One for each ItemLink field. Eg. CDItemLink1 has a hyperlink to a document on my hardisk. CDItemLink1Cbo looks up all the records where a user has entered a hyperlink in this field...

OMG {goodness)!!!! I have been racking my brains and could not figure it out. Thank you very much PHV!! Obviously going blind looking at all this code. Works a treat. Thanks again! donna