Search results for query: *

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!

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

Would using an on timer event be easier?

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?

Fab ideas! Have some stars!

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