Search results

Yes, using the dll. Read above post (it works with different mouse).

Tested with different mouse and it works. So apart from getting a new mouse, is there a another way around?

Yo Bill, Rather than using SQL and append, you could use VBA. E.g. Private Sub btn_append_Click() Dim RdSet Set RdSet = CurrentDb.OpenRecordset("tblCommunication") RdSet.AddNew RdSet!communication = theCommunicationString 'insert all other field props here RdSet.Update End Sub

Thanks guys, must be my hardware. IBM mouse?

Greetings, I am trying to get Lebans Mousehook to work, but it aint do .... http://www.lebans.com/mousewheelonoff.htm I have setup a test database to use the mousehook. When I click the stop mouse button it should stop the mousewheel cycling through records, but it does NOTHING. Anyone got...

ANy chance of posting the entire macro?

Can you just use an append querry rather than copy and pasting everything?

Try something like this:

"INNER JOIN JobType ON tbl_Status.TypeID = JobType.TypeID" TypeID is missing?

A simple method is to have 2 querries. Qry1: SELECT Table1.* FROM Table1 WHERE (((Table1.EXPIREDATE)>Now()) AND ((Table1.LASLEFT)<>0)); Qry2 SELECT Qry1.* FROM Qry1 WHERE (((Qry1.LASLEFT)<>0) AND ((Qry1.REMAINING)<>0)); Then set your form's data source to Qry2

Wow, that is a lot of hard work. Would be easier just to go into the table and use find/replace. Good Luck!

Not Really. Requires editing to make it work. If my guys go in and start scrolling with the wheel I want it to go back to the original record

Greetings Friends, I have a form when it opens the navigator is on 1 of 899 records. I have set up the following to try and prevent mousewheel: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) If Count > 0 Then If Not Me.Recordset.AbsolutePosition = 0 Then...

Problem solved. Stupid mousewheel dll corruption!!!

Greetings, I have a database which is used by approx 7 people here. I do my developing in an mdb file. Then I compile to an MDE. The 7 people use the mde file to update 2 SQL server tables by ODBC. Yesterday afternoon at approx 3pm some forms in the mde when opening became very slow. This has...

Yo SMIG can you post your DB?

Try this from the Spent Geezer's Association:

Thanks Bob!! I never knew about the .column property of comboboxes, how sweet it is.:)

Me thinks: You may need to use combobox.text in your code as just combobox will return the row selected (e.g row 2, combobox = 2). Using combobox.text will also require a setfocus. Perhaps on the form you need the combobox onchange to update another control that is easier to use in your SQL...

Random Access Files? Can you explain: 1)what you are doing exactly 2) How you are doing it ?