Search results

  1. RichO

    Autoplay stopped working on my USB devices

    No such software on my computer. Maybe it is something with the registry. I did use a trial version of JV Power Tools to clean up my registry and that might have been around the time this started happening.
  2. RichO

    Autoplay stopped working on my USB devices

    Actually that was the first thing I tried before I started this thread, but thanks for trying to help. :)
  3. RichO

    Text field to change color when clicked

    Because it is a continuous form, all occurrences of that field will change color, not just the current record. I think I neglected to mention in my original post that it was a continuous form. I will edit it...
  4. RichO

    Text field to change color when clicked

    Here is what seems to be a bit of a unique application. I have a continuous form where when a user clicks on the name field, I want the name field's back color to change. I accomplished this using a hidden yes/no field along with conditional formatting. See attached example (Access 2K). When...
  5. RichO

    Refer to control in a form within a tab

    Actually I was looking to refer to a subform control but from a completely different form. From your answer I was able to come up with this: =[Forms]![AccountTabbed]![frmAccount]![Account2Subform].Form.txtTotal And it worked. Thanks Bob!
  6. RichO

    Refer to control in a form within a tab

    Recently while searching this forum I came across a thread where Bob Larson had explained the syntax to get to a control within a form that was inside a tab control. Now for the life of me I can't find that thread and have no idea what search terms I used previously. I seem to recall the...
  7. RichO

    Prevent user from stopping USB device

    I used to always simply yank the device once I was sure that file transfer was complete but then somebody told me that I should always stop the device or the data on it could get corrupted. Never had a problem so I guess it's probably safe to just pull it. Thanks for your reply.
  8. RichO

    Prevent user from stopping USB device

    I have a computer here with a USB external hard drive. When users of this machine (including myself) use the "Safely Remove Hardware" icon in the system tray to stop another device such as a flash drive or camera for removal, there is always the potential of accidentally stopping the external...
  9. RichO

    Tab control & go to new record

    Using a suggestion in that thread I was able to set focus to the first control in the form for data entry, the problem is that when you set a form's data entry property to true, it no longer shows the other records in the table, only the new records that you enter. None of the form's events...
  10. RichO

    Tab control & go to new record

    I tried using this code: If myTabs = 2 Then Me.frmAccountEntries.Form.DataEntry=True Me.frmAccountEntries.Requery End If But it has no effect. I posted a sample DB (Access 2000) with a form in which the code does have an effect on the form but not the desired effect. When you click...
  11. RichO

    Tab control & go to new record

    I have a form with a tab control. Within one of the tabs is a continuous form. When this tab is selected I want this form to go to a new record for data entry. In the continuous form's On Activate event I have DoCmd.RunCommand acCmdRecordsGoToNew This works fine when opening the form on its...
  12. RichO

    Could not delete from specified tables

    That's very useful to know. There have been a number of times where I had a hard time finding an answer due to exclusion of words. Thanks for your replies.
  13. RichO

    Could not delete from specified tables

    This seems like it would be a common problem but I tried to search for solutions to this and I haven't been able to find a specific answer. The forum excludes too many of the words I'm trying to use in my search.... I have two joined tables and I want a delete query to delete the specified...
  14. RichO

    A little fun with a phone recorder

    My girlfriend has a teenage daughter who is in a dysfunctional relationship with this boy that is insanely jealous and verbally abusive. Still this girl thinks he is the only one for her. Anyways, my GF forbid her daughter to see this boy anymore but after a while she suspected that she was...
  15. RichO

    VBA code window in dual monitors

    Not a video driver issue as the task bar never extended into the second monitor. I toyed around some more and got it fixed.....strangely, the "Restore Down" button on the very top bar maximizes the code window to both screens and the "Maximize" button next to it restores it to maximized view on...
  16. RichO

    VBA code window in dual monitors

    Not sure what happened here.... I was working on an access form, and I received a run time error. When I clicked debug suddenly the VBA code window opened up fully maximized across the width of my dual monitor setup. I don't know how it happened and I can't figure out how to get it back to...
  17. RichO

    Enabling Text Boxes Problem????? Please Help??

    Can you post a db containing your form and table?
  18. RichO

    Enabling Text Boxes Problem????? Please Help??

    The form's record source needs to be the name of your table or a query that queries your table. As far as the text boxes/fields: Material, OD, Length, etc, are those the "names" of your text boxes or the control source property? Or are the name and control source property the same (as the form...
  19. RichO

    Enabling Text Boxes Problem????? Please Help??

    At a glance the code appears to be correct. I would try step debugging the code to see where it is going.
  20. RichO

    Autoplay stopped working on my USB devices

    Lately when I plug in a USB device (camera, thumb drive, etc) a window no longer comes up with options on what to do. The camera used to always open the scanner and camera wizard, the thumb drive would always open a folder to view files. I went to properties (AutoPlay tab) for the devices...
Back
Top Bottom