Search results

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...

I am having to change my code to late binding (:(just when I had early binding all figured out) due to issues with different versions of Outlook. I am stuck on a piece that deletes tasks. Here is what i am working with.. ------------------------------------ Dim strFilter As String...

I have a subform that is set to display as continuous and one of the fields I sort on is a text field that contains single and double digit numbers. ie.. 1 2 3 . . 23 24 etc.. The problem is that 23 sorts before 3. In this form I cannot force leading zeros, it is not an option as 023 may not...

Thanks RuralGuy! That got me going.. Glad to know I'm not the only one working late Saturday night ;-) Here's the working code for the button. ------------------------------------------- Private Sub Command331_Click() Dim stEmailList As String Dim db As DAO.Database Dim rs As...

Trying to generate an email from email addresses pulled from a query. I have parts of this code working in other areas But his one never makes it past the line: Set rs = db.OpenRecordset("qry_EmailAddresses") No errors, no nothing. I have put message boxes in to see where the...

Sorry for a late reply, I've been chasing other bugs.. I fixed this with a Me!Refresh after loading the form. Simple enough.