Visual Basic :: How To Access Visual FoxPro Data In Visual Basic

Visual Basic [DRIVER=Microsoft Visual FoxPro Driver]
I'm developing an application that uses Visual FoxPro free tables and having
a very difficult time being able to modify the structure of the table
programmatically. Below is a sample of what I am doing and hopefully
someone can give me an idea as to what I'm not doing or am doing wrong.
Keep in mind that I'm learning as I go and I'm sure the code isn't pleasant
to look at.

This compares two free tables and should be adding the new fields if any to
the table in the lcFolderTo directory. This will error when it hits the
execute and returns the error the table must be open exclusively.

lcFile = "11111111.dbf"' Example
lcFolderFrom = "\serverfolderFrom' Example
lcFolderFrom = "\serverfolderTo' Example

Public Sub FieldCompare(lcFile As String, lcFolderFrom As String, lcFolderTo
As String)
Dim lcConn1 As ADODB.Connection
Dim lcRst1 As ADODB.Recordset
Dim lcSQL1 As String
Dim lcConn2 As ADODB.Connection
Dim lcRst2 As ADODB.Recordset
Dim lcSQL2 As String
Dim lnCounter1 As Integer
Dim lnCounter2 As Integer
Dim lcMsg1 As String
Dim lcAnswer1 As String
Dim lbFound As Boolean
Dim lcFieldType As String
Dim lcFieldSize As String
Dim lcFieldDec As String
Dim lcExecute As String

Set lcConn1 = New ADODB.Connection
With lcConn1
.Provider = "ODBC;Provider=MSDASQL;DRIVER=Microsoft Visual FoxPro
Driver;SourceType = DBF;SourceDB=" _
& lcFolderFrom & " ;TABLE=" & lcFile
.Open
End With
lcSQL1 = "SELECT * FROM " & lcFile
Set lcRst1 = New ADODB.Recordset
On Error GoTo ExitSub1
lcRst1.Open lcSQL1, lcConn1, adOpenDynamic, adLockOptimistic

Set lcConn2 = New ADODB.Connection
With lcConn2
.Provider = "ODBC;Provider=MSDASQL;DRIVER=Microsoft Visual FoxPro
Driver;SourceType = DBF;SourceDB=" _
& lcFolderTo & " ; TABLE=" & lcFile & ";
EXCLUSIVE=YES;"
.Open
End With
lcSQL2 = "SELECT * FROM " & lcFile
Set lcRst2 = New ADODB.Recordset
On Error GoTo ExitSub2
lcRst2.Open lcSQL2, lcConn2, adOpenDynamic, adLockPessimistic
For lnCounter1 = 0 To lcRst1.Fields.Count - 1
lbFound = False
For lnCounter2 = 0 To lcRst2.Fields.Count - 1
If lcRst1.Fields(lnCounter1).NamelcRst2.Fields(lnCount er2).Name Then
lbFound = True
Exit For
End If
Next
If lbFound = False Then
Select Case Int(lcRst1.Fields(lnCounter1).Type)
Case adChar
lcFieldType = "C"
lcFieldSize = lcRst1.Fields(lnCounter1).DefinedSize
lcFieldDec = 0
Case adDate
lcFieldType = "D"
lcFieldSize = 8
lcFieldDec = 0
Case adDBDate
lcFieldType = "D"
lcFieldSize = 8
lcFieldDec = 0
Case adNumeric
lcFieldType = "N"
lcFieldSize = lcRst1.Fields(lnCounter1).Precision
lcFieldDec = lcRst1.Fields(lnCounter1).NumericScale
End Select
lcExecute = " ALTER TABLE " & lcFile & " ADD COLUMN '" &
lcRst1.Fields(lnCounter1).Name _
& "' '" & lcFieldType & "' (" & lcFieldSize & "," &
lcFieldDec & ") not null "
MsgBox (lcExecute)
lcConn2.Execute lcExecute
End If
Next
lcRst1.Close
lcConn1.Close
lcRst2.Close
lcConn2.Close
Exit Sub
ExitSub1:
lcMsg1 = "File - " & lcFolderTo & lcFile & " is not accessible" &
Chr(13) & Chr(10) _
& "Error # " & str(Err.Number) & " was generated by " _
& Err.Source & Chr(13) & Chr(10) & Err.Description
lcAnswer1 = MsgBox(lcMsg1, vbMsgBoxHelpButton + vbOKOnly, "Error",
Err.HelpFile, Err.HelpContext)
Resume
ExitSub2:
lcMsg1 = "File - " & lcFolderFrom & lcFile & " is not accessible" &

Isn't There A Way To Have The Combobox From Foxpro To Visual Basic???
I like the characteristic of the combobox on foxpro when you use the option of having it related to a table, then putting three fields on the combobox and when you click on the combobox, it can see very neatly separted by a | each column.
But in the combobox in visual basic, there's nothing like that, I have to add the three fields and they cannot be separated neatly like in visual foxpro. How can I possibly do this in Visual Basic with that limitation on VB'S combobox???

Visual Basic And Foxpro Tables
Hi, I'm using VB6 and Visual FoxPro Tables, I use adocd control with
MSHFlexGrid to show the queries result.

the problem it's that when I have a form opened with some query and
other user add some record to that table, I can't see those changes
until he close the program, I refresh the query but this doesn't work.

what can i do?.

Visual Basic ActiveX Used In FoxPro
I need to create a control that can be called up in foxpro to draw a line where ever and when ever. But the corrodinates need to be binded to a dynamic variable in foxpro. Any ideas how I can do this?

Thank you in advance.

Problem: FoxPro And Visual Basic
Hi to all!
Hi have a "small" problem... I need to insert a record in a Fox Pro database from a Visual Basic program.
When i run my program i don't have any errors, but the record doesn't exist in the database. If i execute the same query in Fox Pro, i don't have problem and i find the record in the table.
I don't have syntax error, i don't have any error that come back in Visual Basic, i don't see nothing....
Thanks for the help.

Alex

Edited by - MoltoPulp on 3/8/2004 3:04:29 AM

(VB6) Can You Use Foxpro Database In Visual Basic 6?
Sir,
I use Visual Basic and Access. Can I use foxpro database(dbf file) and link through in place of Access?

pkb_pkb

Pack A FoxPro DBF V5.0 Table From Visual Basic?
Hello All,

I was wondering if anyone know hows to pack a FoxPro 5.0 Table (DBF) from
within VB 6.0? I am not a Fox programmer but I am creating a module that
will add on to an existing Fox application and I need the ability to pack
the table.

Thanks.

Bob.

Visual Basic To Access .csv File From Ftp And Add Data To SQL
Hi.

I have some experience in VB but am completely new in SQL. I have a VB
project involving SQL to be completed in 5 days. I really hope you can
at least give me some ideas to shorten my developement's struggles to
meet the deadline.

My VB program will access a text file (*.csv) from ftp in which the
file is in the format of
a1,b1,c1,d1,e1,f1,a2,b2,c2,d2,e2,f2,......
in which there will be 246 columns in a line separated by commas. Each
6 columns are 1 group. So, there will be 41 groups in a line. The
number of lines of the text file can go up to 60000 lines.
The VB program will read the text file, extract and manipulate the
data. Then, the manipulated data will be added to SQL database.

The VB program needs to do the abovementioned tasks once daily.

Below are my questions:
1) How can i access a file from the ftp directory? The info given to me
is that the location of the text file is
ftp://192.168.1.15/Folder1/FileName.csv
user id: USER
password: USER
I dont know how i can include the "user id" and "password" into my VB
program to access the file in ftp.

2) For the File I/O of the *.csv file i mentioned above, how can i know
where are the
(i) "end of line" of each line &
(ii) "end of file"
?

3) Any quick notes for me to pick up SQL to be used in VB? Or any good
resources for me to kick start?

Any help is highly appreciated as my due date is approaching real soon,

Thanks a lot.

Leng

Passing Data From Visual Basic To Access
hi! how do you pass variable data from vb to an access query?

example:
Query in Access:
Select * from Table1 where ID = '" & variableID & "'

variableID is from Visual Basic

thanks!

Visual Basic 6 With Access XP How Can I Use A Data Control
I'm trying to use a data control to connect to an Access XP database,but i get an error, "Unrecognized database format", when i set up thedatabase name, and the recordsourse. I can use a dataenvironment, but icant get it to update the database when i key in new records. Any helpwill be greatly appriciated.

Insert Data To Access With Visual Basic
Hello guys,

I would like to ask you if you can help me. I have a database wich take tha data with visual basic 6. I want to save tha data (textboxes) into the database. The name of the database is mydb and include the lname,fname and address.

Thanks in advance.

Data Type Conversion From Visual C++ To Visual Basic
I'm trying to convert some code from Visual C++ to Visual Basic. There are some types, however, that I cannot seem to figure out what they should be. The C++ types are dpecifically WORD and DWORD. What should they be in Visual Basic? I thought DWORD is a Long, but I have no idea what a WORD would be. Specifically, I'm determining the types from the BITMAPINFOHEADER structure.

Transfering Data From Visual Basic To Access 2000
Hello,

I have been coding in Vb for about a month and have come across a problem. I'm attempting to open up a txt file which reads data into vb and then inserts the data into access.

I get an error message which states 'run-time error 424 object required'. Can anybody help? - see code below

thank you

Private Sub Command1_Click()
Dim nom As String, wage As Single, hrs As Single
Dim dbMyDB As Database, rsMyRS As Recordset
Dim SQLStmt As String

Set dbMyDB = OpenDatabase("staff.mdb")
Set rsMyRS = dbMyDB.OpenRecordset("staff", dbOpenDynaset)

picPay.Cls
Open "staff.txt" For Input As #1
Input #1, nom, wage, hrs
picPay.Print nom; wage, hrs
Close #1
SQLStmt = "INSERT INTO staff "
SQLStmt = SQLStmt & "(nom, wage, hrs)"
dbMyDBConnection.Execute SQLStmt
dbMyDB.Close
Print "Complete"
End Sub

Export And Import Access Data Using Visual Basic
Sir,
How do I export and import data from an access table to text file and import text files into database using Visual Basic.Pls help.

Visual Basic Data CoOntrol And Access 2003 L
I need work with Access database 2003 but the data controll dont work with it, what is the way ?
Thanks any message

Fernando Oviedo
With MSN Spaces email straight to your blog. Upload jokes, photos and more. It's free!

Problem With MS Access Data Base And Visual Basic!
How can I force my visual basic data base programs linked with ms access database to work on machines that don't have MS Visual Studio or MS Office installed on them ?????
What're the engine software or the runtime files I need to handle this problem ?

Ok that was the last problem I typed, I think I didn't describe my problem correctly !!!
I do make exe file, but the problem in the ODBC Driver, when the user get the exe file from me and try to use the program in his machine he got an error "Class not registered ..." this happens only when the program contains data base coding ...
I hope some one can help me ...

__________________________________________
Jemand,
MCSD Certified,
Arafasoft Senior Manager
jemand@arafasoft.com
http://www.arafasoft.com
http://www.registryshower.com
__________________________________________

Importing Excel Data Into An Access DB Via Visual Basic
Hi. My name is Mark. Hopefully someone can assist me.

Here's the situation:
I have an Excel spreadsheet with about 40,000 records and about 50 columns. I need this data transferred to an Access DB, WITHOUT DOING THE SIMPLE COPY-AND-PASTE METHOD (The person I'm doing this for will not have the Access application). So I'm trying to do this via Visual Basic code (VBA I guess).

I've tried the following two methods:

1) Using the DoCmd.TransferSpreadsheet command - This seemed to work for the most part, but an error was generated stating not all the data was copied. Looking at the resulting Access table, I noticed that only the last column was missing SOME data. (Any ideas on this problem?)

2) Copying the data cell-by-cell (see code snippet below):
i = 0
j = 0

For Each b In a.Workbooks
If b.Path = "C:MJVB StuffVB Project" Then
Set c = b.Worksheets(1)
For i = 1 To 15
rst.AddNew
For j = 1 To 25
rst.Fields(j - 1) = c.Cells(i, j)
Next j
rst.Update
Next i
End If
Next b

This works but it takes FOREVER with 40K records with 50 fields.

===========================================
So here are two questions: Is there a way to using VBA to simulate the way Access imports the data when using the 'Get External Data' option from the File menu? Or does anyone know how to access the behind-the-scene code (macro) that Access uses for this method? This method imported the records in less than 10 seconds.

Any help would be greatly appreciated.

Thanks,
Mark

Visual Basic Data Output With Visual Data Manager
Hi:

I have Visual Studio 6.0 and am using VB6 to make a program. This program takes input through the Visual Data Manager as Records, one by one. Then I want it to display these records one by one on forms, on labels, so that a user can go through them as displays one after another, as soon as the Visual Data Manager is closed.

It uses the Visual Data Manager to collect data, but what I need to do is then output as a label display to a new form or existing form, as a label.

I have tried things like

Unload Me
Form1.Show
RecordSet1 = Label1.Text

or

TxtFields() = = Label1.Text
TxtFields(1) = = Label2.Text

TxtFields() = = Form1.Label1.Text
TxtFields(1) = = Form2.Label2.Text

and the like, but it does not work. I have searched the Internet for answers.

What I do not want is to use say MS Access and SQL as the back and middle ends, because then the user would have to purchase additional software just to run this thing. I just want it to be self-contained and small. Say with maybe up to 100 records, probably much less. One record per set of two labels.

Also, a way to save this Recordset and retrieve it as TXT or RTF.

Any Ideas, All you programming gurus out there?

Thanks In Advance,

Bob

Importing Data From Excel To Access Table Through Visual Basic
Can anybody tell me how can I import data stored in Excel Sheet to Access. I want to do it through VB. Reason behind this is that there I want to restrict Non Administrative users for directly accessing the Database.

They should be allowed to import data from Excel Sheet to Access to make data available for them. Need for this arises to make data entry faster and avoiding more kestrokes needed to fetch data in Database. One more reason is to make it less data entry error prone.

I receive data from client in Excel and want to fetch it in Database without making data entry and saving my time But through VB.

Please provide your wonderful suggestions on this issue.

Thanks,
Manoj

To Manage Data Of Two Differents Ms-Access Table From Visual Basic
Hi sir,

Please, I developing right now an application on Sales and Pusharsing management for a customer, but now I meet two problems :
1. To affect automatically the "SalesPrice" that`s stored in the PRODUCT Table to the INVOICE Table using PRODUCT ID primary key. For ex. VALUE = SaledQuantity * SaledPrice (from Product Table).

2. After processing the invoice, I need to have my Stock in PRODUCT Table being updated automatically ( STOCK = STOCK - SaledQuantity "in INVOICE Table").

Please, help me to resolve this problem.

Truly,

Naasson Fuka.

Getting Data From Excel To Access Via Visual Basic (Adodb Or Any Means)
hi all,

    i am currently working on a project that requires data to be imported from Excel files, actually that data was first maintained in excel, but as now a new software has been developed, that old data needs to be shifted to Access db, the front end is in visual basic 6, and i need to get the data imported from the excel files,

    i had to save my time, and this websites has been very helpful from the day first i joined. kindly help in this regard.

    i just need an example code, which can open an excel document, move back and forward in the excel cells,

suppose i have a table in access containing just one column, and there is an excel file containing data just in a column, now i need to shift this column from excel to access

simple to say but might be its difficul in programming.

and volunteer to help

Thanks and regards
Khalid Mehmood Awan

Never commit a SIN for the sake of pleasure as the pleasure vanishes but the Sin remains

Accessing Visual FoxPro Data
I looking for example how Accessing Visual FoxPro Data from VB

Visual Basic Code For Exporting Excel Data To Access Database
hello all,

There is this data in excel sheet that has to be taken into access database for further processing,
so all the columns from excel need not be exported to access.

There will be only one sheet in Excel.

The number of columns in Excel are fixed but number of rows keep changing .

Another problem is that the format of entry in excel file is to insert a blank row after entering a valid entry, so it is also required to check the blank rows.

Could you please post me a logic which I could use to solve this problem, and could you please post me the code to export data from excel to access.

Thanks & Regards
Shibu P

This message has been scanned by McAfee Virus Protection System

Visual Basic 6.0 Connect Data Report With Access Databse Placed At Server
Hi,

it is possible to connect visual basic 6.0 application data report to an access database placed at remote server.

if any possibilites of connection pls give me the code to connect the datareport to the access databse.

thanks in advance

Manipulating Data In Visual FoxPro Tables
I am trying to process data in a Visual FoxPro table using ADO. While
looping through a recordset of data in the table and updating the
information in each record, I receive a message "The current Record could
not be found for updating in the recordset". I have tried as many different
combinations of cursor/lock types as you can imagine with the same result. I
am trying to update information in a stand-alone table. Every tutorial out
there is about SQL, ACCESS or ORACLE. Based on the example code I have been
able to find (and there is a lot of it) the code should work just fine. The
current code does work for a table in a Access 2k mdb, but not for FoxPro.
Is there something extra that needs to be done when updating an ODBC table
as opposed to a JET DB?

What Would Be The Code In Visual Basic For Exporting Ms Access Table Data To Ms Excel File
what would be the code in Visual Basic for exporting ms access table data to ms excel file ...?

How To Deal With Invalid Data In Visual Foxpro Tables
Hi, I am really having trouble with invalida data on visual foxpro tables. What I'm trying to do is to read data from visual foxpro tables to validate them and insert them into access tables. The problem is when for example a date field in visual foxpro tables is invalid (00-00-0001) and on runtime visual basic generates a runtime error for that, and I have a whole lot problems doing On error goto, I don't want to use that, but I don't seem to find another way which I am asking you or anyone to help me out here. I tried everything:

1.) if(not isnull(rs.fields(1).value))
2.) if(not isnothing(rs.fields(1).value))
3.) if(not isinvalid(rs.fields(1).value))
...

nothing worked. Please somebody help me out here.

Inserting Data In Date Field In Visual Foxpro
Hi All,
I am working unicode database srorage and retrieval for Multilingual data. I am using Visual Basic as
front-end and databases Oracle (Win, Solaris), SQL Server, MS Access, Visual Foxpro simultaeously in
single application.

I am facing a problem while running sql for Visual foxpro from VB.The problem is actually a common
one. I am unable to store date (whether it is string type or Date field) into visual foxpro database.

*** This question has been edited ****

The abstract from my code are pointwise:
1.Coonection string*****

Case "Foxpro":
Dim ConnString As String
ConnString = "Provider=MSDASQL.1;Persist Security Info=False;"
ConnString = ConnString & "Extended Properties=" & """"
ConnString = ConnString & "Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=\OraclesdkIndica2ksdkvfpIndica2ksdk.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
& """"
Conn.Open ConnString

** after some processing**
Dim Str_Name, Str_Soundex_Name, dt_doj As String
'Dim DOJ As Date
'Str_Name = sdkpro.Char2Unicode(sdkpro.LanguageToUnicode(Txt_Name.Text))
'Str_Soundex_Name = sdkpro.Char2Unicode(sdkpro.LanguageToSoundex(Txt_Name.Text))

If (DbCode = 5) Then
Str_Name = sdkpro.Char2Unicode(sdkpro.LanguageToUnicode(Txt_Name.Text))
Str_Soundex_Name = sdkpro.Char2Unicode(sdkpro.LanguageToSoundex(Txt_Name.Text))
Else
If DbCode = 1 Then
dt_doj = "{^" & Txt_DOJ.Text & "}"
Else
dt_doj = Txt_DOJ.Text
End If
Str_Name = sdkpro.LanguageToUnicode(Txt_Name.Text)
Str_Soundex_Name = sdkpro.LanguageToSoundex(Txt_Name.Text)
End If
'qrystring = "Insert into Unitable (Empcode,DOJ) values (111, '{^" & "02-02-1998" & "}')"
If (DbCode = 5) Then
qrystring = "Insert into UniTable (EmpCode,Name,DOJ,Salary,Name_Sx) values ( " & Val(Txt_Sno.Text)
& ", N'" & Str_Name & "','" & Txt_DOJ.Text & "', " & Val(Txt_Salary.Text) & ",N'" & Str_Soundex_Name
& "' )"
Else
qrystring = "Insert into UniTable (EmpCode,Name,DOJ,Salary,Name_Sx) values ( " & Val(Txt_Sno.Text)
& ", '" & Str_Name & "','" & dt_doj & "', " & Val(Txt_Salary.Text) & ",'" & Str_Soundex_Name & "' )"
' 'qrystring = "Insert into UniTable (EmpCode,Name,Salary,Name_Sx) values ( " & Val(Txt_Sno.Text)
& ", '" & Str_Name & "'," & Val(Txt_Salary.Text) & ",'" & Str_Soundex_Name & "' )"
'
End If

Set rs = New ADODB.Recordset
If DbCode = 1 Then
rs.Open qrystring, Conn, adLockOptimistic
Else
rs.Open qrystring, Conn, adOpenDynamic, adLockOptimistic
End If
Str_Name = sdkpro.LanguageToIscii(Txt_Name.Text)
qrystring = "Insert into IsciiTable values ( " & Val(Txt_Sno.Text) & ", '" & Str_Name & "','" &
dt_doj & "', " & Val(Txt_Salary.Text) & ")"
Set rs = New ADODB.Recordset
If DbCode = 1 Then
rs.Open qrystring, Conn, adLockOptimistic
Else
rs.Open qrystring, Conn, adOpenDynamic, adLockOptimistic
End If

cmd_Save.Visible = False
Cmd_Store_DE.Visible = True
Txt_DOJ.Text = ""
Txt_Name.Text = ""
Txt_Salary.Text = ""
Txt_Sno.Text = ""
txt_Soundex.Text = ""
End Sub

****************

but it gives me message::
Runtime error '-214217913(80040e07)':
[Microsoft][ODBC VISUAL FoxPro Driver]Data type Mismatch.

** I have tried by taking variable DOJ as Date as well as String. but it does'nt works....

would you please help me...

regards,
Narender

Capture Visual Foxpro Visual Classes
I'm new to API programming & basically still an intermediate.

how do create a code to capture the objects from a visual foxpro forms create thru visual classes? also all the objects and functions from an *.rpt file- a report file from crystal reports?

i don't know how, can anyone show me a code?

Exporting Data From A Visual Foxpro Table (.dbf) To A Text File
Hello all,

I kinda have some big problems with programming the code voor exporting data from a .dbf (visual foxpro) to a text file.

I already found the connection string and other several strings but the puzzle won't come together.
I'm not so good at programming so I hope that there is a soul here who would like to share some code on how to deal with this baby.

Major thank you in advance.

Greetings

What Is The Different Between Visual Basic And Visual Basic Access?
hey!

actually i'm going to do a database to track student attendance, where the student need to scan their student ID card.

which software is suitable for me? Visual basic or Visual basic access?

actually what is the different between these two?

can anyone explain to me?

Exporting Data From One MS Access Database To Another MS Access Database In Visual Basic
hello friends,
i want to transfer the data from one Access database to another Access database using visual basic.

The first Access Database name is Data1
Table Name is tbldata1
fields - ID -- Number
            venueID -- Number
            Date --- Date/Time
            RNo --- Number
            SRNo --- Number
            HNo --- Number

i want to transfer this data into the second Access Database -- Data2
with table name same & fields also the same

pls can anyone help me out with this problem

Regards
Girish

Word And Visual Basic [ How Can I Get The Save As Window Through Visual Basic? ]
Hi, I made a small program in visual basic that with the use of

Dim oWord as new word.application
Dim oDoc as new word.document

fills a document with some data from the visual basic.
I want when those data are loaded in word the save or save as window to appear.
The command oDoc.saveAs saves the document without even asking for a filename.

What Can I do?

How Do I Run A Program I Made In Visual Basic On A Computer Without Visual Basic?
I created a program in Visual Basic and I was curious at what I needed to do to be able to install or use this program on a computer without Visual Basic. Any help would be great! Thanks in advance.

Extracting Visual Basic Source Code From Visual Basic EXE
hi everyone,

Well actually the problem in my case is that i had mad an EXE in VB6 around a week ago and had stored the EXE and th source code in two diferent folders. By mistake somebody ha deleted the source code folder. I wanted to make some changes i the EXE code and Now i have only the EXE folder to deal with.

Is there any method by which i can extract the Visual Basic cod from the VB EXE. Is there any application or software which ca help me in this? Do give me the hyperlink for downloading th EXE for the extraction if possible.

Please let me know at the earliest.

Thanks in advance.

Ankit

Access Reports Vs Visual Basic Data Reports?
I need some help.

For the longest time - I've been using Access Reports that are printed on carbon copy bill of ladings and the like, etc. These reports print only the data that is based on one query. That one query is based on three text boxes on a form. The query searches whatever the user typed in those 3 text boxes and pulls all the records that match. If the user does not type anything in those 3 text boxes they automatically default to '*' in each of the text.

I want to do the same thing in Visual Basic. But I have a better idea for a search. I am using a DataGrid to list everything in a query and basically the user just highlights the row that he wants to choose. Then up top on the menu he clicks on whatever report he wants to print based on the record he/or she highlights. I know I've got to use DataGrid.Columns(0) as a criteria for a search and so I've finish what kind of SQL statement I'm going to use. As regards output, I'm unsure of what to use. I did try to pull up the actual Access Report I used before but that did not work because it would not recognize the DataGrid.Columns(0) command in the query.

I'm new to the Visual Basic Data Report - I don't see any tutorials anywhere.
I understand Crystal Reports are the old way of doing this but don't have a means to try that out.
At this point - in my development - I'm thinking I'd probably make a form that would have the same output with the text boxes tied to the datasource (recordsource would be the query) and then i'd print the form data only. But not sure how to do this either? Please help.

Thanks,

Stephen

Access Report >to> Visual Basic Data Report
Hi,

I have created some pretty complex reports in access. Is there anyway to convert those to reports to data reports (.dsr) ?

I don't have enough knowledge to remake those reports in vb. Could anybody help me ? (good tutorial or something)

thx in advantage

grz

Difference Between Foxpro And Visual Foxpro
Is there any difference between Foxpro and Visual Foxpro database file formats? Will VFP file format be accessible from Foxpro? I haven't worked with Foxpro so I don't know the difference.

Kinjal

Problem Of Adding XP Visual Styles To A Visual Basic Application
:-)

Code Change From Visual Basic.net - Visual Studio 2005
I am working on a tuturial that i have for Visual basic.net ( for now )

I am working with Visual Studio 2005.

I have been working on a code to change the text color by the name put into
the text box.

Visual Basic .Net code.
Label2.ForeColor = Color.FromName(TextBox1.Text)

i get the error
Name 'Color' is not declared.

I was wondering if someone can show me how things would be in Visual Studio.

thank you

Apply Windows Visual Themes From Visual Basic?
I am moderately new a visual basic - i know quit a bit - but not as much as some people - was just wondering - is it possible to make a visual basic program that applies a windows visual style - if so - how?

Microsoft Visual Studio 6/Visual Basic 6 Sp6 RELEASED!!!!
Microsoft released Service Pack 6 for Visual Studio 6, download the latest(and final) service pack if you have VS6/VB6 installed.

Official Page
Official Page of sp6

List of Fixes
See the fixes from sp4 and sp5

Direct Download
Click here to download it (About 62mb)

Download it, it has many fixes included!

As BrianS told me: VB6 SP6, its only 26mb and VB Runtimes sp6 its only 1.02mb

Enjoy the new service pack! It is the LAST!!!!!

Linking To DLL's Created In Visual Studio From Visual Basic
Can anyone give me some usefull tips or links on how to link to routines writen in C++ from Visual Basic

I am aware of the

Declare Function CloseHandle Lib "testdll.dll" (ByVal hObject As Long) As Long

type notation, but I am curious on what I have to do with my DLL to allow this notation to work.

Any suggestions or links would be a great help, thanks!!!

Visual Basic Development & The Visual C++ Shared Objects
I having a really irritating problem. I'm developing an Add-in in Visual Basic... however, to do the development I'm doing, I require the "Visual C++ shared Objects" reference to be added to the project.

Here in lies the problem. I also need the VB command left [as in left string copy - ie. left("aaaaa", 2)] The only problem is that by adding the "Visual C++ shared Objects" reference, the LEFT command is overridden with the C++ version which returns a long (or something like that).

In the References window, I've already set "Visual C++ shared Objects" to the lowest possible priority... is there anyway to get around this arrangement?

Thanks in advance,
Bishop

Dumb Question About Visual Basic / Visual Studio...
From someone who has been programming as long as I have, this has got to be a dumb (DUH!!!) question.  But if I don't get it answered, I'm going to continue to run around in circles.  The problem stems from what appears to be a simple name change, and the fact that I only upgrade my software infrastructure here every few years, so I miss what's going on.

VB6 appears to be the last (terminating) version of Visual Basic.  There will be no VB7.  But, clearly, the language itself is not being terminated -- just called something else, or is being "assimilated" (resistance is futile) or absorbed into a larger platform, losing its identity as a stand-alone programming environment.

How does Visual Studio relate to Visual Basic?  Is the "next generation" version of Visual Basic now being called Visual Basic.NET?  Is VB.NET part of Visual Studio?  If I get Visual Studio, is VB.NET automatically part of that package?  Or is Visual Studio one thing, and VB.NET something else entirely, ordered as two separate things?  If I want to keep programming in VB (as a programming language/environment), do I now have to get Visual Studio instead?

Sorry to bother the more enlightened souls here with a DUH question -- but I gotta ask SOMEBODY...

Thanks.  You folks have been a GREAT help here.