|
You propably have some problem in the logic (loops or if statements) so the best way to find it is to use debugger.
Only thing I noticed is that the outer loop is made against SQL Server. You loop while there are records in T3B_MON in SQL Server. If you're moving data to SQL Server, rsSql may be empty so EOF is true. Also you don't seem to use rsSQL2 anywhere.
|
|
|
|
|
Hi All ,
I want to add a fnctionality in my hotel managment project with VB.Net to set a alaram factility to certain extension (room). The alaram is initiated by the front desk operator . Can anyone help me on the same , how can this thing implemented.
|
|
|
|
|
|
You beat me to it.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
For once it happened this way
|
|
|
|
|
I think it happens often, but never really noted.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Paul!
I am not sure wat do u want to say!
|
|
|
|
|
I was responding to what Mika said.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Mika!
Can u help me with some Code or API
Thanks in Advance
|
|
|
|
|
|
How to write a program to shutdown, restart and log off the computer by using VB.NET 2005
|
|
|
|
|
|
Thanks Mika for your help
|
|
|
|
|
|
I second Mika with the search tool on this site. Use it and use it well since you can find alot of awesome gems around here
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
|
If VB6 it was simple, but this is what I have.
'My Bee Contacts' represents a contact folder in Outlook. But the code refuses to find it unless I use the .PickFolder command and actually select it. Which I don't want to do. I simply want to enter a name in a textbox, like 'My Bee Contacts' then the code runs through the contacts in that folder- then I can dump them in a file or use Messagebox to display them ... etc.
Dim OutlookApplication_definst As New Microsoft.Office.Interop.Outlook.Application
Dim olApp As Microsoft.Office.Interop.Outlook.Application
Dim objName As Microsoft.Office.Interop.Outlook.NameSpace
Dim Folder As Microsoft.Office.Interop.Outlook.MAPIFolder
olApp = OutlookApplication_definst.Application
objName = olApp.GetNamespace("MAPI")
Folder = objName.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderContacts).Folders("My Bee Contacts")
For Each Item In Folder.Items
If Len(Trim(Item.JobTitle)) = 0 Then Item.JobTitle = "(none)"
If Len(Trim(Item.ManagerName)) = 0 Then Item.ManagerName = "(none)"
MessageBox.Show(Item.JobTitle & "|" & Item.Email1Address & "|" & Item.FullName & "|" & Item.ManagerName)
Next Item
olApp = Nothing
Folder = Nothing
objName = Nothing
|
|
|
|
|
there is an excel file which is programmed with vb but the buttons in it doesn't work and it has compile time error when you click on them. can we by any chance see the source code or solve this problem?
|
|
|
|
|
Hit Alt-F11 to open the code editor.
|
|
|
|
|
Member 2069064 wrote: but the buttons in it doesn't work
Check whether macros are enabled
Member 2069064 wrote: can we by any chance see the source code
Alt-F11
Member 2069064 wrote: solve this problem?
Since you don't even know how to open tha vba-editor I have my doubts about that.
|
|
|
|
|
Smithers-Jones wrote: don't even know how to open the vba-editor I have my doubts about that
I second that since opening the vba editor is probably the most trivial part of it.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Six months from now 2069064 will be posting his CV as a VB developer having completely rewritten the macro supporting this sheet, created a XXXXX system based on excel and will be looking into Access. Poor bugger, this is how I started in Excel 1.0
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Can any one help me regarding how the navigation button works in vb 6.0. i want next and previous button coding.
help me
|
|
|
|
|
You're going to have to explain what you're talking about. There's no "navigation button" control in VB6, nor any other version of VB. What are you "navigating" and how??
|
|
|
|
|
One would assume that given what Dave said, you want a wizard type interface. I would assume you need to code this yourself, showing different controls on a form as you go.
Why on earth does anyone still use VB6, apart from masochism ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|