Visual Basic

helelark12314-Jul-09 1:47

14-Jul-09 1:47

It seems like unecessary to create and delete those tables every time. Just create them and that's all. Tables names and field names are same at each time you run the program, aren't they?
If yes, why to delete them and recreate them at each time.
Explain the target of the program and database use, so we will answer you more precisely.

Shay Noy

Nielvh14-Jul-09 1:55

Nielvh

14-Jul-09 1:55

I do not delete the tables every time. They only need to be created once.
The application is for salesreps and they would add additional information about their clients that the accounting package doesn't cater for. The reason why I want to add the table creation in the code is so that I do not have to create the tables manually each time the application is run at a different site.
Am I going at it the wrong way?

helelark12314-Jul-09 2:09

14-Jul-09 2:09

Understood. I think that it is a good approach. The creation should be when loading but you have to check if the tables do not already exists and if they already exists just skip the creation step.

You also can think on a way how to create the tables in a setup project and not inserting the creation into your project.
Anyway, also then you will have to check that the tables are not yet created to prevent from crashing program.

Shay Noy

run access query for crystal report

Nielvh14-Jul-09 2:17

Nielvh

14-Jul-09 2:17

Thanks for the response - I'll look into putting it in some sort of a setup process.

KIDYA13-Jul-09 23:26

KIDYA

13-Jul-09 23:26

Hello Experts!!

My problem is- "select * from data" i want to show result of this query on to crystal report.......I am using msaccess for a database.

Re: run access query for crystal report

helelark12313-Jul-09 23:37

Re: run access query for crystal report

13-Jul-09 23:37

This link will help you:
http://www.vbforums.com/showthread.php?p=2686697[^]

Shay Noy

KIDYA14-Jul-09 0:39

KIDYA

14-Jul-09 0:39

I used code from given link....but give error "view report is not member of frmOrder"
Dim Report As New frmorder
Dim TableName(0) As String
Dim QueryString(0) As String
TableName(0) = "TableName" 'Pass The Table That you used in the crystal Report
QueryString(0) = "SELECT * FROM TableName" ' Pass the Query
'ReportForm.MdiParent = MainForm 'Pass For Mdi True
Report.ViewReport("CrystalReport1.rpt", TableName, QueryString, )

Data Conversion Error at RecordSet.MoveNext VB6

she-Developer13-Jul-09 22:19

she-Developer

13-Jul-09 22:19

Hi all,
I'm connecting to a SQL database and reading the recordset(Rs1) sequentially using method MoveNext. This is what the data looks like:
It starts reading the records fine, but crashes on 2 records which are close together in the table(input). I'm almost certan that the problem is not in my VB6 app, but something to do with the recordset, plus it doesnt seem to have anything to do with conversion.
Here is the whole error message:

Run-Time error '-2147467559(80004005)':
SQL0802 - Data conversion or data mapping error.

This happens in the line:
Rs1.Movenext

Please assist.

Re: Data Conversion Error at RecordSet.MoveNext VB6

helelark12313-Jul-09 22:27

13-Jul-09 22:27

It will help us if you post the problematic snippet code and in addition give more info on the fields (of table in database) type where the code is crashing.

Shay Noy

Windows Popup Watcher

jeipiyaku13-Jul-09 22:09

13-Jul-09 22:09

Hi guys
im trying do an application wherein it watches other applications activities.
like for example my application will watch for any dialog box generated by the
application specified in the settings.
any idea on where should i start?

jeipiyaku13-Jul-09 22:16

13-Jul-09 22:16

btw im using vb.net

helelark12313-Jul-09 22:23

13-Jul-09 22:23

Your question is to vast. You should more specify what you need, because it is complicated to answer you for this kind of question.

Shay Noy

jeipiyaku13-Jul-09 22:37

Re: Windows Popup Watcher [modified]

13-Jul-09 22:37

thanks for your reply
ok so let me make my question more specific.
the core of the program is to watch a specific application for message boxes, dialog boxes, or error message boxes.
then get the text from the message box then put it in a log file
then preferably simulate a click event on the OK button of that message box

lets say that an application generates that a message box saying that a file is missing
id like to get that message then save it into a log file.

hope this will explain clearly

helelark12313-Jul-09 22:49

13-Jul-09 22:49

My question is, if I understood you right, do the "Watcher" application and the application that display the messageBox are the same one? If not, can they be the same application?

If it is not same application, take a look at the following links:
http://bytes.com/groups/net-vb/363935-extracting-text-another-application[^]

http://www.dreamincode.net/code/snippet2117.htm[^]

Shay Noy

modified on Tuesday, July 14, 2009 5:14 AM

jeipiyaku13-Jul-09 23:26