Hi Stephen Lebans
Thank you very much for your effort and time you have spent writing
and helping small hacks like me.
I have just one problem with your mousewheelhook.
I'm using Access 2002.
I have db with an unbounded Main Form with numerous sub forms. The
mousewheelhook works find with the subforms in the Main Form.
Mousewheelhook is loaded in the Main Form Load event and unloaded in
the same form in the unloaded event.
The problem is from loading a popup form from a list box in the
subforms. Double clicking in the list box calls the form with the
selected record. The record shows up in the popup form, but when you
move the mouse wheel, it cycles between the select record and a new
record. If you go to the list box in the popup form, and select
another record, the record is loaded and the mousewheelhook works
fine. But if you use a new record button, you load a new record but
when you use the mouse wheel you can cycle from the last record loaded
and the new record selected. I don't know if its my coding or
something else.
Here is my code from a Listbox in a subform that loads a popup form.
strFrmName = "frmOrdItem s"
If Not IsNull(Me.txtOr dID.Value) Then
If Not IsNull(Me.lstIt ems.Column(6)) Then
lngItemNo = Nz(Me.lstItems. Column(6), 0)
Form_frmMain.tx tRecExt.Value = lngItemNo
strItemNo = str(lngItemNo)
strLinkCriteria = "[OrdItemsID]=" & strItemNo
DoCmd.OpenForm strFrmName, acNormal, , strLinkCriteria
Else
DoCmd.OpenForm strFrmName, acNormal
DoCmd.GoToRecor d acDataForm, strFrmName, acNewRec
End If
Else
MsgBox "Please Select or Add Order!", vbCritical, "Order No Error"
End If
Any help would be greatly appreciated Steven.
Thanks again for your time and understanding.
Chris Sydney Austraila 1 1848
Can you send me the MDB that demonstrates this issue?
Go to my Web site and submit Feedback with a valid EMail address. I'll
reply with my Email address.
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"ChrisR" <ch***@krisarac omputers.com.au > wrote in message
news:97******** *************** ***@posting.goo gle.com... Hi Stephen Lebans Thank you very much for your effort and time you have spent writing and helping small hacks like me. I have just one problem with your mousewheelhook. I'm using Access 2002. I have db with an unbounded Main Form with numerous sub forms. The mousewheelhook works find with the subforms in the Main Form. Mousewheelhook is loaded in the Main Form Load event and unloaded in the same form in the unloaded event. The problem is from loading a popup form from a list box in the subforms. Double clicking in the list box calls the form with the selected record. The record shows up in the popup form, but when you move the mouse wheel, it cycles between the select record and a new record. If you go to the list box in the popup form, and select another record, the record is loaded and the mousewheelhook works fine. But if you use a new record button, you load a new record but when you use the mouse wheel you can cycle from the last record loaded and the new record selected. I don't know if its my coding or something else.
Here is my code from a Listbox in a subform that loads a popup form.
strFrmName = "frmOrdItem s"
If Not IsNull(Me.txtOr dID.Value) Then If Not IsNull(Me.lstIt ems.Column(6)) Then lngItemNo = Nz(Me.lstItems. Column(6), 0) Form_frmMain.tx tRecExt.Value = lngItemNo strItemNo = str(lngItemNo) strLinkCriteria = "[OrdItemsID]=" & strItemNo DoCmd.OpenForm strFrmName, acNormal, , strLinkCriteria Else DoCmd.OpenForm strFrmName, acNormal DoCmd.GoToRecor d acDataForm, strFrmName, acNewRec End If Else MsgBox "Please Select or Add Order!", vbCritical, "Order No Error" End If
Any help would be greatly appreciated Steven.
Thanks again for your time and understanding.
Chris Sydney Austraila This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Wally |
last post by:
Hi All,
I'm using Stephan Lebans' nifty code for automatically resizing text
fields to the size required to show (almost) all text in that field
(CanGrow3, thanks Stephen!).
In general this function works great. However, I sometimes have a
problem with the last text line. Often the last line is just below the
end of the field and to view that line I have to scroll to it. Is that
a known problem? And is there a solution?
|
by: Patrick |
last post by:
I am using Stephans code to change the background color of the Access
container in Access 97, the code works fine when running in Access in
the normal way.
The problem occurs when running the program after creating a RunTime
version when a gray rectangle appears at the top left hand side of the
screen.
This effect is present when using the sub that changes the color and
when using the sub that calls up an image.
|
by: Alex |
last post by:
The JustiDirect text justification on Stephen LeBans site works well
but I cannot get it to work on a sub report. Could anyone tell me if
this is possible.
Thanks.
Alex
|
by: Alex Wisnoski |
last post by:
I am trying to adapt Lebans' ReportUtilities to export reports (to
preserve formatting) from an Access 97 application. I have made the
reference to his mde and copied the modules into my db. I have
created a custom toolbar with a custom control, "Export to File". In
the On Action property (of the export control) I inserted the code
"pf.ExportToMSWord rptApplicantReferral" which I had copied from his
sample db except for the name of my...
|
by: Karl Roes |
last post by:
Hi Stephen,
Very Cool. I can only get it working on the first row of a continuous
form. Is this correct?
Regards
Karl
| |
by: Phil Stanton |
last post by:
I am trying to produce a program that will output any Access report to an
editable Word document. So far it is working well but slowly with text
boxes, labels, and lines.
I now need to try to output one of Stephen Lebans' RTF2 controls on the
report. He indicates that a copy and paste method will work from a form to
the Word doc and that is fine although I have not done this in VB, rather
used ^C and ^V
I suspect that a similar method...
|
by: Rémi |
last post by:
Hello all!
I've been using Stephen Lebans' MouseWheel stuff for a number of years
now, without problems. I've used on different combinations of Access
and Windows, and have had great results with it. (Even better,
considering what I paid for it.)
Just hit a situation where it didn't work, though, and I was wondering
if anyone else has hit this yet:
*A dumb terminal, running Windows 2003.
|
by: nospamhere |
last post by:
Hello Stephen and all,
This is such a cool group. I really need to spend more time here.
A few months ago I noticed some brief discussion here about the fact
that your excellent HTML Editor for Access is not yet compatible with
IE7. At that time, you correctly pointed out that IE7 was still in
beta status and that you would not consider any update to A2KSHTML
until after IE7 was officially released. Obviously, that was the only...
|
by: grant |
last post by:
Hi
I've copied Stephens code into my db, and can get it to work, but only
on "plain Jane" reports with no images.
Most of my reports has an unbound image obluect in them that I set to
an external image file using on_open code
I've searched through this group and there are a few comments about
snapshots not working with embedded images, and my testing seems to
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |