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!

  • Congratulations bkrike 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

    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?
  2. 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?
  3. 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...
  4. 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...
  5. SpectacledBear

    need help with code for form to launch archives

    I currently have this code on my archive form: Private Sub cmdTime_Click() On Error GoTo Err_cmdTime_Click Dim db As DAO.Database Set db = CurrentDb If Not IsNull(Me!txtTime) Or Not Me!txtTime = "" Then Dim stDocName As String If lst2 =...
  6. SpectacledBear

    Compile Error:User-defined type not defined.

    The following line of code is identified when this message is displayed. Any suggestions? Dim db As DAO.Database
  7. SpectacledBear

    Automatically select one option of an option group on form open

    can this be done? I need the second option (called option5 but is the second one down) to be selected as soon as the form opens, so I was wondering if a similar command to cmdClise_Click in the forms on open could be used to select an option? I have tried this myself but without avail. The...
  8. SpectacledBear

    Code to run macro at a certain time not working, any suggestions?

    Hi there, I have a form which is supposed to allow the user to select either ‘Deliveries’, ‘Sales’ or ‘Orders’ from a list box. There is also a text box called txtTime. In this text box, the user should type the time they want to archive the tables (done by a macro). I have done the macro, and...
  9. SpectacledBear

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

    Hi there, I have a mail merge button which has the following code on its on click event: Dim retval As Variant Dim DocName As String ' Drive and Full path to name and location of Word document DocName = "E:\Word\MailMerge.doc" 'Note full path to Word including...
  10. SpectacledBear

    changing colour/highlighting/ changing weight of words in list box

    I have a queries menu which is in the form of a dialogue box, showing a list box and buttons. In the list box are my queries. Can I make them or their background change colour on mouse move? thanks!
  11. SpectacledBear

    creating funky forms

    as well as flashing labels, what else can you do to funkify a form? I need to impress, promotion is on the line!
  12. SpectacledBear

    revolving logo on a form?

    can a logo continuously spin or rotate or be otherwise animated in a form?

Part and Inventory Search

Back
Top