VB Forum / General / May 2005

I had an working macro application which integrates our intranet data
into excel sheet by using internet explorer. It was working fine till
few days back but now generates error as below.
Runtime error'-2147024894 (80070002)':

In my VB6 program, I'm executing a query against an MS Access database
in which I want to return all records which have a specified date in a
date field. The problem is, if I say: ...WHERE MyDate = #5/27/05# then
I get no records because the date field contains the date AND the time

Hello. I want to add a toolbar that contains buttons that activate the same
code as is contained in the menu items. How do I do this, please? TIA, Jim.

I played a little bit around to get a function which creates a complete
directory tree (subsequent directories) and not only one additional level,
so that I could make a call like 'MakeDir D:\AAA\BBB\CCC\DDD' which calls
subsequent MkDirs internally. It works fine as long as ...

I'm working on a unicode-replacement for the VB-Controls...  i already
finished some controls (Edit, Frame,
CheckBox, OptionButton, ComboBox, ListBox, FileListBox und DirListBox) ...
now i want to make a label-control... but after hours of testing i have no

I am using the GetUserName API and want to know where the API looks to
retrieve the username.I know the documentation say "The GetUserName function
retrieves the user name of the current thread. This is the name of the user
currently logged onto the system."

Im filling a listbox with all the fonts installed using Screen.Fonts &
Screen.FontCount. Now all the names are listed in the listbox. I want to
create a function that when I click on the font name in the listbox it would
display its actual file name.

I have a VB6 (enterprise edition) IDE. Now I want to develop App for PDA.
Can I use my current IDE to develop it? If not, what tool I have to use?
Thanks

I have a VB6 app that uses the DBGrid32.ocx.  Under XP with Service Pack 2
when the user enters data into a cell and then moves to a different row, the
grid scrolls the rows up so the row that was just edited is the top row.
I'm only seeing this when running under XP/SP2.  With ...

After users click on a button on a main form, they are presented with a
question.  If they answer 'Yes', the next form is to open with records
visible for them to choose from.  If they answer 'No', the same form is to
open with no records to choose from.  It should allow them to ...

I currently populate a list box,  (sorted is set to true)  with a group of.
names. There is a text box that allows  entering  a part of a name.  As the
name is entered the I remove all names not matching what has so far been
entered.

When adding a new record from my form, I pre-set my DateTimePicker's value to
System.DateTime.Today
Since the "Today" value is used most of the time, the user doesn't need to
select a date from the DateTimePicker, since the default is shown. My problem

I want to declare a string with just one quotation mark, how can it be done?
Ex.
Dim strQuotationMark As String
strQuotationMark = """

Interesting stuff?
http://www.theregister.com/2005/05/26/dotnet_longhorn/
--
Jim Carlock

We are a small shop - two IT people. We both are developers etc....
We currently have a mix of VB 6.0 and Access 2000 apps. We are trying to
develop a strategy for further new development (in in some cases rebuild the
Access stuff)and basically have decided on either of VB 6.0 or ...