Recent content by ehorde

Found the cure.. 3 part. 1st - created a holding table with two fields set to now() and (now()-30) as the default values. 2dn - bound the form to the holding table 3nd - formated the form's date fields using mm/dd/yyyy (do not use imput mask!) This works and was tested.

Setting field's mask to "short date" fixed it. I don't know why... EDIT.... No, it didn't!!!!!!! Setting the mask to short date fixed the date, but made the datepicker vanish. Holy smokes! what's up Microsoft?!!!!

I know there has been lots of posts, but I have searched and can not find anything on my particular issue. I have a form that launches several reports from command buttons. On this form I have a tow date fields as part of the criteria. I have them set a short date and to use datpicker I...

I feel like an idiot. I have been twaeking the form when I should have been in the table. Ahh, live and lern. Thanks SOS

Wait a minute......

It is set to "Plain Text", Display as hyperlink does not have "No" or "Never" option. fyi - this is accesss 2007

There has got to be some way to enter a string containing http://www.yyyyy.com and have NOT a hyperlink. Me thinks access can be smart for own good sometimes.

I tried that, it wraps the string with # at each end. www.yyyyy.com becomes #www.yyyyy.com# You can's see it because access hides the # symbols, however, when you edit the field they display. Clear the #'s out, exit the field and they pop right back in there as hidden. !%@!*% Then when...

I thought I had this worked out but a new day brings new problems. Access is automatically wrapping # around the text box that contains the hyperlink. So when I type in the text box: http://maps.yahoo.com Access changes it to: #http://maps.yahoo.com# Another thing is that I have told...

Would this work? IE.Navigate Replace(Map.Value, "http://","") That works great! Thanks, I'll tweak the if/thens for different scenarios later. Thanks again.

Because the first part can be pasted as a bookmark or as an https://, https:// #https// I need to be able to tell is to only use text after the last set of double slashes //. I can't help but think there is an easier way to do this. I have seen code in action that strips...

I have a form with a button that does this: The field on the form is called [Map] and it contains something like http://www.thelink.com The button works, except it opens up ie with this address: http://http://www.thelink.com If at a loss, I think I need to somehow strip the http:// out...

Finally got it working with the help of someone very patient on another board.. Thank you freakazoid! Here is the code to delete Outlook Tasks by searching the Subject Line using Late Binding. Dim strFilter As String Dim objOutlook As Object Dim...

Here is the early binding code that is working... Dim strFilter As String Dim objOutlook As New Outlook.Application Dim objNamespace As Namespace Dim objFolder As Object Dim colItems As Items Dim objTasks As String...

OK, I now have this, but still no go.. ------------------------------------- Dim strFilter As String Dim objOutlook As Object Dim objTask As Object Dim objNamespace As Object Dim objFolder As Object Dim colItems As Object Dim objTasks As...