Visual Basic :: Creating A "Data" Report From Multiple Tables

What's More Efficient---Data Environment Or "manually" Creating Report Forms?
After reading the thread on Data Report, I have a question. I' sure my question won't come out right, but if anyone knows wha I'm trying to say, please respond. Is it easier or mor efficient to create reports from an database through using th Data Environment object or jusr creating a form that displays report?

I'll be in the process soon to be ready to setup forms to displa specific reports from many of the database tables. My thinkin is to create forms for the specific database tables & use SQ queries to get the data and use listboxes to display the data=2 But after reading the current thread as I said, I'm getting little confused now on how I should go forward. Right now, I'm I used the link that was in thread and have been reading following the directions to create a data environment and so fa I've been able to follow it. My question is, so I continue t follow it, or go with my original train of thought with creatin the forms? It seems like it would be "easier" to use Data Repor objects to show the queried data. I'm feeling uneasy because al of this is still largely new to me.

"-" Causing Problems When Creating MS Word Tables
Hello All,

Every "-" within a string of text splits and creates a new column when creating Table in Word.
Any ideas how I can eliminate Word adding column at "-" ?

Warm regards,
Mike "the Rat"

Creating An "Array" Of Tables In A Database
I have a table in a database called Script which I access through ADO using:
Public rsScript As ADODB.Recordset
and
Set rsScript = Script.Recordset
etc.
Everything works fine.

I would now like to create several tables Script1, Script2, etc.

How can I refer to them in a generic manner, like Script(i), so I can first choose a table then reuse the same code for any of them?

Thanks!

Hervé Chain
Houston, Texas

Show The Cookie "Privacy Report" And "Security Report" Forms For The Web Browser
hi people..

how do i show the cookie privacy report and the security forms from within the ie webbrowser control?

i know how to show the icons stating if impacts are made etc, but with no luck in finding how to show the forms, im at a loose end.

can any one help help me with showing the forms as in the image below please?

i have looked all thru the MSDN library and PSC, and searched here, with no luck

Thanks ppl.

Urgent Data Report Error "Report Sections Do Not Match Data Source"
hi this is my code when i try to run the report, the error message will come out saying that "Report section do not match data source" thanks

datefrom1 = Format(DTPicker3.Value, "mm/dd/yyyy")
dateto1 = Format(DTPicker4.Value, "mm/dd/yyyy")
z = 0
medicationreport.Sections("Section4").Controls.Item("lblfrom").Caption = DTPicker3.Value
medicationreport.Sections("Section4").Controls.Item("lblto").Caption = DTPicker4.Value
          strConn = ("Driver={SQL Server};Server={.};database=ccmsEquine;Uid=;Pwd=;")
          conn.Open strConn
          Set rs1 = conn.Execute("SELECT count(*) FROM Drug D, Vdrug VD, Visit V WHERE V.visit_id = VD.visit_id AND D.drugid = VD.drug_id AND V.Time_in >= '" & datefrom1 & "' AND V.Time_in <= ('" & dateto1 & "')")
          numf = rs1(0)
          rs.Open "SELECT D.Druggroup,D.brand,SUM(VD.Qty)as qty,SUM(VD.UnitCost)as unitcost FROM Drug D, Vdrug VD, Visit V WHERE V.visit_id = VD.visit_id AND D.drugid = VD.drug_id AND V.Time_in >= '" & datefrom1 & "' AND V.Time_in <= ('" & dateto1 & "') GROUP BY D.DrugGroup,D.brand ORDER BY D.druggroup,D.brand", conn, adOpenStatic, adLockReadOnly

          If numf > 1 Then
          With medicationreport
              Set .DataSource = Nothing
              .DataMember = ""
              Set medicationreport.DataSource = rs
              With .Sections("Section6").Controls
                For intCtrl = 1 To .Count
                      'Place one unbound text at the details
                       If TypeOf .Item(intCtrl) Is RptTextBox Then
                            .Item(intCtrl).DataMember = ""
                            .Item(intCtrl).DataField = rs(z).Name
                            z = z + 1
                       End If
                  Next intCtrl
                End With
              With .Sections("Section1").Controls
                   For i = 1 To .Count
                      'Place one unbound text at the details
                       If TypeOf .Item(i) Is RptTextBox Then
                            .Item(i).DataMember = ""
                            .Item(i).DataField = rs(z).Name
                            z = z + 1
                       End If
                  Next i
               End With
               .Show
          End With

Creating Program "item" In Existing Start Menu "group"
Hi all,

I'm finally at the stage of packaging my application for distibution here at work. When it installs, I don't want it to create a new group in the start menu rather I want to ADD it to an existing group. All of our essential programs go in to a group called "Desktop Applications". During the P&DW, I created a new Group under Programs called "Desktop Applications" and put the program item under that group thinking it would recognize it as an existing group and just add it. Well, apparently I did something wrong because it doesn't add it to this group, nor does it add it anywere else.
Does anyone know how to do this?

If I Use "SaveSetting App.Title, "Settings", "Font", "001122"" - Save Date In The Registry, Where Ca
If i use "SaveSetting App.Title, "Settings", "Font", "001122"" - save date in the registry, where can i find the value saved in the registry? Thanks

Resubmitting: "BeginTrans" , "CommitTrans" And "Rollback With Data Environments
----- Original Message -----

From: shankar [ babu ]

To: visualbasic-l@OpenITx.com

Sent: Wednesday, February 26, 2003 12:24 PM
Subject: "BeginTrans" , "CommitTrans" and "Rollback with dataenvironments

hello everybody,
I am using data enviroment designer in my project.

I am getting error while using
"BeginTrans" , "CommitTrans" and "Rollback"
of the DataEnvironment 's connection properties

kindly let me know the solution
thanks in advance
bye
shankar

Testing "For" And "Copying" Database Tables
I have a vb6 project written with DAO. I don't think the latter is very important in this case. I need to do two things which are somewhat related. The database is called "GL". First, I need to test the database to see if a table called "GLrecActivity" exists. If not, I want to copy that table from another database called "aaaGL" which I will copy to the client's system. I know how to test for a field in a table but not for the table itself. Thanks.

"BeginTrans" , "CommitTrans" And "Rollback With Data Environments
hello everybody,
I am using data enviroment designer in my project.

I am getting error while using
"BeginTrans" , "CommitTrans" and "Rollback"
of the DataEnvironment 's connection properties

kindly let me know the solution
thanks in advance
bye
shankar

Creating "links" To Full Data View
---------------------------------

Hello!

I have a form with the results of a query. The form displays only 3 fields of each record. Near every record I want to create some kind of "link" button (or other stuff) that brings me to a form with all the fields of the record. How can I make it? The problem is saving the information of the RecordId in each button, something like the PHP links that save the id's of the records in each link.

Thanks!

---------------------------------

RESOLVED - Data Report Designer "Show" Only Shows Page 1
When previewing a report created using Data Report Designer using the .Show method
only page 1 displays. Is it possible to preview all pages?

Thank you

Edited by - jbkzmiller on 8/2/2005 5:46:28 PM

RTF In Data Report? <I Fear The Answer To My Question Is One Word... "NO" :) >
Is there anyway that I can include an RTF box, or RTF formatted text into a Data Report in VB6???

Edited by - SkippyJD on 9/23/2003 10:44:37 AM

Data Report Error "Closed Or Invalid Connection"
I am using the Data environment with the Data Report.

My reports run fine the first time, but if the user attempts to run them again, I get the error "Operation is not allowed on an object referencing a closed or invalid connection."

I don't completely understand the correct way to open, close or set the connection the the data environement, or the reports. Here is my code, which works once, but I need to be able to run the reports multiple times. Thanks in advance for any help.

The error occurs when trying to open the rscomHourlyRpt

Catrina

DtaReports.CnnReports.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=pdp.mdb;Persist Security Info=false"

If DtaReports.CnnReports.State = 0 then
MsgBox "Reports failed to initialize. Please try again."
Enable
Exit Sub
End If
on error resume next
DtaReports.rscomHourlyRpt.Close
DtaReports.rscomSalary.Close
DtaReports.rscomScheduled.Close
DtaReports.rscomNoInput.Close
on error GoTo 0

fraPrinting(0).Visible = true
DoEvents

''''Hourly Employee Report
SQL$ = ""
SQL$ = "SELECT Val(PAYEMP) as PAYEMP, LName, FSTName,"
SQL$ = SQL$ & "VAL(RegHrs) * .01 as RegHrs,"
SQL$ = SQL$ & "VAL(OvtHrs) * .01 as OvtHrs,"
SQL$ = SQL$ & "VAL(dblHrs) * .01 as DblHrs,"
SQL$ = SQL$ & "VAL(reg2Hrs) * .01 as Reg2Hrs,"
SQL$ = SQL$ & "VAL(Reg3Hrs) * .01 as Reg3Hrs,"
SQL$ = SQL$ & "VAL(Ovt2Hrs) * .01 as Ovt2Hrs,"
SQL$ = SQL$ & "VAL(Ovt3Hrs) * .01 as Ovt3Hrs,"
SQL$ = SQL$ & "VAL(Oth1Ern) * .01 as Oth1Ern,"
SQL$ = SQL$ & "VAL(SickHrs) * .01 as SickHrs,"
SQL$ = SQL$ & "VAL(VacHrs) * .01 as VacHrs,"
SQL$ = SQL$ & "VAL(HolHrs) * .01 as HolHrs,"
SQL$ = SQL$ & "VAL(CommErn) * .01 as CommErn,"
SQL$ = SQL$ & "VAL(Meals) * .01 as Meals,"
SQL$ = SQL$ & "VAL(Tips) * .01 as Tips,"
SQL$ = SQL$ & "VAL(MiscHrs) * .01 as MiscHrs,"
SQL$ = SQL$ & "VAL(Oth2Ern) * .01 as Oth2Ern,"
SQL$ = SQL$ & "VAL(AdjToNet) * .01 as Adj,"
SQL$ = SQL$ & "Cdiv,cDept FROM Query2 "

If PR.PAGEORDER = 5 And ManPage% = 0 then
frmBalanceMenu.KeyPreview = false
Disable
fraPaging(0).Visible = true
txtPaging.Text = ""
txtPaging.SetFocus
Exit Sub
End If

If PR.PAGEORDER = 1 Or ManPage% = 1 then
SQL$ = SQL$ & "ORDER BY LName, FSTName ASC"
GoTo Choose
End If
If PR.PAGEORDER = 2 Or ManPage% = 2 then
SQL$ = SQL$ & "ORDER BY PAYEMP ASC"
GoTo Choose
End If
If PR.PAGEORDER = 3 Or ManPage% = 3 then
SQL$ = SQL$ & "ORDER BY cDiv,cDept,PAYEMP ASC"
Debug.print SQL$

GoTo Choose
End If
If PR.PAGEORDER = 4 Or ManPage% = 4 then
SQL$ = SQL$ & "ORDER BY cDiv,cDept,LName, FSTName ASC"
GoTo Choose
End If
MsgBox "Paging Order error. set Paging order in Param File"
Exit Sub
Choose:

on error resume next
DtaReports.rscomHourlyRpt.Close
on error GoTo 0

DtaReports.rscomHourlyRpt.Open SQL$ ''error occurs
RptHourly.Orientation = rptOrientLandscape
RptHourly.PrintReport
DtaReports.CnnReports.Close

"Report Sections Do Not Match Data Source"
Hi Everyone,

Could someone help me out here...

I am using Data Environment and Data Report. I was thinking of placing some report text fields in the GROUP HEADER so that my data only appears once. i am getting the error message "Report Sections do not match data source" even before I add any text fields. Please help out! Thank you!

Tim

Solution> Error: """"&&H8007007E (-2147024770) The Specified Module Cannot Be Found"""
Hello

This is the error what i am getting after installing a package of one of my module on user testing machine.
The same module being working fine on others.

What can be the reason for this and what can be the probable solution for this?

Sandeep

Printing Generally ("REPORT"="HSRUW")
This is specifically a question about printing from Crystal Reports in VB.Net but it obviously has a more general cause.

When printing my report the text comes out completely wrong. For instance the word "REPORT" prints as "HSRUW"

If you search for HSRUW in google you will get lots of PDF files with exactly the same error. What is this? A codepage error? Unicode problem. Specifically how do I get Crystal Reports to print correctly?

Method "SaveAs" Or "Save" Of Object "Excel.Workbook" Does Not Work.
Hi people.
I did for a long time a program that uses excel automation, so that from a template will create a final file with some data pulled from the database (with ADO). At the end and when the Excel file is ready to be saved I got in a couple of computers some problems. In the whole LAN have XP, but in these 2 computers we have SP2. I have checked the rights and are OK (I have even tried to save the Workbook under the Temp folder and also the same problem).
Working with Office 2003 (SP1).
I have searched in internet about any bugs but I don´t find anything.
Any ideas.
Thanks for your time
Jaime

Error In Data Report(VB6) "Report Width Larger Than Paper Width"
I am suppose to generate a Data report in VB6..
but i am geting an error like 'Report width larger than paper width'
my data report width is 10000
i have also tried it by reducing it to 8000
but still geeting the same error......
is it because of the few large datafields in the report....

please tell me the solution...i needit urgently

Data Report "report Header"
hello,please help.how to display database field at report header .

for example:
from the database table have Department field.i want to display the Department name to report header.

this is the current code:
Code:Dim total As Double
Dim strSQL As String
Dim conDataConnection As Connection
Dim empName As String
Dim enddate As String
Dim startdate As String
Dim Department As String
'Dim rs As New Recordset

empOTsummary.Orientation = rptOrientLandscape
empOTsummary.Show
empName = Cboempname.Text
'Department = rs1("Department")

start = Format(DTPicker1.Value, "dd MMM yyyy")
enddate = Format(DTPicker2.Value, "dd MMM yyyy")

Set conDataConnection = New Connection
      conDataConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & _
                "Overtime.mdb;Persist Security Info=False"

Dim rs As New ADODB.Recordset
strSQL = "SELECT * FROM Overtime where OvertimeDate BETWEEN #" & start & "# and #" & enddate & "# and EmployeeName='" & empName & "'"
rs.Open strSQL, conDataConnection, adOpenStatic, adLockOptimistic

While Not rs.EOF
        If IsNull(rs("OtHours").Value) Then
            total = total + 0
        Else
            total = total + rs("OtHours").Value
        End If
        rs.MoveNext
    Wend

  'display total at report footer
  empOTsummary.Sections("Section5").Controls.Item("Label15").Caption = Format(total, "#,##0.00")
  empOTsummary.Sections("Section4").Controls.Item("Label17").Caption = rs("Department") i use this method to display department name but have error message type miss match.
  empOTsummary.Sections("Section4").Controls.Item("Label19").Caption = start
  empOTsummary.Sections("Section4").Controls.Item("Label21").Caption = enddate
'set the database source in rs
    Set empOTsummary.DataSource = rs
    'then set the field
    empOTsummary.Sections("section1").Controls.Item("Text1").DataField = "EmployeeName"

thanks for help!

Transfering Data From "Text Box" To "MS Excel"
Dear All,

Request someone to send me the code to transfer data entered in Text box to MS exel automatically

Thanks in advance

Agnihotri

How To Replace "Apple" With "Banana" In A String That Contains "Orange" In A TXT File
Whoa! Long thread title. Basically, how can I search for any string in a text file that contains "Orange", then replace "Apple" with "Banana" in that same string? Is this difficult? Thanks!

Data1.RecordSource = "select * From Salary Where 姓名 Like " + S + " " * ""
Data1.RecordSource = "select * from salary where 姓名 like " + s + " " * ""
thanks in advance gentlemen and ladies..
firstly...I don't know what must add "++" between "s " variant..
who can tell me why?? thanks , ,, I really don't know why it does this..
maybe i am a beginner..please forgive me why add ++ between s..thanks

How To Change Boolean Field From Displaying "0" And "-1" To "Yes" And "No"
Hey there,

I have a data report, which displays a few fields from an Access table, one which is a boolean. At the moment if the boolean value is True, then on the data report it displays "-1", and if False "0".

How can I change this so it displays "Yes" if true and "No" if False?

Would be really grateful for any help.
Thanks.

Extract Local Names For "OK", "Cancel" And "Apply"
Hi!

I noticed that some programs written in C++ have an English language, but the captions of the buttons "OK", "Cancel" and "Apply" are in German, Swedish or whatever localized Windows version the user utilizes. Any idea how to obtain the captions of those buttons in VB? The only method which comes into my mind is to get the locale ID and have an array with strings for the the various language versions, but I doubt that those programs do it in that way.

Regards,
Sebastian

<input Type="submit" Name="op-savefile" Value="Save"> - How To S
<input type="submit" name="op-savefile" value="Save"> - How can you submit this button through visual basic in a webbrowser?

Disabling "wake Up", "sleep" && "power" Button
hello there, how to disable "wake up", "sleep" & "power" button with visual basic? thanks

Pleez, Read This!!! Matter Important! "Printing In "DOS Mode" Using "Shell" -not Happening, I Wonder
Hi

[I had to repost it since I have not received any replies for my earlier post]

I have a problem.

Following is the code :

Shell("c:windowscommand.com /c type " & App.path & "matrix.txt >prn")

where App.path is C:XYZ

when the above line is executed, the contents of "matrix.txt" is not printed on the printer. Instead, control just passes on to the next line.

So, to find out why, I modified the line thus.

Shell("c:windowscommand.com /K")

The above command takes me to the "command prompt". Here, when I give the command "type c:xyzmatrix.txt >prn", which is what the vbcode does, I get the message "file creation error".

So, I have identified the problem. Can anyone tell me why this "File creation error" occurs, And how to solve the problem?

Thanks for reading through.

Data Report With Multiple Tables
Good morning!

I have a VB application that loads information into Access tables about patients into a Client table, and then supporting information (such as allergies, prescriptions, contacts) into separate tables. There is generally a one-to-many relationship between my client table and the supporting tables. I've inserted a data report into my application to print the information about the patients along with all the supporting information. My instructions said to use the Data Environment designer as a data source. I can select fields from the Data Environment and move them to my data report from the client table and one supporting table, but when I try to select a field from the third table in the Data Environment, I get the round graphic with the slash and VB wont let me drop it on the report.

Am I asking too much of the Data Environment and data report? If so, how do I proceed in getting this information into a report?

Can I use the Data Report without Data Environment and load the report fields with VB code like a form?
Thanks for your help,

Data Report And Multiple Tables
I have been struggling with the Data Report part of VB6 for awhile now. I do have a data environment and data environment connection with no properties set. I am trying to do everything with code and at run-time. I have a report setup right now with a bunch of headings and data fields that are just typed in. My problem is that I need to pull info from multiple tables in one database and display it in the same report. My other problme is that the tables I am pulling info from have some of the same field names. My last problem is that I can't seem to figure out how to do this. Here is the code I have now that I basically got from MSDN but it does pull info from one table and work.

Code:
Dim CN As ADODB.Connection
Dim RS As ADODB.Recordset
Set CN = New ADODB.Connection
Set RS = New ADODB.Recordset
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "" & dbName
CN.Open connectionString
Set RS.ActiveConnection = CN
RS.Source = "Select * FROM Drivers"
RS.Open , , adOpenStatic, adLockOptimistic
Set rptRaceAll.DataSource = RS

rptRaceAll.Show
I did think that the table.field method might work somehow but I am not sure where or what. If anybody can help me with this I would be very thankful. Also, if anybody knows of any good resources on the data environment and data reporter and doing things at run-time with them please pass it on. Thanks alot!!

-Scott

I Am Reciveing This Error "20525 Unable To Load Report" Crystal Report Does Not Show
i am reciveing this error "20525 unable to load report"
i can't view crystal report i designed and saved as *.rpt
in vb6
"report.ReportTitle = title
report.DataFiles(0) = App.Path + "mydb.mdb"
report.ReportFileName = App.Path + "report1.rpt"
report.Action = 1"
is the error in the line "report.Action = 1"
i want to know why the report dos not show up

Getting The File "Type" Descriptions (i.e., "doc" = "Microsoft Word Docume
Hello there,
I am creating an Explorer-type Listview to display the files in a directory, and one piece of info I need to know how to obtain is the file "type" (i.e., "doc" = "Mircosoft Word Document", "xls" = "Microsoft Excel Worksheet", etc.). Is there an API, or does anyone have a technique to do this? Thanks.

Changing The "title" Of A VB Created Word Doc From "Document1" 2 "BadgerBai
Ok, when I create a new word doc it automatically takes on the name "DocumentX", where X is a number greater than 1.
What I want to do is change this by using something like:

VB Code:
Dim objWoof As New Word.ApplicationDim objGrowl As Word.Document Set objGrowl = objWoof.Documents.Add objGrowl.[What Property] = "Badger Baiters R Us"

Is this possible?

Oh, and b4 anyone mentions it, I do NOT want to save it, that is NOT an option...just getting that out the way now

Rarararrrrrrrrr

Woka

Pls I Need Codes ASAP "how To Create Databases And Tables In Vb"
how can i create a database and its tables in vb.
that when i click a certainn button the application would automatically create a database and tables in access.

How To Link Data Report With Multiple Tables
I am creating data report. I have a database with 4 tables.
Table 1 : Tree
Fields : Treecode, TreeName, Height, Diameter, Cycle Life
Table 2 : SegmentPlan
Fields : TreeCode,SegmentCode, NumberOfTrees, DatePlanted, ForestOfficerInCharge
Table 3 :Segment
Fields: SegmentCode, SegmentPlan, State
Table 4 : Harvest
Fields :TreeCode, SegmentCode, DateOfHarvest, NumberOfTrees, ForestOfficerInCharger, Comments
When I create the data report I only can link to one of the tables. I want to get all the fields from all the tables in one data report. How do I do that? I ve tried using data environment . I created the 1 parent command and 3 child commands but I can only link to 2 tables(Parent and 1 child)...Is there a way to have all my tables to create 1 data report.
And how to acess data report according to "DATE" whereby user inputs the date.

Can Someone Guide Me On How To "PUT" A "CHECKBOX" Inside A "Datagrid" For VB6.0?
Can someone guide me on how to "PUT" a "CHECKBOX" inside a "Datagrid" for VB6.0?
please i need these to complete my program security....................for my thesis? please please!!Can someone guide me on how to "PUT" a "CHECKBOX" inside a "Datagrid" for VB6.0?

Combobox Help """""""""""""'Urgent"""""""&&quo
Hi Guys,,,,,,

This may be the stupid way.But i need this.................

I am using combobox in my form. I set the style to Dropdown combo.

Here we can exter text in combobox b'coz of the style Dropdown combo.
But i don't want to allow user to enter ......allowed only to select.....

For that i can set the style to Dropdownlist.

But i don't want this style. B'coz i can't clear the text at run time.

Tell me if dropdown combo means, User shouldn't enter at runtime
Tell me if dropdown list means, how to clear the text at runtime...

Pls help me out.....Urgent
sangeetha

Data Report</title> <script Type="text/javascript"> <!-- Function PrintTags() { Var Curr=document.getElementById('vB_Editor_QR_textarea').value; Newval=curr.replace(/[highlight]/gi,'[HIGHLIGHT=vb]');
Hello

I have placed a label in a report i VB6.
Depending on what button the user clicks on I want to change the label that I have in the report, is this possible ?

The report is done via the data report designer.

Thanks in advance
Micke

"LIKE" Command To Compare Tables
Hi,
Is there a straightforward way to compare 2 tables using the LIKE command? To explain, I have table "product" with thousands of product names and table "string" containing pieces of product names. I'd like to select all rows from "product" that have matching strings in table "string". I can use the "LIKE" command to search for one string at a time but I'd like to search them all at the same time.
(I should add, or perhaps you know it already, I'm just a beginner at this!)
Thanks for any help!

Don't Want Populate Tables "pass"
I don't want populate tables name "pass" . How to prevent this tables name populate into the combo box?

Code:
Dim tdf As TableDef
For Each tdf In db.TableDefs
If Left(tdf.Name, 4) <> "MSys" Then _
cboTable.AddItem tdf.Name
Next tdf
cboTable.Text = cboTable.List(0)

Having Trouble Running Game Multiple Times. "Restarting"
The Space Shooter I'm working is nearly complete, I am just having an automation error when I load the game a second time. I have uploaded my code (which I have butchered in a desperate attempt to correct my mistakes by using arrays, loads/unloads, and tons of other random, Darwinic code) in a Zip file, but if anybody can simply tell me a method with with I can simply "reload" a form as if it was never loaded before, that would work just as well...
Also, now that I start thinking about it, if there's any way to run another EXE from within a program, I could have the Atrium program run seperate from the game, and whenever the user started a new game, have the game EXE run seperately, then close itself. I'll look into that.
Anyway, thanks for the help!

Word - Saving Multiple Files From A "base-file"
Hi,
This should be easy for you, but I can´t do it!
I have this document I need to send to many people, so I have used the mail merge tool successfully. BUT, I need to send each letter by email (as an doc attachment), so I need a way to save each letter with a different name.
Like: Letter (Adam).doc, Letter (peter).doc.
I´ve made a macro to save the letter then go to the next one (note that all letters are in one doc, using the merge tool it simply change some fields based on my database) but I can´t manage to make the macro save each file with a different name. How can I do that?

Thanks for the help
Daniel

Modify This Code, Multiple "hotkeys" | Paste From Clipboard
I found the code to create a universal hotkey on these forums
link and code: http://tinyurl.com/twqg

My question is how would I modify this code to be able to allow multiple "hotkeys".

Any ideas? I have been playing around with it this morning but have had no luck, specifically because the registerhotkey function only allows one key to be assigned to it. The number of hotkeys I would need will range between 3 and 12.

Second question is how do you paste the contents of a clipboard, while outside your application? So far I can get the items into the clipboard while outisde the application, But I cannot get them out.

As a side note if anyone can get it to use the function keys F1 (&H70) , F2 (&H71) etc that would be appreciated

If you can provide any insight to my inquiries that would be appreciated.

Thanks,
ins

PRB: Multiple "System Files Are Out Of Date" Errors (Q191096)
I'm getting the following known error when I package and try to install my program using Microsoft's Package & Deployment Wizard. I'm downloading InstallShield right now. Does anybody know if Installshield will have the same problem?

Thanks,
Greg

SYMPTOMS
When you install a Microsoft Visual Basic application, you may receive the following message:

Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cancel to exit setup without updating system files.
After Windows restarts and you begin the installation again, the error message appears again.

NOTE: This occurs with either the Microsoft Visual Basic 5.0 Application Setup Wizard (ASW) or the Microsoft Visual Basic 6.0 Package and Deployment Wizard (PDW).

Help Required - "Multiple-step OLE DB Operation Generated Errors...."
Hi All,

I am passing some values to a Stored Proc in MS SQL from VB and am raising some errors in the SP and showing some custom messages if some conditions are not met.

When the SP raises an Error, then VB shows me "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.", but if i run that same query (one passed from VB to SQL) on the SQL prompt, then it shows me my custom message properly.

Can some1 help me out on this.

Thanks in advance.

Regards.

Attention Gurus : Help With Inet Control : Generates Multiple "winoldap" Sessions ...
Hello,

I have the following problem :

I use inet control (VB5) for downloading a small text file from FTP.

I use a fixed number of attempts(10) for successing, after which i consider download unsuccessfull if I end with some error.

At each try (or attempt), i use "cancel" method after the attempt

Whenever there is a problem, i have noticed that the control leaves in the system a lot of "winoldap" active sessions. And they end up crashing the program.

Is there anything I can do ?

TIA

Yfh

Creating An Internet Explorer ToolBar (like Googles Or "links" Etc)
Hi all,

This seems to be a bit of a gray area for creating one in Visual Basic!!

I am wanting to create a little tool bar with a combo-style dropdown box, a text box and a button to click.

For ease of use for this project (and to help other people in the future), I want to make the pressing of the button send your entered data to the search engine of your choice (from the dropdown list).

I have noticed several posts about the subject, but none apear to be solved comprehensively - and the information seems a bit sparse on the web (most people creating internet "style" toolbars, rather than actual bars to fit into IE. Actual examples I have found are in C. Doh!).

So - Can anyone help me with some good references or clues please?!?! I am intending to create the tool bar as a generic example then post the code back on here so that others can use it with ease in the future (unless someone has already done it?!)

For now I am not too bothered about the interaction with the other websites (because I think you need an understanding of the search engines themselves) - I just want the buttons to do things and to join IE in the "View / Toolbars" menu.

Any help would be appreciated - I am sure the code will benefit others also in the future!

Cheers guys,

Paul.

What Thought Processes Do "Real Programmers" Go Through When Creating A Program?
Hi,
All my programs previously have been just for me. I didn't really need a "User Interface", i.e. Form. They were formless, no option buttons, no text boxes, etc.
I'm now trying to create programs that other people can use and I'm finding this most difficult. I'll spend hours trying to get the Form just right and then start actually programming. Then I find I should have used option buttons instead of check boxes.

How do "Real Programmers" go about creating a program?

Al.

------------------
A computer is a tool, not a toy.
<A HREF="mailto:asmith3914@aol.com
asmith@spxateg.com">asmith3914@aol.com
asmith@spxateg.com</A>