Mouse over in vba Results

Is there a way in VBA so that when the mouse is held over a control for 1 second a message appears saying what it means.

You all know the sort. Happens in Windows all the time when you put your mouse over a icon.

Hi guys would really appreciate some help here.

I've created a database and I'm trying to make a log-in screen for it. I've currently got a table named "tbl_SystemUsers"

For the Log In form, I've got Username (Combo10) and Password (Text 2) fields. Every time I click the log in button I get error 424 (object not found)

My exact script for the click of Log In (Command12) is:

	Private Sub Command12_Click()

    'Check value of password in tblSystemUsers to see if this
    'matches value chosen in combo box
  If Text2.Value = DLookup("[Password]", tbl_SystemUsers, "[UserID]=" & UserName.Value) Then
        UserID = UserName.Value

        'Close logon form and open splash screen

        DoCmd.Close acForm, "frm_LogIn", acSaveNo
        DoCmd.OpenForm "frm_StartUp"

      MsgBox "Password Invalid. Please Try Again", vbOKOnly, "Invalid Entry!"
    End If

End Sub

When I hover the mouse over tbl_SystemUsers, it says that is empty.

Any help would be appreciated, bit of a newb in this area so any help would be fantastic.


I'm trying to change a border from transparent to solid when a command button is moused over.
Is there an event to trigger this (similar to onMouseOver in JavaScript) ?

I am wondering if there is a easy way to get the control that the mouse i move over. I mean access has it built in with the controltip. It know what control the mouse i hovering over because it shows the controls controltiptext. It should be fairly easy to get the control that the mouse i hovering over or if anyone have the vba code for controltip would be helpful.

Thanks in advance

I've been trying unsuccessfully to find a way to have some VB code run when ever the user presses the arrow buttons at the bottom of a form to move to the next (or previous) records.

All I have been able to implement is something that runs when the user moves the mouse over the detail space or if they click in the detail space. This is ok, but since the VB code is changing the background colors of text boxes depending on which fields are selected, I get a lot of screen flutter as the user is mousing around. Ideally I'd like the code to just execute once on a record change.

Is there a way to link my code to record change instead of mouse move?



Actually this question i asked in From section.
Quote: thanks buddy, Now i have another problem, I have an image button, how can i change the mouse cursor when i rollover it and make the image size bigger a bit? Thanks for the guidance. So how to change the mouse cursor picture using VBA? because when you mouse over an image in form, the mouse cursor won't change. Thanks for the guidance.

I have designed a form in Access 2010 to handle results of a survey.
The beginning of the form has a question if you are an adult or a youth. There are 2 adult possibilities; adults with combo box answers only to questions and no text comments (in this case the text box for comments that appears with each question is dimmed) and adults with combo box answers plus text comments to any or all of the questions. (in this case the text box for comments that appears with each question is highlighted)
If you are a youth, then the "adult" questions are dimmed. There are also 2 youth possibilities: youth with combox box answers only to questions (the text box for comments that appears with each question is dimmed) and no comments and youth with combox box answers plus comments to any or all of the questions (textbox for comments that appears with each question is highlighted).

I have set the form so the tab order follows the combox box responses only. If there are comments I have to mouse over to the text box, add the comments. If I tab, the tab moves me into the next questions text box, not the next questions combo box. I then have to mouse to the next question combo box.

I would like to set the form up so that in those adults and youth that comment on the combo box questions, when I hit tab it would move from (for example) question 1 text box to question 2 combo box rather than question 2 comment text box.

Form example:
Question 1 dropdown Combo box choices 1-5, 88 (did not participate), or 99 missing response; Text Box for comments
Question 2 dropdown Combox choices 1-5, 88, 99; Text box for comments.

Can anyone provide me suggestions?

I was, with your help, able to resolve some "if/then VBa code" to dim textboxes when a specific value was chosen in the Adult/Youth combo box at the start of the form.

Dear All (Especially Rod),

I've been trying to rewrite my database, hopefully, incorporating Rod's suggestions; from my previous version.
However, I've broken the VBA code

When I try to enter a new Examination report, using the form, I get a 'Datatype Mismatch' error.

I've looked in to everything, the only thing I can see (when it errors), the value of TEPreD; in the code window (when hovering the mouse over it); shows as a time?

I'm not sure if there's something I'm not understanding with regard to the PK/FK relationship either.
I think I have checked all the date formats, in the tables, forms & queries.

The code is supposed to check for and (if present) insert a previously entered date in the field 'TEPreD'

I would appreciate anyone looking at this and letting me know what I'm missing/doing wrong, please.
Didn't want to pester Rod directly (I'd need to start paying him a retainer )

Dave... Attached Files Copy of FleetSupport (73.2 KB, 3 views) Reply With Quote 08-21-2012, 09:31 AM #2 Missinglinq Expert Windows 7 64bit Access 2007 Join Date May 2012 Location Richmond (Virginia, not North Yorkshire!) Posts 828 Originally Posted by Scifi67 The code is supposed to check for and (if present) insert a previously entered date in the field 'TEPreD' What code? Posting the app is fine, but not giving an explanation and expecting anyone to slog through all of this, trying to reproduce your problem, is not apt to get much help, I'm afraid. You really should always post the errant code here and/or give us some step-by-step instructions on reproducing it.

Your problem, I think, is not with TEPreD, it's with FleetID. It is defined as a Number, in your underlying Table, but the line

Code: Me.TEPreD = DMax("TEDate", "TblTEDetails", "FleetID = '" & Me.FleetID & "'")

uses the correct syntax for it as a Text Field! That is the 'type mismatch' error you're receiving. For a Number Field the syntax would be

Code: Me.TEPreD = DMax("TEDate", "TblTEDetails", "FleetID = " & Me.FleetID) Linq ;0)>

Hi! Access question here.
I have three entry fields in a form. VBA mouse over I see the entries except on the last line of code below. I am not sure if my concatenate of these three values are formatted right. Form runs with full content because the values are not being recognized.
"'strrangecategory' & 'strFromDate' & 'strToDate'"
is the troubled string I think. Entry is From thru To date with a desired category (NULL for all). UG!
Here is the function below....can anybody help?
Private Sub Command99_Click()
Dim strFromDate As String
Dim strToDate As String
Dim strrangecategory As String

strFromDate = "adj_date_post >= '" & FromDate & " '"
strToDate = "adj_date_post

I want my mouse pointer to change to a hand when it passes over a text label. How can I achieve this as an event in VBA or as a macro.

Hi All,
I have created a chart using the form PivotChart view. I have done this initially using VBA, but i have also tried just using a query and puting two text boxes in the form.
The data is a summary of some other data in the database. (Number of faults, between 2 dates, for any selected production line, and product on any particular shift)
What I would like to do is click on one of the bars of the chart and run some VBA (For instance. Click on the highest bar (needle blocked, say) that would take me to a breakdown of occurances of needle blocked that occured in the original query. ( For instance, so I could see if a particular shift had that problem)
If I click on the chart I get it highlighted or on hover i get the value of the bar + the description
I have tried to name the chart in VBA

	myForm.ChartSpace.Charts(0).Name = "Fred"

But i cant get an event to fire is I put this event on the form

	Private Sub Fred_MouseDown(button, shift, X, Y)

I believe that Access knows which bar the mouse is over, because of the on hover letting me know....
I would like to use this to dynamically display a new graph based on the bar I have just clicked. (along with the original information on the associated form)
BTW - I have got around this by displaying a table next to the graph and the user can click on the table to get to the new information. However, this duplicates the data on the form and does not look good!

If anyone can help I would be very greatful.


Tim W

Hey all,

I'm currently trying to make a Powerpoint presentation that will run my macros when I hover the mouse over a shape and then press a key on the keyboard.

right now all my macros work fine, but they're programmed to work on a mouse click. It seems like this should be one or two lines of code but so far it looks like it will be more complicated than that. Here's what I was expecting it to look like (sort of...):

Sub ArrowControl()
' wait until Right Windows button is pressed, and then run macro
If RWin.IsPressed Then
End If
End Sub

So really what I want is for it to wait while the mouse is hovering over the shape until the Right Windows (RWin) key is pressed (or more specifically on KeyUp) and then run the macro.

I would very much appreciate help on this! I am relatively new with VBA

Thanks in advance,

-a guy with hurting eyes

Hi all,
I have a problem with notification area:
when I use taskkill to close an application (=WinFax controller) with VBA, the icon remains on the notification area (it doesn't disappear), problem is, when I rerun that app., the icon become double!
To correct this problem, I must moving the mouse over notification area to refresh it.
My question: is there any solution to make it automatic using VBA?
Thankyou in advance for your help.

I've built a few relational databases for my company and they are willing to back me up in getting some kind of certification/training in this area in order to try and sell some data management tools.

What kinda of certification should I be looking at? Here's some stuff about my Access skill that I don't know how to do.

1) All built in ACCESS 2000
2) All the databases I've done so far run off of ONE computer of over a network with a general password.
3) I don't know SQL
4) Don't use VBA in Access (although I know some Excel VBA).

Since my company is willing, I would like to take this oppurtunity but don't know what would suit me best?

Was reviewing the Denver Area Access Users Group (DAAUG) and came across this excellent presentation. This is probably something that will be more in demand for the next Access version as well.
There is an excellent Power Point Slide of the presentation plus credits that include:

Access data macros are similar to Triggers in SQL Server.
Also an interesting tidbit on XML.

There are over a dozen more free Access Downloads at the DAAUG site The titles and short descriptions are listed below - the site to link to the downloads is:

Access Excel Automation - 8/1/2012 From Keith Poulin's April 2012 presentation, "Access Excel Automation" This presentation will cover the basic Excel capabilities that Access provides out of the box, as well as more advanced techniques for importing flexible spreadsheet formats and producing richly formatted Excel reports.

Microsoft Access Logging - 7/31/2012 From Lindsay Wert's November 2011 presentation, "Microsoft Access Logging" Discover an approach for consistently and easily logging run-time information from Access and VBA.

Focus on Access 2010: Table Macros - 7/30/2012 From Paul Schnitzler May 2011 presentation, "Focus on Access 2010: Table Macros"

A Generic Lookup Table Editing Form - 3/2/2011 From Jim Pilcher's March 2011 presentation, "A Generic Lookup Table Editing Form"

VBA Table Wrapper Classes - 6/17/2010 Lindsay Wert's Table wrapper classes

Crystal's Analyzer... the ultimate Data Dictionary Tool - 5/6/2010 Crystal's free Analyzer application to document databases.

How to Make an Add-in - 5/5/2010 Aaron Kogan's presentation on how to make an Add-in which includes an Add-in Template.

Access 2010 Web Database Template Relationship Diagrams - 4/9/2010 Access 2010 Web Database Template Relationship Diagrams, documented by Crystal, March 2010

Search Buddy - 3/4/2010 Aaron Kogan's Search Buddy (aka 'Search Pane') from his March 2010 presentation.

Outlook Attachment Options - 3/4/2010 Outlook Attachment Options utility (from Slovak Technical Services Briefly presented by Aaron Kogan during the March 2010 meeting.

Importing Excel Data - 3/4/2010 Samples from Patrick Headley's March 2010 presentation, "Importing Excel Data".

'Tips and Tricks Inspired by Student Questions' Samples - 2/8/2010 Samples from Sco's January 2010 presentation, "Tips and Tricks Inspired by Student Questions"

Disable Mouse Wheel - 1/31/2010 From Sco's January 2010 presentation, the sample from Wayne Philips' 'A new method for disabling the Mouse Scroll Wheel in Access forms'.

Table Interface Class Builder for DAAUG - 10/12/2009 Access, PPT, and related files from Lindsay's Presentation

MSDN Access Team Contributors' Toolkit - 5/21/2009 Background info on contributing to Power Tips

Access Add-ins and Code Snippets - 4/7/2009 More of Aaron Kogan's "Little Buddies" from his Code Library

Office Automation in Microsoft Access - 1/17/2008 Phil Ferrero demonstrated several techniques for automating Microsoft Word and Excel using Microsoft Access. He also demonstrated the differen between early and late binding in VBA code. Download and run this self extracting zip file to access the files that Phil used in his demonstration.

Word Automation from Access - 11/16/2006 This zip file was provided by member Alan Ruff as part of his demonstration on automating Microsoft Word by using Microsoft Access. When you unzip the files a new folder named C:AccessAutomation will be created and the files placed in that folder. Everything will work from within that folder.

Hitting the Cycle with Outlook and Access - 4/20/2006 Mike Nindorf explained the application and processes that he built for his company to use in order to input data into Access from Outlook and then export that data into Word templates. Though he was unable to share the application with the group he has provided his presentation notes which includes code for gathering the data form Outlook and outputting it to Word.

The Access Sub-way - 2/16/2006 Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. This download contains the forms and subforms that Jim used in his presentation.

DAO Transactions - 11/17/2005 (447 KB) Demo files preapared by M.L. "Sco" Scofield for his presentation on SQL Transactions. SQL Transactions allow you to process a set of SQL commands and commit the updates or roll back the updates as a batch, instead of one command at a time. In this way, you can roll back the set of SQL commands if one or more of the individual commands fail.

Practical Ways to Use XML with Access 2003 - 10/20/2005 (1.33 MB) presented by Tim Getsch, Microsoft Access Program Manager, Redmond, WA

A One-form Application - 9/15/2005 (29 KB) "Export Access Table Structure" Add-in presented by M.L. (Sco) Scofield

Unbound Forms - 8/18/2005 (780 KB) Presented by Jim Pilcher

Upsizing SQL Server - 7/15/2004 (16 KB) Presented by Kevin Bell

Recordsets in Microsoft Access - 6/20/2002 (264 KB) Presented by Barton P. Haase.

I notice when you hover the mouse over a linked table in the Database window, that a tool tip appears displaying the connection string for that table. Where is this connection string stored and how may it be recovered by other means ( VBA )?


Hi there,

I've converted the following statement from a standard query into code that VBA will understand and it will now run without errors, however the recordset returned from this query has no entries in it. The query it is based on returns 2 records. I won't post the whole SQL string unless requested as its massive and this bit seems to be causing the problem: (customer Id number is the same always but had to remove for confidentiality)

"WHERE (((tblSites.AccountNo)="""") AND ((tblProcessing_Log.ProcessDate)=" & strDate

strDate is a date format (DD/MM/YYYY - UK) which is retreived from a calander control (CalSelect.value) before running the SQL. The format of the string is:
strDate = "#" & Me.CalSelect.Value & "#" & "));"
Inserting the calselect.value straight from the control into the SQL was causing all sorts of errors.

Finally, in debugging, the SQL runs fine but on holding the mouse over the recordset.count it reveals no records are contained but the correct value is contained within the strDate string!

If anyone can help I would be greatly appreciative.


I am calling a continous form from a combo box on another form. The code below used to warn me that there were no records and shut the form down to avoid showing a blank form.

	Private Sub Form_Load()

If IsNull(Me.TxtUnit) Then
MsgBox "There are no operations recorded for this Unit", vbOKOnly, "No Recorded Operations"
End If

End Sub

All was working fine until I changed the properties of the continous form to "Allow Additions = No" to remove the spare blank line at the bottom of the records (just for neatness really).
Now, if there are no records to display, the Me.TxtUnit is not Null anymore. It does not seem to exist. If I hover the mouse over it (in VBA) I get no response at all.

How can I get my Msgbox back please ?


I am not a specialist, but am trying to create an application with Access 2000to manage our company’s orders. I have a table called ‘Service’ containing descriptive data on the type of service requested. This table is linked to several other tables, with ‘ServiceNo’ as the primary key linking most of them. The service number is not an autonumber, but a counter incremented through code, for specific reasons that I won’t develop here.

I have created two forms: one to consult all the service records (F_Service_Consult), with a button to open another form that allows the user to add a new service record (F_Service_Add).

When the new service form opens, the service number counter is incremented and this number is assigned as the new 'ServiceNo' in a new record added to the ‘Service’ table (using the SQL ‘Insert’ command). I would like this form (F_Service_Add) to open on this record only. In the code that creates ‘ServiceNo’, the correct value is contained in a variable called ‘lngServiceCount’. I have tried using this code to open my form:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "F_Service_Add"
stLinkCriteria = "Forms![F_Service_Add]![ServiceNo]='" & lngServiceCount & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

When I run the code step-by-step, the correct value is shown for ‘lngServiceCount’ when the mouse hovers over the variable (for ex. ‘155’). When the form opens, I have 1 record (Filtered), but nothing shows in the ‘ServiceNo’ text box.

I have deactivated the code that is in the ‘OnCurrent’ event procedure of this form to avoid any interference.

There are many sub-forms on the main form, which also contain the ‘ServiceNo’ in text boxes.

When I use this command to open the form:

DoCmd.GoToRecord , , acLast

the form opens correctly, with the correct ‘ServiceNo’, but ALL the records are opened.

The variable type for ‘lngServiceCount’ is a long integer. (I hope that is the correct term in English, because I am using a French version of Access).

I would be very grateful if anyone could tell me what I’m doing wrong. I’ve tried to be clear, but if more information is required, I would of course provide what’s missing.
Thanks in advance.


I have searched the Access Help and Internet, but could not find a related topic on this.

Then I came to know this forum and am hopeful that I can get some help here.

I am a novice in Access.
I work mainly in Excel but due to ever growing data, I am now switching over to Access. While working in Access, I have hit a roadblock on Access 2007 PivotTable (while displaying on a Form).

What I want to do is to get/grab the Pivot Table value (as displayed on a Form) whenever the user clicks on any of the value.

This is what I have on this Form:
- multiple subforms.
- and 1 subform displaying a Pivot Table.
- a separate subform to display data corresponding to the PivotTable value when the user clicks on it.

For example, the user clicks on row 3 / column 5 of the Pivot Table subform, the other subform should display this value as well.

The reason why I want to do so is because I want the user to make a comment against the Pivot Table value. Pivot Table does not allow you to enter data, hence I am going for this alternative.

I have noticed that when I do a mouse-over the Pivot Table (on a Form), there is small popup window displaying the value of it.
If I can get/grab this value, either from a Macro or VBA, it will solve my problem as in I can then pass this value to the other subform.

If I am not wrong, this is the screentips popup for the PivotTable.
You can set this screentips on/off by:
- set your Form to PivotTable view
- goto Property Sheet
- goto the Report tab and there is a checkbox for Screentips

It would be nice if I can grab this screentips value via a Macro or VBA.
Is this possible?

PS: Sorry for the long post. I am trying my best to illustrate my problem as concise as possible.

Thank you for your time in reading this and I would really appreciate any advise/help on this.

Not finding an answer? Try a Google search.