Recent content by FrankMars

Thanks Andy and thanks Duane. Duane, your code worked great. I wouldn't have gotten there without it. Thanks again.

Thanks Duane. I understand what you're suggesting to do but I'm unable to write the code in vba on a button to update the SQL property of a saved query with "mySearch". How do I do that? I am able to write the code to export the saved query to Excel as shown below. Thanks again. Dim...

Hello - I have several fields on a main form (asfAddressAll) that filter records to a continuous subform (asfAddressAllSubform). I would like to send the filtered records on the subform to Excel. How can I accomplish this? The following is the code used on buttons in the main form for...

Thanks strongm, works great. Still developing so may be back with additional questions.

Hello, I am bringing to top the window of an external program (Microsoft Outlook) with the following code: Private Declare Function BringWindowToTop Lib "user32" _ (ByVal hwnd As Long) As Long Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _...

Hello. I am able to open Internet Explorer and Outlook with the following code on a button on my form; Dim X As Variant Dim Y As Variant Dim Path1 As String Dim Path2 As String Path1 = "C:\Program Files\Internet Explorer\iexplore.exe" Path2 = "C:\Program Files (x86)\Microsoft...

Duane - will do.

Andy - my field is declared as a number. I removed all single quotes from that line as suggested and it worked. Thank you very much!

Andy/Duane- I changed the code as suggested and I'm getting "Run-time error '2001' - You canceled the previous operation". ????. It seems to be a problem with the last If Not statement but I cant find it. The error does not come up if nothing is in the from/to fields. My code is as follows...

Andy - thanks, works well. Now I'm having another problem. I added additional combo boxes and I'm attempting to get recordset results which are in the range between the 2 values in those combo boxes. This is the code I have so far which is not working due to the last If Not statement: Dim...

MajP, I ran into another problem. Your code worked but when adding an additional combo box to filter by, it only works when either all, one or none of the combo boxes are filled out. I plan on adding 10 or so more combo boxes to filter by. Is it possible to fill out any combination of combo...

MajP- The first code works. I wasn't able to get the second code to work. Thank you.

I have a continuous form which I filter the results by selections through 2 combo boxes and clicking a button in the header portion of the form. My code on the button is as follows: Private Sub Command17_Click() Dim mySearch As String mySearch = "Select * from qMarconL where (([City] = '" &...

Thanks AceMan, works great! Also, the window title is now working ok.

Thanks AceMan, that's just what I did with Calculator. The Calculator does come up to top when it is behind Access. However, when Calculator has first been minimized, it only flashes on the taskbar and does not come to top. Is there a way to have it come to top after it has been minimized to...