Search results

I want to open Outlook with the recipients name in the To: box by clicking on the email address held in a subform list field... Any ideas? Dave E

"If MsgBox("Message here", vbYesNo) = vbYes Then" I like that one, ailyn Dave E

Yes. Dim MyReply As Integer MyReply=MsgBox("Yes or No?",vbYesNo,"Question") If MyReply=6 Then '6 = Yes' Do some action for the Yes response Else Do some action for the No response 'No = 7' End If HTH Dave E

I'll take it that it can't be done then... It was asking a lot of both Outlook and Access, I suppose. Still, it would have been a good feature. :-( Dave

No suggestions then? Dave Eyley

I have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum... I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post... I...

Ok Peter, I'm there. I'm not sure how but it's all working properly now. I cleaned up the code, removed any default statements and checked the syntax against your last suggestion... Here's the code.. If Not IsNothing(Me!Searchstr) Then DoCmd.SetWarnings False DoCmd.RunSQL ("SELECT...

Peter, I think the problem isn't with the code for formatting... The problem starts when the data is exported using the OutputTo function... I tried another export function which saves data in another spreadsheet unrelated to the code for formatting, then I ran the formatting code and the...

It tripped out on - With xlSheet.Selection with the message - Object doesn't support this Property or Method... I don't see why not, it's only the same code in a different form, isn't it? Dave

Hi Peter, The code so far - All the code works but a copy of Excel remains in Task List which stops the user repeating the action... If Not IsNothing(Me!Searchstr) Then DoCmd.SetWarnings False DoCmd.RunSQL ("SELECT Property.Property, Space_Room_Data.Block, Space_Room_Data.Floor...

Yes I did as you suggested but to no avail... Still stuck for a moment but I'm so close now I don't intend giving up... Your help is very much appreciated. Dave

Thanks to both Carl and Peter for your responses and dedication... It works well now but for the last bit - it leaves Excel open as a Process in Task Manager when there's no apparent spreadsheet open. Any subsequent attempts to output to the spreadsheet results in a seemingly random error... Dave

I think I see where the problem might be... I am using OutputTo to create the unformatted Spreadsheet called - "D:\PropertyExportByDept" Then, I'm using the routine (ex-macro) to format it. Would it be that the first action is interfering with the second and causing Excel to hang? Is there...

Well, I've tried every combination of Set xlApp = Nothing, Set xlSheet = Nothing, Quit, Close and Save and I still get the problem... What is the correct method for ending a Excel application from Access? And saving the changes, of course... At the moment it leaves Excel as a process in...

Before or after those 3 lines? Dave

OK, spoke too soon... It works fine once but gives an error on the second attempt. I have found that in the task list Excel is running as a process when it shouldn't be. If I end the task then the spreadsheet creation and format works ok... I thought I closed the spreadsheet by including -...

Thanks to both Carl and Peter I now have a formatted spreadsheet with data as a single button operation. I didn't think I'd get there but it worked. Thanks again.. Dave Eyley

Hi Carl, I was hoping to copy the code from an Excel Macro to format a spreadsheet after I'd created and populated it in Access. Some reports are exported into Excel and then used for other uses by different managers. So, naively, I cut and pasted the macro from Excel into the Access code where...

I did do something similar - Dim xlApp As Object Dim xlSheet As Object Set xlApp = CreateObject("Excel.Application") Set xlSheet = xlApp.WorkBooks.Open("D:\PropertyExportByDept.xls").Sheets(1) With xlApp .Application.Cells.Select...

Thanks Peter, I'll try that... Dave