Recent content by SpectacledBear

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

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

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

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?

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?

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

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

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!

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...

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?

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...

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?

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...

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...

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!