Question about Operating Systems

1 Answer

Using find or filter command in vb6

Kindly send a example to find and filter to or more data field by using input text in vb6

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Search command in visual basic 6.0

Posted on Mar 09, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Word .doc vanished


When a Word document file is corrupted, then you can try several methods to recover it:
1. First of all, you can try the recovery function integrated with Microsoft Word, as follows:
1) On the File menu, click Open.
2) In the Look in list, click the drive, folder, or Internet location that contains the file that you want to open.
3) In the folder list, locate and open the folder that contains the file.
4) Select the file that you want to recover.
5) Click the arrow next to the Open button, and then click Open and Repair.
The "Recover Text from Any File" converter has limitations. For example, document formatting is lost. Additionally, graphics, fields, drawing objects, and any other items that are not text are lost. However, field text, headers, footers, footnotes, and endnotes are retained as simple text.
1. In Word 2007, click the Microsoft Office Button, and then click Open.
2. In Word 2010, click the File Menu, and then click Open.
3. In the Files of type box, click Recover Text from Any File(*.*).
4. Click the document from which you want to recover the text.
5. Click Open.
After the document is recovered by using the "Recover Text from Any File" converter, there is some binary data text that is not converted. This text is primarily at the start and end of the document. You must delete this binary data text before you save the file as a Word document.
Here's something to look at:http://support.microsoft.com/default.aspx?scid=kb;en-us;87856
https://community.office365.com/en-us/f/172/t/269739

I have had great success with the Word Recovery Toolbox application from http://www.oemailrecovery.com/word_repair.html
They have a free version you can try. I would suggest you run the deep scan in order to get the best data set to look through.

Try also to restore the file using this online service. I found it in Google. https://onlinefilerepair.com/en/rtf-repair-online.html

Apr 10, 2016 | Operating Systems

2 Answers

Can anyone explain how batch file works?


This is kind of tricky not knowing how familiar you are with the commandline, but a batch file simply contains single commands and executes them in order (usually from top to bottom). A batch file (or bash script in Linux) can be very helpful if you have to run certain commands over and over again, so you don't have to write them by hand.

An Example: You want to store your network settings in a text file.
You open the command prompt (WIN+R) and type this line:
mkdir C:\Network
Then you type this line:
ipconfig /all > C:\Network\ipconfig.txt
The first line creates a folder on your C: drive called "Network"
The second line runs the ipconfig command and saves it as a text file in that new folder.

To make a batch file, you open Notepad and insert the two lines. Then save it as "IP.bat" (make sure not to save it as "IP.bat.txt"! This is the most common mistake. If you save a file from Notepad, select "All Files" in the "Save As Type" dialog. Otherwise it will save it as a .txt file and you have to rename it later.)

Now you can double click the batch file and it runs all commands in the file.

You can also see the danger. If you run a batch file and don't know what it really does, it can destroy your whole system. So make sure you understand it and/or get it from a trustworthy source.

A nice example of how complex a batch file can be is here:
AllHelp.bat

Copy the content into a text file, save it as AllHelp.bat, run it and it will create a webpage with all available DOS commands.

Hope this helps - otherwise let me know if you have specific questions.
Enjoy!

Feb 26, 2012 | HEWLETT-PACKARD Operating Systems

1 Answer

Run time error the microsoft jet database engine cannot find the input table or query 'zsms'


hi,

Can you please elaborate your problem, it seems you are using some api's to fetch data from ACCESS but not defining the type of command object (text, procedure, table...)

Please provide details, we'll help you out.

Thanks.

Mar 03, 2009 | Microsoft Operating Systems

1 Answer

How to connect vb with ms access


se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

Feb 26, 2009 | Operating Systems

1 Answer

How to add items in combobox using database in vb6.0


There are 2 ways:-

you can set the recordsource in the properties for the comboBox to a table or create a recordset and loop through it adding one item at a time, see example below:-


Dim dept As String
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qd As DAO.QueryDef
Dim varResults
Dim oMessage
Dim sQueryName As String
Set db = CurrentDb
mdbname.[Form_Name].Department.SetFocus
dept = formname[Form_Name].Department.Text
sQueryName = "Query_Name"
Set qd = db.QueryDefs(sQueryName)
'
' set up input field for query
'
qd.Parameters("field_from_query") = dept
Set rst = qd.OpenRecordset()
Dim recCount As Integer
recCount = rst.RecordCount
If recCount > 0 Then
With rst
.MoveLast
.MoveFirst
Do While Not .EOF
listBoxproducts.AddItem .Fields("pname")
listboxCode.AddItem .Fields("pcode")
listboxPrice.AddItem .Fields("pprice")
.MoveNext
Loop
End With
rst.Close
Set rst = Nothing
Set qd = Nothing
Set db = Nothing

Jan 13, 2009 | Operating Systems

1 Answer

Migration from single machine to multiuser environment


have you made sure that the ADODC path points to the machine that holds the database on a remote path for example (\\ComputerName\c$\Data\) and that it isn't a local path. (C:\Data\)

Dec 15, 2008 | Microsoft Windows Server Standard 2003 for...

2 Answers

Vb variable error


Change the code:

strdbname = "d:\vivek\company.mdb"
Set DB = DBEngine.OpenDatabase("D:\VIVEK\COMPANY.MDB")
strrsname = "company"
Set RS = DB.OpenRecordset("COMPANY")
comp.Text = RS!COM_CODE
compnm.Text = RS!COMPANY
isinno.Text = RS!ISIN
AD1.Text = RS!ADD1
'AD2.Text = RS!ADD2
'AD3.Text = RS!ADD3
AD4.Text = RS!ADD4
BK.Text = RS!BOOK
'PG.Text = RS!Page
to become:

strdbname = "d:\vivek\company.mdb"
Set DB = DBEngine.OpenDatabase(strdbname )
strrsname = "company"
Set RS = DB.OpenRecordset(strrsname )
comp.Text = RS!COM_CODE
compnm.Text = RS!COMPANY
isinno.Text = RS!ISIN
AD1.Text = RS!ADD1
AD2.Text = RS!ADD2
AD3.Text = RS!ADD3
AD4.Text = RS!ADD4
BK.Text = RS!BOOK
PG.Text = RS!Page
mostly to eliminate the extra "quote" (') characters,
and to use the values you set.


Dec 10, 2008 | Operating Systems

2 Answers

USB printing through DOS mode


Google for DOS PRINT USB, and you'll find some utilities that do this.

Or, you can include some commands in your batch file.

First, get the device name:

In a DOS window, type NET VIEW ComputerName (or use 127.0.0.1)

Once you know the printer share name, you use it in a batch file.

NET USE lpt1: \\ComputerName\ShareName /Persistent:Y

This captures the print queue to the shared printer.

You must also go into Printer Properties/Advanced/Print Processor and set it to TEXT

Your copy, print and other commands will work.

Jul 12, 2008 | Operating Systems

1 Answer

Vb6 source code is not compiling.


What the heck are you compiling it with that doesn't give a line number for that error? Pay attention to the titles of messageboxes! Perhaps noting what lines you changed from the original will give a clue to narrow it down, but I expect you addressed an object with a property (object.property) in a context that can't be expected to generate or use that property as you gave it. Moreover there are spaces in object names, it seems....

Apr 13, 2008 | Operating Systems

1 Answer

How to create program in delphi


i wants to create form for data input
with the condition

Mar 13, 2008 | Operating Systems

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

445 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...