Search results

I believe "Path/File Access error" means that there is no such folder. Question: if it was erased the first time, won't that make it already deleted, giving you the error? Bones

Get rid of the open form event. I added this to reset the url to null: Me.WMP.URL = "" just delete it. Bones

search the forum some more. There are many things you can do with Word through Access. Bones

Here is a better version. I stripped down some code I had in there that was not needed. This will help you understand how I did it. Good Luck

I've attached a file to get you started. I comprised the code from numerous post and also used GHudson "Browser" Example for the code. Hope this helps.

Have you select the windows media form the object library?

where "WindowsMediaPlayer0" is the name of YOUR media player. if the name your media player control is "MD" then use this line: Me.MD.URL = filename

Sounds like you deleted the "on Click Event" for the combo box

I never store a image as a BLOB, I have the user select the file from there computer and I drop it into a folder where the DB is located. I Store the address on a table.... Works great and doesnt bloat the DB

Do a search on google for ImagesA2K or Access BLOB. I downloaded a nice sample for three methods of storing BLOBS. I cant find the site, but I know its out there. I would like to give credit where credit is do. I cant remember where I got it from. Hope this helps

ok try this. Place the Media player in a form. On the Enter Event procedure use this code: Dim filename As String filename = ("C:\nameoffile.wmv") Me.WindowsMediaPlayer0.URL = filename Bones

G, good point.; only trying to help. I'll do that next time. Bones

create a Module called playwavefile input this code: Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" (ByVal filename As String, ByVal snd_async As Long) As Long Public Function playwavefile(sWavFile As String) If apisndPlaySound(sWavFile, 1) = 0 Then MsgBox "The Sound Did Not...

SEE: http://www.access-programmers.co.uk/forums/showthread.php?p=466787#post466787

Make sure MS Outlook is selected in the reference library Private Sub Command0_Click() ' Open outlook and select a folder, create a form with a button called command0 and a text field called text1 Dim objApp As Outlook.Application Dim objItem As Outlook.MailItem Dim SndName As String...

Thanks G, but I am still getting the error. oh well, I'll look for a work around.... Thanks for the help!

G, I added this to a module and have the same error message. I read the article but I am still confused....what am i missing? Public Function Environ$(Expression) On Error GoTo Err_Environ$ Environ$ = VBA.Environ(Expression) Exit_Environ$: Exit Function Err_Environ$: MsgBox...

Hi All In reference to my last post: http://www.access-programmers.co.uk/forums/showthread.php?t=102106 In my code below I get the users info from "username = Environ$("username")". My question is, can I use that value in my sql statement? I keep getting an error "No Value Given for one or more...

Thanks! Works great. This help out a lot. Bones

Hi All, I am trying to learn sequel strings and I have a question. How do i extract the value from this sql statement? Thanks! Dim myconnection As ADODB.Connection Dim myrecordset As New ADODB.Recordset Set myconnection = CurrentProject.Connection myrecordset.ActiveConnection =...