Visual Basic Discussion Boards

First Prev Next

Re: comma delimited files

jkgh9-Jan-02 4:55

jkgh

9-Jan-02 4:55

Instantiate an Excel Application object (try get before you try create) and use the Excel object model to load the CSV.

If it was me I'd use the filesystem object (part of scripting) and then parse it with the Split function into an array or some such, but I gues that dependes on where and what you want to do with the data.

registry editing

xxx8-Jan-02 19:15

xxx

8-Jan-02 19:15

In internet explorer when we type in the url at address bar then we get a list of dropdown of urls (guesing that they are coming from the registry). I have created a combobox in vb, i want whatever new entry is entered in the combo box should be added to registry and also the earlier entries should be visible when we click the dropdown of the combo box.

Re: registry editing

Ravish10-Jan-02 21:59

Ravish

10-Jan-02 21:59

It may not be a good idea to store it in the registry. Probably saving a certain number say 10 - in a local file should serve the purpose. But if you need to store that in registry - see GetSetting() function.

Batch update linked tables

Mattias Wahlberg8-Jan-02 2:42

Mattias Wahlberg

8-Jan-02 2:42

Hello fellow developers!

I have a problem. I am trying to optimize some database transfer code and I am stuck.

Here is a brief introduction to what I have today:

The database is a Jet 3.5 database with a lot of tables. The tables I want to update are linked together like this (PK):
Shelf(ShelfNr)-->Inventory(ShelfNr,ArticleNr)<--Article(ArticleNr).

ArticleNr is a unique number but ShelfNr is based on an auto-counter field. The problem with this that I cant use batch updates (through an ODBCDirect workspace) and at the same time use code like this:

' Pseudo VB-code
rsShelfTo.AddNew
' copy all fields except key
rsShelfTo.Fields = rsShelFrom.Fields
rsShelfTo.Update
rsShelfTo.Bookmark = rsShelfTo.LastModified
' CurrentShelf always gets the value 0 with this code, why?
CurrentShelf = rsShelfTo.Fields("ShelfNr")

I would like to include all updates in a transaction some my question is can I switch between using dbUseClientBatchCursor and dbUseDefaultCursor and still keep the transaction alive?

Any ideas?

--
Mattias Wahlberg
IDNet

Trouble automating PowerPoint XP

argaleen7-Jan-02 23:46

argaleen

7-Jan-02 23:46

Hello,

I've got a problem regarding PowerPoint XP. In Office 2000 the following lines worked just perfectly:

Dim ppApp As PowerPoint.Application
Set ppApp = New PowerPoint.Application

With PowerPoint XP I always get the error message: "ClassFactory cannot supply requested class". It works fine in VBA (code entered directly in PowerPoints VB Editor) but not from Visual Basic.

Can anyone help?

Thanks,

Ruediger

Using Plugins in a program

4-Jan-02 10:18

I am planning to make a pretty big program (compared to what I have done already) and I am pondering the possibility of creating the program so that it can use plugins. What I am wondering is if this is a reasonable/easy type of thing to do. And is it really worth it in most programs. I am planning to make the program fairly dynamic as it is. (dynamic being synonyms with generic)
Either way I am also wondering if anyone can point me in the direction of a good resource on how to make a program that can use plugins.
Thanks for any help and advice you give

Quinn
(a.k.a Monkey Joe)

VB Email Server Possible?

Pumpkin Carver4-Jan-02 6:43

Pumpkin Carver

4-Jan-02 6:43

Has anyone created an email server using VB? Is it even possible to do without killing server resources? I want to write one, a plain one, nothing fancy, just a basic email server to send and receive email, maybe a web interface, for few users (maybe 5 max users). Any links or anything out there to try and do this?

-Nick

HRESULT

Firoz31-Dec-01 19:59

Firoz

31-Dec-01 19:59

Hi,

Is there any way to check the HRESULT returned from a COM Method
in a VB client ?

Thanks,

Firoz

Re: HRESULT

Ravish10-Jan-02 21:54

Ravish

10-Jan-02 21:54

I am not sure whether you can see the HResult. But if the HRESULT is not equal to S_OK, I think Vb raises an exception with err.number equal to the hresult.!!

LAN Chat

28-Dec-01 4:33

I wish to develop a software on my own for LAN in office so that users can chat(text) through it.Can i get help from Anywhere ? Confused | :confused:

saxenashobhit@rediffmail.com

Re: LAN Chat

4-Jan-02 10:40

There is a really simple version of a server/client chat program in the MSDN for visual basic. You may be able to use that as a base for one (to help you learn what needs to be done).
If you search for "Using the Winsock Control" in the MSDN you should come up with the 'page' that has the simple version of a chat type program.
I played with this myself a bit and it is fairly easy to understand.
Hope that helps some.

Quinn
(aka Monkey Joe)

Cyber Software

28-Dec-01 0:24

dear sir,
My name is gautam, i am software proffessional and make my software in VB6.0,
I want to make one good software for Cyber caffe.
I want some support from your side for making this software,
If you agry with me then
plz mail me as soon as possible, I am waiting for your reply
Thanks
Gautam
(India)
Email: ewebgautam@rediffmail.com
Rose | [Rose]

I desperately need help to create a custom IE Toolbars in Visual Basic

28-Dec-01 0:00

I need help to create a custom IE Toolbars in Visual Basic like Google or Yahoo does.Please help me I am in damn need of it .

I need the help specifically in Visual basic as i dont know C++.
A piece of Code in VB will be helpful ...........

Re: I desperately need help to create a custom IE Toolbars in Visual Basic

12-Jan-02 7:35

Hello Gaurav,

I have the Pure VB Code to make IE Toolbars like Google and yahoo. See the screenhots of the toolbars developed using this code at www.chadhaajay.net

I need help to create a custom IE Toolbars in Visual Basic

26-Dec-01 1:58

I need help to create a custom IE Toolbars in Visual Basic like Google or Yahoo does.Please help me I am in damn need of it . Cry | :((

I need the help specifically in Visual basic as i dont know C++.

Re: I need help to create a custom IE Toolbars in Visual Basic

Nick Parker26-Dec-01 11:05

Nick Parker

26-Dec-01 11:05

Here is some information on the subject in C++

Hope this can lead you in the right direction.

Deskbands

Laugh | :laugh:

Nick Parker

Batch compile in VB

AG26-Dec-01 1:21

26-Dec-01 1:21

Hello,

In our project, we have about 30 VB projects.
Pl. tell me a way to batch compile them so that I can just do a "get latest" on VSS & then batch compile them.

Regards,
~A.

Re: Batch compile in VB

Konstantin Vasserman26-Dec-01 13:07

Konstantin Vasserman

26-Dec-01 13:07

Look at the command line parameters for vb6.exe:

vb6.exe /?

File Read

Warlock2725-Dec-01 14:58

Warlock27

25-Dec-01 14:58

How do you read a file into a variable after opening the file?

Re: File Read

Nick Parker26-Dec-01 10:05

Nick Parker

26-Dec-01 10:05

Something like this should do it

Dim strFileName as String
Dim Data as String
Dim strVariable as String

Open strFileName For Input as #1
     Do Until EOF(1)
         Line Input #1, Data
         strVariable = Right(Data, 5)
         ...Do something with strVariable
     Loop
Close #1

Nick Parker

Command Line Parameters

Firoz22-Dec-01 4:17

Firoz

22-Dec-01 4:17

Hi,

Can I develop an Application in VB which can accept
Command Line Parameters.

Thanks,

Firoz

Re: Command Line Parameters

Konstantin Vasserman23-Dec-01 7:43

Konstantin Vasserman

23-Dec-01 7:43

Yes. There is a built-in string variable called Command that returns the string of parameters passed to your application from command line.

Re: Command Line Parameters

Firoz24-Dec-01 1:21

Firoz

24-Dec-01 1:21

Thanks

Firoz

Operating a wav file from VB.

Ahuva21-Dec-01 1:52

Ahuva

21-Dec-01 1:52

I want to operate a wav file by pressing the space bar on the keyboard.

How can I do this action ??

Thank you !!

Ahuva

Re: Operating a wav file from VB.

Michael P Butler21-Dec-01 2:19

Michael P Butler

21-Dec-01 2:19

From MSDN,

'This function declaration must be entered onto a single line.
Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
    (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long


Sub PlaySound()
    If Application.CanPlaySounds Then
        'Substitute the path and filename of the sound you want to play
        Call sndPlaySound32("c:\windows\media\chimes.wav", 0)
    End If
End Sub

Michael

Last Visit: 31-Dec-99 18:00 Last Update: 19-May-24 0:11

Refresh

ᐊ Prev 1...4789 4790 4791 479247934794 4795 4796 4797 4798 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.