Type: Posts; User: TH1
Search took 0.05 seconds.
April 26th, 2002, 07:33 AM
You can use Shell to call winzip and pass commandline parameters
Have a look at http://www.winzip.com/xcmdline.htm
Also have a look at the FindExecutable API to find the winzip exe on a system
April 26th, 2002, 04:51 AM
Download the API guide from http://www.allapi.net/agnet/appdown.shtml
It has good examples of most of APi functions (If not all of them) including GetAsyncKeyState.
It's a handy tool to have anyway
April 26th, 2002, 04:08 AM
April 25th, 2002, 11:17 AM
April 25th, 2002, 10:53 AM
Go to http://hem.spray.se/mattias.sjogren/samples_en/index.html
And look at the VBBubble Sample (3rd one down)
April 25th, 2002, 10:10 AM
You could do something like this
Dim Mystr as string
for i = 0 to List1.ListCount - 1
Mystr = Mystr & List1.List(i) & vbCrLf
April 25th, 2002, 08:58 AM
Set the pattern property of the filelistbox to *.xls
April 25th, 2002, 08:31 AM
Only if the UNIX box has a windows emulator on it
have a look at http://www.winehq.com/
April 24th, 2002, 09:14 AM
Sorry mate but I don't have Win2K here and it works fine for me on NT4
April 24th, 2002, 08:52 AM
Go to http://www.vbbox.com/codebox.htm
and download the Owner Drawn Banner Menu Sample.
It should get you started, the only thing is that you may have to add the app.res resource file in manually...
April 24th, 2002, 04:43 AM
I'm sure that there are hyperlink controls out there but you can mimic them with labels
private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (byval hwnd as Long, byval...
April 23rd, 2002, 11:34 AM
There is a sleep API
Add this to a module
public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (byval dwMilliseconds as Long)
Then you can just say
April 23rd, 2002, 10:22 AM
Its probably because you're using a server side cursor.
DB.CursorLocation = adUseClient
in your code and see if that works
April 23rd, 2002, 08:14 AM
If you set the KeyPreview property of the form to True then you can use this code
private Sub Form_KeyDown(KeyCode as Integer, Shift as Integer)
If KeyCode = vbKeyF5 then
'Put your code here...
April 22nd, 2002, 10:46 AM
MsgBox date 'Gives date
MsgBox time 'Gives time
MsgBox Now 'Gives date and time
April 22nd, 2002, 06:57 AM
Dim Ctl as Control
for each Ctl In me.Controls
If Typeof ctl is textbox then
April 19th, 2002, 11:21 AM
private Type POINTAPI
X as Long
Y as Long
private Declare Function SetCursorPos Lib "user32" (byval X as Long, byval Y as Long) as Long
private Declare Function GetCursorPos...
April 19th, 2002, 10:45 AM
April 19th, 2002, 10:23 AM
You could download the CRegistry class from http://www.vbaccelerator.com
and then use this code to get the values for the uninstallstring
Dim c as new cRegistry
Dim sKeys() as string,...
April 19th, 2002, 08:10 AM
You can use Microsoft help work workshop to create a .hlp file or HTML Help Workshop to create a .chm file.
Have a look at http://www.mvps.org/htmlhelpcenter For help on HTML Help
April 19th, 2002, 07:23 AM
You have probably got your view set to "Procedure View".In the bottom left of the code window beside the horizontal scrollbar there are two buttons. One for procedure view and one for full module...
April 18th, 2002, 11:19 AM
Yep your right I just tested it and even when I use the GetLastError API it tells me it completed successfully. Strange...
Sorry I have no othere suggestions
April 18th, 2002, 11:01 AM
Isn't it the other way round. If it fails it returns 0 and non-zero if it succeeds.
Also by the way you should declare nResult as a Long because that is what the function returns
April 18th, 2002, 10:19 AM
I presume you're talking about a pass through Query, so you should put the connection parameters in to the "ODBC Connect Str" property of the query.
April 18th, 2002, 09:40 AM
As far as I know you can't because attachments are not part of the mailto protocol.
Have a look at http://www.cis.ohio-state.edu/cgi-bin/rfc/rfc2368.html
Click Here to Expand Forum to Full Width