Recent content by MikeLeBen

Dear all, it's been a while, but once you become acquainted with Access and databases, it stays with you and you begin to imagine applying all sorts of solutions to everyday problems thorugh its use. Therefore, I am a bit a rusty and could use some advice before diving into form design. I am...

You use the VBA Editor menu to Insert -> Module. In the newly inserted module you paste the code: '************ Code Start ********** ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in any...

You use the VBA Editor menu to Insert -> Module. In the newly inserted module you paste the code: '************ Code Start ********** ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in any...

I am not sure what you mean by that. With the potential number of URL's being infinite, what feature could possibly predict which URL you are going to need? You may prompt the user to enter the URL, using a folder picker function, if that is what you mean.

Please refer to this: http://www.utteraccess.com/wiki/index.php/Opening_Files_From_Access#The_ShellExecute_API I personally like the ShellExecute API very easy and well devised. With it you would go more or less (after entering the code for the function in a separate module): Option Compare...

I reckon the URL info is not stored in the table you stated would contain it. Does the location of these files change? Does it make sense to add this path to your hyperlink field? If your hyperlink field only holds filenames, I would think it makes sense to do so.

The %20 parts are there because spaces in URL's are encoded like that. Also, it appears Access handles hyperlink field data by wrapping it in number signs ('#', I have never used this field type). Furthermore, you have been returned what appears to be only a filename, and not a URL; unless the...

As far as I know hyperlinks are stored in access tables as text fields, that are highlighted and clickable in datasheet view, but text fields nonetheless (for your intents and purposes). Therefore depending on the purpose of your application you could use any of the several ways access offers...

I was under the impression the url's were stored in your table. If this is the case you could just use it as a string and feed it to your e-mail sub. Maybe I misunderstood your question? Basically you want to send hyperlinks to a SharePoint database by e-mail?

You should use .HTMLBody on your e-mail object and add HTML links (i.e.:<a href="url"></a>)

I am not sure this applies to VBA as much as it does to Junk mail filter settings?

Try DoCmd.OpenReport "Similar Clauses", acViewReport The default action with the openreport method is print :)

Hi Bob :) Although you are correct, and I am well aware you can edit all the non-coded contents of an ACCDE/MDE, the wording is not mine, but Microsoft's! At least the Italian version of Access 2010 reads "The file will be compiled as an only executable file". Redundant and inaccurate, I know...

Please note that the where clause in this statement needs to be valid SQL. What comes to my mind is that your combo box has been set-up with month names instead of numbers? You could try test your query with the query design view, and then make sure the SQL WHERE clause criteria are expressed...

You would use something along the lines of: DoCmd.OpenReport "YourReport", acViewPreview, , "[Job] = " & Me.cboJob & " AND [Month] = '" & Me.cboMonth & "'" Note: the above has not been tested, and variable names need to be adapted to your needs.