Disabling New Post On Mousewheel Scroll
Jan 17, 2006Hi
I have a problem, when on a form based on a table, scrolling the mousewheel will by default change the post shown, how can I disable that event ???
Im using Access XP..
ADVERTISEMENT
Disabling Mouse Scroll In A Database
Nov 27, 2007Has anyone stumbled on VBA coding that will disable the wheel scroll function on the mouse when using it in an Access database. I am using Access 2003. I was given some code for this by a friend and it worked on the first database I tried but none after. I keep getting a Compile error: Sub of Function not defined - even though I cut and paste the code from the database where it works.
Can anyone help? It'd be very much appreciated.
Forms :: Subform Scroll Bar Scroll To Bottom?
Apr 25, 2013I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?
Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub
Mousewheel In A Form?
Jan 18, 2005How can I force the wheel (found on some mouses) to scroll down a page and not cycle through records? I tried to change the Cycle property to Current Record Only, but that still allows going to another new record if users are already entering a new record.
Thanks in advance.
Enable Mousewheel In A Form
Apr 27, 2006Hi guys!
Got a small problem. I got a big Access-form (big of size) but a small computerscreen before me. I am very much used to scroll up and down with my mousewheel.
However, when I open my file and the opening-form pops up I cannot scroll up-and-down the form using my mousewheel.
Is there a VBA-code or whatsoever which can enable the mousewheel???
I tried to find the answer in earlier discussions, but I found only discussions where the topic was about disabling the mousewheel. I want to ENable it.
Does anyone has a clou?
Many thanks, cheers,
Willem
Reports :: Why Does Report Repaint On Mousewheel
Jun 18, 2013So whenever I scroll through my report it will repaint all of the graphs and other stuff on each scroll event. Its pretty fast, but it still looks pretty bad. My only guess is that there are enough graphs on there that its handling too much data, but its just a guess.
View 4 Replies View RelatedMousewheel Block On Subform Only (for Fussy Users)
Sep 23, 2005The Return of the dreaded mousewheel! I have used the fab Search option on this topic, but I feel I have some requirements that prohibit me using some of the options available. I need to allow its use for navigation of the mainform, but totally block it on the subforms, but with lots of conditions!
The database in question is NOT mine, and it's already built. If it were one of mine, I'd simply block the darn thing entirely or adopt some of the example databases I found (ghudsons was the kind of data verification I can dig, and a few in A97 format were good too).
I have to cater for workmates that are strangly fussy, rather lazy and totally unappreciative of order. Who would have though enforcing uniform entry of dates from 20 different ways (I counted) to one way, was such a contentious issue? OR, a BAD idea? Sigh.
As a result, I cannot be seen to have done ANYTHING to its function. So, I cannot have:
*Any form of "save" each record or blocks or anything like that
*Any form of validation boxes or message boxes popping up
*No dlls (if possible)
*In a nutshell, no extra effort - Type 'n' go - it has to be a secret
*And, I can't block the mousewheel from scrolling through personnel in the mainform.
I have to eliminate the RAMPANT creation of duplicate subentries (like, you're still on the one record in the main form, but if you're not paying attention and wheel in the subform, you flick over to the new row and type, and POW).
Am I dreaming? Is there some easy solution in form setup that I'm overlooking? (the problems of self-education, you are often unaware of some of the simplest little options). I aplogize if this solution has been presented before on the board, but it is likely I didn't not understand what I saw properly, or I felt it wasn't quite what I wanted. Thanks very much.
Where Should I Post?
May 6, 2005I have a very involved question regarding the export of data from and Access front end, SQL back end into multiple Excel Worksheets.
Where is the best place to post this in order to get maximum exposure to the great minds that cruise this board.
Regards
Not Sure Where To Post This
May 17, 2005I have a form that has several multiple choice question and i have also designed a table and update queries for the DB so far i can enter the values and then have them changed from the original to the values requested by my bos however i also need to find a way to make a report that will allow me to shot the percentage of people that chose each individual answer with anywhere from 2 to 10 possible choices on each question i see no logical way to do this....... help!
View 1 Replies View RelatedMy First Post
May 24, 2005Hello every one
I am new here and this is my first post
I am trying to make overtime record for my company
I use the following feilds
field name .................... format
Start_Time ................... short time
End_Time ..................... short time
Total_Over_Time ........... short time
now when i use
Total_Over_Time = [End_Time]-[Start_Time]
I got correct answer
but
while i am trying to make monthly report
if Total_Over_Time is greater then 24 hours it shows me 1
means for 25 hours is shows 1
Please help me to overcome this problem
Thanks
Pehalwan
Don't Know Where To Post This
Jul 8, 2006I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance using SQL server as the back end but have never had to develop my own server.
I do not have access to an existing server but do have permission to purchase SQL software, this is where I need the help. If anyone has suggestions, advice, links or other information I would be greatly appreciative.
Thanks in advance for your help.
“where I added information”
A lot of you have been reading this but no help.:eek: Did I use a poor title? I have used SQL as a back end but really need to know how to produce one out of thin air.
I ordered SQL 2005 off my company's IT store but when reading further it needs a special operating system, I think. Is this true? What do I need to have in order to provide a very large data set to a bunch of barely computer literate analysts?
These people are excited when they realize that vlookup can do more than one thing!! The concept of a union query would blow them away. I am frustrated with the competency of my co-workers but need to give them something that is idiot proof without letting them know that this is the object.
Currently they are having an SAP download sent to a specified share drive and running an Excel “macro”, moves a couple of columns an such, that puts it into a format that is semi-usable. This is totally inefficient for their needs but they don’t know it as yet.
What I am asking is how to take a fairly robust pc and make it a SQL server that will service a dozen or so people. What kind of operating system is needed and what sort of admin rights will be necessary to allow access to the desktop so they can get their data?
The IT help desk is very scary, not really understanding the requests presented. I haven’t been with the company very long but what I have garnered disturbs me I don’t believe the IT people have a clue.
I’ve been an Access developer for about 4 years now and know this is not an insurmountable obstacle. I am confident that SQL is the solution but haven’t ever had to create it from scratch before. Please, links or other suggestions are MOST appreciated.
Dunno Where To Post This....
Sep 4, 2007Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue.
I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the problem I'm running into is with serial numbers.
Some serial numbers are entirely numbers, while others are alphanumeric. When the field is set to numbers all of the parts (a different field) show up, but not all of the serial numbers are imported. When the field is set to text some of the parts are dropped, along with their associated serial numbers and then some of the serial numbers show up as scientific notation.
Any ideas on how to solve this problem?
Does Anyone Know How To Post A Db On This Forum
Mar 17, 2005could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable
View 4 Replies View RelatedDatabase Example. Please Post
Nov 10, 2005i need dbase example from all of u..especially example for newbie like me...i'm looking for example that update subform using combobox...
View 5 Replies View RelatedPost Code Search
Aug 16, 2005does anyone know if it is possible to add a post code checker/search to access, if so do you know of one which works. I want to be able to bring up an addess by post code/house number in the UK
View 2 Replies View RelatedValidating A Post Code
Nov 29, 2006HiBeen trying To Find A Way Of Validating A Postcode.But Getting No Where Being They Can Be Like CT1 1QX, CT11 2DT, CT11 12DT Act.Best I've done is to make sure there's a space and it starts and ends with a Letter.Any Help Advice Would be much AppreciatedMick
View 2 Replies View RelatedDifference Between Post And Thread
Mar 15, 2007Hi guys am not sure if i got dis in d correct forum (forgive me if not)
Just wanted 2 know what's d diff btwn a thread & a post (if d's any)
Noks
Post-code On Form
Jan 23, 2008Hallo,
I have a post code field on my form. What I want to do is, if a user enters a wrong code ... i,.e., not Post code format it alerts the user of post-code not in use. Please if there is any example of a database of this functionality usage or a way of doing it will be much appreciated.
I live in UK and the post codes down here are like E12 5AH ....
Many thanks
Follow-Up To Previous Post...
Nov 15, 2004Greetings,
I am just posting a follow-up on my previous post on designing functional forms. Telling by the lack of replies, my original question may have been long winded and tedious. Let me try to narrow my question and make it more concise.
In two tables connected by a one-one field name ProfileID, how can I set a new field in the second table (call it StepNo or procedureNo) so that it increments step numbers for each unique ProfileID record? Thus for each new Profile record created in the first table, a new form will allow the entry of X numbers of steps into the second table and automatically link the two records?
I hope that clarifies my problem. Thanks in advance.
Post Code Validation
Apr 7, 2006I have searched the forum for posts on the subject of UK postal code validation and found the reg expression that seems to be recommended for this.
I tried the expression but it will not accept this postal code? TS183AM
Like "(?:(?:A[BL]|B[ABDHLNRST]?|" & "C[ABFHMORTVW]|D[ADEGHLNTY]|E[CHNX]?|F[KY]|G[LUY]?|" & "H[ADGPRSUX]|I[GMPV]|JE|K[ATWY]|L[ADELNSU]?|M[EKL]?|" & "N[EGNPRW]?|O[LX]|P[AEHLOR]|R[GHM]|S[AEGKLMNOPRSTWY]?|" & "T[ADFNQRSW]|UB|W[ACDFNRSV]?|YO|ZE)" & "d(?:d|[A-Z])? d[A-Z]{2})"
First Number In A Post Code
May 23, 2007Hi,
I'm trying to isolate the first letter / letters of UK post codes.
Typically they are of the format ..
WS9 0JL
The obvious choice is left,2 but of course it's never that simple
some post codes are B1 7FH so left 2 gives me B1 but I need just the B
I can use Left 2 and the look at the second character to see if it is = "1" or "2" etc. but this seems a bit crude.
Is there a way I can find the position of the first number in a string (using the Instr function maybe)
That way i could Isolate the letter/s
Thanks
SBM
Form Designs (Please Post Yours)
Jan 4, 2007One thing that I personally think I'm bad doing is creating GUIs. I think my forms look pretty bad overall, and I'd like to get some ideas/pointers from some of the more experienced folks.
I've included a typical example.
Post Code Validation
Mar 20, 2006hello all
this thing is really bugging me im trying to come up with a post code validation and i have tried dozens, which should have worked really, but just havent so wondering if you guys knew any
examples of postcodes would be
BN3 8JH
BN41 8JH
the first and second characters have to be a letters
the 3rd has to be a number
the 4th is sometimes a letter (not always present)
then theres a space
then there has to be a number
letter
letter
any suggestive codes would be great, as none of mine have worked its in access
thanks
Query Help-1st Time Post
Jun 5, 2007hi this is my first post. This is probably so basic you will think i am stupid but your help would be appritiated.
I have a very simple database which displays the questions stored in a table in a form . The recipent answers the questions generaly yes or No. On answering yes or no i wish to attach values (hidden) to thier answers and then based on the answers produce a simple set of bar charts. I have tried but do not know how to assign the values to the questions . i would then like to produce 5 bar charts 1 for each of the catogories and one as a total (as an overall and also in sub groups of which there are 4 each of which has a field with a specific prefix either b,c,r,s dependant on the type of question. )
hope someone can help
Page Jump
Newbie Post - Query Question
Mar 14, 2006Hi, i'm a newbie so please be gentle :)
ok, i have 2 tables, one is for part number and product ID and the other has product ID and Vehicle details.
i know how to set up a parameter query but just can't quite get the result i want, which is to set up a query based on the result of the first query.
in short i want to enter a part number and it comes up with the vehicle details.
Many thanks in advance
Ty
Cities/Towns+Post Codes
Nov 21, 2005I have a Contacts DB and at the moment I enter Cities/Towns and Post (zip) codes separately. I now want to set it up so I can select a city or town and have the appropriate post code fill it's own field without my intervention. Is this a case of cascading combo's or can I just bind a post code field to the city/town field? Can someone point me in the direction I need to go please?
View 1 Replies View Related