|
Hi,hello.I want to create a command button that used to
convert microsoft access file to Excel file.What is the code in vb6 for the command button.
Hi, i have create a program using VB6.The purpose of this program are for sales department person key in the data and then review by manager.Now, my problem is manager want me to create a command button to export the data from microsoft access to excel.What is the command button code and the step? Another Question,this program must set up in the office and all the staff can see and use this program at their own PC's!Thank for ur help!
|
|
|
|
|
I'm having all kinds of fun trying to iron out this problem, and im SURE there's an easy solution out there...
I need to use COM interop between unmanaged C++ and VB .NET to have my C++ client catch and respond to events raised in VB .NET. More specifically, I've got a VB .NET custom user ActiveX control with a valid COM interface that I've imported and used in my C++ client. I can make function calls from the COM client to the .NET server, but I cannot seem to handle events from the control.
I'm certainly no expert on COM interop, but I've browsed around and read bits of literature here and there on how to do this to no avail. The control doesn't seem to have any connection points to which I can connect to (which might be the problem), but trying to use ATL SINK_ENTRY with IDispEventImpl hasn't worked, nor has an MFC DECLARE_EVENTSINK_MAP with ON_EVENTs. I'm at a total loss and any help would be greatly appreciated.
P.S. if none of this works, would it be feasible to pass VB a C++ function pointer via its COM interface and then have VB "call" the C++ function using this pointer? They're in the same address space so it should work, but can VB call a function given only an address as a long?
|
|
|
|
|
Any suggestions on using a timer to check for a backup log's existence at a certain time every day? Is there some other function I should be using instead of Timer? Newbie needs help. Thanks!
Stacy
|
|
|
|
|
At a certain time every day? Doesn't sound like a job for a Timer. Sounds more like using the Scheduled Task control panel. Then your app wouldn't have to bother with the time or a countdown timer.
RageInTheMachine9532
|
|
|
|
|
Can I create a scheduled task programatically? This was written as a service. Thanks!
Stacy Springer
|
|
|
|
|
If it was written as a Service, then you can't launch it with the Scheduler. What does this thing do? Why the service?
RageInTheMachine9532
|
|
|
|
|
The service was designed to access a network drive once a day and verify that a certain backup file exists and that the size is greater than 500MB. If the file is there and meets the size requirement it sends an email to several people letting them know the backup was successful, else it sends an email indicating backup failure. I wrote it as a service to ensure it would run without user intervention and whether or not a individual was logged into the server it is running on. This has been my first project and a good learning experience. I appreciate any advice you have to offer. Thanks! 
Stacy
|
|
|
|
|
Well, if you want to keep it as a service, then you would have to use a Timer to wake up every so often, poll the system for the time, then see if it is time for the service to do its job. Configuration might be done in an .INI file, for time to wake up and do its job, then restart the service.
RageInTheMachine9532
|
|
|
|
|
Hi.
Anyone knows how to create an option whereby the user can choose the number of squares to appear on the screen for a simple picture matching game?
Help is much needed here.
Thank alot!
|
|
|
|
|
Hello i am working in VB6, using regular run of the DTpicker control. I had 2 requirements one to allow a blank in the dtpicker, which is easy set it to custom properties and put a space in the custom format field.
The second one is to allow invalid dates as well,
for example
31/04/2004 - April showing 31 days
All 30 day months should be allowed 31 days as well
The business logic requires such a situation. does anyone know how to do that?
Thanks in advance
Khizer Haroon
|
|
|
|
|
Dear ppl... Im an intern and recently my boss ask mi to work on a vb project... This is my first time using AS400 wit Vb and i have no idea wat to do....
I did manage to setup e ODBC(took mi a day to understand) and managed to retrieve e data from e AS400 server and its now in access format... But can any1 enlighten mi or show mi sample codes as to how to retrieve e data from AS400 and display it in vb? My main problem is wit e connection strings and i have no idea wat i need to type in...
Dim strConn As String, strSQL As String
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
cdgDataBase.ShowOpen
strConn = "User Id=Dian; Data Source=AS400_Test; DATABASE=SISTFL12T; Password=dian9" & cdgDataBase.FileName
strSQL = "select * from SIBRND"
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = strConn
.Open
The above is wat i did so far but dun think its e right codes... Can any 1 help mi out thank u bery bery much!
|
|
|
|
|
You first problem is your using the wrong Provider. The 'Microsoft.Jet.OLEDB.4.0' provider is for Microsoft Access databases only. Your going to need a Provider that works with AS400. You can find one at www.hit.com.
RageInTheMachine9532
|
|
|
|
|
Hi,
I'm struggling a bit with getting my programme to automatically encrypt a set of files when the programme closes. My programme writes the files during run-time in response to people's answers to certain questions. I don't want others able to snoop on this data and thus need the programme, when the CLOSE button is pressed, to automatically encrypt all the files which have been written to that session,
Any help would be much appreciated.
|
|
|
|
|
VB6 or VB.NET?
Do you really NEED to encrypt the files or just keep them from the eyes of others?
If you are on a system that has access privileges set up you should be able to just keep the data file for each user inside their own profile space so that no other logged on user can access them.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
VB.Net.
Unfortunately I really do need to encrypt the files since they would contain confidential information which should not be accessible to anyone except people with admin privileges ( IOW, the people entering the info shouldn't even have access to the entered info).
I've looked into the various other ways of doing this and I really think encryption is the way I need to go, unfortunately I haven't found a way to enact it without first loading the file into a textbox and then encrypting only that text. Unfortunately that's a no go also.
|
|
|
|
|
Hi, i have create a program using VB6.The purpose of this program are for sales department person key in the data and then review by manager.Now, my problem is manager want me to create a command button to export the data from microsoft access to excel.What is the command button code and the step? Another Question,this program must set up in the office and all the staff can see and use this program at their own PC's!Thank for ur help!
|
|
|
|
|
Hi.
I am trying to design some simple games using VB 6.( Eg: Picture matching )
Currently, I wish to create levels of diffculty that the user can choose ( Number of boxes to appear on the screen) and also a timer to record the time taken to finish the game.
Can anyone help?
Thank You.
|
|
|
|
|
I guess you can set the number of boxes by creating a control array from code (define the element 0 in your form, not from code)
The timer: use the Timer control, make it a countdown timer (define a variable, for ex. an integer,s et it to a value and start the timer)
Dim timeout as Integer
timeout = 60 ' 60 x interval = 1 minute
Timer1.Interval = 1000 ' 1 second
Timer1.Enabled = True
and in the timer event:
timeout = timeout - 1
lblTime.Caption = timeout & " second(s) left"
This will create a countdown for 1 minute...
greetz 
*Niels Penneman*
Software/Dev Site
Personal Site
|
|
|
|
|
I have coded a project using VB.NET that uses a speech library called AXinterop.httslib.dll
This program runs on win98se & win2000 simply by dumping all files on the target PC and it goes!(+ dot NET of course)
This failed on XP - XP proclaimed the dll was not registered!
So I used the deployment installer in Vis Studio to create an installer to register the dlls.
The program still fails to run. XP proclaims a dll is not registered!
Using REGASM.EXE to make a .reg file for the offending dlls, I could see that both the MSI installer & regasm.exe produced the same entries under the ROOT -but it still won't work!!
Do I need to make reg entries under local machine &/or user as well ... ?
Someone please help! My program works fine under win98se & win2000...
|
|
|
|
|
I am looking for a robust way for an application written in VB6 to communicate with a VC++6 application. The information flow needs to be bi-directional.
I have a rich GUI written in VB6, and an application that uses various third party libraries to do some intensive processing and written in VC++6.
For the prototype, I used AppActivate to launch the VC++ app and use SendKeys to drive the VC++ program interface.
When I realised I needed bi-directional communication quickly, I hacked in use of the clipboard and pass text strings in both directions.
I now have some synchronisation glitches, and given that my approach precludes the user from cutting and pasting using the clipboard, I'm looking for a more robust approach.
Whereas I can find many IPC mechanisms if I'm writing entirely in VC++, I can find few examples using VB, and none linking VB to VC++.
Can you offer any suggestions.
TIA
|
|
|
|
|
If an ActiveX control returns a pointer to a TIFF image and the size of the image (both integers), can a VB.NET App load the image from memory?
There's no such thing as a bad beer... some are just better than others.
|
|
|
|
|
If the pointer is the handle to a bitmap, you can use Image.FromHbitmap:
intPtr = new IntPtr( pointer )
img = Image.FromHbitmap( intPtr )
|
|
|
|
|
Of course... the ActiveX control returns a pointer to an in-memory TIFF image (not a bitmap).
-Joe
There's no such thing as a bad beer... some are just better than others.
|
|
|
|
|
Hey,
I am trying to emplement a notepad type form into my application and I seen to be haveing a formatting problem. If I open the same .txt file useing notepad and with my editor the formatting is different. Mainly the whitespace seems to be off eg...
(item:something price:25) in notepad
is displayed as
(item:something price:25) in my editor
I counted the whitespace between each item in my editor and it doesn't seem to be the same with each one so its not standardizeing the whitespace or anything. I don't know what is causeing the difference.
Here is the generated code for my textbox on the editor form (textField)
Me.textField.AcceptsReturn = True
Me.textField.AcceptsTab = True
Me.textField.AllowDrop = True
Me.textField.AutoSize = False
Me.textField.Dock = System.Windows.Forms.DockStyle.Fill
Me.textField.Font = New System.Drawing.Font("Bookman Old Style", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.textField.HideSelection = False
Me.textField.Location = New System.Drawing.Point(0, 0)
Me.textField.MaxLength = 0
Me.textField.Multiline = True
Me.textField.Name = "textField"
Me.textField.ScrollBars = System.Windows.Forms.ScrollBars.Both
Me.textField.Size = New System.Drawing.Size(560, 323)
Me.textField.TabIndex = 0
Me.textField.Text = ""
Me.textField.WordWrap = False
I am useing no wordwrap by default and have an option to turn it on but i have tried it with and without on both notepad and my editor and that doesn't seem to make a difference.
Its important that my editor save and display text unformatted as Notepad does.
Thanks in advance for any suggestions
Harley
EDIT:
It just hit me that the way i read the data into the textbox may make a difference here so if it counts for anything i use...
Dim name As String
Dim title As String
Dim text As String
Dim path As String
path = OpenFileDialog.FileName
Dim sr As StreamReader = New StreamReader(path)
text = sr.ReadToEnd()
name = OpenFileDialog.FileName
title = name
newChild(Me, name, title, text)
and of course i have a module for creating new MDI child forms with the textbox and I pass the value of text to that modules newChild sub wich then does a simple
textField.text = text 'Where textField is the textbox in my editor form
|
|
|
|
|
Use a System.IO.StreamWriter and specify filename and encoding. Maybe there's an encoding problem?
greetz 
*Niels Penneman*
Software/Dev Site
Personal Site
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
