Visual Basic :: Need Advice On A Choosing A VB Compiler For A PPC Mobile 2003 Application

Evb And Mobile 2003 Second Edition
Although MS says their runtime (msvbppc.armv4.cab) is compatible with both Mobile 2003 and the Second Edition, a couple of my users have been unable to install on their devices, both of which are Ipaqs having the 2nd Edition. However, another user with Second Edition was successful. Anyone out there having similar issues? I have had no complaints so far with just Mobile 2003 and the runtime.

Another question: I am looking to purchase Visual Studio.net 2003 to try to stay up with things but the retail price is out of my budget. I have seen many $79.99 for the "Pro full install" version and also those for $400 on Ebay. The descriptions are exactly the same except the cheaper one says "Academic pricing" which leads me to believe that there would be restrictions although it is supposed to be different from the Academic version. I have sent several emails to the seller and to former buyers without response so don't know the real story. Does anyone have any experience with what's available and advice on how I should proceed? I mainly want it for Pocket PC development.

Jim Schuchert

VB6 App Running On Windows Mobile 2003
Hi All,

I have created a simple application in VB6, just a lot of forms, list boxes and text boxes, the most difficult thing it does is output a CSV file, and im wondering will it work ok on windows mobile 2003?

I need to purchase a specific handheld, costing a considerable amount, they cant guarantee that it will work and arent willing to let me test before buying, so can anyone shed any light on the subject.

Thanks

Choosing Sender With StrPrefAccoutn In Outlook 2003
I am trying to enter this

'Global object
Private WithEvents olApp As Outlook.Application

'Put this line in a function****************

Set olApp = CreateObject("Outlook.Application")

**********

Private Sub olApp_ItemSend(ByVal Item As Object, _
                                 Cancel As Boolean)
    Dim objInsp As Outlook.Inspector
    Dim colCB As Office.CommandBars
    Dim objCBAccounts As Office.CommandBarPopup
    Dim objCBB As Office.CommandBarButton
    Dim strPrefAccount As String
    Dim strMsg As String
    Dim intRes As Integer
    Dim blnAccountFound As Boolean

    strPrefAccount = "EMO"
    Set objInsp = Item.GetInspector
    Set colCB = objInsp.CommandBars
    Set objCBAccounts = colCB.FindControl(ID:=31224) ' Accounts
    Set objCBB = objCBAccounts.Controls.Item(1)
    If Not objCBB Is Nothing Then
        If objCBB.Caption <> strPrefAccount Then
            strMsg = "This message will be sent with " & _
                     "the " & Quote(objCBB.Caption) & _
                     " account. " & vbCrLf & vbCrLf & _
                     "Would you rather use your " & _
                     "preferred account (" & _
                     strPrefAccount & ")?"
            intRes = MsgBox(strMsg, _
              vbYesNoCancel + vbDefaultButton1 + _
              vbQuestion, _
              "Send with Preferred Account?")
            If intRes = vbYes Then
                Set objCBB = Nothing
                blnAccountFound = False
                For Each objCBB In objCBAccounts.Controls
                    If InStr(1, objCBB.Caption, _
                             strPrefAccount, _
                             vbTextCompare) > 0 Then
                        blnAccountFound = True
                        Err.Clear
                        objCBB.Execute
                        Exit For
                    End If
                Next
                If blnAccountFound = False Or _
                   Err.Number <> 0 Then
                   Cancel = True
                End If
            ElseIf intRes = vbCancel Then
                Cancel = True
            End If
        End If
    End If

    Set objCBB = Nothing
    Set objCBAccounts = Nothing
    Set colCB = Nothing
    Set objInsp = Nothing
End Sub

on my Outlook 2003 , so to choose a sender as i hit NEW but i get false massages like .
The above source script is for outlook 2002 as i saw , how can i made this possible to outlook 2003 and
what can i do to make script with strPrefAccount for choosing a sender as i hit NEW.

Thanx....

Navigation Buttons Do Not Pass To Form In Windows Mobile 2003
Hi,

We have a quite complicated Evb app (30 forms and three modules!) controlling a laboratory instrument. This has worked very well using Mips based devices running CE 3.0. These are now very scarce so I have moved it all to one running an X Scale processor and Windows Mobile 2003 SE. Everything works fine with minor tweaks apart from the fact that the the keyboard events that I used to navigate controls on many forms from the machines Joystick, do not work any more (apart from on "standard multi button Message Boxes" and the enter Key which always passes to the control with the focus).

As a test, I created a simple form with four command buttons and no code at all for joystick navigation.

On a CE 3.0 device, the the Cursor Wheel and Up/Down buttons moves the focus in the tab order and rolls over at the top or bottom straight out of the box. However, on a device with Windows Mobile 2003 SE, you can hear the clicks from the knobs but the focus does not tab through the buttons at all. Only the Enter/Action Key works on the button that has the focus.

I can directly control the focus directly from the code that handles the joystick input but keeping track of which form is visible and if the user touches the screen and changes it is a nightmare compared with the original which was simple and foolproof!

Does anyone know if this is a "Feature" of the later OS with Evb and if there is a simple workaround?

Thanks for any help.

Accces 2003 - Need Some Advice
For now I have 20 comboboxes on my form each bound to a field from my sourcetable. Since ya can only choose 1 value in a combobox, the users want to choose multiple values in each box. How should I implement this?
I can't use 20 listboxes because I haven't got any free space left on my form.

Can somebody gove me some good advice on this?

thanx in advance,

Johnny

.Net Mobile Application Deployment
I am having trouble with deploying via MSI a .Net Mobile application to a pocket pc. The setup runs as expected and it ends by stating on the pocket pc that 'setup did not successfully complete. please run setup again.' Now, if I deploy the app directly from visual studio, it runs just fine.. I have followed the guideline project from MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/netcfdeployment.asp)

_____________________________
John Saunders
MCP, MCDST, MCAD.Net, MCSD.Net

How To Send A Private Msg To Mobile Through My Application
How to Send a private Msg to pager..Mobile..Etc
Hi all;

In my work Field My maneger asked me to supply the Programe

With something interesting for users that

give the Application the ability to send users a msg to their mobile

Pager or send a Fax to specific Number they gonna to specify.

Just like a remider for some thing,Or send private msg too.

I have just the Idea but Anyone Know How to start with it??

*What Hardware needed((Modem for instance)??

*What code to write??

*What else that hide on my mind??
-----------------------------------------------
I hope to get the Code and other answers to my Questions..

Thanks in advanced..

OLA

How To Get Mobile Directories From Desktop Application?
Hi Respected All,
respectivally I am saying that I am working in .net CE 2.0.
I have done synching between Desktop and Mobile, and I want to get Directory structure of mobile from Desktop application , but How I don't know.
Any one who has any idea about it please post me and solve my problem.
thnks in advance.
bye
regards Rajat.

Mobile-based Application Connect To PC
i'm write a chatting application for PDA, below is my code for establish connection to computer(the ip address is the router ip address)........but i still new for mobile programming....now i ask for some opinion whether it will work in PDA or not?

Code:
    Const mBufferSize As Integer = 255
    Private mBuffer(mBufferSize) As Byte
    Private sendBuffer(mBufferSize) As Byte
    Public Shared mSocket As Socket

    Public Sub Connect()
        mSocket = New Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp)
        mSocket.BeginConnect(New IPEndPoint(IPAddress.Parse("192.168.0.111"), 8080), AddressOf Connected, mSocket)
    End Sub

    Public Sub Connected(ByVal ar As IAsyncResult)
        mSocket = DirectCast(ar.AsyncState, Socket)
        mSocket.EndConnect(ar)

        MsgBox("Connected")

        mSocket.BeginReceive(mBuffer, 0, mBufferSize, SocketFlags.None, AddressOf getMessage, mSocket)

    End Sub

Choosing A 'Start In' Folder When Starting Up An Application?
I know how to shell to another application but some of them need to start in a certain folder for them to work. How do I choose what folder the programs in question are going to start in?

--
Screaming Fist
Life sucks. Then you die.

Can I Use Vb6 To Develop Simple Application For Mobile Phone?
can i use vb6 to develop simple application for mobile phone?

Develop Application To Send Sms In Vb To A Mobile Phone
Code: to send sms to a mobile phone through visual basic program.

A Compiler In My Application
Hi to all...
I want to put in my application a "vb compiler" so when I run my application, I can write down VB code and then my program will compile it...

any suggestion?

thanks

Can I Make An Application Opens Mobile Java Games??
Hi every1..

I have a little question..
can i open mobile java games and play them with my application..??
i attached a mobile java game 4 an example..

c ya

Solved:Mobile Application Interfacing With Desktop SQL Server
    Hey Guys

          I have a Scanner that connects to my Linksys Router. The way the Scanner and Router Interface with each other is through a SSID. Now What I would like to do is Insert,Select,Delete,Update data into my SQL Server that located on my desktop PC.

   How would I make my connection my my Desktop pc????

Thanks

Sincerely; Oscar Martinez

Edited by - youngOz on 1/5/2005 7:48:11 PM

Application Layout Advice
I'm building an application in VB6 that will prompt a manager to build a to do list for their employees. The list of data to choose from will be a rather large list and these to do lists will be made for a number of different people week to week and will change accordingly. My original idea was to prompt the user to select the items from a master list...then click a command button that will have a separate form load with the list of items chosen in a grid for an entire week and when they complete the to do items each day, the user can check that item off the list when the task is complete. I'd like to save the tasks that are completed as data from these dynamically generated forms to separate records then be able to call them back when the user opens their particular file. So, I guess what I'm asking is, will I have to tie this all to a database file (I would imagine so), and if so, which one or how do I create the database from scratch? I've been reading a little bit about using access but if I compile the program using that database, does the end user need to have that on their computer to get it to run? or can I just create a database in VB6 that can be included with the program?

Since the form is generated dynamically per to do list and may contain 5 things on the list one week and 10 things next week...I need to be sure to recall the proper number of items or tasks and whether they were completed or not each time the form is loaded for a particular person.

Also, ..I'd like to be able to track what tasks were completed by each person each week and perhaps keep a tally of points or something to give out incentives for completing the tasks.

I'm a beginner but have completed a few applications in the last few months..but nothing with a database.

Any advice or ideas would be greatly appreciated.

Thanks

Need Advice On Deploying Application
I have written an application in VB6 and need to deploy it. I am new to deployment methods and need advice on the best way to proceed. I tried to bring up the MS Package and Deploment Wizard in VB6 by checking that box under the Project->Components menu, got the error message "error in loading DLL". Does anyone know why that is happening? Is there an alternative package and deployer that you could recommend? Thanks.

Application Development Advice
Hi,

I am a beginner in VB and looking for some advice!
I have to develop a pretty big application that needs a secure login so the user that logs into the database should have a username + pwd and belong to multiple access groups (whether admin, user, power user, Finance, partner etc) and depending on which usergroups the user is in determines which parts of the system they can access.

The application that I have to develop is a Project Management database which includes witin it a Customer/supplier Management system and an Internal Quality Mgmnt System.

I have an Idea of how I want the appln to look like but I dont know whether to use Access/MySQL as the backend.
The database if implemented successfully will be used for a long time and will contain lots of Info (but Ive been told that I can use multiple access databses to contain my tables and link them together??)

Also can I use a combination of both?

PS: Multiple users (approx. 50) should be able to connect to it(via LAN) and update/modify information at any one time.

Any help/suggestions would be most welcome!
Eb

Advice On Application Architecture
We are writing a VB/Oracle application. There has been some discussion on where the business rules should reside (ie., in VB or Oracle). One point of view is business rules will be in classes in VB and calls will be made to Oracle for data manipulation. The other point of view is calls will be made to Oracle where the validation and data manipulation will occur and VB will get the result.

Needed some advice on what is practised in industry? What are some experiences people have had? Pros and Cons?

Thank You!

VB6 Application Migration From Win NT To Win 2003
What are the points to be taken care of when migrating VB6 applications from Windows NT to Windows 2003? I understand that domain names get changed during migration. Hence one could check for the usage of any somain names in the VB6 code. What are the other things one should check for to ensure a smooth and complete migration?

PPC 2003 Application Error
Hi,

I have created an application in evb and wanted to use it on a ppc2003. I have installed runtime and seems to work OK except when it comes to show forms in which I have used the DATAVIEWER Control, in fact everytime I am getting this error
The control dataviewer1 ({6AB9C903-48A3-11D6-810A-00105AA9A07C}) could not be created. Could you please tell me what I am doing wrong. I jave created the "executable" for this applicationo and copied it on the PPC. The PPC I am trying to install on is IPAQ 5555. Thanks in anticipation for your valuable help because I need to go urgently life with this S/W. thanks again . The Dataviewer is a control which is available for free from ODYSSEY and which replaces the GRIDCONTROL speeding up info fettching/display in grid form, available for free from:- http://www.odysseysoftware.com

Edited by - JasonWRX on 6/16/2004 11:04:04 PM

Advice On Report Application Used For Fieldwork
A few years ago I was asked by a client to write a Report Application for use in outdoor fieldwork. The client uses Laptops in the field, and Desktop PC's in the office. The client will record field details in the report application on the laptop while in the field, and then upload the information to the central server on returning to the office. The biggest limitation is that our Department is only allowed to use Microsoft products. We also don't have access to the .Net development platform - so no Visual Studio 2005.

My original amateurish solution was based on Visual Basic 6 . When the application is used on the laptop, it records its information in an Access database. The reports are uploaded from the Access database on the laptop to an SQL Server at the Central Office/Headquarters. The biggest problem I encountered was how to implement a process by which information could be transferred from an Access database on a laptop to an SQL Server database on another server.

Due to other work commitments, I had to abandon this project but it's nagged me that I was never able to arrive at a viable solution. Has anyone ever attempted something similar to this? Or can anyone recommend some good articles to read?

Give Me An Advice For My First Application Meeting!!!
hi,

Tomorrow will be very important day for me.It will be my first job application and this job is about programming.For this reason I want to ask to experienced programmers that how I should act in my first meeting for application , what is your offer?What I sould say to them? Please take me some offerings!!!(This is the jewel firm and they want to making their software team)

Need Advice For Creating Modem Application
Hi there,

I want to make an application that will run on a machine with 16 com ports. All com ports will be used to listen for incoming connections. (No IP or internet stuff, just other modems dialing to this machine!)

I figured i have to use the MSComm Control, but after trying a little with this control, i still couldn't get it to work, to just respond on a RING or something.

How can i see when another modem calls to the modem connected to a com port? What about the handshaking between them, do i have to do that myself? (The irritating noise you hear when you dial in somewhere ;-) or do they just connect and after that i get some sort of event or something?

I think when i solved this, it's not very hard to send data back and forth, (please say no ;-)
it's just the connecting problem.

(Please also advice if you think MSComm is not the right control for this problem)

Thanx in advance!!

Greetings,
Law

Seeking Advice Regarding Multimedia Application
Hi
I have a simple media application that needs the have an *.avi
file loop with the precision of proffessional software like Vegas Video for example. So far I've tried everything that
Windows Media Player, MCI control, the Win API with the timer and nothing so far can give me this precision.
What would be my next step..I'm not looking for a free bee.
Maybe something written in VC++ and brouht over to VB.
Any help in pointing me in the right direction would be greatly appreciated.
Thanks..Ron L

VB6 Application On Windows Server 2003
Hi,

I have a problem with running VB6 application on Windows Server 2003. Project has one or more simple forms, and after calling FORM.SHOW application crashes and throw error OUT OF MEMORY.

Does anybody know where is the problem? With compatibility or something else?

Thanks.

Launch A VB Application From Access 2003
I have a VB6.0 application that should be launched from Access 2003 application. I am clear on how to launch the VB6 application.

But, if users try to launch the VB6 application separately, it shouldn't run.

How can I do this?

Thanks
nath :

Remote Control Of Application Advice Needed.
Hello

I am in the process of building a VB application to control my aquarium. I need help interfacing this application so that it can be manipulated from the WEB, TELNET or FTP, and possibly the WEB via an ActiveX control.

The app is currently in VB6 but could be moved to VB.NET if really needed.

I am going to be long winded with my explanation of what I have and what my goals are before I ask my question. I have asked for help in other forums only to be frustrated by useless responses.

The details: Local PC running WINXP embedded. VB application interfaces to sensors (PCI and USB) Lights, Pumps and outlets are controlled by the software. Temp, PH and other data are logged by the software.

The software is currently a "game loop" type of setup. At system boot the app runs and pulls startup parameters from an ACCESS database. The loop begins and the timers and interupts (from sensors) manipulate variables stored in memory. These variables are acted upon with each "loop". Data is also logged at pre determined intervals (ranging in time from seconds to hours, depending on the stimulus being monitored).

So there is no confusion. I KNOW HOW TO READ AND MANIPULATE MY SENSORS. I don't need help with this part of the software. Everybody seems to miss that point on the other forums.

The software must be 100% stable, as it is controlling my aquarium. The database is only used for fetching startup paramaters and logging data. I am comfortable being able to read data via an ASP page from the database.

Here is my question:

How do I provide the ability to control the parameters of this system via the internet? The original Idea was to use an ASP web page to update the system paramaters in the database. But this would require the application to poll the database every second or so and check for system paramater changes. This seems very resource intensive and does not appear to be a stable way of doing things.

I am looking for a way to have a WEB page send paramaters directly into the variables that control the application. I am also looking for a way to add FTP or TELENET access to the application so that it could be manipulated directly from the command line. Lastly, it would be nice to have an ActiveX or Java interface to directly manipulate the software.

I have heard horrible things about winsock, and been told that VB.net was designed for just such an application, but can not find anybody to get me started. If this can be done in VB6 great. If I have to learn VB.NET and port my app to make my goals a reality, then I will.

Could somebody with an Idea of what I am trying to accomplish, please help me get started in the right direction.

Bill

Advice Needed On Application Development Software
Hi,

can anyone advise as to which application development software is best to use to develop a management reporting system?

The development software needs to be simple to use (not require extensive programming experience).

Basically, a system is needed to create automated (and ad-hoc) weekly management reports (outputs in form of tables, charts and graphs). The new system will use data from a number of sources including excel files, text files and a database.

Any suggestions/advice would be most appreciated

Broad Application Design Advice Needed.
I'd like to design an application that can read image files from a digital camera, crop them to a certain size, add brightness and contrast, and save (or even port to Microsoft Word).

Can anyone suggest a sensible overall plan of classes and methods I could use? I don't need detailed implentation code, just a top-level plan.

I'm new to OOP, so breaking this task up sensibly would be beneficial. I think I can work out the details, but to start off with a bad plan would be potentially disastrous.

Peter

Advice Needed - Database Selection For Application
Im developing an application that will require the usage of a database, it will need to a very large index of files on a system and therein lies the problem.

I had planned on using Access 2000, but say a user has hundreds and thousands files on a system, the database would fill up rapidly. Although im aware of the 2GB limit im pretty sure the actual database would be well below this limit however, looking around i see a number of SQL database solutions and their numerous benefits.

However would a database created using MYSQL be accessible using an offline application? by simply connecting to it via ADO as with Access? I have also had success connecting to a database held on a shared directory on a local network, would this work without having to initiate MYSQL etc? At present im just connecting to the Access database by passing it the full path (including network) within the ADO connection code.

Thanks a lot.

< Confused!

Gav

Application Wide Databse Connections (ADO Vb 2003)
Can you put a oledbconnection and olddbadapter in a module so it can be used across multiple forms without recreating it for every form, or no? Or could you use some method to call it only when needed? A module? How will the form designer know to allow access to the databse, if this is possible?

Upgrade From Windows 2003 Sp1 To Sp2, What Is The Impact On VB6 Application
Can someone tell me the impact on my VB6 application if i upgrade the server from Windows 2003 sp1 to sp2?

Thanks for your help !!

VB Windows Application Connect To SharePoint 2003
how can I connect to Sharepoint 2003 portal server in a Windows Application written in VB6?

Error While Running An Application In Evb On Pocket PC 2003
I have an application in eVB and am trying to run it on a Pocket PC 2003 device. Now, Pocket PC 2003 does not support eVB but can run eVB applications after installing eVB runtime files. I did all that.

But I get an error saying "The Platform Manager could not connect to the device". How can I rectify this? Another problem is that in the application program, when I go to Tools - Remote Tools - Control Manager and click on Pocket Pc 2003 Device, it shows the error "Failed to find suitable Control Manager Server for your device". Does anyone know why?

I would appreciate any help that I can get.

I Am Looking For Advice On How To Backup And Save A File From A Database Application
Hi, I am looking for some advice on how to backup my database. I want to be able to click on a button to backup and it checks for a disk in the A drive and then backs up the whole database. I don't even know how to start this.

Secondly, I have a bunch of estimates in the database. They all have their own number and are in related tables. I need to be able to bring up an estimate, which I know how to do, but then click file-save As and save it as the next number so that I don't have to redo an estimate that is similiar to one I already have.

Any advice to get me on the right track would be appreciated. Thanks

thanks
leadfinger
http://www3.nbnet.nb.ca/gspil

Advice On Detecting Screen Resolution And Resizing Application And Its Objects
I need to be able to detect different screen resolutions and then
resize my applications forms, objects, fonts etc, to suit.
Any ideas how to go about it?
I use VB 5.
Many thanks in advance.

Problems With 2 Computers Sharing Vb6 Application And Access Database.-Thanks For Advice
Hi,
  I am wondering 2 things actually. Right now, I have two computers hooked up in a network. I have my vb6 application and access database installed on one of the machines. I went on the other machine and went through the network connection and tried to start up my application, which is on the other machine. It had a run time error because it couldn't find the database I think.
  One of my questions is, can I install this vb6 application on the 2nd machine and change the path so that it can find the database on the other machine?
  My second question is, is it possible for both of these machines to access the database at the same time or is this going to be very difficult to make happen.
thanks
leadfinger

thanks
leadfinger
http://www3.nbnet.nb.ca/gspil

Edited by - leadfinger on 3/15/2004 10:01:56 AM

Messages Sent By A VB6 Application Return Undelivered If Email Client Is Outlook 2003
In my vb6 application I use two controls:
a MAPISession control named "POSTA"
a MAPIMessages control named "INVIAPREV"
the following is the code used to send a message with an attachment. (sorry for variable names and control names in italian)
----------------------
POSTA.SignOn
With INVIAPREV
.SessionID = POSTA.SessionID
.Compose
.RecipDisplayName = "TUO SERVIZI PER IL LEASING"
.RecipAddress = "tuo@analisifinanziaria.it"
.MsgSubject = "Invio Preventivo Leasing n." & Me.CERCA
.AttachmentPathName = App.Path & stDBF
.MsgNoteText = "Invio Preventivo"
.Send True
End With
POSTA.SignOff
MsgBox "Invio eseguito", vbInformation, "E-MAIL"
------------------------
The attachment is a text file
The application has been in use for over 2 years and the code works perfectly if the default email client is Outlook Express or Outlook 2000.
When the default email client is Outlook 2003 the message returns undelivered.
The message is displayed before is sent.
Normally, right clicking the recipient address of a message about to be sent the context menu contains the item "Outlook Properties"
in the case of the message generated by my application, instead, the context menu contains an item "Properties" instead of the standard "Outlook Properties"
the properties displayed by a normal message ("Outlook Properties") are the following
_________________
Displayed name: TUO SERVIZI PER IL LEASING
Email: tuo@analisifinanziaria.it
Email Type: SMTP
Internet Type: "Send in RTF Outlook format"
------------------------
In the case of the message displayed by my application the properties are
------------------------
Displayed name: TUO SERVIZI PER IL LEASING
Email: tuo@analisifinanziaria.it
Email Type: TUO@ANALISIFINANZIARIA.IT
Internet Type: "Send in RTF Outlook format"
-------------------------
If the message is sent as it is it will return undelivered.
I can manually correct the email type by clicking the button "internet type" and changing the type in "SMTP" after which the message is regularly dispatched.
I have no idea on how to make the same correction programmatically.
It is very important for me to solve this problem.

Send Sms Through Gsm Mobile To Any Mobile
vb-6 code reqd. to send sms through gsm mobile to any mobile.

i already written this message so many time but till date i don't get any reply. i hope that i will get reply as soon as possible.

Reading/Import Data From Excel 2003 File And Write/export To Access 2003 Database
I'm developing Database System using MS Access 2003
As the old data are all in Excel format, I'd like to add a function into the system so that operator import old data from Excel file into the Access 2003. But i do not know how to write data into Access Database using dataset object

I have write the follwing code to read data from Excel file:

Code: Public Sub import_from_excel()
Dim conn_excel As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=c:
eport
eport_10102006.xls;Extended Properties=Excel 8.0")

sqlcommand = String.Empty
sqlcommand = "Select * from ['Multiple PN$']"
Dim excel_adaptor As New OleDbDataAdapter(sqlcommand, conn_excel)
Dim excel_DS As New DataSet
excel_adaptor.Fill(excel_DS)

'For testing
Dim excel_DT As New DataTable
Dim f_ed As New excel_data
f_ed.Show()
excel_adaptor.Fill(excel_DT)
f_ed.dg_excel.DataSource = excel_DT
'conn_excel.Open()
conn_excel.Close()

End Sub

Cannot Log Into Exchange 2003 In Program, But Outlook 2003 Works Ok For That Account
I have an error when trying to log into outlook accounts in my vb6 program. I do not have a problem logging into these same accounts using outlook 2003. I have googled and found most of the solutions refer to wsock32.dll is missing. I have a wsock32.dll file. And that also would not explain why I can log in to the accounts on our exchange server using outlook 2003.

Anyways, here is my code: (it is still rough, but I just want to get past this and I will clean it up later for all you experts...lol) I may have pinpointed it to the IPM.Appointment error. I have checked my books and that looks correct though.
Code:
Dim objSession As MAPI.Session
Dim objFolder As MAPI.Folder
Dim objMsgs As MAPI.Messages
Dim objMsg As MAPI.AppointmentItem
Dim objField As MAPI.Fields

Dim mar102007 As String
Dim mar112007 As String
Dim mar122007 As String
Dim nov32007 As String
Dim nov42007 As String
Dim nov52007 As String

Dim i As Long
Dim numChecked As Long
Dim temp As String
Dim Count As Long
Dim Subject As String
Dim location As String

Dim startDate As Date
Dim endDate As Date

Dim notes As String

mar102007 = "03/10/2007"
mar112007 = "03/11/2007"
mar122007 = "03/12/2007"
nov32007 = "11/03/2007"
nov42007 = "11/04/2007"
nov52007 = "11/05/2007"

On Error GoTo ErrorHandler

If Check4.Value <> 1 And Check5.Value <> 1 And Check6.Value <> 1 And Check7.Value <> 1 Then
MsgBox "You must check one of the check boxes of a year to the left to run this program"
Exit Sub

End If

Set objSession = New MAPI.Session

objSession.Logon 'must logon before you can use objSession
Set objFolder = objSession.GetDefaultFolder(CdoDefaultFolderCalend ar)
Set objMsgs = objFolder.Messages

If Check4.Value = 1 Then
Count = Count + 1
MsgBox "here"
'it appears that this is need before you make the event to add to outlook
objMsg.Type = "IPM.Appointment" 'this is erroring
objMsg.ConversationIndex = objSession.CreateConversationIndex
Set objMsg = objMsgs.Add

'mar 10, 2007 10 pm to mar 11, 2007 6 am

startDate = DateAdd("h", 22, mar102007)
endDate = DateAdd("h", 6, mar112007)

objMsg.Subject = "Regular event on March 10, 2007 from 10 pm to March 11, 2007 at 6 am"
objMsg.Text = "Here is some text"
objMsg.StartTime = startDate
objMsg.EndTime = endDate
objMsg.location = "This is the location field"
objMsg.ReminderSet = True
'set reminder 15 minutes before startDate
objMsg.ReminderMinutesBeforeStart = 15

Set objFields = objMsg.Fields
objMsg.Update True, True

DoEvents
End If

If Check5.Value = 1 Then
Count = Count + 1
End If

If Check6.Value = 1 Then
Count = Count + 1
End If

If Check7.Value = 1 Then
Count = Count + 1
End If

Cleanup:
MsgBox "enter exitsub"
Set objFields = Nothing
Set objMsg = Nothing
Set objMsgs = Nothing
Set objFolder = Nothing
If Not objSession Is Nothing Then
objSession.Logoff
Set objSession = Nothing
End If
MsgBox "exit exit sub"
GoTo AtEnd

ErrorHandler:
MsgBox "Error Handler"
MsgBox "Error Occurred: " & Err.Description & " [" & Err.Number & "]", vbOKOnly, "DSTMaker - Error"
GoTo Cleanup

AtEnd:
MsgBox "Done"
End Sub
Thanks for the help in advance

Closing Excel Process After Creating Excel.Application From Access 2003
After such code:
Code:
Dim xLs As Excel.Application
Set xLs = New Excel.Application
xLs.Visible = True
xLs.Workbooks.Open DtR
‘do stuff
xLs.ActiveWorkbook.Close savechanges:=False
Set xLs = Nothing
There is always Excel process left running. When I do this 5 times I will have 5 instances of Excel running.
Is there a way to kill this process at the end of the code?

Converting Word 2003 Table To Excel 2003 With VBA
I'm working on inputting project summary data into a spreadsheet.
The data is arranged in tables in Word 2003.
I've created sheets to store the information.

Currently, I have a form where the user specifies the path of the summary .doc file. Conversion is done thru VBA code
How do I get a specific piece of data into a specific field?

I'm thinking of crushing it into a text file and reading the field=value pairings.

I've zipped a sample summary and my .xls file

My manager wishes to automate the data entry process as much as possible

ANY help is greatly appreciated

Cheers,

Problem Running VB6 Application In Windows XP && Windows 2003 Server
I have installed a program written in VB6 and Crystal Reports 8.

When I run the program in Windows XP Professional, once a while I encounter "Illegal Operation" for SslstBar.ocx, Ssdw3a32.ocx and Ssdw3b32.ocx.

When I run the program in Windows 2003 server (program and database in the server), frequently my program seems like hang and I can only close my program using "Endtask".

I need to your help to resolve the above problem soonest possible.

Thank you very much.

Have a nice day.

Can I Get Your Advice Please? {Storage Advice: Product Descriptions}
Hi all,

I need your advice on this:

I'm writing a program which will have a main form with 40 command buttons. Each of these buttons will open a different form (let's call these level two forms). Each level two form has 15-20 command buttons. Clicking on a button on any of these level two forms will open a level three form which will display a product description in a text box. There is only one single form on level three, form that will be used by all buttons in level two forms - in other words, since the text box is populated every time when a button is clicked, a user can not see two descriptions at the same time. I was thinking to store the descriptions in individual files (no two descriptions are identical), but I'll end up with about 600-800 files (40 forms x 15-20 commands). Is there any better way to store all those descriptions, like in a common file?

Any help would be much appreciated,
poli