I have an Access 2007 continuous view Form and would like to capture the mouse X=-Y coordinates to set the start up position for a small Form.
I hoped to use MouseMove method, but this does not work.
Hi all,
I am having problems joining two tables together.
The first table contains X and Y coordinate values:
X Y
525914 176619
525942 176685
525964 176697
525952 176710
525905 176738
The second table contains the same/similar X and Y values and an asset ID.
ASSET_ID XX YY
00030781 525914 176617
00031583 525942 176684
00032265 525964 176697
00032260 525952 176711
00032255 525907 176738
I would like to make the query on the X and Y fields from both tables and when they match, join them - Simple. But I would also like to add a tolerance of 2 in the query, so if the XX or YY coordinate value from the second table is within 2 of the X or Y coordinate of the first table they should also join.
For example if table 1 had X and Y values of:
525914 176619
and table 2 had XX and YY values of:
525914 176617 or
525916 176619 or
525915 176617
I would want to make the join.
So far I have only managed to join when the values match:
X Y YY XX ASSET_ID
525687 176521
525697 176447
525709 176392 176392 525709 00032873
525709 176408
525709 176535
525711 176515 176515 525711 00035221
I have tried using < and > expressions but I can’t get the SQL right. Can anyone help please? It would be much appreciated.
Many Thanks,
Greig
I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedI am working on a database at the moment to try and find the customer that has spent the most money. At the moment i can only get the customers that have placed the most orders. I have a dispatch table that consists of all the orders and a customer table that are linked using a Customer Number. Each order has a dispatch number because one customer can buy more than one product per order. Like i said at the start I'm trying to find the customer that has spent the most money but the top 10 would be better.
View 7 Replies View RelatedI have the following code which returns me the number of rows in an excel sheet:-
Lastrows = .Worksheets(1).Cells.Find(What:="*", SearchDirection:=2, SearchOrder:=1).Row
How do I mod the code to find the last 'used' row in the sheet?
The sheet is automatically generated daily, so I can't change anything in that area. It's always 2000 rows long and usually only has around 1100-1200 rows of data.
It's just that I do a for loop later on in my code for 1 to Lastrows and would like it as exact as I can.
I work in the Insurance Industry and I am having a hard time trying to find the formula for finding the answer to the below issue I am having.
In a table I have 4 columns:
1st: Total # of Claims (Claim Count)
2nd: Total # of Items (Item Count)
3rd: Item % of Claim Count
4th: Average # of Items per Claim (This is the number which I am trying to get)
Is there a formula which could give me the "Average # of Items per Claim"?
I am using access 2007
i have a materialsUsed tbl that list all the materials used in a job and the quantity of each.
(ID
Material Code
Quantity
Unit of Measure)
I also have 2 look-up tables - 1 for the material codes and 1 for the units of measure
I have another table, priceperunitofMeasure
id
material Code (FK to material lookup tbl)
Unit of Measure (FK to unit of measure tbl)
Price
In my form Users will select material code from combo box - enter the quantity, and select a unit of measure from a combo box.
For example: they could enter the following :
Paint 2 gallons
Paint 3 tubes
Paint 1 pint
How do I lookup the price per unit of measure for each of these records in the price per unit of meassure table? The price per unit of measure table has 2 foreign keys.
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
View 5 Replies View RelatedIn 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......
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 8 Replies View RelatedHi,
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
What is the simple code to stop mouse wheel to scroll records on the form?
View 3 Replies View RelatedI 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
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 RelatedHi 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
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.
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.
Steve
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?
Thanks-- Appreciate any suggestions
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.
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
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
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
You know the scroll ball wheel thingy on your mouse inbetween the two mouse buttons.
On a form i created if you scroll up and down on it it scrolls through the records on the form.
Is there anyway i can stop this from happening?