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!
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)
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.
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
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.
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.
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?
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.
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.
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.
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
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
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......
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.
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:
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?
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
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.
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.
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?
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?
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
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.
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