Search results

Greetings, Has anyone ever used Docmd.printout to print a form? If so how do you get it to fit to 1 page? Are there properties to do this? Spent

Greetings, I have a Pivot chart form that I have embedded in another form. I want the user to be able to use the pivot chart, but not be able to right click it and add fields etc.. Any tips on how to achieve this? Spent.

Have you tried: Open strFile For Binary Access Write As hFile Len = 3 Put hFile, , "RID"

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: