Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SpectacledBear

    Assigning a new icon for access

    No, i didn't, diodnt know i had to. Will now though, have a star
  2. SpectacledBear

    changing font colour on labels.

    Zmr Roy Vidars second link sorted my problem out, check it out :D
  3. SpectacledBear

    changing font colour on labels.

    Thanks Roy Vidar, and thanks Zameer Abdulla, it seems the labels were corrupted. Both have a star :)
  4. SpectacledBear

    Assigning a new icon for access

    Ive created a new icon for my system which is in access, on the startup menu I click on the icon browse button, and select it (its called Icon.ico), and I'm being told I cant use it as it is not an icon file, though it is a .ico file. Any Ideas why?
  5. SpectacledBear

    changing font colour on labels.

    Hi, you've just reminded me theres a problem with that. Whn i try to compact and repair my database, it says something like the table MStempAccessObjects already exists, and then closes the system. Why is that?
  6. SpectacledBear

    need help with code for form to launch archives

    I've tried everything on it, have spent four days now trying to sort this out, and would really really appreciate it if anyone could offer any suggestions
  7. SpectacledBear

    microsoft access cannot find the macro '.'

    Hi, this is sorted now thanks, there was a space in the on activate section of the properties. have a star anyway
  8. SpectacledBear

    changing font colour on labels.

    Thanks for the advice :D. Checked all the event procedures and they were there, so it must be the labels. Will try creating them again and will let you know how i get on. Thanks!
  9. SpectacledBear

    changing font colour on labels.

    This is the code I am using: Private Sub OptionLabel1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single) Me.OptionLabel1.ForeColor = vbRed End Sub Private Sub OptionLabel2_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single) Me.OptionLabel2.ForeColor...
  10. SpectacledBear

    changing font colour on labels.

    I have the same code on 8 labels (a switchboard) and the first two turn red on mousemoe, then black when the mouse moves away, but the other six don't, even though the code is the same. Does anyone know why?
  11. SpectacledBear

    microsoft access cannot find the macro '.'

    when i close a form or query, i get this message (only about 50% of time). I have not got a macro called . and access doesnt allow you to name a macro '.'I have trawled through every bit of vba in my system, and thwere are no referneces to any macro called '.' has anyone got an idea why my sytem...
  12. SpectacledBear

    need help with code for form to launch archives

    Thanks for that, have done it. Button is working, but runs macro stragith away, regardless of specified time. Is there any way to combat this?
  13. SpectacledBear

    Macro running regardless of time when it's supposed to wait

    This is the macro I have running. It is supposed to check to see if the value of txtTime is the same as the current time, and if so run either one of three macros. The user inputs a date in to txtTime, and chooses a table to archive from lst2. However, even if the time is ten hours away, the...
  14. SpectacledBear

    Mail merge code cant find document ( calling it .doc1)

    Hi, the code now reads: Dim retval As Variant Dim DocName As String document DocName = "E:\Word\MailMerge.doc" 'Note full path to Word including Drive and folder retval = Shell("C:\Program Files\Microsoft Office\Office\WinWord.exe " & DocName...
  15. SpectacledBear

    need help with code for form to launch archives

    Appstaff. How do I reference the dao in the reference library? Ah yes, I see the closee. This will be changed. Silly Me. As for the dim line, I never noticed that before, it does seem out of place. I will delete it. Thanks for your help!
  16. SpectacledBear

    Mail merge code cant find document ( calling it .doc1)

    Hi there, this did not help either. Any suggestions?
  17. SpectacledBear

    need help with code for form to launch archives

    Would using an on timer event be easier?
  18. SpectacledBear

    need help with code for form to launch archives

    When I run the code, it tells me there is an error and I need to debug. When I debug, the following line is highlighted: Dim db As DAO.Database. If i delete it and run the code again, the following line is highlighted Set db = CurrentDb Any ideas?
  19. SpectacledBear

    creating funky forms

    Fab ideas! Have some stars!
  20. SpectacledBear

    need help with code for form to launch archives

    No I was using a click event. However, if you think a on timer eent is easier/better I will change it. The click event is when the user selects the table they wish to archive, and types a time which they want to archive it, they click a button called 'set' (cmdTimer). This seemed logical to me...

Part and Inventory Search

Back
Top