Mouse Over Effect

Jul 4, 2007

Hello, I have two images (img1 and img2) and I want to have img1 visible when the form opens and when I run the mouse over img1 it changes it to visible = False and img2 is visible = True. Also when I mouse off the image it changes back to img1… How is this done? Thanks!

View Replies


ADVERTISEMENT

Read Only Effect In Query...

Jun 22, 2005

Hello,
I'm having a little problem with an Access Query. Simple table design, with relationships as normal, using a junction table for a many-to-many link.

Table1
Field: Area (Text)
Field: T1_ID (AutoNumber)

Table2
Field: T2_ID (AutoNumber)
Field: Value (Double)

Table3Join
Field: Area_ID (Long Integer) *Rel: Table1.T1_ID
Field: Value_ID (LongInteger) *Rel: Table2.T2_ID

Table4
Field: T4_ID (AutoNumber)
Field: Area (Number) *Rel: Table1.T1_ID
Field: Description (Text)

Query1
Sources: Table4, Table3Join, Table2, Table1
Fields: Description, Area, Value

SQL:

SELECT Table4.Description,Table4.Area,Table2.Value
FROM Table2 INNER JOIN ((Table1 INNER JOIN Table4 ON Table1.T1_ID = Table4.Area_ID) INNER JOIN Table3Join ON Table1.T1_ID = Table3Join.Area_ID) ON Table2.T2_ID = Table3Join.Value_ID;


However, with this design as it is, I cannot "edit" the Description field, or change the Area field. The entire Query becomes read only. Why is this? And how should i re-write this to allow me to use the relationships which Link Table2.Value to the appropriate Table4.Area (and display them both in one query), while allowing me to edit all the sub fields.

Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner

Using: Access XP 2002 (10.4302.4219) SP-2

View 3 Replies View Related

If/Then Effect Only Current Button

Oct 25, 2005

I am trying to write code to change the color of the text on a button on a continues form. I only want the button for the specific record, that meets the requirements of the if/then, to be effected. The code below will change the button for every record if one record meets the requirements.

If Me.datPMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datPMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
If Me.datSMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datSMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
Me.cmdAccessMaintenance.ForeColor = 0
End If
End If
End If
End If

View 5 Replies View Related

Queries :: ORDER BY Statement Seems To Have No Effect

Oct 15, 2014

SELECT Count(Query1.Route) AS NumberofReRoutes, Query1.Route
FROM Query1
WHERE [Start Date] <= #9/30/2014# AND [End Date] >= #9/1/2014#
GROUP BY Query1.Route
ORDER BY "NumberofReRoutes" DESC;

The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. I need these sorted by the NumberofReRoutes field, but this method isn't working!The output at the moment is two columns: Route, and NumberofReRoutes.

View 3 Replies View Related

Hyperlink Roll Over Effect On The Access Form

Nov 11, 2005

Hello,
I have a MS Access form with a few hyperlinks on it. I have tried to achieve effect similar to hyperlink roll over effect on a web page: when mouse pointer goes over a hyperlink it changes colour, etc.
Unfortunately, all I could find was MouseMove event:
Sub Label_MouseMove
Label.ForeColour=vbBlue
End Sub

But in this case hyperlink stays blue even after mouse pointer leaves it. And I would like hyperlink get back it's initial colour.

Thank you

View 2 Replies View Related

Textbox Values Not Valid Because Of Misterious Side Effect

Feb 26, 2007

Hello the problem I am having is that when I imported data from excel, it somehow placed carraige return at the end of the text box ( this is what I believe), this is a problem because in that field is a drop down box and it complains about my value not being valid. I press the del key behind the value and it doesnt complain. Can anyone help me?

View 1 Replies View Related

Tables :: Change In Sharepoint List Not Taking Effect?

Jul 24, 2013

I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.

I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.

View 1 Replies View Related

General :: Effect Size In Multiple Linear Regression

Jul 4, 2012

I have (from SPSS) many multiple regression analyses, and each one of them has about 7-8 independent variables. I need to find the effect size-in particular I want to have effect size above 1% and statistical significance p<0.001. I am familiar with p, but I cannot understand whether effect size is b, beta or R square and how to interpret it.

View 1 Replies View Related

Forms :: Strange Font Effect While Running Through Records

Nov 28, 2013

It is a strange effect I get when switching among records.

In a form I have a TAB Control with some pages, when I open the form everything is ok:

But, when switching continuosly among records, the font becomes strange, looking like being bold.

It seems to happen only when using TAB control or, if you prefer, only on every TAB control's page except for the first one. Tried on different pc with different resolution.

View 2 Replies View Related

Wheel Mouse

Apr 30, 2005

Hello to all,
Here is my questions :
1) Is it possible to enable/disable mouse wheel in modifiable list (combo box) ?
In access2000 i can't select a record on the list with mouse wheel.
2) Same thing in a form.
In a form the wheel is active to go to next or previous record but sometime would like to disable it.
Thks in advance

View 3 Replies View Related

Mouse Wheel

Dec 1, 2005

hey all I am having a problem, and most people dont seem to know what to say and not to give me any ideas. So here we go. I have a form which you can scroll through the reocrds, with the mouse wheel, or through the navagation command buttons with I have created. However when I use my mouse wheel the record changes but it doesnt change my activeX Control. When I use my command buttons it changes. However I would like to have both the options so anyone have any ideas on how to get the activeX Control to change with the rest of my record?? Thanks

View 5 Replies View Related

Mouse Scrolling

Feb 15, 2007

In Access (2003) I was able to (by default?) scroll through records with the mouse scroll wheel. That no longer works. How can I have the form scroll backwords and forwards with the mouse wheel?

I've been reading threads and it sounds like MS "fixed" a feature that I was relying on heavily to move through records. I can't find a way to enable it again......

View 2 Replies View Related

Mouse Scrolling

Jan 17, 2008

Hi,

how can i stop wheel mouse scrolling on certain forms? it is ok on some forms but others where specific data is viewed can be scrolled to a blank space.

Many Thanks,

Nigel

View 4 Replies View Related

Mouse Wheel

Mar 10, 2008

What is the simple code to stop mouse wheel to scroll records on the form?

View 3 Replies View Related

Right Mouse Click

Apr 5, 2005

I would like to add to my form the ability to right mouse click to print a report, is it possible to achive this and if how can I.

Regards - Paul

View 3 Replies View Related

Mouse Options

Jul 14, 2005

Is there an option so that turning the mouse wheel will scroll through the screen rather than scrolling through the different records in a form? Thanks! :confused:

View 3 Replies View Related

Mouse Scroll

May 20, 2006

Hi all,

I have read much about disabling the mouse scroll bar - but my problem is that while I want the use of the scrollbar, it is very jumpy.

Does anyone know how I can control the functionality of the scroll bar?

Cheers

Robert

View 1 Replies View Related

A Better Mouse Trap...

Jun 20, 2006

Hi,

I need a way at preventing users from using the scroll funtion on mouses from creating a multitude of balnk records and hence was looking at ghudson better mouse trap as a way of doing this... this is the way forward isnt it?

Looking at the code it starts with...
'For those of us not using Access XP, we have a challenge to prevent
'our users from advancing to another record if they do not use the controls
'we want them to use or to prevent them from bypassing our validation
'procedures too ensure the current record is okay to be saved.

How do you prevent this from happening in Access XP?? Access XP = 2002 does it not?

Regards
H.

View 3 Replies View Related

A EVEN BETTER Mouse Trap?

Jul 28, 2006

First off sorry about the really bad layout…..I don’t know how to do all the fancy stuff but really wanted to share this because it seams like a lot of people wanted help with this.

So here is what I have going on.

I have a form to add a record, and I have a number of fields, then an “Add Record” button and a “Cancel Record” Button. What I wanted to do was:

A: Stop the form from going to another “New Record Form” when moving the mouse wheel
B: Stop the form from going to another “New Record Form” when pressing the “Tab” key


Here is what you got to do to solve the mouse problem:

1.) Create a field in the form that has the Name “MouseWheel Move”, and set the “Visible” property to “No”
2.) Enter the Fallowing:
Private Sub Form_Load()
Me![MouseWheel Move] = "No"
End Sub
3.) Enter The Fallowing:
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
Me![MouseWheel Move] = "Yes"End Sub
4.) Enter The Fallowing:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me![MouseWheel Move] = "Yes" Then
DoCmd.CancelEvent
Me![MouseWheel Move] = "No"
End If
End Sub


Here is what you got to do to solve the Tab problem:

The last item on my form is my “Cancel” button; so when the focus is on my “Cancel” button (ie. the last item on the form) and I press tab I want the focus to go to the first field on my form.

Private Sub Cancel_Button_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 9 Then
Me![Field Name for the First Item on the Form].SetFocus
End If
End Sub

One more thing, I am using Microsoft Access 2002 (10.6771.6735) SP3 and it works fine

View 8 Replies View Related

Wheeled Mouse

Mar 8, 2005

does anyone know how to stop the scroll wheel on a mouse from scrolling
through records whilst users are trying in imput data to forms? I assume there is some vb code that
could be used.

Steve

View 3 Replies View Related

The Mouse Wheel

Feb 3, 2007

I have a form, that is longer than the height of the screen, so the user must scroll down to get to it all. If the user uses the scroll bar all is well. If they try to use their mouse wheel to go down the form jumps to the next record.

How can I stop the form from doing this. If it doesn't want to scroll down with the mouse wheel I can live with that, but it should not go to the next record with this.

View 1 Replies View Related

Scrollable Mouse Changes Records (Is There A Fix)

Sep 25, 2005

Hi,
I'm using a scrollable mouse and I'am always accidently hitting it while in access 2003 and it keeps changing the records, Is there a fix for this with out changing to a non scrollable mouse?

Thanks-- Appreciate any suggestions

View 1 Replies View Related

VB Editor And Mouse Wheel

Nov 7, 2005

Hello to all,

Just something I hate and been frustrated about and would like to know whether it can be solved. I don't know about your PC but my mouse's wheel does not work in the Visual Basic Editor. This applies to all Office apps.

When I scroll the wheel, nothing moves. It works great in other apps, though, such as Explorers, ....

Is it something that was meant at designed or am I missing something here?

Thank you all in advance.

View 7 Replies View Related

Exit A Sub Form Without The Mouse

Jan 4, 2006

My main form has 2 “Continuous Forms” sub forms.
The cycle of the sub forms is set to “All Records”

Is there a way to exit the first sub form and move the focus to the second sub form utilizing only the keyboard? (Like shift + tab, or any custom buttons)
I’m trying to avoid using the mouse

Thank you

View 1 Replies View Related

Disable The Mouse Wheel

Jul 26, 2006

Hi everyone. Listen, is there a way to disable the mouse wheel from scrolling through entries in a form? I would like to do this in order to not confuse and upset the user further in the database I am developing, since they do have to enter data into it. Please help me.

Thanks,
LookingMoney

View 2 Replies View Related

Automate Mouse Click

Aug 10, 2006

I want to be able to automaticallly send a mouse click in response to a message using a Macro or VBA code. Is this possible, Any suggestions appreciated

thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved