Recent content by raindrop3

  1. R

    Dialog messages

    Dialog Thanks for your answer. But: this dialog isn't an error. It is just an information dialog. So if it isn't an error, I also cannot 'catch' it with an error trapping function. Maybe there is somekind of a function that disables information dialogs, even when I press e.g. the print button...
  2. R

    Dialog messages

    Dialog Thanks for your quick response, but setwarnig wil only prevent the dialog from displaying when I open the report. When I clik on the print button, it displays the warning again. Any ideas how to prevent that? Many thanks. Greetings, Albert
  3. R

    Dialog messages

    Hello, I have a little problem: I have a report with data, but the data is somtimes to much (big) for one label. Acces comes up with this stupid message 'Some data may not be displayed.....' Does anyone know how to disable this 'information dialogs'? Many thanks! It took me hours and still I...
  4. R

    VBA sql statement

    WOW! Thanks a lot, StuBailey! It works now. Quit simple... :D Greetings, Albert
  5. R

    VBA sql statement

    Morning! I have a little problem, but big enough for me to play with it for hours, and still I haven't found the solution. Time to ask help. This is my SQL-statement: sql = "SELECT * FROM Music WHERE artist = '" & sArtist & "' AND title = '" & sTitle & "';" The problem: when a ' (apostroph?)...
  6. R

    Winamp and Access

    He! Have a look at this website: http://www.winamp.com/nsdn/winamp2x/dev/sdk/api.jhtml Greetings, Albert
  7. R

    Winamp and Access

    NICE! I give it a try when I am home! Albert
  8. R

    Winamp and Access

    Jatfill, Thanks a lot for your help. It's working now! I found out the you can replace the /ADD part in /PLAY. Winamp play's the song immediately instead of placing it in the playlist. When there are spaces in the path to the file, you can use the ~ to refer to the path. I.g. c:\my documts -->...
  9. R

    Winamp and Access

    Thanks jatfill! That worked great, but when the path to the mp3-file is in a variable, it gives a syntax-error. I tryed everything, but it won't work. Now I can open winamp and play a song from access, but i had to program the path...I wan't to put it in a variable so, i can play every song i...
  10. R

    Winamp and Access

    Hello, I tryed the API-stuff and it works, but it don't support the .mp3 format. For wav it works fine. Under a (play)button you can use code like this: dim a a = fPlayStuff("C:\WINDOWS\MEDIA\Microsoft Office 2000\applause.wav", 1) under a stop button you can use: dim b b = b =...
  11. R

    Winamp and Access

    Hello, I have a little mp3 database and i want to play a song when i click on a button. I can open winamp, but the song won't start. If i open winamp mannualy with a shortcut, I can play a song automaically, but in access it wont work. Any ideas? Thanks. Albert
  12. R

    login form

    D B Lawson, can you e-mail me the example too? Thanks! Albert
  13. R

    Brows for file button

    Hello, I have the following references: - Microsoft Common Dialog control 6.0 File: comdlg32.ocx Albert
  14. R

    Dumb question BUT

    Hello, On the moment you click on a button, you can set a 'flag' to true. I.g. In the module you say: global cmdsaveclick as boolean In the same module you set cmdsaveclick to false. Under the button cmdSave, in the 'on click' event you can say: cmdsaveclick = true. Another form that opens...
  15. R

    Brows for file button

    It is possible. Search this forum for 'browse file' or something. You had to use the CommonDialo control. Use the following code to open it an to put the path in a textbox: CommonDialog1.CancelError = True 'CommonDialog1 is the name of the CommonDialogControl On Error GoTo ErrHandler ' Set...
Top Bottom