VB Forum / General / July 2006

How can I make a user defined function be called by anyone, not only dbo?
I tried with Grant Execute on functionname to public.
but I always have to write "dbo." in front of the function when I call it.
I need the function to be used in the public domain without restrictions.

I am using a monthview control.  if while the program is running the
system date changes (at midnight) the "Today" remains on the previous
day unless I close and reopen the program even if I run
monthview1.refresh every minute.  Am I missing something?

How do I get my form to open higher up on the screen?  I tried setting
Me.Top = <various values>, and even Me.Top = (Screen.Height -
(Screen.Height - 10)), but nothing works.  What's the secret?

I have set one of my command buttons to Style Graphical so I can place a
picture on it, only problem is the text for the button has been pushed to the
bottom of the button, is there a way to centre it?
David

hello..
I am new to VB and really new to LDAP
I am trying to write an application for our lunch card system...where a
student's card is read by a barcode reader and the information (a

I have the Learning Edition.  My project currently consists of three forms
and a text document (contains an explanation of how everything is supposed
to work and how to use it like it's supposed to be used).  I also see a
couple of frx files and the project vbp and vbw files.  ...

Is there a way within VB6 to send a keystroke to my own application (which
is alive and well, but does not necessarily have focus)?
Basically, I have an external device which, when used simulates key
presses using the VB6 command "SendKeys". Unfortunately, I have noticed

I I think I have a resource problem with my VB 6 program. It's a very
complicated program with many controls. very rarely,when I attempt to
run it with too many other programs open,I get an out of memory error
message. This, despite the fact that she nor has one gig of memory. If

Is there a way in VB6 to loop through the files resident in a folder and
determine which one has the latest date? The file-name will conform to a
specific format.
Any help will be much appreciated.

If I have several enums, I want to
know what their group is, not just intellisense for what the actual
enums under the group are.  I need it to be like the .NET languages or
Borland languages.  In other words:

Dim ts As TimeSpan = crun.Subtract(lrun)
I am using this to find the elapsed time, is there any way I can do this
comparison without time part, such as if lrun=07/16/2006 and crun=07/17/2006
I need to return 1 since there has been 1 day passed.

I'm just trying to do some simply profiling on a program that's running
slow.
I started by wrapping blocks of code in:
Dim d as date

My problem: I would like to use Visual Basic 2005 express addition to
develop applications for Excel 2002 (version 10). The reason is that
VB.net supports more of OOP such as inheritance, etc.
In particular I would like to build a main library of classes and

I'm trying to re-create in VB(6) how my drag-drop works with my VBA/MSForm.
I have a grid of CommandButtons as a ControlArray (in VBA though a
WithEvents class to trap button events)
On button press and mouse move start-drag. Actually only after X or Y move