Search results for query: *

Hi. In a Module (or class) in outlook I have written a sub. In Access I am instantiating an outlook object. Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application") objOutlook.Module1.Test2 If the user defined sub in outlook is called Test2 ( in...

Hi. I am trying to replace rst!(varMyvariable) = strSoundName varMyvariable = "[Event" & MyCloseObject.[Tag] & "]" where rst is a recordset. I have tried concatenating differently but to no avail. How do I do this correctly? I have a number of Fields, Event1, Event2, Event3 etc...

I am using word to preview some .docx documents from Access 2007. My Current sub ... 'Word Document handling 'Previews word document(s) from named path Public Sub PreviewWordDoc(WordDocFullPath As String, Optional Orientation As String = "Portrait") Dim objWord As Word.Application...

I am using Word to preview documents from Access 2007. My existing code .... 'Previews word document(s) from named path Public Sub PreviewWordDoc(WordDocFullPath As String, Optional Orientation As String = "Portrait") Dim objWord As Word.Application Set objWord = New Word.Application...

Hi. I have a class consisting of several nested classes. How do I make these hidden to the project while still allowing them to be accessed through the parent classes namespace? If It was just the functions, properties etc, I could make them private. Can I make private or friend classes? Any way...

I have a form with a subform frame in it. Using Me.MySubformFrame.Form = "MySubForm1" works but the subform open outside of the frame. Top left corner in fact. Any ideas on why this is happening and how I can solve it? Thanks Mike

I have a form creating an invoice/order. Apon double clicking part of the record I am launching another form to edit data in the current record on the parent form (details that may or may not be added on a standard order). I think I can use Me.Recordset = Me.parent.recordset but was wondering...

Has anyone had any luck in getting the Outlook View Control (OVC) to work in Access 2007. It is pretty well known that it doesnt work in Access 2007 but I'm wondering if anyone here has been able to come up with a solution. Currently I am using the Outlook Web Control (OWC), embedded in a MS...

I have a combobox. It has "A" as the value in the .Tag property. As the rowsource I have a list of values in a table. I want to set the controlsource to a single record in a table, simular to dlookup ("Column", "Table", "Row =" & Variable). I am trying to set the controlsource to [SELECT...

I have a form with a source set as a table with fields [Number] and [Job]. On the form is 26 Combobox's. I want to have each combobox to have a single record of the underlying table as its controlsource. Currently all the combobox's show the current record, when I increment or move records they...

thread707-834151 The above thread has a great bit of code, only it puts the string into reverse alphabetical order. Anyone know how to modify the code to produce normal alphabetical order? Any help much appreciated, Mike