Visual Basic :: Status Bar Related Query

Reading Game Port Status (not Gaming Related)
I currently use the gameport on my soundcard to monitor magnetic reed switches (basically it simulates when a joystick button is being pressed) and have certain events (home automation related) happen when this is detected. I modified the software to support a second gameport, but it's pretty clumsy.

So I want to write a vb app now that can monitor more than 1 gameport (in my case 10, but I don't want the # of connected joysticks hardcoded), all I want to monitor is the status of the 4 joystick buttons. Is this possible without having to run 4 instances of the same single gameport program? I really could use some pointers, examples, anything you can think of! Thanks guys!

Dan

Related To Query
I need to access the value of a field from database and my criteria is if field B is empty then query return me value of A field otherwise return the value of B
wat should i do

Vb5.0 Related Query
The problem is :
I have an application that has been developed in vb5 enterprise edition .
I am working on vb 5.0 profession edition.
This application opens in my version but when i execute it the following error occurs which is related to remote data object :
RUNTIME ERROR : 40041
OBJECT COLLECTION : COULD'NT FIND THE ITEM INDICATED BY THE TEXT

Can anyone help me in this matter?
Is this due to the edition difference?
Can anything be done in this matter?

Vb Package Related Query
Hi,

I would like to create a package deployment kit using VB which when deployed on client machine should not over write any system files. If a .dll already exists then it should not copy that .dll file.
A .dll should be copied and registered on the client machine only if it does not exist.

Is is possible to do this using Vb package deployment wizard? Or is there any other alternative to do this?

Thanks,
Chandana

Time Related Query
I want to write a simple app, that sends keystrokes to an external application.

I want my app to send a repetitive keystroke to that application
i)till a certain time eg, till 8:25pm(no matter when i start it)
ii)for a certain time period eg for 5 mins(no matter when i start it)

I would like to know, how can i define the above times?

Thanks

Flash And V.B.related Query
Hello,

At present, i m doing project in which i am transmitting video flash file from server to client frame by frame using flash component provided by V.B.
But when flash video files are transmitted audio is not audible at the client side.what might be the reason for this?how should i make this possible ?

Printer Related Query
How can i get the default printer name?
How can i set the doc to print thru a non default printer?

I want to save the print files to local hard disk. I don't want a popup asking for path to save file. Is there some way, using which i can specify a folder where all the files should be saved?

Thanks in Advance.

Connection Related Query
hi guys

this is a query about connection related to vb and sqlserver.
we oftenly use ADO in vb i.e. ADODB nd open connections through it like

Code:

Dim myCon as new ADODB.Connection

now if there are 5 users using the same application they will open 5 connections (1 on each client computer) using same sort of Transaction on same database or different like if all the 5 clients are fetching same data from a common table the server creates sessions for each user.

what about the connection on the server?
how does it work for all sort of activities,

does sqlserver uses any connection object ????????????

i m newbie to this plz help me in understanding this foolish question.
or any suggestion to follow that make me understand it.

thanks to u all

Silly

Smalldatetime And Reporting And SQL Related Query
Hello

I want to execute following query with MSSqlServer 2000 as database.

SELECT * FROM TABLENAME WHERE CurrentDate = 'Date Selected by user'

Well now my date field in the table is smalldatetime

I am using DTPicker on the VB form to get the date: So i am trying to get the date from it as DTPicker1.value

Second query:
I want to sort records on tha basis of dates i.e "between and" sequence

Third query:
I want to get the datareports based on teh date and time

How to do this?

Help me out

I want to get the report

!Urgent! RS Query Related Problem
Hi All,

Sorry to place urgent in the title. I am not that good at VB but have some data I need to extract from an access database. I have been writing an aplication to extract it but I need to have tha data in about an Hour. Can someone please give me a hand. I have got code working that looks through a database and adds all of a feild that has the same programName. This works great but I need to also filter it so it only takes this data if the date in feild is in the last calendar month. Im not sure how to takkle it. Can i add this to my sql query?

Code:
Public Sub PopulateProgramTable()
'Open database
Dim rs1, rs2 As ADODB.Recordset
Dim Cn As ADODB.Connection
Dim Program, ProgramTotal, DateIn, StartDate, EndDate

StartDate = "1/1/05"
EndDate = "1/2/05"
ProgramTotal = 0
Set Cn = New ADODB.Connection
Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Mode=ReadWrite;Persist Security Info=False"
Cn.Open
   Cn.CursorLocation = adUseClient
    Set rs1 = New ADODB.Recordset
    Set rs2 = New ADODB.Recordset
    rs1.Open "select distinct(Program) from Vehicles", Cn
    Do While Not rs1.EOF
    If IsNull(rs1!Program) Then
        Else
        Program = rs1!Program
            ProgramTotal = 0
            rs2.Open "select * from vehicles WHERE [Program] = '" & Program & "' Order by ID Asc", Cn
                    Do While Not rs2.EOF
                        If IsNull(rs2!Duration) Then
                            Else
                            DateIn = rs2!DateIn
                            '
                            ProgramTotal = ProgramTotal + rs2!Duration

                        End If
                        rs2.MoveNext
                    Loop

                    Me.List1.AddItem rs1!Program & vbTab & ProgramTotal
            rs2.Close
    End If
    rs1.MoveNext
    Loop
    rs1.Close

End Sub

Thanks in advance

Ben

Edited by - Ben Lee on 3/3/2005 2:11:46 AM

MS Access Data Transfer To VB Related Query
I've used some VB code to query an access database and one of the queried
fields is a bitmapped graphic. My question is, how can I now work with this
graphic? (e.g. put it on clipboard/on a form/etc). If I try to, for
example, put it on the clipboard, it says that this object does not support
this property, am I going about it totally the wrong way? Currently, the
records are held in a recordset, and I'm fairly sure it's queried alright at
I can access all the text-based fields.

Thanks For any help

Michael

Datagrid Cell Validation And Related Query.
I am using ADO Datagrid to capture sales Order data. How to validate each column by assigning it a name (E.g. Datagrid1.Column(0) should have name 'Product Name'). Also how to make part of the grid read-only and part user editable?.

An Important Career Related Query PowerBuilder,vb V.s C,c++.java,php,perl
Hi all,
I am an undergraduate student of computer Science.
I am a good programmer & i love programming.
I have been programming since the last 5 years.
I am good at programming on the c platform.
Basically i have programmed in c,c++,Perl,PHp,Java & am quite good in them.
I have also used MySql as the database for these applicatuions.

Now i have been offered training by a compnay which develops its projetcs using PowerBUilder 6.0,visual basic & MSSQL.
Will it be useful for me to start learning VB & POWERBUILDER or wll it be more useful for me to continue on the c platform.
I am of the view that the c platform is far better for programming.So am very confused.
I would be very gretaful if any one can guide me regarding the same for the betterment of my career.

P.S I plan to join the company only if it will help my knowledge.Its not a course requirement.
so please base your answer only to the fact of better knowledge & nothing else.

I hope you people can understand my situation.

Wishing everybody a very happy New Year

Thanks/Regards
Sanket Gupta

Query: Status Bar?
Does anyone know how to make a status bar like in the Setup programs?
If you do, than do tell me...

Thanks Alot
magicbeans14

Problem To Query The Status
Hi Everybody,

Current I am working on a TAPI based Dialer. I want to trace the status of the the TAPI line(telephone extension). Please help me. I am in a big trouble.

Regards
Uddhab from Nepal

Query A Printers Status
How do you query any printer in the printers collection to determine whether it is on or off line.

Problem To Query The Status
Hi Everybody,

Current I am working on a TAPI based Dialer. I want to trace the status of the the TAPI line. Please help me. I am in a big trouble.

Regards
Uddhab from Nepal

Display Status While MS Query(s) Are Refreshing
I have a spreadsheet that has multiple sheets that connects to an Oracle database and pulls data in. I have the queries set up to refresh when the spreadsheet is opened. Currently, the user can't tell that the data is refreshing and it appears that the spreadsheet is hung up. I have created the following code that attempts to display a message on the status bar to let the user know that the data is refreshing; however, I don't see the message in the status bar. Can anyone provide any feedback as to why I can't get this to work?

Sub DataFresh()

With worksheets("historical by month").querytables(1)
If .refreshing = True Then
Application.StatusBar = "Please wait.... data is refreshing"

Else
Application.DisplayAlerts = False

End If
End With
End Sub

Thanks,
EDJ

ProgressBar To Show Status Of Sql Query...
Just a quickie...

I am creating an extraction program from excel to access. It has been designed to extract data from both single excel files and multiple excel files. i think that the uses would find it useful to know how much of the files (multiple extraction) have been done.

I have succesfully used the:

ProgressBar1.Value = Min
'Put at beginning of sql query

ProgressBar1.Value = Max
'Put at end of sql query

However, there just doesnt seem to be any middle ground for the progress bar, it is either Min or Max.

If anyone can help me with this...

How To Query Printer Status Thru Code?
Hi,

Can someone tell me how to query the status of a printer, attached/ connected to one's desktop, thru code.?
I need to find out if the printer my application is trying to print to, is valid/ offline/ ... before attempting to print, to save on parsing log files, to find out why the print job did not print.

Parsing Log files, may look a small job, but for my application they are huge - 16Kb and higher.

Any clues, in VB/ VC/Win SDK will be appreciated, as I dont know MFC and Java.

regards

Jeevan

Not Related To Programming, But Related To VB
Alright everyone!

I would just like to find out if any of you guys/girls have a problem with your computer that seems to revolve around VB6. Mine does - it slows right down, and actually stops executing anything (be it Windows stuff or whatever) as though I had frozen time. This lasts for anything up to 10 seconds, and whilst this is happening, the CMOS clock is losing time, about 10 minutes a day! But it only does this AFTER i have opened VB6.

Anyone else experiencing this? Usually my PC is pretty quick. It's no spring-chicken, but it's no lame duck either.

Think i'll go beat up Bill Gates or something... )

Kind regards,

------------------
- Chris
chris.kilhams@btinternet.com
If it ain't broke - don't fix it

Printer Status On/Off - Paper Status...for Any Printer Available On Machine
How do you find out the status of a printer that is available to the machine you are running your app on.

The Printer May be a network printer or a printer connected to this machine.
It may be connected thru a com/lpt/usb port...
It does not have to be the default printer.

Want Help Related To Ocr
hello friends,
i am finding problem in designing an application that reads (ie.. converts an .tif image to .rtf) an image and also shows the errors in the richtextbox after the image being converted to .rtf.
so if any help u can provide then do help me.
thanks.
sumit_vbindia

IRC Related
Im currently making an IRC Channel Admin but im having problems. I can get it to connect, keep the connect,send message blah blah. but the only thing I cant get is the /KICK and /BAN commands. Can anybody help me? Im useing the "PRIVMSG #<channel>" command to send the message to channel, should I be useing a different line of command?

Related
how can i put a file in my project like a related document?

Not So Related To VB But Still....
How can I save a file which is for viewing-only (video-streaming only)?
like this one:

mms://video9.technion.ac.il/Courses/PhysMech/PhysMech-18.wmv

sorry for not being related to VB so much.
thanks...

Another Pop-Up Related!
I am creating (rather, trying to create ) a browser using the WebBrowser control. It works OK except for a weird problem!

Suppose I visit a website which opens a pop-up window. Now when I close the pop-up window, the main window also closes! How do I avoid this?

Strangely enough, if I close the main window, the pop-up window doesn't get unloaded; it remains open as it is!

Thanks,

Arpan

Might Not Related To Vb, But I Need Your Help
Any one have such experience?

when you click a link on the web which points to a .pdf file, it shows--
"the index associated with this document blah.pdx could not be located"

I went to that directory, and actually .pdx file is there, and when I double click the file, it shows--"the file is corrupted....".

the most weird thing is that it's only happening on a few machines, which I don't know why some doesn't need to locate .pdx file at all and works properly while some does.

besides rebuild .pdx file which I should use adobe catalogue , any quickier, easier way to work around this?

thanks

ADO Related
I have a simple program which views peoples details as I enter them into my database!! (ADO with Access 97) I have a option to enter a persons date of birth!! However If you do not enter it in correctly or not at all you get a runtime error!!

Any ideas how to fix this??

Dll Related
hi guys,

if i use the dll from two application then how many instances of the dll will be there.

thanks

Not VB Related
Not VB related, but... you guys here seem to be the most knowledgable group on the net. Does anyone here know about DVD format and why when I burn my output to one it is only viewable on certain machines?

Please, Anyone Help Me With This(ADO Related)
What am I doing wrong here?

Here's my code

VB Code:
'This goes to a module Public Cn As New ADODB.ConnectionPublic Rs As New ADODB.RecordsetPublic FilePath As String Sub Main() FilePath = App.Path & " si.mdb" Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & FilePath & ";" & _ "User Id=Admin;" & _ "Password=" Cn.Open Rs.CursorLocation = adUseClient Rs.CursorType = adOpenStatic Rs.LockType = adLockOptimistic Rs.Open "Select * from PersonalData", Cn, _ adOpenStatic, adLockBatchOptimistic Set Rs.ActiveConnection = CnEnd Sub

But when I try to add a record with this code

VB Code:
Rs.AddNew Rs.Fields("Fullname") = txtFullname.Text Rs.Update

No record would add. Can anyone please help me with this one coz I badly need it now....PLEASE!!!

Please Help. Non-VB Related.
Hi everyone,

Sorry about this. It's nothing related to VB. It's actually an error message in WinXP, that I keep getting. I did'nt know where else to go.

Everytime I start anything in WinXP (Ie, explorer, My Computer, Control Panel, any app). I get an exception error message, that has something to MFC42.dll. I've tried everything from "Sys Restore" to anti virus scan to "SFC".

How do I solve this ? I need to do this ASAP.

Please help !!

I Don't Know What This Is Related To
Sorry about the post here, because this is not VB related. My question is, you know how those URL links for example http://domain.com/search?name=Mike&lasname=Smith work? I want to build a page just like that which will retrieve the information about Mike, Smith and display it in the browser. What language do I use for that and if you can point me to some tutorials, I would appreciate it. Thanks.

Somewhat VB Related......need Help
Hey, I installed Win 98 on a 300 celeron system I'm running just as a Jukebox (mp3s). I wrote my own software for it in VB. It had 98 on it before with some Diamond Stealth drivers or something, but it was messing up so I formatted and did a clean install. Now here's the VB problem. I designed my program in 800 X 600 resolution. The computer it will run on is stuck in 640 X 480 and is just running on a standard VGA adapter. Can I d/l a display driver like NVIDIA to get it back to 800 X 600? The Diamond driver before was having some kind of conflict with the Socos monitor I was using. The socos monitor would work in 800 X 600 just fine on other computers, but would go haywire with the diamond stealth driver. Anyway, I'm stuck with 16 colors and 640 X 480 & winamp looks HORRIBLE. Any suggestions to fix the resolution would be much appreciated. Thanks

Not VB Related
I dont usually post off topic, but I am in a bind and was hoping someone could point me in the right direction.

My laptop crashed so I transfered the hardrive to another computer so I could keep working. It initially worked fine. After a coubple of boots it started complaining about an ethernet card and/or cable (??) and now will not boot at all.

This is Windows XP Pro. COuld this have anythign to do with the hardware hash registration thing?

I now have my original computer working, but it still will not boot with my original hard drive. It just goes through the initial scrten ("press F2 to ...) then a blinking cursor appears.

How can I get this thing working?

THanks for any help, or nudge in the right direction.

Not Really Vb Related But...
how do you get the ip address using windows XP?
thanks

Please Help Me! (sql Related)
why doesn't this statement work:

ExpiryParamComp = Format(txtExpiryParam.Text, "Short Date")

rsMembersReport.Source = "SELECT * FROM Members WHERE ExpiryDate < " & ExpiryParamComp & " ORDER BY " & SortType & ""

the report produced is blank. (SortType is another variable-it works)

Not Related To VB! But Please Help....
Hi,
I was working in VB and I used Shell command to open "C:WindowsDialler.exe" and I then used sendkeys "123456", vbNormalFocus
Doing the above things twice hung my system since phone dialler was already running. and I had to restart it using "Reset" button on the CPU.
After this my system takes a lot of time to boot around 3 minutes.
I also tried to boot using the "logged" mode and have created a log file which shows some 5 failed activities in it.

Can anyone please tell me what the problem is?

Thanks:

Kinjal

Not Really Related.....but Please Help!
Hello,

I have a picture box that moves a certain distance when you click a command button and stops when a loop ends. But when the picture box moves, it leaves a black streak behind it and then the streak disappears when the picture box stops. What can i do to make this streak go away???

heres my code...

Private Sub Command1_Click()
Do
picBox1.Left = picBox1.Left + 1
Text1.Text = Counter
Counter = Counter + 1
Loop While Counter < 2000
End Sub

'this will make the txt box disappear...
Private Sub Form_Load()
Text1.Visible = False
End Sub

thanks for any help!

Non VB Related, But I Need To Know...
How do I edit my prfile here? I can view it, but how do I EDIT it?

Not VB Related, But YEA HAW DSL....
just got it connected not 2 minutes ago, and this is the first this I'm doing with it. letting you all know.

This Really Isn't VB Related...
Win9x question. You can set a system to run an app automatically at startup, but can you do it at shutdown? I'm looking to run an app just before shutdown. Anyone know if it can be done?

ASP Related
Here is an ASP related question.

I have a HTML/ASP form, which has the user details.When I submit the form using ADO I want to Insert into database at the same time I want to dislay a user listing from the database.This user listing has all the columns, and records with two additional columns Modify,Delete.When I select Modify, the corresponding record has to displayed in the previous submitted form, so that I can change values and resubmit it.Delete will delete the record and should refresh the list.My problem is how to get back the displayed values, which I have displayed in a table format.
Your help is appreciated.

Not VB Related....
Sorry, this has nothing to do with VB, but they are still related, indirectly.

As I was creating my DB file using Access 2000 for my system (written using VB...see? told ya), I have some fields like date, where I can specify my own Input Mask.

I dunno what I did wrong, the last thing I remember was, the Input Mask Wizard was acting strangely, where the mask doesnt work on the testing textbox which was on the form, I can key in anything in it and it's not masked.

So, after I close the wizard, the next time I open (by clicking on the elipses beside Input Mask text field), I get an error message:

Code:
MsgBox "Overflow", vbInformation, "Input Mask Wizard"
(please compile it if you cant figure out how it looks like, just trying to make this question more VB-related :D )

How can I fix this problem?
Any way to reset it back to normal?

Thanks

Harddisk

Status Bar Related Query

How to insert Progress Bar in Status Bar in VB 6.