Problem solved.
Inside the user control I have a picture control that is used to show/hide a list view. I changed the use of mousedown to click and this event was picked up without the user control having focus.
I've created a user control that is now one of many standard controls on a form. It functions OK once it has focus but I have to click on it (with no action taking place) for it to get focus. I've tried to set focus based on mouseenter, gotfocus, enter (control events) but these events are not...
BobRodes,
The controls are "hidden" because the relevant tab that they are on is not shown at the point of the resize. After resizing, I should be able to go to that tab and see the relevant controls resized. However, they are gone! Irrespective of the tab that is shown when I resize, those...
On examination, the controls on the hidden tabs are given large negative values for their "Left" property and this produces the unwanted result.
Does anyone know of a way to effect a resize on all a forms controls when some are placed on a hidden tab?
p.s. Sorry about the post spread over a few...
When the user resizes their form, this triggers for form resize event which I trap and then use the ratio of old size to new size to give me new figures for height, left, top etc for each control.
I then iterate through the controls collection applying the new figures. This is fine for those...
rennis,
Not sure if I'm reading this right, but is that the exact SQL statement?
Select * from table where primary_key in ("& the_primary_key_var &")
If you are putting the sql into a string I would expect to see:
sSQL="Select * from table where primary_key in (" & the_primary_key_var & ")"
HTH
Unfortunately, I didn't solve the problem and having tried two Sony Vaio's had to send them both back. Now have a heavier, bigger and faster laptop that works!
Has anybody had these symptoms and do they know a workaround/update please?
I have a brand new Sony laptop (SZ3XWP/C) using XP Pro SP2 and have installed Norton AV and MS Visual Studio 6. Other software was then installed but the symptoms started at this point.
During use of VB6 the system...
You could install them into the default folder and then have a routine that runs the first time only that looks for the relevant files and moves them to the place where you want them to be.
We are using XP and Outlook 2003. We print all e-mails as a record of correspondence. Some e-mails when printed show the header - From/To/Sent/Attachments, some do not. I don't know what makes one do this and another not! We are using the same pc, printer and print method to print both. It...
If you use 2 connection objects the logon's to each database will be handled by each connection. I have written various routines which talk to tables on two databases which can be on two separate pc's.
I use a config file to give me the database locations and read this in at startup. That way...
You could create a control array with the first button hidden (index=0) but already containing the code. Create a new instance on the form (index=1) - that's visible and position it where needed - and the code will already be there!
Latest update following feedback from microsoft newsgroup:
Output of emails to Drafts is not a problem. They still get sent when Outlook is scheduled to send/receive.
Still have the crashing problem on one pc though. Think it may be to do with Outlook or Redemption settings.
Further update after more testing....
On the pc used above, the VB dev environment crashes when I return from the routine above. If I take the code above and run it within the loop and reinstate the Set orSafeMailItem=Nothing, the VB dev env crashes when it executes that line.
On another pc...
David,
Have you tried converting the dates to Doubles. I had major problems creating SQL from VB and submitting dates that can be transposed into Access until using the conversion.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.