Recent content by tomco22

Rather some strong reactions. This is a government computer in a government facility with a sometimes chaotic environment. This particular terminal is used exclusively to monitor foreign detainees. It is vital that I get someone's attention every 15 minutes. If someone has turned the volume...

Is there a way to un-mute and max the speaker volume from within Access? My user gets an alarm if he does not do some thing (task) every 15 minutes. Tom

Thank you pdldavis. That works rather well. Tom

Access 2000. I have several forms that have started acting wierd. When a user opens up particular forms all they see is a sliver which they cannot be resized. The forms in question are set to Auto Resize = No, Auto Center = Yes, PopUp = Yes, Modal = No, Border Style = Thin, Width = 7.5 (which...

This is my final report of how this situation came out at work. Once TheAceMan1 got me on the right trail I chased that rabbit until it quit running. To suppress the “Picture Loading” message box you actually have to write two keys to the registry. Paste this into Notepad and name it *.reg. I...

Well, to wrap all this up: 1- I can add a key to the registry. It works great on my machine but I’ll have to see if I have rights at work. I have less than 10 users so even if I need a system administrator it is doable. 2-I can use .bmp files instead of .jpg files and automatically get no...

TheAceMan1, Is there any way to run: [HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\Graphics Filters\Import\JPEG\Options] "ShowProgressDialog"="No" from Visual Basic? Tom

Ed2020, I’ll try converting the jpg’s to bitmaps. File size is not really a problem. I’ll have to figure out some way to automate the bitmap conversion because I have 1000 pictures to randomly cycle through. Thanks Private Sub PicturiZER() Dim strPatH As String Dim intP As Integer Randomize...

Thank you for your response Remou. I was afraid someone was going to bring up the registry. Because of security settings at work I don’t think I can make registry changes to my or the various user’s machines. Hey TheAceMan1. I had the code in a Sub called Picturizer(). The timer event...

On my Switchboard form the timer event cycles through random pictures every 5 seconds. Every time a new picture cycles, a vbCancel message box briefly appears that says: Importing C\Documents and Settings\...\ \...jpg Is there any way to keep this annoying message box from appearing? Tom

Thanks PH. That works great and will actually eliminate setting the variable name for each control. A lot less typing. Tom

How do I refer to a control in code. I found a close answer in FAQ's but it doesn't get me there. I have multiple and specific labels I want to set a specific line height to in code. The following snippet does not work. Private Sub LineHt(ctlLabeL As Label) ctlLabeL.LineSpacing = 100 End Sub...

Does this mean that if MSDATGRD.ocx is not installed that VB code will not run? Tom MCSD I Nab Terrorists

I work in a government environment that does not allow ActiveX files on the computers. What specifically does MSDATGRD.ocx contribute to Access. Can I run a lean database with forms and queries without having MSDATGRD.ocx. I already have the database up and running. I’m trying to figure out...

I'm using record level locking in a shared database. There is not many users and I've tried this code when I was the exclusive user. Same result. All records are properly added but the edit form returns a "lock violation". After compact & repair everything works great. Private Sub...